Questions tagged as 'mysql'

Tagged questions
1
answer

Select from 3 tables mysql

I have a query that already brings information from 2 tables, but I need to add to the statement that brings me information from the table called locales to bring the name of the place that is identified with id from the table equipos...
asked by 23.08.2018 / 09:31
0
answers

why are articles in 0's or null not shown in my final mysql report?

I appeal to you since I have not been able to resolve this detail in the sql statement, well, the error I have is when I consult my products classified by category, because when I filter with a simple where I get 126 products, but when I include...
asked by 22.08.2018 / 15:04
0
answers

Error trying to export database in MySQL Workbench

Good day, when trying to backup my database from here: I get the following error:    16:24:28 Dumping db_cards (all tables) Running: mysqldump.exe   --defaults-file="c: \ users \ luisca ~ 1 \ appdata \ local \ temp \ tmpn2bwpl.cnf" --us...
asked by 29.08.2018 / 22:30
0
answers

ERROR IN MYSQL 1241 operand should contain 1 column

I need to register two tables from an application, for this I must enter records to the first table tb_ ordered, to get your code, then I must capture that code to enter records to the table tb_detalle_pedido, according to the last code of tb_pe...
asked by 29.08.2018 / 20:46
0
answers

How to replace database with JSON file for Jquery Ui autocomplete?

I'm doing a search engine and I'm using Jquery UI autocomplete to bring suggestions from a database. My question is if I can (and if so, how it is done) replace the database with a JSON file because I imagine it must be faster. My current code i...
asked by 23.08.2018 / 19:10
2
answers

validate TextChange function subtraction of numbers

Hello good morning to all, I have to do a calculation (calculate the returned to deliver) between a total and cash delivered, I am working with decimal values. The calculation operation is performing well, I enter the values and it automatically...
asked by 20.08.2018 / 15:38
1
answer

Constructor threw exception; nested exception is java.lang.NullPointerException

I am trying to connect to my DB by MySQL pe I get that error of Constructor threw exception; nested exception is java.lang.NullPointerException and do not access any parameter: jdbc.driverClassName = com.mysql.jdbc.D...
asked by 20.08.2018 / 16:09
1
answer

Query data from a MySql table with REGEXP

The first thing I do is capture the variable of a form and through a PHP file I make the query. But in this way I only capture the IDs that do not have asterisks, example 123456789, I need to show the information of the IDs in this way 123 * 456...
asked by 20.08.2018 / 18:00
1
answer

Elinimar Data of Several SQL Tables

I'm trying to delete the records of my DB but only the first 2 tables are deleted, nothing happens in the third one. DELETE cliente, historia, descripcion FROM cliente INNER JOIN historia ON historia.idCliente = c...
asked by 17.08.2018 / 17:52
0
answers

Medoo, PHP, Mysql

I have a problem they gave me a web page to migrate and it is working with this framework, that the truth is unknown, the point is that it is already connected to the database in the new hosting, but the links do not work, nie ne the menu or the...
asked by 17.08.2018 / 15:22