Questions tagged as 'mysql'

Tagged questions
1
answer

Query to show only fields that are not empty! [closed]

I have a table with 20 fields which are filled by a for and the amount of data that I tell you to insert. But now I need to show the data of each row, but show me nothing else the fields that have data, so those that are empty do not show them t...
asked by 12.08.2017 / 22:36
1
answer

MYSQL: ERROR 2027 (HY000): Malformed packet

I can not connect a MySQL server remotely. The connection seems to be fine since with telnet [ip] [door] I get an answer: 4.1.3b-beta-nt-max▒@mysql -u[user] -p -h [host]v'[uZ,B{efSLa$,Q4N When running by command line or MySQL Workbench 6.3...
asked by 12.08.2017 / 21:11
1
answer

Failed to restore database copy from PHP

I am doing a database backup / restore system for my project. So far I have been able to back up the database of my systems without problems, but I can not get it restored from the "Restore" section that I have done, and all due to the way the d...
asked by 13.08.2017 / 23:01
0
answers

Error exporting a csv file in MySql

Good afternoon, I am trying to export an Excel file to a MySql table, using phpmyadmin. My query is: load data infile 'c:\evasiondb.csv' into table 'datos' fields terminated by ';' I get the following error. Error SQL query:    load d...
asked by 21.08.2017 / 17:47
0
answers

login with javaFx and MySQL

I am new using JavaFX and I am trying to make a login connected to the database Program Launcher public class Login extends Application { @Override public void start(Stage primaryStage) { try { AnchorPane root...
asked by 15.09.2017 / 18:16
1
answer

How do I create a java method to load a jcomboBox with JPA?

I am trying to make a method to load a bombobox in an application of > mysql using jpa . I use: NETBEANS 8.2 JAVA version "1.8.0_131" EclipseLink (JPA 2.1) JDBC Library Form code public jfrm_Administrador() { initComponents(...
asked by 28.07.2017 / 19:56
1
answer

Error executing query

It had not happened to me until I wanted to make a chat with php and ajax, I know that a chat is better to do it with other languages, but it does not demand the robustness to use the other languages. My query that I am trying to do is the fo...
asked by 22.07.2017 / 23:03
1
answer

How to create a remote connection from my Mysql Workbench to Codeanywhere

I have a problem, I tried to connect remotely to the database that I have in a container on the CodeAnywhere platform, that container uses as S.O Ubuntu 16.04 . I have been reading and apparently to connect, I must use this window that off...
asked by 12.07.2017 / 08:11
1
answer

Search in mysql of 4 tables

Good friends I hope you can help me, the problem is the following .. I have 4 tables in MYSQL , I want to search in each of them Table field1: id,numero Table field2: nombre, apellido Table field 3: id,condicion,identif...
asked by 10.09.2017 / 18:23
1
answer

Trigger to update mysqli php record

Hi, I'm new to the trigger and I have a problem. I have a table with 2 fields | quantity | criteria | and I need that when updating the amount the trigger updates the criterion: example if I update the amount to > 0 then which criterion is up...
asked by 09.07.2017 / 21:58