MariaDB [(none)]> create database clinica; Query OK, 1 row affected (0.056 sec) MariaDB [(none)]> use clinica; Database changed MariaDB [clinica]> show tables; Empty set (0.035 sec) MariaDB [clinica]> create table paciente(Cedula varchar(10) not null primary key, -> Nombre varchar(50) not null, -> Edad int(3) not null, -> Telefono varchar(15) not null, -> Direccion varchar(50) not null); Query OK, 0 rows affected (0.242 sec) MariaDB [clinica]> describe paciente; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Cedula | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Edad | int(3) | NO | | NULL | | | Telefono | varchar(15) | NO | | NULL | | | Direccion | varchar(50) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.081 sec) MariaDB [clinica]> create table medico(Idmedico varchar (10) not null, -> Nombre varchar(50) not null, -> Especialidad varchar(50) not null); Query OK, 0 rows affected (0.254 sec) MariaDB [clinica]> create table status(Idstatus varchar(10) primary key not null, -> Observaci¢n varchar(50) not null); Query OK, 0 rows affected (0.353 sec) MariaDB [clinica]> delete 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 '' at line 1 MariaDB [clinica]> drop table medico; Query OK, 0 rows affected (0.048 sec) MariaDB [clinica]> show tables; +-------------------+ | Tables_in_clinica | +-------------------+ | paciente | | status | +-------------------+ 2 rows in set (0.002 sec) MariaDB [clinica]> create table medico(Idmedico varchar (10) primary key not null, -> -> Nombre varchar(50) not null, -> Especialidad 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 '-> Nombre varchar(50) not null, Especialidad varchar(50) not null)' at line 2 MariaDB [clinica]> create table medico(Idmedico varchar (10) primary key not null, -> Nombre varchar(50) not null, -> Especialidad varchar(50) not null); Query OK, 0 rows affected (0.274 sec) MariaDB [clinica]> describe medico; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | Idmedico | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Especialidad | varchar(50) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 3 rows in set (0.080 sec) MariaDB [clinica]> describe status; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Idstatus | varchar(10) | NO | PRI | NULL | | | Observaci¢n | varchar(50) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 2 rows in set (0.081 sec) MariaDB [clinica]> describe paciente; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Cedula | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Edad | int(3) | NO | | NULL | | | Telefono | varchar(15) | NO | | NULL | | | Direccion | varchar(50) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.077 sec) MariaDB [clinica]> create table ingreso(Idingreso int(5) not null, -> Fecha DATE, -> Diagnostico varchar(50) not null, -> Cedula varchar(10) not null, -> Idmedico varchar(10) not null, -> Idstatus varchar(10) not null, -> foreign key(cedula) references paciente(cedula) on delete cascade on update cascade, -> foreign key(idmedico) references medico(idmedico) on delete cascade on update cascade, -> foreign key(idstatus) references status(idstatus) on delete cascade on update cascade); Query OK, 0 rows affected (0.131 sec) MariaDB [clinica]> describe ingreso; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Idingreso | int(5) | NO | | NULL | | | Fecha | date | YES | | NULL | | | Diagnostico | varchar(50) | NO | | NULL | | | Cedula | varchar(10) | NO | MUL | NULL | | | Idmedico | varchar(10) | NO | MUL | NULL | | | Idstatus | varchar(10) | NO | MUL | NULL | | +-------------+-------------+------+-----+---------+-------+ 6 rows in set (0.149 sec) MariaDB [clinica]> exit MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | biblioteca | | clinica | | colegio | | escuela | | fechas | | information_schema | | libreria | | matricula | | matricula2 | | mysql | | otros | | performance_schema | | phpmyadmin | | subconsultas | | taller2 | | test | | trespastore | | turismo | +--------------------+ 18 rows in set (0.179 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]> describe paciente; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Cedula | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Edad | int(3) | NO | | NULL | | | Telefono | varchar(15) | NO | | NULL | | | Direccion | varchar(50) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.265 sec) MariaDB [clinica]> alter table paciente add Eps varchar(50) not null after Edad; Query OK, 0 rows affected (0.260 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [clinica]> describe paciente; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Cedula | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Edad | int(3) | NO | | NULL | | | Eps | varchar(50) | NO | | NULL | | | Telefono | varchar(15) | NO | | NULL | | | Direccion | varchar(50) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 6 rows in set (0.107 sec) MariaDB [clinica]> describe medico; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | Idmedico | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Especialidad | varchar(50) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 3 rows in set (0.103 sec) MariaDB [clinica]> describe status; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Idstatus | varchar(10) | NO | PRI | NULL | | | Observaci¢n | varchar(50) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 2 rows in set (0.077 sec) MariaDB [clinica]> alter table status add Estado_Pac varchar(50) not null after Observaci¢n; Query OK, 0 rows affected (0.071 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [clinica]> describe status; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Idstatus | varchar(10) | NO | PRI | NULL | | | Observaci¢n | varchar(50) | NO | | NULL | | | Estado_Pac | varchar(50) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 3 rows in set (0.061 sec) MariaDB [clinica]> describe ingreso; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Idingreso | int(5) | NO | | NULL | | | Fecha | date | YES | | NULL | | | Diagnostico | varchar(50) | NO | | NULL | | | Cedula | varchar(10) | NO | MUL | NULL | | | Idmedico | varchar(10) | NO | MUL | NULL | | | Idstatus | varchar(10) | NO | MUL | NULL | | +-------------+-------------+------+-----+---------+-------+ 6 rows in set (0.172 sec) MariaDB [clinica]> alter table ingreso drop Diagnostico; Query OK, 0 rows affected (0.096 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [clinica]> describe ingreso; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Idingreso | int(5) | NO | | NULL | | | Fecha | date | YES | | NULL | | | Cedula | varchar(10) | NO | MUL | NULL | | | Idmedico | varchar(10) | NO | MUL | NULL | | | Idstatus | varchar(10) | NO | MUL | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.082 sec) MariaDB [clinica]> describe status; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Idstatus | varchar(10) | NO | PRI | NULL | | | Observaci¢n | varchar(50) | NO | | NULL | | | Estado_Pac | varchar(50) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 3 rows in set (0.060 sec) MariaDB [clinica]> show tables; +-------------------+ | Tables_in_clinica | +-------------------+ | ingreso | | medico | | paciente | | status | +-------------------+ 4 rows in set (0.002 sec) MariaDB [clinica]> delimiter// -> create procedure insertar_paciente(in Cedula varchar(10), in Nombre varchar(50), in Edad int(3), in Eps varchar(50), in Telefono varchar(15), in Direccion varchar(50)) -> begin -> Insert into paciente(Cedula,Nombre,Edad,Eps,Telefono,Direccion) values(Cedula,Nombre,Edad,Eps,Telefono,Direccion); 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 'delimiter// create procedure insertar_paciente(in Cedula varchar(10), in Nomb...' at line 1 MariaDB [clinica]> MariaDB [clinica]> ; ERROR: No query specified MariaDB [clinica]> delimiter// -> create procedure insertar_paciente(in Cedula varchar(10), in Nombre varchar(50), in Edad int(3), in Eps varchar(50), in Telefono varchar(15), in Direccion varchar(50)) -> begin -> insert into paciente values(Cedula,Nombre,Edad,Eps,Telefono,Direccion); 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 'delimiter//create procedure insertar_paciente(in Cedula varchar(10), in Nombr...' at line 1 MariaDB [clinica]> ; ERROR: No query specified MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure insertar_paciente(in Cedula varchar(10), in Nombre varchar(50), in Edad int(3), in Eps varchar(50), in Telefono varchar(15), in Direccion varchar(50)) -> begin -> Insert into paciente(Cedula,Nombre,Edad,Eps,Telefono,Direccion) values(Cedula,Nombre,Edad,Eps,Telefono,Direccion); -> end -> // Query OK, 0 rows affected (0.125 sec) MariaDB [clinica]> show procedure status; -> ; -> . -> delimiter; -> sd -> ; -> a -> // +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | 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 | | 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 | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 9 rows in set (0.179 sec) 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 '; . delimiter;sd ; a' at line 1 MariaDB [clinica]> show procedure status; -> delimiter ; -> ; -> // +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | 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 | | 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 | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 9 rows in set (0.077 sec) 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 'delimiter' at line 1 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_paciente | PROCEDURE | root@localhost | 2021-02-01 14:43:42 | 2021-02-01 14:43:42 | 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 | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 9 rows in set (0.055 sec) MariaDB [clinica]> describe medico; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | Idmedico | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Especialidad | varchar(50) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 3 rows in set (0.058 sec) MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure insertar_medico( in Idmedico varchar(10),in Nombre varchar(50),in Especialidad varchar(50)) -> begin -> insert into medico(Idmedico,Nombre,Especialidad) values(Idmedico,Nombre,Especialidad); -> end -> // Query OK, 0 rows affected (0.016 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_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 | | 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 | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 10 rows in set (0.166 sec) MariaDB [clinica]> describe status; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Idstatus | varchar(10) | NO | PRI | NULL | | | Observaci¢n | varchar(50) | NO | | NULL | | | Estado_Pac | varchar(50) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 3 rows in set (0.053 sec) MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure insertar_status( in Idstatus varchar(10), in Observacion varchar(50), in Estado_Pac varchar(50)) -> begin -> Insert into status(Idstatus,Observacion,Estado_Pac) values(IdStatus,Observacion,Estado_Pac); -> 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 | 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 | | 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 | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 11 rows in set (0.075 sec) MariaDB [clinica]> describe ingreso; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Idingreso | int(5) | NO | | NULL | | | Fecha | date | YES | | NULL | | | Cedula | varchar(10) | NO | MUL | NULL | | | Idmedico | varchar(10) | NO | MUL | NULL | | | Idstatus | varchar(10) | NO | MUL | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.091 sec) MariaDB [clinica]> delimiter // MariaDB [clinica]> create procedure insertar_ingreso(in Idingreso int(5), in Fecha date, in Cedula varchar(10), in Idmedico varchar(10), in Idstatus varchar(10)) -> begin -> Insert into ingreso(Idingreso,Fecha,Cedula,Idmedico,Idstatus) values(Idingreso,Fecha,Cedula,Idmedico,Idstatus); -> end -> // Query OK, 0 rows affected (0.026 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 | | 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 | +-------------+---------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 12 rows in set (0.157 sec) MariaDB [clinica]> show create procedure insertar_paciente; +-------------------+-----------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +-------------------+-----------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | insertar_paciente | NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`root`@`localhost` PROCEDURE `insertar_paciente`(in Cedula varchar(10), in Nombre varchar(50), in Edad int(3), in Eps varchar(50), in Telefono varchar(15), in Direccion varchar(50)) begin Insert into paciente(Cedula,Nombre,Edad,Eps,Telefono,Direccion) values(Cedula,Nombre,Edad,Eps,Telefono,Direccion); end | cp850 | cp850_general_ci | utf8mb4_general_ci | +-------------------+-----------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.030 sec) MariaDB [clinica]> show create procedure insertar_medico; +-----------------+-----------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +-----------------+-----------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | insertar_medico | NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`root`@`localhost` PROCEDURE `insertar_medico`( in Idmedico varchar(10),in Nombre varchar(50),in Especialidad varchar(50)) begin insert into medico(Idmedico,Nombre,Especialidad) values(Idmedico,Nombre,Especialidad); end | cp850 | cp850_general_ci | utf8mb4_general_ci | +-----------------+-----------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.001 sec) MariaDB [clinica]> show create procedure insertar_status; +-----------------+-----------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +-----------------+-----------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | insertar_status | NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`root`@`localhost` PROCEDURE `insertar_status`( in Idstatus varchar(10), in Observacion varchar(50), in Estado_Pac varchar(50)) begin Insert into status(Idstatus,Observacion,Estado_Pac) values(IdStatus,Observacion,Estado_Pac); end | cp850 | cp850_general_ci | utf8mb4_general_ci | +-----------------+-----------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.001 sec) MariaDB [clinica]> show create procedure insertar_ingreso; +------------------+-----------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +------------------+-----------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | insertar_ingreso | NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`root`@`localhost` PROCEDURE `insertar_ingreso`(in Idingreso int(5), in Fecha date, in Cedula varchar(10), in Idmedico varchar(10), in Idstatus varchar(10)) begin Insert into ingreso(Idingreso,Fecha,Cedula,Idmedico,Idstatus) values(Idingreso,Fecha,Cedula,Idmedico,Idstatus); end | cp850 | cp850_general_ci | utf8mb4_general_ci | +------------------+-----------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.001 sec) MariaDB [clinica]> describe paciente; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Cedula | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Edad | int(3) | NO | | NULL | | | Eps | varchar(50) | NO | | NULL | | | Telefono | varchar(15) | NO | | NULL | | | Direccion | varchar(50) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 6 rows in set (0.116 sec) MariaDB [clinica]> call insertar_paciente('54255457',' Cruz Ana Palacios Barcos ',50,' Sumedical ','3122427664','Barbosa'); Query OK, 1 row affected (0.079 sec) MariaDB [clinica]> select *from paciente; +----------+----------------------------+------+-------------+------------+-----------+ | Cedula | Nombre | Edad | Eps | Telefono | Direccion | +----------+----------------------------+------+-------------+------------+-----------+ | 54255457 | Cruz Ana Palacios Barcos | 50 | Sumedical | 3122427664 | Barbosa | +----------+----------------------------+------+-------------+------------+-----------+ 1 row in set (0.009 sec) MariaDB [clinica]> call insertar_paciente('26322915',' Eugenia Barcos Martinez ',63,' Sumedical ','3116217416','Quibdo'), ('1101880098',' Carmen Lucia Camacho Barcos ',32,' SURA ','3137661223','Cali'),('35981036',' Addy Jackeline Palacios Barcos ',40,' Nueva Eps ','3297544','Itagui'); 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 ' ('1101880098',' Carmen Lucia Camacho Barcos ',32,' SURA ','3137661223','Cali...' at line 1 MariaDB [clinica]> ; ERROR: No query specified MariaDB [clinica]> call insertar_paciente('26322915',' Eugenia Barcos Martinez ',63,' Sumedical ','3116217416','Quibdo'), ('35981036',' Addy Jackeline Palacios Barcos ',40,' Nueva Eps ','3297544','Itagui'); 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 ' ('35981036',' Addy Jackeline Palacios Barcos ',40,' Nueva Eps ','3297544','I...' at line 1 MariaDB [clinica]> call insertar_paciente('26322915',' Eugenia Barcos Martinez ',63,' Sumedical ','3116217416','Quibdo'); Query OK, 1 row affected (0.036 sec) MariaDB [clinica]> call insertar_paciente ('35981036',' Addy Jackeline Palacios Barcos ',40,' Nueva Eps ','3297544','Itagui'); Query OK, 1 row affected (0.023 sec) MariaDB [clinica]> call insertar_paciente ('1101880098',' Carmen Lucia Camacho Barcos ',32,' SURA ','3137661223','Cali'); Query OK, 1 row affected (0.004 sec) MariaDB [clinica]> select *from paciente; +------------+----------------------------------+------+-------------+------------+-----------+ | Cedula | Nombre | Edad | Eps | Telefono | Direccion | +------------+----------------------------------+------+-------------+------------+-----------+ | 1101880098 | Carmen Lucia Camacho Barcos | 32 | SURA | 3137661223 | Cali | | 26322915 | Eugenia Barcos Martinez | 63 | Sumedical | 3116217416 | Quibdo | | 35981036 | Addy Jackeline Palacios Barcos | 40 | Nueva Eps | 3297544 | Itagui | | 54255457 | Cruz Ana Palacios Barcos | 50 | Sumedical | 3122427664 | Barbosa | +------------+----------------------------------+------+-------------+------------+-----------+ 4 rows in set (0.001 sec) MariaDB [clinica]> insert into paciente(Cedula,Nombre,Edad,Eps,Telefono,Direccion) values ('1010039369',' Christian Camilo Trespalacios Palacios',20,' Sumedical ','3008346830','Barbosa'), ('32291622',' Juan Manuel Mendoza ',30,' Coomeva ','2667790','Medellin'); Query OK, 2 rows affected (0.005 sec) Records: 2 Duplicates: 0 Warnings: 0 MariaDB [clinica]> select *from paciente; +------------+-----------------------------------------+------+-------------+------------+-----------+ | Cedula | Nombre | Edad | Eps | Telefono | Direccion | +------------+-----------------------------------------+------+-------------+------------+-----------+ | 1010039369 | Christian Camilo Trespalacios Palacios | 20 | Sumedical | 3008346830 | Barbosa | | 1101880098 | Carmen Lucia Camacho Barcos | 32 | SURA | 3137661223 | Cali | | 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 | +------------+-----------------------------------------+------+-------------+------------+-----------+ 6 rows in set (0.001 sec) MariaDB [clinica]> insert into paciente(Cedula,Nombre,Edad,Eps,Telefono,Direccion) values ('1182101201',' Jheraldin Pelaez ',19,' Medimas ','3055678901','Itagui'), ('1001159997',' Sofia Vargas Iba¤ez ',25,' Colsanitas ','3136579088','Medellin'); Query OK, 2 rows affected (0.006 sec) Records: 2 Duplicates: 0 Warnings: 0 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 | | 1101880098 | Carmen Lucia Camacho Barcos | 32 | SURA | 3137661223 | Cali | | 1182101201 | Jheraldin Pelaez | 19 | Medimas | 3055678901 | Itagui | | 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 | +------------+-----------------------------------------+------+--------------+------------+-----------+ 8 rows in set (0.001 sec) MariaDB [clinica]> insert into paciente(Cedula,Nombre,Edad,Eps,Telefono,Direccion) values ('1213501201',' Daniela Rivera Duque ',35,' Salud Total ','3023712651','Envigado'), ('56789012',' Enriqueta Hernandez Gonzalez ',70,' Savia ','3114563210','Bello'); Query OK, 2 rows affected (0.004 sec) Records: 2 Duplicates: 0 Warnings: 0 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 | | 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 | +------------+-----------------------------------------+------+---------------+------------+-----------+ 10 rows in set (0.001 sec) MariaDB [clinica]> describe medico; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | Idmedico | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Especialidad | varchar(50) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 3 rows in set (0.072 sec) MariaDB [clinica]> insert into medico(Idmedico,Nombre,Especialidad) values('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'); Query OK, 5 rows affected (0.005 sec) Records: 5 Duplicates: 0 Warnings: 0 MariaDB [clinica]> insert into medico(Idmedico,Nombre,Especialidad) values('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'); Query OK, 5 rows affected (0.333 sec) Records: 5 Duplicates: 0 Warnings: 0 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.044 sec) MariaDB [clinica]> insert into paciente(Cedula,Nombre,Edad,Eps,Telefono,Direccion) values ('1012038379',' Luisa Fernanda Cardona ',10,' Salud Total ','3734576','Sabaneta'); Query OK, 1 row affected (0.006 sec) MariaDB [clinica]> describe status; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Idstatus | varchar(10) | NO | PRI | NULL | | | Observaci¢n | varchar(50) | NO | | NULL | | | Estado_Pac | varchar(50) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 3 rows in set (0.378 sec) MariaDB [clinica]> insert into status(Idstatus,Observaci¢n,Estado_Pac) value('0001','Hospitalizado','Ingresado'); Query OK, 1 row affected (0.016 sec) MariaDB [clinica]> delete from status where '0001'; Query OK, 1 row affected (0.070 sec) MariaDB [clinica]> select *from status; Empty set (0.001 sec) MariaDB [clinica]> insert into status(Idstatus,Observaci¢n,Estado_Pac) value('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'); Query OK, 7 rows affected (0.007 sec) Records: 7 Duplicates: 0 Warnings: 0 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.001 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.001 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.002 sec) MariaDB [clinica]> describe status; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Idstatus | varchar(10) | NO | PRI | NULL | | | Observaci¢n | varchar(50) | NO | | NULL | | | Estado_Pac | varchar(50) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 3 rows in set (0.139 sec) MariaDB [clinica]> describe ingreso; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Idingreso | int(5) | NO | | NULL | | | Fecha | date | YES | | NULL | | | Cedula | varchar(10) | NO | MUL | NULL | | | Idmedico | varchar(10) | NO | MUL | NULL | | | Idstatus | varchar(10) | NO | MUL | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.179 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.001 sec) MariaDB [clinica]> insert into ingreso(IdIngreso,Fecha,Cedula,Idmedico,Idstatus) values (01,'2021-01-25','1001159997','001','0007'); Query OK, 1 row affected (0.046 sec) MariaDB [clinica]> select *from ingreso; +-----------+------------+------------+----------+----------+ | Idingreso | Fecha | Cedula | Idmedico | Idstatus | +-----------+------------+------------+----------+----------+ | 1 | 2021-01-25 | 1001159997 | 001 | 0007 | +-----------+------------+------------+----------+----------+ 1 row in set (0.003 sec) MariaDB [clinica]> insert into ingreso(IdIngreso,Fecha,Cedula,Idmedico,Idstatus) values (02,'2020-12-28','56789012','005','0003'),(02,'2020-12-28','56789012','002','0003'); Query OK, 2 rows affected (0.006 sec) Records: 2 Duplicates: 0 Warnings: 0 MariaDB [clinica]> insert into ingreso(IdIngreso,Fecha,Cedula,Idmedico,Idstatus) values (03,'2021-01-15','26322915','006','0005'),(04,'2020-12-31','1012038379','007','0004'); Query OK, 2 rows affected (0.004 sec) Records: 2 Duplicates: 0 Warnings: 0 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 | 007 | 0004 | +-----------+------------+------------+----------+----------+ 5 rows in set (0.001 sec) MariaDB [clinica]> exit MariaDB [(none)]> use clinica; Database changed MariaDB [clinica]> show tables; +-------------------+ | Tables_in_clinica | +-------------------+ | ingreso | | medico | | paciente | | status | +-------------------+ 4 rows in set (0.020 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 | 007 | 0004 | +-----------+------------+------------+----------+----------+ 5 rows in set (0.326 sec) MariaDB [clinica]> delete from ingreso where idngreso = '4'; ERROR 1054 (42S22): Unknown column 'idngreso' in 'where clause' MariaDB [clinica]> delete from ingreso where idingreso = '4'; Query OK, 1 row affected (0.016 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 rows in set (0.001 sec) MariaDB [clinica]> insert into ingreso(IdIngreso,Fecha,Cedula,Idmedico,Idstatus) values (04,'2020-12-31','1012038379','003','0001'); Query OK, 1 row affected (0.007 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-1','1182101201','008','0009'),(6,'2021-01-17','1213501201','010','0010'),(7,'2021-01-26','32291622','009','0004'), (8.'2021-01-29','54255457','004','0002'); 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 ''2021-01-29','54255457','004','0002')' at line 1 MariaDB [clinica]> insert into ingreso(IdIngreso,Fecha,Cedula,Idmedico,Idstatus) values (5,'2021-01-1','1182101201','008','0009'),(6,'2021-01-17','1213501201','010','0010'),(7,'2021-01-26','32291622','009','0004'), (8,'2021-01-29','54255457','004','0002'); 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]> insert into ingreso(IdIngreso,Fecha,Cedula,Idmedico,Idstatus) values (05,'2021-01-1','1182101201','008','0009'),(06,'2021-01-17','1213501201','010','0010'),(07,'2021-01-26','32291622','009','0004'), (08,'2021-01-29','54255457','004','0002'); 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]> insert into ingreso(IdIngreso,Fecha,Cedula,Idmedico,Idstatus) values (05,'2021-01-1','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]> 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 (04,'2020-12-31','1012038379','003','0001'); Query OK, 1 row affected (0.006 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 | | 4 | 2020-12-31 | 1012038379 | 003 | 0001 | +-----------+------------+------------+----------+----------+ 6 rows in set (0.001 sec) MariaDB [clinica]> delete from ingreso where idingreso = '4'; Query OK, 2 rows affected (0.006 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 rows in set (0.002 sec) MariaDB [clinica]> insert into ingreso(IdIngreso,Fecha,Cedula,Idmedico,Idstatus) values (04,'2020-12-31','1012038379','003','0001'); Query OK, 1 row affected (0.020 sec) MariaDB [clinica]> insert into ingreso(IdIngreso,Fecha,Cedula,Idmedico,Idstatus) values (05,'2021-01-1','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]> insert into ingreso(IdIngreso,Fecha,Cedula,Idmedico,Idstatus) values(05,'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