I have a problem This code does not work. I miss this error # 1064 - Something is wrong in its syntax near '' on line 6
CREATE OR REPLACE TRIGGER TR_MORA
AFTER INSERT on servicios
FOR EACH ROW
BEGIN
INSERT INTO deteconomico(FECHA_PAGAR)
VALUES...
I'm doing a data entry and then create a table in which I have two types of user (administrator and client), but when I relate it to the table in which all the registered users are going to be stored, I try to register a new user and does not re...
I need to create a foreign key in a database that I have in phpmyadmin. The database consists of 4 tables, all of them already contain data. One of the three tables is related to the rest of them. All the columns in the main table have an index...
I have an .sql file that I import into phpmyadmin. I load all the tables correctly, but when I click on the "vehicles" table it tells me the following message: # 1054 - Unknown column 'PHOTO' in 'order clause'. I do not have in any table the PHO...
I have a table in mysql, which when inserted from PHP alters the logical order of the ID:
"INSERT INTO 'persona' ('id_persona', 'nombre_contacto', 'apellido_contacto',
'telefono_persona', 'email_persona', 'documento'...
I am learning php and when I try to connect to the database I get this error:
Warning: mysqli_connect (): php_network_getaddresses: getaddrinfo
failed: Unknown host. in C: \ xampp \ htdocs \ php2 \ Exercise
1 \ conexion.php on line 2...
I have a database with phpMyAdmin, when I use it with my localhost it works perfect, but if I want to upload the database to my domain, how do I know the host, username and password?
Thanks
I need help I am making a PHP connection with Mysql and it appears to me that it can not be done.
I get this error:
Can not connect to MySQL server on 'localhost' (10061).
Use:
<?php
$conexion = new mysqli('localhost',...
THE MANAGER IS MYSQL PHP ADMIN, I WANT TO MAKE THIS CONSULTATION WITH PARAMETERS
CREATE PROCEDURE VALIDAR_USUARIO (IN nombre varchar(20), IN contraseña varchar(50) )
BEGIN
SELECT * FROM usuario WHERE usuario.User = nombre AND usuario.Pass= con...