Supposedly the counter ends in "2" but the error tells me that "3" is not defined.
<?php include_once 'includes/templates/header.php'; ?>
<section class="seccion contenedor">
<h2>Calendario de Eventos</h2>...
I was working on an app that connects to mysql server as a database but at some point I changed the password of the user root now when I try to see the data in my tables I get this 10:52 : 23: Error Code: 1820 You must reset your password usin...
I try to create a table that refers to a foreign key that I created earlier, the statement of my instruction goes like this:
create table IF NOT EXISTS opcion(
id_opcion varchar(21) not null,
id_pregunta varchar (21)not null,
prima...
I have a query in which I consult a record which I do with ajax and I get the data in json. now my questions is how I could optimize the response time since for example the query takes about 4 seconds, the table that I consult has ten rows, then...
Good day,
I need to "replicate" some fields of some a database, the problem is that I must contemplate the fact that some data in the source DB are modified to update those in the new DB and not generate a new record.
In my first load of data, I...
Good friends I hope you can help me, I have the following table
CREATE TABLE 'almacen_articulo' (
'id' INT(4) NOT NULL AUTO_INCREMENT,
'existencia' VARCHAR(5) NOT NULL DEFAULT '0',
'id_articulo' VARCHAR(4) NOT NULL DEFAULT '0',
'id_almacen'...
I have 6 survey tables, form_alumnos, dimension, questions, answer_type, answer.
Table form_alumnos
and I have this query
SELECT p.id_pregunta, tr.tipo, COUNT(r.id_respuesta) as cantidad_respuestas
FROM encues...
Hi, I wanted to tell you that I want to do an Insert but check if there is a value in a column of the table before doing it, if it is an update only in the value of the column of the same.
I pass the code to you as I have it:
if(in_array($t...
Good morning,
I am designing a REST API with NODEJS and when I insert this query:
function getInvTop(req, res) {
if (connection)
{
connection.query('SELECT recvTimeTs, CONVERT_TZ(recvTim...