MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | gestionescolar | | information_schema | | libreria | | matricula2 | | mysql | | performance_schema | | phpmyadmin | | procolor | | reto2 | | subconsultas | | test | +--------------------+ 11 rows in set (0.040 sec) MariaDB [(none)]> create dabases hospital; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'dabases hospital' at line 1 MariaDB [(none)]> create database hospital; Query OK, 1 row affected (0.001 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | gestionescolar | | hospital | | information_schema | | libreria | | matricula2 | | mysql | | performance_schema | | phpmyadmin | | procolor | | reto2 | | subconsultas | | test | +--------------------+ 12 rows in set (0.001 sec) MariaDB [(none)]> use hospital; Database changed MariaDB [hospital]> create table paciente -> (Id_paciente varchar(10) not null primary key, -> Nombre varchar(50) not null, -> Fecha_nacimiento date not null, -> Telefono int(10) not null, -> Direccion varchar(50), -> Correo varchar(100)); Query OK, 0 rows affected (0.007 sec) MariaDB [hospital]> show table; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 MariaDB [hospital]> show tables; +--------------------+ | Tables_in_hospital | +--------------------+ | paciente | +--------------------+ 1 row in set (0.001 sec) MariaDB [hospital]> create table medico -> (Id_medico varchar(10) not null primary key, -> Nombre_Medico varchar(50) not null, -> Turno varchar(20) not null); Query OK, 0 rows affected (0.015 sec) MariaDB [hospital]> show tables; +--------------------+ | Tables_in_hospital | +--------------------+ | medico | | paciente | +--------------------+ 2 rows in set (0.001 sec) MariaDB [hospital]> create table especialidad -> (Id_ especialidad varhcar(10) not null primary key, -> Nombre_especialidad varchar(50) not null, -> ubicacion varchar(50) not null); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varhcar(10) not null primary key, Nombre_especialidad varchar(50) not null, u...' at line 2 MariaDB [hospital]> create table especialidad -> (Id_especialidad varchar(10) not null primary key, -> Nombre_especialidad varchar(50) not null, -> ubicacion varchar(50) not null); Query OK, 0 rows affected (0.007 sec) MariaDB [hospital]> show tables; +--------------------+ | Tables_in_hospital | +--------------------+ | especialidad | | medico | | paciente | +--------------------+ 3 rows in set (0.001 sec) MariaDB [hospital]> create table estado -> (Id_estado varchar(10) not null primary key, -> Descripcion varchar(50) not null); Query OK, 0 rows affected (0.007 sec) MariaDB [hospital]> show tables; +--------------------+ | Tables_in_hospital | +--------------------+ | especialidad | | estado | | medico | | paciente | +--------------------+ 4 rows in set (0.001 sec) MariaDB [hospital]> create table ingreso -> (Id_ingreso varchar(10) autoincrement primary key, -> Fecha_Ingreso date not null, -> Id_paciente varchar(10) not null, -> Id_especialidad varchar(10) not null, -> Id_medico varchar(10) not null, -> Id_estado varchar(10) not null, -> foreign key(Id_paciente) references paciente(Id_paciente) on delete cascade on update cascade, -> foreign key(Id_especialidad) references especialidad(Id_especialidad) on delete cascade on update cascade, -> foreign key(Id_medico) references medico(Id_medico) on delete cascade on update cascade, -> foreign key(Id_estado) references estado(Id_estado) on delete cascade on update cascade); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'primary key, Fecha_Ingreso date not null, Id_paciente varchar(10) not null, I...' at line 2 MariaDB [hospital]> CREATE TABLE ingreso ( -> Id_ingreso INT AUTO_INCREMENT PRIMARY KEY, -> Fecha_Ingreso DATE NOT NULL, -> Id_paciente VARCHAR(10) NOT NULL, -> Id_especialidad VARCHAR(10) NOT NULL, -> Id_medico VARCHAR(10) NOT NULL, -> Id_estado VARCHAR(10) NOT NULL, -> FOREIGN KEY (Id_paciente) REFERENCES paciente(Id_paciente) ON DELETE CASCADE ON UPDATE CASCADE, -> FOREIGN KEY (Id_especialidad) REFERENCES especialidad(Id_especialidad) ON DELETE CASCADE ON UPDATE CASCADE, -> FOREIGN KEY (Id_medico) REFERENCES medico(Id_medico) ON DELETE CASCADE ON UPDATE CASCADE, -> FOREIGN KEY (Id_estado) REFERENCES estado(Id_estado) ON DELETE CASCADE ON UPDATE CASCADE -> ); Query OK, 0 rows affected (0.023 sec) MariaDB [hospital]> describe ingreso; +-----------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+---------+----------------+ | Id_ingreso | int(11) | NO | PRI | NULL | auto_increment | | Fecha_Ingreso | date | NO | | NULL | | | Id_paciente | varchar(10) | NO | MUL | NULL | | | Id_especialidad | varchar(10) | NO | MUL | NULL | | | Id_medico | varchar(10) | NO | MUL | NULL | | | Id_estado | varchar(10) | NO | MUL | NULL | | +-----------------+-------------+------+-----+---------+----------------+ 6 rows in set (0.016 sec) MariaDB [hospital]> describe paciente; +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+-------+ | Id_paciente | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Fecha_nacimiento | date | NO | | NULL | | | Telefono | int(10) | NO | | NULL | | | Direccion | varchar(50) | YES | | NULL | | | Correo | varchar(100) | YES | | NULL | | +------------------+--------------+------+-----+---------+-------+ 6 rows in set (0.012 sec) MariaDB [hospital]> insert into paciente (Id_paciente,Nombre,Fecha_nacimiento,Telefono,Direccion,Correo)values -> ('1146436052','Marina Cifuentes','1992-08-22',3012859864,'calle 57A #27-48','marinacifuentes@gmail.com'); Query OK, 1 row affected, 1 warning (0.068 sec) MariaDB [hospital]> insert into paciente (Id_paciente,Nombre,Fecha_nacimiento,Telefono,Direccion,Correo)values -> ('21406452','Juan Mesa','1985-11-8',3128249896,'carrera 45 #56-23',juanmesa@gmail.com), -> ('1037535969','Robin Cardona','1970-5-5',3128249835,'calle 32 #45-78','robincardona@gmail.com'), -> ('32469859','Maria Jose Bedoya','1995-4-30',3123049896,'calle 101A #27-48','mariajosebedoya@gmail.com'), -> ('41506894','Isaac Valencia','1995-3-22',3128899896,'carrera 45 #56-201',isaacvalencia@gmail.com), -> ('1406458332','Paola Toro','1974-9-9',3125812896,'calle 32 #46-78','paolatoro@gmail.com'), -> ('38546459','Catalina Lopez','1985-12-12',3128214986,'calle 57A #27-48','catalinalopez@gmail.com'), -> ('1036552698','marta Jaramillo','1999-10-18',3122345836,'carrera 103 #56-32','martajaramillo@gmail.com'), -> ('1024322365','Camilo Caro','2001-2-21',3128246986,'calle 32 #45-78','camilocaro@gamail.com'), -> ('1150352288','Carolina Marin','1983-2-3',3128223896,'carrera 86 #56-34','carolinamarin@gmail.com'); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@gmail.com), ('1037535969','Robin Cardona','1970-5-5',3128249835,'calle 32 #4...' at line 2 MariaDB [hospital]> insert into paciente (Id_paciente,Nombre,Fecha_nacimiento,Telefono,Direccion,Correo)values -> ('21406452','Juan Mesa','1985-11-8',3128249896,'carrera 45 #56-23',juanmesa@gmail.com), -> ('1037535969','Robin Cardona','1970-5-5',3128249835,'calle 32 #45-78','robincardona@gmail.com'); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@gmail.com), ('1037535969','Robin Cardona','1970-5-5',3128249835,'calle 32 #4...' at line 2 MariaDB [hospital]> insert into paciente (Id_paciente,Nombre,Fecha_nacimiento,Telefono,Direccion,Correo)values -> ('21406452','Juan Mesa','1985-11-8',3128249896,'carrera 45 #56-23',juanmesa@gmail.com) -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@gmail.com)' at line 2 MariaDB [hospital]> INSERT INTO paciente (Id_paciente, Nombre, Fecha_nacimiento, Telefono, Direccion, Correo) -> VALUES -> ('21406452', 'Juan Mesa', '1985-11-08', 3128249896, 'carrera 45 #56-23', 'juanmesa@gmail.com'), -> ('1037535969', 'Robin Cardona', '1970-05-05', 3128249835, 'calle 32 #45-78', 'robincardona@gmail.com'), -> ('32469859', 'Maria Jose Bedoya', '1995-04-30', 3123049896, 'calle 101A #27-48', 'mariajosebedoya@gmail.com'), -> ('41506894', 'Isaac Valencia', '1995-03-22', 3128899896, 'carrera 45 #56-201', 'isaacvalencia@gmail.com'), -> ('1406458332', 'Paola Toro', '1974-09-09', 3125812896, 'calle 32 #46-78', 'paolatoro@gmail.com'), -> ('38546459', 'Catalina Lopez', '1985-12-12', 3128214986, 'calle 57A #27-48', 'catalinalopez@gmail.com'), -> ('1036552698', 'Marta Jaramillo', '1999-10-18', 3122345836, 'carrera 103 #56-32', 'martajaramillo@gmail.com'), -> ('1024322365', 'Camilo Caro', '2001-02-21', 3128246986, 'calle 32 #45-78', 'camilocaro@gmail.com'), -> ('1150352288', 'Carolina Marin', '1983-02-03', 3128223896, 'carrera 86 #56-34', 'carolinamarin@gmail.com'); Query OK, 9 rows affected, 9 warnings (0.007 sec) Records: 9 Duplicates: 0 Warnings: 9 MariaDB [hospital]> select * from paciente; +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | Id_paciente | Nombre | Fecha_nacimiento | Telefono | Direccion | Correo | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | 1024322365 | Camilo Caro | 2001-02-21 | 2147483647 | calle 32 #45-78 | camilocaro@gmail.com | | 1036552698 | Marta Jaramillo | 1999-10-18 | 2147483647 | carrera 103 #56-32 | martajaramillo@gmail.com | | 1037535969 | Robin Cardona | 1970-05-05 | 2147483647 | calle 32 #45-78 | robincardona@gmail.com | | 1146436052 | Marina Cifuentes | 1992-08-22 | 2147483647 | calle 57A #27-48 | marinacifuentes@gmail.com | | 1150352288 | Carolina Marin | 1983-02-03 | 2147483647 | carrera 86 #56-34 | carolinamarin@gmail.com | | 1406458332 | Paola Toro | 1974-09-09 | 2147483647 | calle 32 #46-78 | paolatoro@gmail.com | | 21406452 | Juan Mesa | 1985-11-08 | 2147483647 | carrera 45 #56-23 | juanmesa@gmail.com | | 32469859 | Maria Jose Bedoya | 1995-04-30 | 2147483647 | calle 101A #27-48 | mariajosebedoya@gmail.com | | 38546459 | Catalina Lopez | 1985-12-12 | 2147483647 | calle 57A #27-48 | catalinalopez@gmail.com | | 41506894 | Isaac Valencia | 1995-03-22 | 2147483647 | carrera 45 #56-201 | isaacvalencia@gmail.com | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ 10 rows in set (0.001 sec) MariaDB [hospital]> decribe medico; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'decribe medico' at line 1 MariaDB [hospital]> describe medico; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | Id_medico | varchar(10) | NO | PRI | NULL | | | Nombre_Medico | varchar(50) | NO | | NULL | | | Turno | varchar(20) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 3 rows in set (0.020 sec) MariaDB [hospital]> insert into medico (Id_medico,Nombre_medico,Turmo) values ('100900400','MARIA MASO','DIA'),('200500600','ANTONIO AGUIRRE','DIURNO'),('300400500','ADELA MARIN','NOCHE'),('300500800','ERNESTO LOPERA','DIA'),('999000200','ROSA LOPEZ','NOCHE'),('999000300','HERNAN BENITEZ','DIA'),('999000400','CATERIN GIL','DIA'),('999000500','LEO TABORDA','DIURNO'); ERROR 1054 (42S22): Unknown column 'Turmo' in 'field list' MariaDB [hospital]> insert into medico (Id_medico,Nombre_medico,Turmo)values ('100900400','MARIA MASO','DIA'),('200500600','ANTONIO AGUIRRE','DIURNO'),('300400500','ADELA MARIN','NOCHE'),('300500800','ERNESTO LOPERA','DIA'),('999000200','ROSA LOPEZ','NOCHE'),('999000300','HERNAN BENITEZ','DIA'),('999000400','CATERIN GIL','DIA'),('999000500','LEO TABORDA','DIURNO'); ERROR 1054 (42S22): Unknown column 'Turmo' in 'field list' MariaDB [hospital]> insert into medico (Id_medico,Nombre_Mdico,Turno)values -> ('300400500','Adela Marin','Noche'), -> ('300500800','Ernesto Lopera','Dia'), -> ('200500600','Antonio Aguirre','Diurno'), -> ('100900400','Maria maso','Dia'), -> ('999000200','Rosa Lopez','Dia'), -> ('999000300','Hernan Benitez','Dia'), -> ('999000400','Caterine Gil','Dia'), -> ('99900500','Leo Taborda','Diurno'); ERROR 1054 (42S22): Unknown column 'Nombre_Mdico' in 'field list' MariaDB [hospital]> insert into medico (Id_medico,Nombre_Medico,Turno)values -> ('300400500','Adela Marin','Noche'), -> ('300500800','Ernesto Lopera','Dia'), -> ('200500600','Antonio Aguirre','Diurno'), -> ('100900400','Maria maso','Dia'), -> ('999000200','Rosa Lopez','Dia'), -> ('999000300','Hernan Benitez','Dia'), -> ('999000400','Caterine Gil','Dia'), -> ('99900500','Leo Taborda','Diurno'); Query OK, 8 rows affected (0.002 sec) Records: 8 Duplicates: 0 Warnings: 0 MariaDB [hospital]> select * from medico; +-----------+-----------------+--------+ | Id_medico | Nombre_Medico | Turno | +-----------+-----------------+--------+ | 100900400 | Maria maso | Dia | | 200500600 | Antonio Aguirre | Diurno | | 300400500 | Adela Marin | Noche | | 300500800 | Ernesto Lopera | Dia | | 999000200 | Rosa Lopez | Dia | | 999000300 | Hernan Benitez | Dia | | 999000400 | Caterine Gil | Dia | | 99900500 | Leo Taborda | Diurno | +-----------+-----------------+--------+ 8 rows in set (0.001 sec) MariaDB [hospital]> describe especialidad; +---------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------------+-------------+------+-----+---------+-------+ | Id_especialidad | varchar(10) | NO | PRI | NULL | | | Nombre_especialidad | varchar(50) | NO | | NULL | | | ubicacion | varchar(50) | NO | | NULL | | +---------------------+-------------+------+-----+---------+-------+ 3 rows in set (0.019 sec) MariaDB [hospital]> insert into especialidad (Id_especialidad,Nombre_especialidad,ubicacion)values -> ('0001','Neurologia','piso 1'), -> ('0002','Oftalmologia','Piso 2'), -> ('0003','Pediatria','Piso 3'), -> ('0004','toxicologia','Piso 4'), -> ('0005','Cardiologia','Piso 5'), -> ('0006','Urologia','Piso 6'), -> ('0007','Psiquiatria','Piso 7'), -> ('0008''Gastroenterologia','Piso 8'), -> ('0009','Geriatria','Piso 9'), -> ('0010','Medicina fisica','Piso 10'); ERROR 1136 (21S01): Column count doesn't match value count at row 8 MariaDB [hospital]> insert into especialidad (Id_especialidad,Nombre_especialidad,ubicacion)values -> ('0001','Neurologia','piso 1'), -> ('0002','Oftalmologia','Piso 2'), -> ('0003','Pediatria','Piso 3'), -> ('0004','toxicologia','Piso 4'), -> ('0005','Cardiologia','Piso 5'), -> ('0006','Urologia','Piso 6'), -> ('0007','Psiquiatria','Piso 7'), -> ('0008','Gastroenterologia','Piso 8'), -> ('0009','Geriatria','Piso 9'), -> ('0010','Medicina fisica','Piso 10'); Query OK, 10 rows affected (0.010 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [hospital]> select * from especialidad; +-----------------+---------------------+-----------+ | Id_especialidad | Nombre_especialidad | ubicacion | +-----------------+---------------------+-----------+ | 0001 | Neurologia | piso 1 | | 0002 | Oftalmologia | Piso 2 | | 0003 | Pediatria | Piso 3 | | 0004 | toxicologia | Piso 4 | | 0005 | Cardiologia | Piso 5 | | 0006 | Urologia | Piso 6 | | 0007 | Psiquiatria | Piso 7 | | 0008 | Gastroenterologia | Piso 8 | | 0009 | Geriatria | Piso 9 | | 0010 | Medicina fisica | Piso 10 | +-----------------+---------------------+-----------+ 10 rows in set (0.000 sec) MariaDB [hospital]> describe estado; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Id_estado | varchar(10) | NO | PRI | NULL | | | Descripcion | varchar(50) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 2 rows in set (0.019 sec) MariaDB [hospital]> insert into estado(Id_estado,Descripcion)values -> ('900000','DE ALTA'), -> ('800000','OBSERVACION'), -> ('700000','HOSPITALIZADO'), -> ('100099','FALLECIDO'); Query OK, 4 rows affected (0.002 sec) Records: 4 Duplicates: 0 Warnings: 0 MariaDB [hospital]> select * from estado; +-----------+---------------+ | Id_estado | Descripcion | +-----------+---------------+ | 100099 | FALLECIDO | | 700000 | HOSPITALIZADO | | 800000 | OBSERVACION | | 900000 | DE ALTA | +-----------+---------------+ 4 rows in set (0.000 sec) MariaDB [hospital]> describe ingreso; +-----------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+---------+----------------+ | Id_ingreso | int(11) | NO | PRI | NULL | auto_increment | | Fecha_Ingreso | date | NO | | NULL | | | Id_paciente | varchar(10) | NO | MUL | NULL | | | Id_especialidad | varchar(10) | NO | MUL | NULL | | | Id_medico | varchar(10) | NO | MUL | NULL | | | Id_estado | varchar(10) | NO | MUL | NULL | | +-----------------+-------------+------+-----+---------+----------------+ 6 rows in set (0.011 sec) MariaDB [hospital]> alter table ingreso auto_increment = 1; Query OK, 0 rows affected (0.011 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [hospital]> select * from ingreso; Empty set (0.000 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_escialidad,Id_medico,Id_estado)values -> ('2019-5-22','1146436052','0001','300400500','900000'); ERROR 1054 (42S22): Unknown column 'Id_escialidad' in 'field list' MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2019-5-22','1146436052','0001','300400500','900000'); Query OK, 1 row affected (0.006 sec) MariaDB [hospital]> select * from ingreso; +------------+---------------+-------------+-----------------+-----------+-----------+ | Id_ingreso | Fecha_Ingreso | Id_paciente | Id_especialidad | Id_medico | Id_estado | +------------+---------------+-------------+-----------------+-----------+-----------+ | 1 | 2019-05-22 | 1146436052 | 0001 | 300400500 | 900000 | +------------+---------------+-------------+-----------------+-----------+-----------+ 1 row in set (0.000 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2018-11-21' -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2 MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2018-11-21','21406452','0002','300500800','800000'), -> ('2018-8-5','1037535969','0003','200500600','700000'), -> ('2019-9-6','32469859','0004','100900400','100099'), -> ('2019-2-11','41506894','0005','999000200','800000'), -> ('2018-4-12','1406458332','0006','999000300','800000'), -> ('2019-5-18','38546459','0007','999000400','900000'), -> ('2019-6-26','1036552698','0008','999000500','700000'), -> ('2018-6-1','1024322365','0009','200500600','900000'), -> ('2019-2-20','1150352288','0010','100900400','900000'), -> ('2018-10-23','1406458332','0005','999000200','700000'), -> ('2019-7-29','21406452','0005','999000300','700000'), -> ('2018-8-16','1036552698','0008','300500800','900000'), -> ('2019-7-29','21406452','0009','999000300','900000'), -> ('2018-8-16','38546459','0007','999000500','700000'), -> ('2018-9-14','1037535969','0008','999000200','700000'), -> ('2019-12-8','1406458332','0002','999000300','800000'), -> ('2019-12-9','38546459','0001','300400500','800000'); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`hospital`.`ingreso`, CONSTRAINT `ingreso_ibfk_3` FOREIGN KEY (`Id_medico`) REFERENCES `medico` (`Id_medico`) ON DELETE CASCADE ON UPDATE CASCADE) MariaDB [hospital]> select * from ingreso; +------------+---------------+-------------+-----------------+-----------+-----------+ | Id_ingreso | Fecha_Ingreso | Id_paciente | Id_especialidad | Id_medico | Id_estado | +------------+---------------+-------------+-----------------+-----------+-----------+ | 1 | 2019-05-22 | 1146436052 | 0001 | 300400500 | 900000 | +------------+---------------+-------------+-----------------+-----------+-----------+ 1 row in set (0.001 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2018-11-21','21406452','0002','300500800','800000'); Query OK, 1 row affected (0.002 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2018-8-5','1037535969','0003','200500600','700000'), -> ('2019-9-6','32469859','0004','100900400','100099'), -> ('2019-2-11','41506894','0005','999000200','800000'), -> ('2018-4-12','1406458332','0006','999000300','800000'), -> ('2019-5-18','38546459','0007','999000400','900000'), -> ('2019-6-26','1036552698','0008','999000500','700000'), -> ('2018-6-1','1024322365','0009','200500600','900000'), -> ('2019-2-20','1150352288','0010','100900400','900000'), -> ('2018-10-23','1406458332','0005','999000200','700000'), -> ('2019-7-29','21406452','0005','999000300','700000'), -> ('2018-8-16','1036552698','0008','300500800','900000'), -> ('2019-7-29','21406452','0009','999000300','900000'), -> ('2018-8-16','38546459','0007','999000500','700000'), -> ('2018-9-14','1037535969','0008','999000200','700000'), -> ('2019-12-8','1406458332','0002','999000300','800000'), -> ('2019-12-9','38546459','0001','300400500','800000'); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`hospital`.`ingreso`, CONSTRAINT `ingreso_ibfk_3` FOREIGN KEY (`Id_medico`) REFERENCES `medico` (`Id_medico`) ON DELETE CASCADE ON UPDATE CASCADE) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2018-8-5','1037535969','0003','200500600','700000'); Query OK, 1 row affected (0.008 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2019-9-6','32469859','0004','100900400','100099'); Query OK, 1 row affected (0.008 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2019-2-11','41506894','0005','999000200','800000'); Query OK, 1 row affected (0.002 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2018-4-12','1406458332','0006','999000300','800000'); Query OK, 1 row affected (0.002 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2019-5-18','38546459','0007','999000400','900000'); Query OK, 1 row affected (0.007 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2019-6-26','1036552698','0008','999000500','700000'); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`hospital`.`ingreso`, CONSTRAINT `ingreso_ibfk_3` FOREIGN KEY (`Id_medico`) REFERENCES `medico` (`Id_medico`) ON DELETE CASCADE ON UPDATE CASCADE) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 MariaDB [hospital]> selec * from medico; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'selec * from medico' at line 1 MariaDB [hospital]> select * from medico; +-----------+-----------------+--------+ | Id_medico | Nombre_Medico | Turno | +-----------+-----------------+--------+ | 100900400 | Maria maso | Dia | | 200500600 | Antonio Aguirre | Diurno | | 300400500 | Adela Marin | Noche | | 300500800 | Ernesto Lopera | Dia | | 999000200 | Rosa Lopez | Dia | | 999000300 | Hernan Benitez | Dia | | 999000400 | Caterine Gil | Dia | | 99900500 | Leo Taborda | Diurno | +-----------+-----------------+--------+ 8 rows in set (0.001 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2019-6-26','1036552698','0008','99900500','700000'); Query OK, 1 row affected (0.009 sec) MariaDB [hospital]> select * from ingreso; +------------+---------------+-------------+-----------------+-----------+-----------+ | Id_ingreso | Fecha_Ingreso | Id_paciente | Id_especialidad | Id_medico | Id_estado | +------------+---------------+-------------+-----------------+-----------+-----------+ | 1 | 2019-05-22 | 1146436052 | 0001 | 300400500 | 900000 | | 19 | 2018-11-21 | 21406452 | 0002 | 300500800 | 800000 | | 36 | 2018-08-05 | 1037535969 | 0003 | 200500600 | 700000 | | 37 | 2019-09-06 | 32469859 | 0004 | 100900400 | 100099 | | 38 | 2019-02-11 | 41506894 | 0005 | 999000200 | 800000 | | 39 | 2018-04-12 | 1406458332 | 0006 | 999000300 | 800000 | | 40 | 2019-05-18 | 38546459 | 0007 | 999000400 | 900000 | | 42 | 2019-06-26 | 1036552698 | 0008 | 99900500 | 700000 | +------------+---------------+-------------+-----------------+-----------+-----------+ 8 rows in set (0.000 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2019-2-20','1150352288','0010','100900400','900000'), -> ('2018-10-23','1406458332','0005','999000200','700000'), -> ('2019-7-29','21406452','0005','999000300','700000'), -> ('2018-8-16','1036552698','0008','300500800','900000'), -> ('2019-7-29','21406452','0009','999000300','900000'), -> ('2018-8-16','38546459','0007','999000500','700000'), -> ('2018-9-14','1037535969','0008','999000200','700000'), -> ('2019-12-8','1406458332','0002','999000300','800000'), -> ('2019-12-9','38546459','0001','300400500','800000'); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`hospital`.`ingreso`, CONSTRAINT `ingreso_ibfk_3` FOREIGN KEY (`Id_medico`) REFERENCES `medico` (`Id_medico`) ON DELETE CASCADE ON UPDATE CASCADE) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2019-2-20','1150352288','0010','100900400','900000'); Query OK, 1 row affected (0.002 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2018-10-23','1406458332','0005','999000200','700000'); Query OK, 1 row affected (0.007 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2019-7-29','21406452','0005','999000300','700000'); Query OK, 1 row affected (0.007 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2018-8-16','1036552698','0008','300500800','900000'); Query OK, 1 row affected (0.007 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2019-7-29','21406452','0009','999000300','900000'); Query OK, 1 row affected (0.001 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2018-8-16','38546459','0007','999000500','700000'); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`hospital`.`ingreso`, CONSTRAINT `ingreso_ibfk_3` FOREIGN KEY (`Id_medico`) REFERENCES `medico` (`Id_medico`) ON DELETE CASCADE ON UPDATE CASCADE) MariaDB [hospital]> select * from medico; +-----------+-----------------+--------+ | Id_medico | Nombre_Medico | Turno | +-----------+-----------------+--------+ | 100900400 | Maria maso | Dia | | 200500600 | Antonio Aguirre | Diurno | | 300400500 | Adela Marin | Noche | | 300500800 | Ernesto Lopera | Dia | | 999000200 | Rosa Lopez | Dia | | 999000300 | Hernan Benitez | Dia | | 999000400 | Caterine Gil | Dia | | 99900500 | Leo Taborda | Diurno | +-----------+-----------------+--------+ 8 rows in set (0.001 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2018-8-16','38546459','0007','99900500','700000'); Query OK, 1 row affected (0.008 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2018-9-14','1037535969','0008','999000200','700000'); Query OK, 1 row affected (0.003 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2019-12-8','1406458332','0002','999000300','800000'); Query OK, 1 row affected (0.008 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2019-12-9','38546459','0001','300400500','800000'); Query OK, 1 row affected (0.002 sec) MariaDB [hospital]> select * from ingreso; +------------+---------------+-------------+-----------------+-----------+-----------+ | Id_ingreso | Fecha_Ingreso | Id_paciente | Id_especialidad | Id_medico | Id_estado | +------------+---------------+-------------+-----------------+-----------+-----------+ | 1 | 2019-05-22 | 1146436052 | 0001 | 300400500 | 900000 | | 19 | 2018-11-21 | 21406452 | 0002 | 300500800 | 800000 | | 36 | 2018-08-05 | 1037535969 | 0003 | 200500600 | 700000 | | 37 | 2019-09-06 | 32469859 | 0004 | 100900400 | 100099 | | 38 | 2019-02-11 | 41506894 | 0005 | 999000200 | 800000 | | 39 | 2018-04-12 | 1406458332 | 0006 | 999000300 | 800000 | | 40 | 2019-05-18 | 38546459 | 0007 | 999000400 | 900000 | | 42 | 2019-06-26 | 1036552698 | 0008 | 99900500 | 700000 | | 52 | 2019-02-20 | 1150352288 | 0010 | 100900400 | 900000 | | 53 | 2018-10-23 | 1406458332 | 0005 | 999000200 | 700000 | | 54 | 2019-07-29 | 21406452 | 0005 | 999000300 | 700000 | | 55 | 2018-08-16 | 1036552698 | 0008 | 300500800 | 900000 | | 56 | 2019-07-29 | 21406452 | 0009 | 999000300 | 900000 | | 58 | 2018-08-16 | 38546459 | 0007 | 99900500 | 700000 | | 59 | 2018-09-14 | 1037535969 | 0008 | 999000200 | 700000 | | 60 | 2019-12-08 | 1406458332 | 0002 | 999000300 | 800000 | | 61 | 2019-12-09 | 38546459 | 0001 | 300400500 | 800000 | +------------+---------------+-------------+-----------------+-----------+-----------+ 17 rows in set (0.000 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2019-6-26','1036552698','0008','999000500','700000'); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`hospital`.`ingreso`, CONSTRAINT `ingreso_ibfk_3` FOREIGN KEY (`Id_medico`) REFERENCES `medico` (`Id_medico`) ON DELETE CASCADE ON UPDATE CASCADE) MariaDB [hospital]> describe medico; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | Id_medico | varchar(10) | NO | PRI | NULL | | | Nombre_Medico | varchar(50) | NO | | NULL | | | Turno | varchar(20) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 3 rows in set (0.014 sec) MariaDB [hospital]> select * from medico; +-----------+-----------------+--------+ | Id_medico | Nombre_Medico | Turno | +-----------+-----------------+--------+ | 100900400 | Maria maso | Dia | | 200500600 | Antonio Aguirre | Diurno | | 300400500 | Adela Marin | Noche | | 300500800 | Ernesto Lopera | Dia | | 999000200 | Rosa Lopez | Dia | | 999000300 | Hernan Benitez | Dia | | 999000400 | Caterine Gil | Dia | | 99900500 | Leo Taborda | Diurno | +-----------+-----------------+--------+ 8 rows in set (0.001 sec) MariaDB [hospital]> insert into ingreso(Fecha_Ingreso,Id_paciente,Id_especialidad,Id_medico,Id_estado)values -> ('2019-6-26','1036552698','0008','99900500','700000'); Query OK, 1 row affected (0.002 sec) MariaDB [hospital]> select * from ingreso; +------------+---------------+-------------+-----------------+-----------+-----------+ | Id_ingreso | Fecha_Ingreso | Id_paciente | Id_especialidad | Id_medico | Id_estado | +------------+---------------+-------------+-----------------+-----------+-----------+ | 1 | 2019-05-22 | 1146436052 | 0001 | 300400500 | 900000 | | 19 | 2018-11-21 | 21406452 | 0002 | 300500800 | 800000 | | 36 | 2018-08-05 | 1037535969 | 0003 | 200500600 | 700000 | | 37 | 2019-09-06 | 32469859 | 0004 | 100900400 | 100099 | | 38 | 2019-02-11 | 41506894 | 0005 | 999000200 | 800000 | | 39 | 2018-04-12 | 1406458332 | 0006 | 999000300 | 800000 | | 40 | 2019-05-18 | 38546459 | 0007 | 999000400 | 900000 | | 42 | 2019-06-26 | 1036552698 | 0008 | 99900500 | 700000 | | 52 | 2019-02-20 | 1150352288 | 0010 | 100900400 | 900000 | | 53 | 2018-10-23 | 1406458332 | 0005 | 999000200 | 700000 | | 54 | 2019-07-29 | 21406452 | 0005 | 999000300 | 700000 | | 55 | 2018-08-16 | 1036552698 | 0008 | 300500800 | 900000 | | 56 | 2019-07-29 | 21406452 | 0009 | 999000300 | 900000 | | 58 | 2018-08-16 | 38546459 | 0007 | 99900500 | 700000 | | 59 | 2018-09-14 | 1037535969 | 0008 | 999000200 | 700000 | | 60 | 2019-12-08 | 1406458332 | 0002 | 999000300 | 800000 | | 61 | 2019-12-09 | 38546459 | 0001 | 300400500 | 800000 | | 63 | 2019-06-26 | 1036552698 | 0008 | 99900500 | 700000 | +------------+---------------+-------------+-----------------+-----------+-----------+ 18 rows in set (0.000 sec) MariaDB [hospital]> describe ingreso; +-----------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+---------+----------------+ | Id_ingreso | int(11) | NO | PRI | NULL | auto_increment | | Fecha_Ingreso | date | NO | | NULL | | | Id_paciente | varchar(10) | NO | MUL | NULL | | | Id_especialidad | varchar(10) | NO | MUL | NULL | | | Id_medico | varchar(10) | NO | MUL | NULL | | | Id_estado | varchar(10) | NO | MUL | NULL | | +-----------------+-------------+------+-----+---------+----------------+ 6 rows in set (0.014 sec) MariaDB [hospital]> exit MariaDB [hospital]> show tables; +--------------------+ | Tables_in_hospital | +--------------------+ | especialidad | | estado | | ingreso | | medico | | paciente | +--------------------+ 5 rows in set (0.038 sec) MariaDB [hospital]> describe ingreso; +-----------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+---------+----------------+ | Id_ingreso | int(11) | NO | PRI | NULL | auto_increment | | Fecha_Ingreso | date | NO | | NULL | | | Id_paciente | varchar(10) | NO | MUL | NULL | | | Id_especialidad | varchar(10) | NO | MUL | NULL | | | Id_medico | varchar(10) | NO | MUL | NULL | | | Id_estado | varchar(10) | NO | MUL | NULL | | +-----------------+-------------+------+-----+---------+----------------+ 6 rows in set (0.079 sec) MariaDB [hospital]> describe especialidad;; +---------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------------+-------------+------+-----+---------+-------+ | Id_especialidad | varchar(10) | NO | PRI | NULL | | | Nombre_especialidad | varchar(50) | NO | | NULL | | | ubicacion | varchar(50) | NO | | NULL | | +---------------------+-------------+------+-----+---------+-------+ 3 rows in set (0.032 sec) ERROR: No query specified MariaDB [hospital]> Delimiter // MariaDB [hospital]> delimiter // MariaDB [hospital]> end -> // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'end' at line 1 MariaDB [hospital]> end // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'end' at line 1 MariaDB [hospital]> delimiter ; MariaDB [hospital]> DELIMITER // MariaDB [hospital]> MariaDB [hospital]> cr‚ate procedure insertar(in p_Fecha_Ingreso DATE,in p_Id_paciente VARCHAR(10),in p_Id_especialidad VARCHAR(10),in p_Id_medico VARCHAR(10),in p_Id_estado VARCHAR(10)) -> begin -> insert into ingreso (Fecha_Ingreso, Id_paciente, Id_especialidad, Id_medico, Id_estado)values -> (p_Fecha_Ingreso, p_Id_paciente, p_Id_especialidad, p_Id_medico, p_Id_estado); -> end // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'cr‚ate procedure insertar(in p_Fecha_Ingreso DATE,in p_Id_paciente VARCHAR(1...' at line 1 MariaDB [hospital]> MariaDB [hospital]> delimiter ; MariaDB [hospital]> DELIMITER // MariaDB [hospital]> MariaDB [hospital]> CREATE PROCEDURE InsertIngreso( -> IN p_Fecha_Ingreso DATE, -> IN p_Id_paciente VARCHAR(10), -> IN p_Id_especialidad VARCHAR(10), -> IN p_Id_medico VARCHAR(10), -> IN p_Id_estado VARCHAR(10) -> ) -> BEGIN -> INSERT INTO ingreso (Fecha_Ingreso, Id_paciente, Id_especialidad, Id_medico, Id_estado) -> VALUES (p_Fecha_Ingreso, p_Id_paciente, p_Id_especialidad, p_Id_medico, p_Id_estado); -> END // Query OK, 0 rows affected (0.061 sec) MariaDB [hospital]> MariaDB [hospital]> DELIMITER ; MariaDB [hospital]> show procedure status; +----------+---------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +----------+---------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | hospital | InsertIngreso | PROCEDURE | root@localhost | 2024-08-15 19:06:29 | 2024-08-15 19:06:29 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | procolor | insertar | PROCEDURE | root@localhost | 2024-06-02 20:25:11 | 2024-06-02 20:25:11 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | procolor | listar | PROCEDURE | root@localhost | 2024-06-02 20:49:05 | 2024-06-02 20:49:05 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | +----------+---------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 3 rows in set (0.038 sec) MariaDB [hospital]> describe ingreso; +-----------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+---------+----------------+ | Id_ingreso | int(11) | NO | PRI | NULL | auto_increment | | Fecha_Ingreso | date | NO | | NULL | | | Id_paciente | varchar(10) | NO | MUL | NULL | | | Id_especialidad | varchar(10) | NO | MUL | NULL | | | Id_medico | varchar(10) | NO | MUL | NULL | | | Id_estado | varchar(10) | NO | MUL | NULL | | +-----------------+-------------+------+-----+---------+----------------+ 6 rows in set (0.024 sec) MariaDB [hospital]> call InsertIngreso('2024-08-15','12345678','0021','300420510','654321'); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`hospital`.`ingreso`, CONSTRAINT `ingreso_ibfk_1` FOREIGN KEY (`Id_paciente`) REFERENCES `paciente` (`Id_paciente`) ON DELETE CASCADE ON UPDATE CASCADE) MariaDB [hospital]> describe paciente; +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+-------+ | Id_paciente | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Fecha_nacimiento | date | NO | | NULL | | | Telefono | int(10) | NO | | NULL | | | Direccion | varchar(50) | YES | | NULL | | | Correo | varchar(100) | YES | | NULL | | +------------------+--------------+------+-----+---------+-------+ 6 rows in set (0.029 sec) MariaDB [hospital]> delimiter // MariaDB [hospital]> create procedute Insertar_paciente( -> in Id_paciente varchar(10), -> in Nombre varchar(50), -> in Fecha_nacimiento date, -> Telefono int(10), -> Direccion varchar(50), -> Correo varchar(100)) -> begin -> insert into paciente (Id_paciente,Nombre,Fecha_macimiento,Telefono,Direccion,correo) values -> (p_Id_paciente, p_Nombre, p_Fecha_nacimiento, p_Telefono, p_Direccion, p_Correo); -> end // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'procedute Insertar_paciente( in Id_paciente varchar(10), in Nombre varchar(50...' at line 1 MariaDB [hospital]> delimiter // MariaDB [hospital]> MariaDB [hospital]> create procedure insertar_paciente( -> in p_id_paciente varchar(10), -> in p_nombre varchar(50), -> in p_fecha_nacimiento date, -> in p_telefono int(10), -> in p_direccion varchar(50), -> in p_correo varchar(100) -> ) -> begin -> insert into paciente (id_paciente, nombre, fecha_nacimiento, telefono, direccion, correo) -> values (p_id_paciente, p_nombre, p_fecha_nacimiento, p_telefono, p_direccion, p_correo); -> end // Query OK, 0 rows affected (0.011 sec) MariaDB [hospital]> MariaDB [hospital]> delimiter ; MariaDB [hospital]> describe paciente; +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+-------+ | Id_paciente | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Fecha_nacimiento | date | NO | | NULL | | | Telefono | int(10) | NO | | NULL | | | Direccion | varchar(50) | YES | | NULL | | | Correo | varchar(100) | YES | | NULL | | +------------------+--------------+------+-----+---------+-------+ 6 rows in set (0.025 sec) MariaDB [hospital]> call insertar_paciente('1036599052','Juan Higuita','1990-01-21','calle 57A #65-32','juanhiguita@gmail.com'); ERROR 1318 (42000): Incorrect number of arguments for PROCEDURE hospital.insertar_paciente; expected 6, got 5 MariaDB [hospital]> call insertar_paciente('1036599052','Juan Higuita','1990-01-21',3205647812,calle 57A #65-32','juanhiguita@gmail.com'); -> ; ERROR 1054 (42S22): Unknown column 'calle' in 'field list' MariaDB [hospital]> call insertar_paciente('1036599052','Juan Higuita','1990-01-21',3205647812,'calle 57A #65-32','juanhiguita@gmail.com'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [hospital]> select * from paciente; +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | Id_paciente | Nombre | Fecha_nacimiento | Telefono | Direccion | Correo | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | 1024322365 | Camilo Caro | 2001-02-21 | 2147483647 | calle 32 #45-78 | camilocaro@gmail.com | | 1036552698 | Marta Jaramillo | 1999-10-18 | 2147483647 | carrera 103 #56-32 | martajaramillo@gmail.com | | 1036599052 | Juan Higuita | 1990-01-21 | 2147483647 | calle 57A #65-32 | juanhiguita@gmail.com | | 1037535969 | Robin Cardona | 1970-05-05 | 2147483647 | calle 32 #45-78 | robincardona@gmail.com | | 1146436052 | Marina Cifuentes | 1992-08-22 | 2147483647 | calle 57A #27-48 | marinacifuentes@gmail.com | | 1150352288 | Carolina Marin | 1983-02-03 | 2147483647 | carrera 86 #56-34 | carolinamarin@gmail.com | | 1406458332 | Paola Toro | 1974-09-09 | 2147483647 | calle 32 #46-78 | paolatoro@gmail.com | | 21406452 | Juan Mesa | 1985-11-08 | 2147483647 | carrera 45 #56-23 | juanmesa@gmail.com | | 32469859 | Maria Jose Bedoya | 1995-04-30 | 2147483647 | calle 101A #27-48 | mariajosebedoya@gmail.com | | 38546459 | Catalina Lopez | 1985-12-12 | 2147483647 | calle 57A #27-48 | catalinalopez@gmail.com | | 41506894 | Isaac Valencia | 1995-03-22 | 2147483647 | carrera 45 #56-201 | isaacvalencia@gmail.com | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ 11 rows in set (0.011 sec) MariaDB [hospital]> delimiter // MariaDB [hospital]> create procedure listar() -> begin -> select * from paciente; -> end -> -- -> -> -> -> -> -> -> -> // Query OK, 0 rows affected (0.010 sec) MariaDB [hospital]> delimiter ; MariaDB [hospital]> call listar(); +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | Id_paciente | Nombre | Fecha_nacimiento | Telefono | Direccion | Correo | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | 1024322365 | Camilo Caro | 2001-02-21 | 2147483647 | calle 32 #45-78 | camilocaro@gmail.com | | 1036552698 | Marta Jaramillo | 1999-10-18 | 2147483647 | carrera 103 #56-32 | martajaramillo@gmail.com | | 1036599052 | Juan Higuita | 1990-01-21 | 2147483647 | calle 57A #65-32 | juanhiguita@gmail.com | | 1037535969 | Robin Cardona | 1970-05-05 | 2147483647 | calle 32 #45-78 | robincardona@gmail.com | | 1146436052 | Marina Cifuentes | 1992-08-22 | 2147483647 | calle 57A #27-48 | marinacifuentes@gmail.com | | 1150352288 | Carolina Marin | 1983-02-03 | 2147483647 | carrera 86 #56-34 | carolinamarin@gmail.com | | 1406458332 | Paola Toro | 1974-09-09 | 2147483647 | calle 32 #46-78 | paolatoro@gmail.com | | 21406452 | Juan Mesa | 1985-11-08 | 2147483647 | carrera 45 #56-23 | juanmesa@gmail.com | | 32469859 | Maria Jose Bedoya | 1995-04-30 | 2147483647 | calle 101A #27-48 | mariajosebedoya@gmail.com | | 38546459 | Catalina Lopez | 1985-12-12 | 2147483647 | calle 57A #27-48 | catalinalopez@gmail.com | | 41506894 | Isaac Valencia | 1995-03-22 | 2147483647 | carrera 45 #56-201 | isaacvalencia@gmail.com | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ 11 rows in set (0.001 sec) Query OK, 0 rows affected (0.048 sec) MariaDB [hospital]> call listar(1036599052); ERROR 1318 (42000): Incorrect number of arguments for PROCEDURE hospital.listar; expected 0, got 1 MariaDB [hospital]> call listar('1036599052'); ERROR 1318 (42000): Incorrect number of arguments for PROCEDURE hospital.listar; expected 0, got 1 MariaDB [hospital]> call listar(); +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | Id_paciente | Nombre | Fecha_nacimiento | Telefono | Direccion | Correo | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | 1024322365 | Camilo Caro | 2001-02-21 | 2147483647 | calle 32 #45-78 | camilocaro@gmail.com | | 1036552698 | Marta Jaramillo | 1999-10-18 | 2147483647 | carrera 103 #56-32 | martajaramillo@gmail.com | | 1036599052 | Juan Higuita | 1990-01-21 | 2147483647 | calle 57A #65-32 | juanhiguita@gmail.com | | 1037535969 | Robin Cardona | 1970-05-05 | 2147483647 | calle 32 #45-78 | robincardona@gmail.com | | 1146436052 | Marina Cifuentes | 1992-08-22 | 2147483647 | calle 57A #27-48 | marinacifuentes@gmail.com | | 1150352288 | Carolina Marin | 1983-02-03 | 2147483647 | carrera 86 #56-34 | carolinamarin@gmail.com | | 1406458332 | Paola Toro | 1974-09-09 | 2147483647 | calle 32 #46-78 | paolatoro@gmail.com | | 21406452 | Juan Mesa | 1985-11-08 | 2147483647 | carrera 45 #56-23 | juanmesa@gmail.com | | 32469859 | Maria Jose Bedoya | 1995-04-30 | 2147483647 | calle 101A #27-48 | mariajosebedoya@gmail.com | | 38546459 | Catalina Lopez | 1985-12-12 | 2147483647 | calle 57A #27-48 | catalinalopez@gmail.com | | 41506894 | Isaac Valencia | 1995-03-22 | 2147483647 | carrera 45 #56-201 | isaacvalencia@gmail.com | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ 11 rows in set (0.000 sec) Query OK, 0 rows affected (0.040 sec) MariaDB [hospital]> delimiter // MariaDB [hospital]> create procedure eliminar_paciente(in Id_paciente int) -> begin -> delete from paciente where id = Id_paciente; -> end -> // Query OK, 0 rows affected (0.010 sec) MariaDB [hospital]> delimiter ; MariaDB [hospital]> call listar(); +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | Id_paciente | Nombre | Fecha_nacimiento | Telefono | Direccion | Correo | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | 1024322365 | Camilo Caro | 2001-02-21 | 2147483647 | calle 32 #45-78 | camilocaro@gmail.com | | 1036552698 | Marta Jaramillo | 1999-10-18 | 2147483647 | carrera 103 #56-32 | martajaramillo@gmail.com | | 1036599052 | Juan Higuita | 1990-01-21 | 2147483647 | calle 57A #65-32 | juanhiguita@gmail.com | | 1037535969 | Robin Cardona | 1970-05-05 | 2147483647 | calle 32 #45-78 | robincardona@gmail.com | | 1146436052 | Marina Cifuentes | 1992-08-22 | 2147483647 | calle 57A #27-48 | marinacifuentes@gmail.com | | 1150352288 | Carolina Marin | 1983-02-03 | 2147483647 | carrera 86 #56-34 | carolinamarin@gmail.com | | 1406458332 | Paola Toro | 1974-09-09 | 2147483647 | calle 32 #46-78 | paolatoro@gmail.com | | 21406452 | Juan Mesa | 1985-11-08 | 2147483647 | carrera 45 #56-23 | juanmesa@gmail.com | | 32469859 | Maria Jose Bedoya | 1995-04-30 | 2147483647 | calle 101A #27-48 | mariajosebedoya@gmail.com | | 38546459 | Catalina Lopez | 1985-12-12 | 2147483647 | calle 57A #27-48 | catalinalopez@gmail.com | | 41506894 | Isaac Valencia | 1995-03-22 | 2147483647 | carrera 45 #56-201 | isaacvalencia@gmail.com | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ 11 rows in set (0.001 sec) Query OK, 0 rows affected (0.042 sec) MariaDB [hospital]> eliminar_paciente(1036599052); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'eliminar_paciente(1036599052)' at line 1 MariaDB [hospital]> call eliminar_paciente(1036599052); ERROR 1054 (42S22): Unknown column 'id' in 'where clause' MariaDB [hospital]> call eliminar_paciente(1036599052); ERROR 1054 (42S22): Unknown column 'id' in 'where clause' MariaDB [hospital]> describe paciente; +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+-------+ | Id_paciente | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Fecha_nacimiento | date | NO | | NULL | | | Telefono | int(10) | NO | | NULL | | | Direccion | varchar(50) | YES | | NULL | | | Correo | varchar(100) | YES | | NULL | | +------------------+--------------+------+-----+---------+-------+ 6 rows in set (0.030 sec) MariaDB [hospital]> delimiter // MariaDB [hospital]> drop procedure if exists eliminar_paciente // Query OK, 0 rows affected (0.012 sec) MariaDB [hospital]> delimiter ; MariaDB [hospital]> delimiter // MariaDB [hospital]> create procedure eliminar_paciente(IN paciente_id varchar(10)) -> begin -> delete from paciente -> where Id_paciente = paciente_id; -> end // Query OK, 0 rows affected (0.009 sec) MariaDB [hospital]> delimiter ; MariaDB [hospital]> call listar(); +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | Id_paciente | Nombre | Fecha_nacimiento | Telefono | Direccion | Correo | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | 1024322365 | Camilo Caro | 2001-02-21 | 2147483647 | calle 32 #45-78 | camilocaro@gmail.com | | 1036552698 | Marta Jaramillo | 1999-10-18 | 2147483647 | carrera 103 #56-32 | martajaramillo@gmail.com | | 1036599052 | Juan Higuita | 1990-01-21 | 2147483647 | calle 57A #65-32 | juanhiguita@gmail.com | | 1037535969 | Robin Cardona | 1970-05-05 | 2147483647 | calle 32 #45-78 | robincardona@gmail.com | | 1146436052 | Marina Cifuentes | 1992-08-22 | 2147483647 | calle 57A #27-48 | marinacifuentes@gmail.com | | 1150352288 | Carolina Marin | 1983-02-03 | 2147483647 | carrera 86 #56-34 | carolinamarin@gmail.com | | 1406458332 | Paola Toro | 1974-09-09 | 2147483647 | calle 32 #46-78 | paolatoro@gmail.com | | 21406452 | Juan Mesa | 1985-11-08 | 2147483647 | carrera 45 #56-23 | juanmesa@gmail.com | | 32469859 | Maria Jose Bedoya | 1995-04-30 | 2147483647 | calle 101A #27-48 | mariajosebedoya@gmail.com | | 38546459 | Catalina Lopez | 1985-12-12 | 2147483647 | calle 57A #27-48 | catalinalopez@gmail.com | | 41506894 | Isaac Valencia | 1995-03-22 | 2147483647 | carrera 45 #56-201 | isaacvalencia@gmail.com | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ 11 rows in set (0.001 sec) Query OK, 0 rows affected (0.042 sec) MariaDB [hospital]> call eliminar_paciente(1036599052); Query OK, 1 row affected (0.010 sec) MariaDB [hospital]> call listar(); +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | Id_paciente | Nombre | Fecha_nacimiento | Telefono | Direccion | Correo | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | 1024322365 | Camilo Caro | 2001-02-21 | 2147483647 | calle 32 #45-78 | camilocaro@gmail.com | | 1036552698 | Marta Jaramillo | 1999-10-18 | 2147483647 | carrera 103 #56-32 | martajaramillo@gmail.com | | 1037535969 | Robin Cardona | 1970-05-05 | 2147483647 | calle 32 #45-78 | robincardona@gmail.com | | 1146436052 | Marina Cifuentes | 1992-08-22 | 2147483647 | calle 57A #27-48 | marinacifuentes@gmail.com | | 1150352288 | Carolina Marin | 1983-02-03 | 2147483647 | carrera 86 #56-34 | carolinamarin@gmail.com | | 1406458332 | Paola Toro | 1974-09-09 | 2147483647 | calle 32 #46-78 | paolatoro@gmail.com | | 21406452 | Juan Mesa | 1985-11-08 | 2147483647 | carrera 45 #56-23 | juanmesa@gmail.com | | 32469859 | Maria Jose Bedoya | 1995-04-30 | 2147483647 | calle 101A #27-48 | mariajosebedoya@gmail.com | | 38546459 | Catalina Lopez | 1985-12-12 | 2147483647 | calle 57A #27-48 | catalinalopez@gmail.com | | 41506894 | Isaac Valencia | 1995-03-22 | 2147483647 | carrera 45 #56-201 | isaacvalencia@gmail.com | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ 10 rows in set (0.000 sec) Query OK, 0 rows affected (0.037 sec) MariaDB [hospital]> describe paciente; +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+-------+ | Id_paciente | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Fecha_nacimiento | date | NO | | NULL | | | Telefono | int(10) | NO | | NULL | | | Direccion | varchar(50) | YES | | NULL | | | Correo | varchar(100) | YES | | NULL | | +------------------+--------------+------+-----+---------+-------+ 6 rows in set (0.027 sec) MariaDB [hospital]> delimiter // MariaDB [hospital]> create procedure modificar_paciente( -> in Id_paciente varchar(10), -> Nombre varchar(50), -> Fecha_nacimiento date, -> Telefono int(10), -> Direccion varchar(50), -> Correo varchar(100)) -> begin -> update paciente -> set Nombre = -> end // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 11 MariaDB [hospital]> end // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'end' at line 1 MariaDB [hospital]> delimiter ; MariaDB [hospital]> -- Cambia el delimitador a // MariaDB [hospital]> DELIMITER // MariaDB [hospital]> MariaDB [hospital]> -- Define el procedimiento almacenado MariaDB [hospital]> CREATE PROCEDURE modificar_paciente( -> IN paciente_id VARCHAR(10), -> IN nuevo_nombre VARCHAR(50), -> IN nuevo_correo VARCHAR(100) -> ) -> BEGIN -> UPDATE paciente -> SET Nombre = nuevo_nombre, -> Correo = nuevo_correo -> WHERE Id_paciente = paciente_id; -> END // Query OK, 0 rows affected (0.010 sec) MariaDB [hospital]> MariaDB [hospital]> -- Restaura el delimitador al punto y coma MariaDB [hospital]> DELIMITER ; MariaDB [hospital]> listar(); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'listar()' at line 1 MariaDB [hospital]> call listar(); +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | Id_paciente | Nombre | Fecha_nacimiento | Telefono | Direccion | Correo | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | 1024322365 | Camilo Caro | 2001-02-21 | 2147483647 | calle 32 #45-78 | camilocaro@gmail.com | | 1036552698 | Marta Jaramillo | 1999-10-18 | 2147483647 | carrera 103 #56-32 | martajaramillo@gmail.com | | 1037535969 | Robin Cardona | 1970-05-05 | 2147483647 | calle 32 #45-78 | robincardona@gmail.com | | 1146436052 | Marina Cifuentes | 1992-08-22 | 2147483647 | calle 57A #27-48 | marinacifuentes@gmail.com | | 1150352288 | Carolina Marin | 1983-02-03 | 2147483647 | carrera 86 #56-34 | carolinamarin@gmail.com | | 1406458332 | Paola Toro | 1974-09-09 | 2147483647 | calle 32 #46-78 | paolatoro@gmail.com | | 21406452 | Juan Mesa | 1985-11-08 | 2147483647 | carrera 45 #56-23 | juanmesa@gmail.com | | 32469859 | Maria Jose Bedoya | 1995-04-30 | 2147483647 | calle 101A #27-48 | mariajosebedoya@gmail.com | | 38546459 | Catalina Lopez | 1985-12-12 | 2147483647 | calle 57A #27-48 | catalinalopez@gmail.com | | 41506894 | Isaac Valencia | 1995-03-22 | 2147483647 | carrera 45 #56-201 | isaacvalencia@gmail.com | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ 10 rows in set (0.001 sec) Query OK, 0 rows affected (0.038 sec) MariaDB [hospital]> call modificar_paciente('1024322365','Andres Cortes','andrescortes@gmail.com'); Query OK, 1 row affected (0.008 sec) MariaDB [hospital]> call listar(); +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | Id_paciente | Nombre | Fecha_nacimiento | Telefono | Direccion | Correo | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ | 1024322365 | Andres Cortes | 2001-02-21 | 2147483647 | calle 32 #45-78 | andrescortes@gmail.com | | 1036552698 | Marta Jaramillo | 1999-10-18 | 2147483647 | carrera 103 #56-32 | martajaramillo@gmail.com | | 1037535969 | Robin Cardona | 1970-05-05 | 2147483647 | calle 32 #45-78 | robincardona@gmail.com | | 1146436052 | Marina Cifuentes | 1992-08-22 | 2147483647 | calle 57A #27-48 | marinacifuentes@gmail.com | | 1150352288 | Carolina Marin | 1983-02-03 | 2147483647 | carrera 86 #56-34 | carolinamarin@gmail.com | | 1406458332 | Paola Toro | 1974-09-09 | 2147483647 | calle 32 #46-78 | paolatoro@gmail.com | | 21406452 | Juan Mesa | 1985-11-08 | 2147483647 | carrera 45 #56-23 | juanmesa@gmail.com | | 32469859 | Maria Jose Bedoya | 1995-04-30 | 2147483647 | calle 101A #27-48 | mariajosebedoya@gmail.com | | 38546459 | Catalina Lopez | 1985-12-12 | 2147483647 | calle 57A #27-48 | catalinalopez@gmail.com | | 41506894 | Isaac Valencia | 1995-03-22 | 2147483647 | carrera 45 #56-201 | isaacvalencia@gmail.com | +-------------+-------------------+------------------+------------+--------------------+---------------------------+ 10 rows in set (0.000 sec) Query OK, 0 rows affected (0.036 sec) MariaDB [hospital]> exit