Questions tagged as 'mysql'

Tagged questions
2
answers

Empty array with Inner Join

I have some related tables, to do a SELECT brings me all the normal info and INNER JOIN , but there is a table of tickets that I have, I'm doing INNER JOIN , now when I go to detail a vehicle, the info that normally brings me...
asked by 17.04.2017 / 16:42
3
answers

Error entering data to MYSQL

What happens is that everything worked fine until I added codsem - > which is semester code. Now he tells me registered assistance when the student does not exist and not even. <?php $link = mysql_connect('localhost', 'root', '') or die(...
asked by 08.12.2016 / 16:12
1
answer

Download CSV file with FileZilla and MYSQL

I want to download a CSV file created from a query from mySQL. I want to use FileZilla but I do not know how to do it, someone to support me? I have this code. SELECT * FROM EMPLEADOS INTO OUTFILE 'C:\prueba.csv' FIELDS TERMINATED BY ';' ENCLO...
asked by 15.11.2016 / 02:47
0
answers

Error in rails Object does not support #inspect with table name with reserved word in mysql

The name of the table is "char" which is a reserved word in mysql, how can I correct the error without having to change the name of the table? I can not change the name of the table because it is from the game ragnarok In the model (Char...
asked by 10.12.2016 / 03:07
0
answers

Java query error to Prolog-Mysql in Fedora 22 (Netbeans)

I've been playing with Java doing consultations with Prolog with the JPL library and it works for me, all right up there. Then I made a Prolog connection to MySQL with ODBC and it worked great. Then I had a problem with making queries in Prol...
asked by 24.10.2016 / 03:15
1
answer

Update or insert record using 1 statement and 2 MYSQL clauses

I have a table with the columns id_autor , id_publicacion and fecha , what I would like is that when the id_autor and the id_publication are equal to the values that happened to them, update fecha , if Both are differe...
asked by 27.11.2016 / 18:29
0
answers

Graph a Flot Chart of lines with multiple series obtaining data from the database

I am trying to create a jQuery Flot chart with multiple strings extracting the data from the database with a query. This is the table I have in the database:    Code | Date / Time       A | 9-10-2016 09:25       B | 10-11-2016 10:11   ...
asked by 17.11.2016 / 18:51
1
answer

Problem with login in Java with connection to database (MySQL & Eclipse)

I followed a tutorial to create a login connected to MySQL, when running it and enter username and password, it sends me the error message and in the console it shows the following each time you enter the username and password again:            ...
asked by 16.11.2016 / 23:26
1
answer

Problem when performing a query JSONArrayRequest. I always receive null

I have this code and I am trying to get a JSON from a PHP script with Android Studio and MySQL, and then use a url of an image obtained from the database and fill in a ReciclerView with some lists. I always get a NullPointerException exception f...
asked by 28.02.2017 / 16:15
0
answers

Errors when creating table in phpmyadmin from java

Good morning, Clarify that the table is created, the problem is that something will be wrong because I get the following errors. In the table I have 2 columns in which I do not fill anything to be able to do it manually, if once the table is...
asked by 28.02.2017 / 22:45