MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | biblioteca | | clinica | | colegio | | escuela | | fechas | | information_schema | | libreria | | matricula | | matricula2 | | mysql | | otros | | performance_schema | | phpmyadmin | | practicaf | | subconsultas | | taller2 | | test | | trespastore | | turismo | +--------------------+ 19 rows in set (0.515 sec) MariaDB [(none)]> use clinica; Database changed MariaDB [clinica]> show tables; +-------------------+ | Tables_in_clinica | +-------------------+ | ingreso | | medico | | paciente | | status | +-------------------+ 4 rows in set (0.002 sec) MariaDB [clinica]> select *from ingreso; +-----------+------------+------------+----------+----------+ | Idingreso | Fecha | Cedula | Idmedico | Idstatus | +-----------+------------+------------+----------+----------+ | 1 | 2021-01-25 | 1001159997 | 001 | 0007 | | 2 | 2020-12-28 | 56789012 | 005 | 0003 | | 2 | 2020-12-28 | 56789012 | 002 | 0003 | | 3 | 2021-01-15 | 26322915 | 006 | 0005 | | 4 | 2020-12-31 | 1012038379 | 003 | 0001 | +-----------+------------+------------+----------+----------+ 5 rows in set (0.297 sec) MariaDB [clinica]> select *from medico; +----------+--------------------------+--------------------+ | Idmedico | Nombre | Especialidad | +----------+--------------------------+--------------------+ | 001 | Ricardo Mena Ortiz | Medicina General | | 002 | Rene Velasquez Molina | Medicina Intensiva | | 003 | Oscar Lavalle Lopez | Pediatria | | 004 | Laura Trespalacios Mu¤oz | Medicina Interna | | 005 | Sofia Barrientos Avila | Neumologia | | 006 | Alejandro Acosta Arcucci | Cardiologia | | 007 | Enrique Medina Hernandez | Medicina General | | 008 | Oscar Alfredo Ruggeri | Traumatologia | | 009 | Heidy Zapata Ospina | Cirugia General | | 010 | Dania Thanela Narvaez | Neurologia | +----------+--------------------------+--------------------+ 10 rows in set (0.200 sec) MariaDB [clinica]> select *from paciente; +------------+-----------------------------------------+------+---------------+------------+-----------+ | Cedula | Nombre | Edad | Eps | Telefono | Direccion | +------------+-----------------------------------------+------+---------------+------------+-----------+ | 1001159997 | Sofia Vargas Iba¤ez | 25 | Colsanitas | 3136579088 | Medellin | | 1010039369 | Christian Camilo Trespalacios Palacios | 20 | Sumedical | 3008346830 | Barbosa | | 1012038379 | Luisa Fernanda Cardona | 10 | Salud Total | 3734576 | Sabaneta | | 1101880098 | Carmen Lucia Camacho Barcos | 32 | SURA | 3137661223 | Cali | | 1182101201 | Jheraldin Pelaez | 19 | Medimas | 3055678901 | Itagui | | 1213501201 | Daniela Rivera Duque | 35 | Salud Total | 3023712651 | Envigado | | 26322915 | Eugenia Barcos Martinez | 63 | Sumedical | 3116217416 | Quibdo | | 32291622 | Juan Manuel Mendoza | 30 | Coomeva | 2667790 | Medellin | | 35981036 | Addy Jackeline Palacios Barcos | 40 | Nueva Eps | 3297544 | Itagui | | 54255457 | Cruz Ana Palacios Barcos | 50 | Sumedical | 3122427664 | Barbosa | | 56789012 | Enriqueta Hernandez Gonzalez | 70 | Savia | 3114563210 | Bello | +------------+-----------------------------------------+------+---------------+------------+-----------+ 11 rows in set (0.074 sec) MariaDB [clinica]> select *from status; +----------+------------------+----------------+ | Idstatus | Observaci¢n | Estado_Pac | +----------+------------------+----------------+ | 0001 | FIEBRE | HOSPITALIZADO | | 0002 | MALESTAR GENERAL | EN OBSERVACIàN | | 0003 | SINTOMAS COVID | HOSPITALIZADO | | 0004 | ACCIDENTE | FALLECIDO | | 0005 | PREINFARTO | HOSPITALIZADO | | 0006 | INTOXICACIàN | DE ALTA | | 0007 | MALESTAR GENERAL | DE ALTA | +----------+------------------+----------------+ 7 rows in set (0.072 sec) MariaDB [clinica]> select *from ingreso; +-----------+------------+------------+----------+----------+ | Idingreso | Fecha | Cedula | Idmedico | Idstatus | +-----------+------------+------------+----------+----------+ | 1 | 2021-01-25 | 1001159997 | 001 | 0007 | | 2 | 2020-12-28 | 56789012 | 005 | 0003 | | 2 | 2020-12-28 | 56789012 | 002 | 0003 | | 3 | 2021-01-15 | 26322915 | 006 | 0005 | | 4 | 2020-12-31 | 1012038379 | 003 | 0001 | +-----------+------------+------------+----------+----------+ 5 rows in set (0.001 sec) MariaDB [clinica]> insert into ingreso(Idingreso,Fecha,Cedula,Idmedico,Idstatus) values(5,'2021-01-01','1182101201','008','0009'); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`clinica`.`ingreso`, CONSTRAINT `ingreso_ibfk_3` FOREIGN KEY (`Idstatus`) REFERENCES `status` (`Idstatus`) ON DELETE CASCADE ON UPDATE CASCADE) MariaDB [clinica]> Delimiter // MariaDB [clinica]> Create procedure listar_paciente() -> Begin -> Select *from paciente; -> End -> // Query OK, 0 rows affected (0.602 sec) MariaDB [clinica]> Delimiter ; MariaDB [clinica]> Delimiter // MariaDB [clinica]> Create procedure listar_medico() -> Begin -> Select *from medico; -> End -> // Query OK, 0 rows affected (0.013 sec) MariaDB [clinica]> Delimiter ; MariaDB [clinica]> Delimiter // MariaDB [clinica]> Create procedure listar_status() -> begin -> select *from status; -> end -> // Query OK, 0 rows affected (0.016 sec) MariaDB [clinica]> delimiter ; MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure listar_ingreso() -> begin -> select *from ingreso; -> end -> // Query OK, 0 rows affected (0.017 sec) MariaDB [clinica]> delimiter ; MariaDB [clinica]> show procedure status; +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | clinica | insertar_ingreso | PROCEDURE | root@localhost | 2021-02-01 15:00:35 | 2021-02-01 15:00:35 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_medico | PROCEDURE | root@localhost | 2021-02-01 14:49:56 | 2021-02-01 14:49:56 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_paciente | PROCEDURE | root@localhost | 2021-02-01 14:43:42 | 2021-02-01 14:43:42 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_status | PROCEDURE | root@localhost | 2021-02-01 14:52:39 | 2021-02-01 14:52:39 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_ingreso | PROCEDURE | root@localhost | 2021-02-12 11:12:07 | 2021-02-12 11:12:07 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_medico | PROCEDURE | root@localhost | 2021-02-12 11:10:41 | 2021-02-12 11:10:41 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_paciente | PROCEDURE | root@localhost | 2021-02-12 11:09:32 | 2021-02-12 11:09:32 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_status | PROCEDURE | root@localhost | 2021-02-12 11:11:30 | 2021-02-12 11:11:30 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | matricula | consultar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:47:02 | 2020-11-10 18:47:02 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | eliminar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:55:12 | 2020-11-10 18:55:12 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:27:16 | 2020-11-10 18:27:16 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | listar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:40:43 | 2020-11-10 18:40:43 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | trespastore | consultar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:42:44 | 2020-11-10 19:42:44 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | trespastore | eliminar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:45:42 | 2020-11-10 19:45:42 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | trespastore | insertar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:34:11 | 2020-11-10 19:34:11 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | trespastore | listar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:39:40 | 2020-11-10 19:39:40 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 16 rows in set (0.459 sec) MariaDB [clinica]> Delimiter // MariaDB [clinica]> create procedure cons_paciente(in cedula varchar(10)) -> Begin -> Select *from paciente where cedula=cedula; -> end -> // Query OK, 0 rows affected (0.038 sec) MariaDB [clinica]> delimiter ; MariaDB [clinica]> create procedure cons_medico(in Idmedico varchar(10)) -> begin -> select *from medico where Idmedico=Idmedico; 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 3 MariaDB [clinica]> delimiter ; MariaDB [clinica]> create procedure cons_medico(in idmedico varchar(10)) -> begin -> select *from medico where idmedico=idmedico; 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 3 MariaDB [clinica]> Delimiter // MariaDB [clinica]> create procedure cons_medico(in Idmedico varchar(10)) -> begin -> select *from medico where Idmedico=Idmedico; -> end -> // Query OK, 0 rows affected (0.014 sec) MariaDB [clinica]> delimiter ; MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure cons_status(in Idstatus varchar(10)) -> begin -> select *from status where Idstatus=Idstatus; -> end -> // Query OK, 0 rows affected (0.014 sec) MariaDB [clinica]> delimiter ; MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure cons_ingreso(in Idingreso int(5)) -> begin -> select *from ingreso where Idingreso=Idingreso; -> end -> // Query OK, 0 rows affected (0.014 sec) MariaDB [clinica]> delimiter ; MariaDB [clinica]> show procedure status; +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | clinica | cons_ingreso | PROCEDURE | root@localhost | 2021-02-12 11:27:41 | 2021-02-12 11:27:41 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | cons_medico | PROCEDURE | root@localhost | 2021-02-12 11:24:54 | 2021-02-12 11:24:54 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | cons_paciente | PROCEDURE | root@localhost | 2021-02-12 11:19:06 | 2021-02-12 11:19:06 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | cons_status | PROCEDURE | root@localhost | 2021-02-12 11:26:19 | 2021-02-12 11:26:19 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_ingreso | PROCEDURE | root@localhost | 2021-02-01 15:00:35 | 2021-02-01 15:00:35 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_medico | PROCEDURE | root@localhost | 2021-02-01 14:49:56 | 2021-02-01 14:49:56 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_paciente | PROCEDURE | root@localhost | 2021-02-01 14:43:42 | 2021-02-01 14:43:42 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_status | PROCEDURE | root@localhost | 2021-02-01 14:52:39 | 2021-02-01 14:52:39 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_ingreso | PROCEDURE | root@localhost | 2021-02-12 11:12:07 | 2021-02-12 11:12:07 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_medico | PROCEDURE | root@localhost | 2021-02-12 11:10:41 | 2021-02-12 11:10:41 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_paciente | PROCEDURE | root@localhost | 2021-02-12 11:09:32 | 2021-02-12 11:09:32 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_status | PROCEDURE | root@localhost | 2021-02-12 11:11:30 | 2021-02-12 11:11:30 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | matricula | consultar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:47:02 | 2020-11-10 18:47:02 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | eliminar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:55:12 | 2020-11-10 18:55:12 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:27:16 | 2020-11-10 18:27:16 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | listar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:40:43 | 2020-11-10 18:40:43 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | trespastore | consultar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:42:44 | 2020-11-10 19:42:44 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | trespastore | eliminar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:45:42 | 2020-11-10 19:45:42 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | trespastore | insertar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:34:11 | 2020-11-10 19:34:11 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | trespastore | listar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:39:40 | 2020-11-10 19:39:40 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 20 rows in set (0.341 sec) MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure eli_paciente(in Cedula varchar(10)) -> begin -> delete from paciente where cedula=cedula; -> end -> // Query OK, 0 rows affected (0.015 sec) MariaDB [clinica]> delimiter ; MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure eli_medico(in Idmedico varchar(10)) -> begin -> delete from medico where Idmedico=Idmedico; -> end -> // Query OK, 0 rows affected (0.014 sec) MariaDB [clinica]> delimiter ; MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure eli_status(in Idstatus varchar(10)) -> begin -> delete from status where Idstatus=Idstatus; -> End -> // Query OK, 0 rows affected (0.093 sec) MariaDB [clinica]> delimiter ; MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure eli_ingreso(in Idingreso int(5)) -> begin -> delete from ingreso where Idingreso=Idingreso; -> end -> // Query OK, 0 rows affected (0.017 sec) MariaDB [clinica]> delimiter ; MariaDB [clinica]> show procedure status; +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | clinica | cons_ingreso | PROCEDURE | root@localhost | 2021-02-12 11:27:41 | 2021-02-12 11:27:41 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | cons_medico | PROCEDURE | root@localhost | 2021-02-12 11:24:54 | 2021-02-12 11:24:54 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | cons_paciente | PROCEDURE | root@localhost | 2021-02-12 11:19:06 | 2021-02-12 11:19:06 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | cons_status | PROCEDURE | root@localhost | 2021-02-12 11:26:19 | 2021-02-12 11:26:19 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | eli_ingreso | PROCEDURE | root@localhost | 2021-02-12 11:32:06 | 2021-02-12 11:32:06 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | eli_medico | PROCEDURE | root@localhost | 2021-02-12 11:30:14 | 2021-02-12 11:30:14 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | eli_paciente | PROCEDURE | root@localhost | 2021-02-12 11:29:31 | 2021-02-12 11:29:31 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | eli_status | PROCEDURE | root@localhost | 2021-02-12 11:31:13 | 2021-02-12 11:31:13 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_ingreso | PROCEDURE | root@localhost | 2021-02-01 15:00:35 | 2021-02-01 15:00:35 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_medico | PROCEDURE | root@localhost | 2021-02-01 14:49:56 | 2021-02-01 14:49:56 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_paciente | PROCEDURE | root@localhost | 2021-02-01 14:43:42 | 2021-02-01 14:43:42 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_status | PROCEDURE | root@localhost | 2021-02-01 14:52:39 | 2021-02-01 14:52:39 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_ingreso | PROCEDURE | root@localhost | 2021-02-12 11:12:07 | 2021-02-12 11:12:07 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_medico | PROCEDURE | root@localhost | 2021-02-12 11:10:41 | 2021-02-12 11:10:41 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_paciente | PROCEDURE | root@localhost | 2021-02-12 11:09:32 | 2021-02-12 11:09:32 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_status | PROCEDURE | root@localhost | 2021-02-12 11:11:30 | 2021-02-12 11:11:30 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | matricula | consultar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:47:02 | 2020-11-10 18:47:02 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | eliminar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:55:12 | 2020-11-10 18:55:12 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:27:16 | 2020-11-10 18:27:16 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | listar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:40:43 | 2020-11-10 18:40:43 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | trespastore | consultar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:42:44 | 2020-11-10 19:42:44 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | trespastore | eliminar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:45:42 | 2020-11-10 19:45:42 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | trespastore | insertar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:34:11 | 2020-11-10 19:34:11 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | trespastore | listar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:39:40 | 2020-11-10 19:39:40 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 24 rows in set (0.071 sec) MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure mod_paciente(in Nombre varchar(50), in Eps varchar(50)) -> begin -> Update paciente set nombre=nombre where eps=eps; -> end -> // Query OK, 0 rows affected (0.018 sec) MariaDB [clinica]> delimiter ; MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure mod_medico(in Idmedico varchar(10), in Nombre varchar(50)) -> begin -> update medico set nombre=nombre where Idmedico=Idmedico; -> end -> // Query OK, 0 rows affected (0.018 sec) MariaDB [clinica]> delimiter ; MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure mod_status(in Idstatus varchar(10), in observacion varchar(50)) -> begin -> update status set observacion=observacion where Idstatus=Idstatus; -> end -> // Query OK, 0 rows affected (0.027 sec) MariaDB [clinica]> delimiter ; MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure mod_ingreso(in Idingreso int(5), in Cedula varchar(10)) -> begin -> update ingreso set Idingreso=Idingreso where cedula=cedula; -> end -> // Query OK, 0 rows affected (0.014 sec) MariaDB [clinica]> delimiter ; MariaDB [clinica]> show procedure status; +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | clinica | cons_ingreso | PROCEDURE | root@localhost | 2021-02-12 11:27:41 | 2021-02-12 11:27:41 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | cons_medico | PROCEDURE | root@localhost | 2021-02-12 11:24:54 | 2021-02-12 11:24:54 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | cons_paciente | PROCEDURE | root@localhost | 2021-02-12 11:19:06 | 2021-02-12 11:19:06 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | cons_status | PROCEDURE | root@localhost | 2021-02-12 11:26:19 | 2021-02-12 11:26:19 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | eli_ingreso | PROCEDURE | root@localhost | 2021-02-12 11:32:06 | 2021-02-12 11:32:06 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | eli_medico | PROCEDURE | root@localhost | 2021-02-12 11:30:14 | 2021-02-12 11:30:14 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | eli_paciente | PROCEDURE | root@localhost | 2021-02-12 11:29:31 | 2021-02-12 11:29:31 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | eli_status | PROCEDURE | root@localhost | 2021-02-12 11:31:13 | 2021-02-12 11:31:13 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_ingreso | PROCEDURE | root@localhost | 2021-02-01 15:00:35 | 2021-02-01 15:00:35 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_medico | PROCEDURE | root@localhost | 2021-02-01 14:49:56 | 2021-02-01 14:49:56 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_paciente | PROCEDURE | root@localhost | 2021-02-01 14:43:42 | 2021-02-01 14:43:42 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | insertar_status | PROCEDURE | root@localhost | 2021-02-01 14:52:39 | 2021-02-01 14:52:39 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_ingreso | PROCEDURE | root@localhost | 2021-02-12 11:12:07 | 2021-02-12 11:12:07 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_medico | PROCEDURE | root@localhost | 2021-02-12 11:10:41 | 2021-02-12 11:10:41 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_paciente | PROCEDURE | root@localhost | 2021-02-12 11:09:32 | 2021-02-12 11:09:32 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | listar_status | PROCEDURE | root@localhost | 2021-02-12 11:11:30 | 2021-02-12 11:11:30 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | mod_ingreso | PROCEDURE | root@localhost | 2021-02-12 11:43:16 | 2021-02-12 11:43:16 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | mod_medico | PROCEDURE | root@localhost | 2021-02-12 11:39:01 | 2021-02-12 11:39:01 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | mod_paciente | PROCEDURE | root@localhost | 2021-02-12 11:36:34 | 2021-02-12 11:36:34 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | clinica | mod_status | PROCEDURE | root@localhost | 2021-02-12 11:41:19 | 2021-02-12 11:41:19 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | matricula | consultar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:47:02 | 2020-11-10 18:47:02 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | eliminar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:55:12 | 2020-11-10 18:55:12 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:27:16 | 2020-11-10 18:27:16 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | listar_alumno | PROCEDURE | root@localhost | 2020-11-10 18:40:43 | 2020-11-10 18:40:43 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | trespastore | consultar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:42:44 | 2020-11-10 19:42:44 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | trespastore | eliminar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:45:42 | 2020-11-10 19:45:42 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | trespastore | insertar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:34:11 | 2020-11-10 19:34:11 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | trespastore | listar_proveedor | PROCEDURE | root@localhost | 2020-11-10 19:39:40 | 2020-11-10 19:39:40 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 28 rows in set (0.141 sec) MariaDB [clinica]> call insertar_ingreso(5,'2021-01-01','1182101201','008','0009'); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`clinica`.`ingreso`, CONSTRAINT `ingreso_ibfk_3` FOREIGN KEY (`Idstatus`) REFERENCES `status` (`Idstatus`) ON DELETE CASCADE ON UPDATE CASCADE) MariaDB [clinica]> exit