Questions tagged as 'mysql'

Tagged questions
1
answer

Connect Mysql with vb6

I'm trying to connect vb6 with MySql but it gives me an error I show connection code Option Explicit Public cn As ADODB.Connection Public rs As ADODB.Recordset Public Sub Conectar() Set cn = New ADODB.Connection Set rs = New ADODB....
asked by 07.05.2017 / 23:55
1
answer

Save image in a server folder and save the path in MySQL with PHP and AJAX

I try to save an image in a server folder and then save the path in my DB to later show it in a html table. I'm working with MySQL , PHP and AJAX . I have seen several ways to do it on the web but I have not b...
asked by 26.07.2017 / 04:48
1
answer

Are the changes made to a temporary table reflected in their original tables?

I create a temporary table and insert data from other tables. If these data are modified, are these modifications reflected in their original tables? Here my temporary table: DROP TEMPORARY TABLE IF EXISTS categoriasaseleccionar; CREATE TEM...
asked by 05.09.2017 / 21:02
1
answer

Is it possible to specify a format for a varchar field in MySQL?

I have a column in my database that always starts in the same way, for example let's say it always starts with "ABCD" and then some number Is it possible to create a CONSTRAINT within the database so that it does not allow to enter values that d...
asked by 08.09.2017 / 22:39
1
answer

Do not upload the table to the datagridview and give me a warning of invalid operation exception

I have the following problem. I try to upload a table to the datagridview, but when I try it, it gives me a warning with the message invalid operation exception . I leave the exception details given. System.InvalidOperationException w...
asked by 12.04.2017 / 19:59
2
answers

Help with the select in a combobox

I'm using a select to save data from a database, but when selecting several of select only saves me the last one selected from the combobox box and I want to logically save all the selected. This is the code I have <...
asked by 12.04.2017 / 23:27
2
answers

Export to .csv from Table

I am currently trying to do a job for a friend, but I can not do the following. I have a table where everything is in the database. And the code of that page is this (Ask for a connection that works): index.php <?php require('c...
asked by 24.05.2017 / 14:12
1
answer

How to convert a MySQL query to JSON in C #

I would like to know how to convert the result of a MySQL query to JSON in C # I do not have much knowledge in the following, but I would like the result of the query to be saved in JSON. public class WebService1 : System.Web.Services.WebSe...
asked by 23.05.2017 / 01:09
2
answers

COUNT and complex query with INNER JOIN. (sql)

I have the comment tables, user, spam. The business logic, is that simple: a user can make comments, and this comments can be marked as spam by other users. The query I want to make must have the following structure: datos de comentarios...
asked by 07.04.2017 / 22:08
1
answer

I do not understand why I get this error 1136?

   Operation failed: There was an error while applying the SQL script to the database. Executing: INSERT INTO 'bdaeropuerto'.'tb_hangars' ('Clave', 'Aeropuerto', 'Capacidad', 'Tipo', 'Aerolinea', 'Estatus', 'Aeropuertos_Id', 'Avione...
asked by 08.04.2017 / 21:17