Questions tagged as 'mysql'

Tagged questions
1
answer

display data from a table in mysql using a jtable

My query is as follows, I have 3 related tables (students, tutors, kinship) and a jtable which shows me the data from a database MYSQL , but I want to right click and give to the option "Data Tutor" which I have done with a jmenu...
asked by 03.07.2017 / 17:57
1
answer

MySql Simple query with "Where In" does not recognize Index

Good, I have a problem with the Mysql I have a very small table: CREATE TABLE 'Prueba' ( 'idTipoCliente' int(10) COLLATE utf8_general_mysql500_ci NOT NULL, 'descripcion' varchar(20) COLLATE utf8_general_mysql500_ci NOT NULL, 'observacion...
asked by 10.08.2017 / 19:52
3
answers

Do not do the date comparison [closed] well

I am doing a query where I know that my start date is '2017-06-12' and when I compare it I get that it is less than '2017-06-04' , what could it be? The query is as follows: select fecha_inicio ,month(fecha_inicio) as mes...
asked by 21.06.2017 / 00:03
3
answers

In MySQL I get error 1242. For Delete and Insert Into

I have a Sales table that is very much related to many with a table Products For that reason, create the table DetailofProductsEnLaSale CREATE TABLE IF NOT EXISTS DetalleDeLosProductosEnLaVenta ( ID_Productos INT NOT NULL, ID_Venta...
asked by 13.09.2017 / 19:51
1
answer

Take out an sql query

Hello, good morning and I look forward to your help. I need to get out of the table restaurant: and the table user: all those restaurants that do not belong to a user in this case is 3 (empty restaurant name), because as you...
asked by 20.05.2017 / 10:17
1
answer

Array to string conversion. Modify mysql data with php

I have the following code that generates a table in php, returning the data saved in a database in mysql require("conexion.php"); $consulta = mysqli_query($conexion, "SELECT * FROM clientes"); if (!$consulta) { die("Fallo al realizar la...
asked by 19.05.2017 / 21:29
1
answer

Make a MySQL query from Inno Setup

I'm doing an installer, which needs to send a query at the end of the installation and after mounting the sMySQL service. I have no idea how this is done, this would be in the CODE section in PascalScript. Once the installation is finished, a...
asked by 31.05.2017 / 00:26
1
answer

Why do I change the time when I insert?

Hello, I am handling a graph where the date and time are displayed and the parameters are clear, but at the moment of inserting the time and date, the time is advanced by 5 hours. To insert I take the time and date of the current equipment an...
asked by 19.07.2017 / 23:00
3
answers

Warning: mysql_fetch_row () expects parameter 1 to be resource, boolean given

Could someone tell me why did you mark this error in my code?    Warning: mysql_fetch_row () expects parameter 1 to be resource, boolean given in C: \ xampp \ htdocs \ dashboard \ PROJECTFINALLP4 \ registerbd.php on line 61 * I try to mak...
asked by 20.07.2017 / 01:53
3
answers

query with ranges of dates and values of a month

In my app I have a table like this: INACTIVITY: id user_id start end comment 265 2 29-04-2017 05-05-2017 Vacaciones 356 2 07-04-2017 10-04-2017 Baja Enfermedad 455...
asked by 27.06.2017 / 13:55