Good, I have this query that I show in a table:
$sql2 = "SELECT * FROM cart_product
JOIN cart_product_to ON cart_product.cart_id
JOIN product ON cart_product.product_id = product.id
JOIN cart ON cart_product.cart_i...
I get that error when creating an FK, this KEY already existed and it was deleted when updating the table and when trying to create it, it throws me that error.
In class we work with java and we have started with the databases, we use the MySQL Driver Library JDBD (I do not know if this influences anything, forgive my ignorance) and I would like to know when entering a date in a table , in what order th...
In this case I will use ALTER TABLE to take the AUTO_INCREMENT to zero (0) .
The goal is to bring the table to 0 without having to delete it and create a new one.
To do this we just have to write the following order:
ALTER TABLE 'nombr...
I want to perform a procedure stored in MYSQL, to which a text with JSON structure is passed, and convert this text to JSON in the procedure to obtain the data.
The JSON will not always have the same fields. It is intended to save only the d...
I have two tables, the first call question_tags_g3 and the second questions_g3.
In the question_tags_g3 table the tag field contains programming languages and some are repeated many times, and when executing this statement:
select a.tag, count...
I have a query that is this
SELECT COUNT(id_orden) as cuantas FROM 'orden_trabajo' ORDER BY status
this gives me a result of
cuantas
46
my problem is that I can not pass this result of the query to an html.
my idea was to pass it to a...
I have the following query;
SELECT id,
oficina,
sector,
nombre,
correo,
telefono,
ext,
comentario,
datos_solicitudes.fecha,
fecha_no_laboral,
prioridad,
estado,
asignado,
fecha_ultima_respues...
I need support. In the application that I am developing I put a button to open a top level window with the fields that my table has MySQL and so modify any record already created, in turn I want that top level appears a drop-down menu to selec...
Good morning guys, I would like you to please help me. I'm doing an attendance record and in the consultation I do, I get what I want, but in some cases the date comes out as null, what I want is to show me the date that the person has not marke...