Microsoft Windows [Versión 10.0.22621.1992]
(c) Microsoft Corporation. Todos los derechos reservados.

C:\Users\Harold Martinez>cd/xampp/mysql/bin

C:\xampp\mysql\bin>mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.4.24-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database DBUrgencias;
Query OK, 1 row affected (0.002 sec)

MariaDB [(none)]> use DBUrgencias;
Database changed
MariaDB [DBUrgencias]> create table paciente(codpaciente varchar(4) not null primary key,      
    -> nombre varchar(50) not null,
    -> edad varchar(3) not null,
    -> direccion varchar(20),   
    -> telefono varchar(10) not null,     
    -> email varchar (20) not null);
Query OK, 0 rows affected (0.009 sec)

MariaDB [DBUrgencias]> create table examen(codexamen varchar(4) not null primary key,      
    -> descripcion varchar(50) not null);
Query OK, 0 rows affected (0.010 sec)

MariaDB [DBUrgencias]> create table planta(codplanta varchar(4) not null primary key,      
    -> descripcion varchar(50) not null,     
    -> codexamen varchar(4) not null,
    -> foreign key(codexamen) references examen(codexamen) on delete cascade on update cascade);
Query OK, 0 rows affected (0.011 sec)

MariaDB [DBUrgencias]> create table doctor(coddoctor varchar(4) not null primary key,      
    -> nombre varchar(50) not null,
    -> especialidad varchar(20) not null,
    -> telefono varchar(10) not null,     
    -> email varchar (20) not null);
Query OK, 0 rows affected (0.009 sec)

MariaDB [DBUrgencias]> create table paciexamen
    -> (codexamen varchar(4) not null,
    ->  codpaciente varchar(4) not null,
    ->  foreign key(codexamen) references examen(codexamen) on delete cascade on update cascade, foreign key(codpaciente) references paciente(codpaciente) on delete cascade on update cascade);
Query OK, 0 rows affected (0.012 sec)

MariaDB [DBUrgencias]> create table plantadoc
    -> (codplanta varchar(4) not null,
    ->  coddoctor varchar(4) not null,
    ->  foreign key(codplanta) references planta(codplanta) on delete cascade on update cascade, foreign key(coddoctor) references doctor(coddoctor) on delete cascade on update cascade);
Query OK, 0 rows affected (0.012 sec)

MariaDB [DBUrgencias]> insert into bodega(codpaciente, nombre, edad, direccion, telefono, email) values('P01','ACEVEDO BURITICA JUAN ESTEBAN','20','Barrio la pradera','5846069','juanestebacardona@gmail.com');
ERROR 1146 (42S02): Table 'dburgencias.bodega' doesn't exist
MariaDB [DBUrgencias]> insert into paciente(codpaciente, nombre, edad, direccion, telefono, email) values('P01','ACEVEDO BURITICA JUAN ESTEBAN','20','Barrio la pradera','5846069','juanestebacardona@gmail.com');
Query OK, 1 row affected, 1 warning (0.009 sec)

MariaDB [DBUrgencias]> insert into paciente(codpaciente, nombre, edad, direccion, telefono, email) values('P02','ALVAREZ AGUDELO ESTEBAN','5','Barrio rosaleda','5882104','estebanlavarez@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into paciente(codpaciente, nombre, edad, direccion, telefono, email) values('P03','ZAPATA CAMPIÑO ISABEL','45','Barrio Aragon','5841998','zapataisabel@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into paciente(codpaciente, nombre, edad, direccion, telefono, email) values('P04','VALLE VELASQUEZ SOFIA','32','Barrio la pradera','2791469','sofiavelasquez@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into paciente(codpaciente, nombre, edad, direccion, telefono, email) values('P05','MORENO POSADA DIEGO ALEJANDRO','48','Urbanizacion compartir','2868617','diegomoreno@gmail.com');
Query OK, 1 row affected, 2 warnings (0.002 sec)

MariaDB [DBUrgencias]> insert into paciente(codpaciente, nombre, edad, direccion, telefono, email) values('P06','LZATE ORTIZ JORGE MARIO','10','Urbanización ciudadela prado ','5841497','marioalzae@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into paciente(codpaciente, nombre, edad, direccion, telefono, email) values('P07','ZAPATA QUINTERO JOSE MARIA','24','Barrio Sangabriel','5840570','josezapata@gmail.com');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into paciente(codpaciente, nombre, edad, direccion, telefono, email) values('P08','MNTOYA MONTOYA AEJANDRO','79','Barrio la pradera','3767289','alejandromontoya@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into paciente(codpaciente, nombre, edad, direccion, telefono, email) values('P09','LOPERA CARTAGENA LUISA FENANADA','28','Barrio el limonar 1','5709957','luisalopera@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into paciente(codpaciente, nombre, edad, direccion, telefono, email) values('P10','JARAMILLO HENAO JOSE LUIS','3','Barrio el limonar2','2866222','josearamillo@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into paciente(codpaciente, nombre, edad, direccion, telefono, email) values('P11','ALVAREZ AGUDELO LUNA','18','Barrio rosaleda','5882104','lunaalvarez@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into paciente(codpaciente, nombre, edad, direccion, telefono, email) values('P12','ALVAREZ AGUDELO XAVIER','15','Barrio rosaleda','5882104','xavieralvarez@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into examen(codexamen, descripcion) values('E02','CONTUSION');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into examen(codexamen, descripcion) values('E03','DOLOR ESTOMAGO');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into examen(codexamen, descripcion) values('E04','FRACTURA');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into examen(codexamen, descripcion) values('E05','PARO RESPIRATORIO');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into examen(codexamen, descripcion) values('E06','PARO CARDIACO');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into examen(codexamen, descripcion) values('E07','INFECCION');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into examen(codexamen, descripcion) values('E08','HEMORRAGIA');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into examen(codexamen, descripcion) values('E09','HERIDA ABIERTA');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into examen(codexamen, descripcion) values('E10','ALERGIA');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into planta(codplanta, descripcion, codexamen) values('PL01','CARDOLOGIA','E06');
Query OK, 1 row affected (0.004 sec)

MariaDB [DBUrgencias]> insert into planta(codplanta, descripcion, codexamen) values('PL02','PEDIATRIA','E01');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into planta(codplanta, descripcion, codexamen) values('PL03','CIRUGIA','E04');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into planta(codplanta, descripcion, codexamen) values('PL04','DERMATOLOGIA','E10');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into planta(codplanta, descripcion, codexamen) values('PL05','HEMATOLOGIA','E08');
Query OK, 1 row affected (0.001 sec)

MariaDB [DBUrgencias]> insert into planta(codplanta, descripcion, codexamen) values('PL06','REHABILITACION','E05');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into planta(codplanta, descripcion, codexamen) values('PL07','NEUROLOGIA','E07');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into planta(codplanta, descripcion, codexamen) values('PL08','ODONTOLOGIA','E09');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into planta(codplanta, descripcion, codexamen) values('PL09','ORTOPEDIA','E02');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into planta(codplanta, descripcion, codexamen) values('PL10','PSIQUIATRIA','E03');
Query OK, 1 row affected (0.001 sec)

MariaDB [DBUrgencias]> insert into doctor(coddoctor, nombre, especialidad, telefono, email) values('D01','CIFUENTES MESA MYEIDY MARIA','ODONTOLOGA','5846069','myleidym.iearm@gmail.com');
Query OK, 1 row affected, 1 warning (0.004 sec)

MariaDB [DBUrgencias]> insert into doctor(coddoctor, nombre, especialidad, telefono, email) values('D02','CUADRADO PEREZ ADRID JOSE','PEDIATRA','5882104','adrid.iearm@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into doctor(coddoctor, nombre, especialidad, telefono, email) values('D03','DUQUE RESTREPO ESTER LUCIA','NEUROLOGO','5841998','esterl.iearm@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into doctor(coddoctor, nombre, especialidad, telefono, email) values('D04','GUIRALES MAURICIO','GINECOLOGO','2791469','mauriciog.iearm@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into doctor(coddoctor, nombre, especialidad, telefono, email) values('D05','VERA DAZA MARIA ELENA','PSIQUIATRA','2868617','mariae.iearm@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into doctor(coddoctor, nombre, especialidad, telefono, email) values('D06','PALACIO TOMAS FELIPE','CIRUJANO','5841497','tomasf.iearm@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into doctor(coddoctor, nombre, especialidad, telefono, email) values('D07','MOSUERA OSORIO MARYETH','GENERAL','5840570','maryeth.iearm@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into doctor(coddoctor, nombre, especialidad, telefono, email) values('D08','ARBOLEDA VARGAS MARIA OFELIA','GENERAL','3767289','ofeliaa.iearm@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into doctor(coddoctor, nombre, especialidad, telefono, email) values('D09','MOSCOTE MARULANDA YANET MARIA','GENERAL','5709957','yanetm.iearm@gmail.com');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [DBUrgencias]> insert into doctor(coddoctor, nombre, especialidad, telefono, email) values('D10','MACIAS EDGAR ALBERTO','GENERAL','2866222','edgarm.iearm@gmail.com');
Query OK, 1 row affected, 1 warning (0.001 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P01','E01');
Query OK, 1 row affected (0.005 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P02','E02');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P03','E03');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P04','E04');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P05','E05');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P06','E06');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P07','E07');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P08','E08');
Query OK, 1 row affected (0.001 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P09','E09');
Query OK, 1 row affected (0.001 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P10','E10');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P11','E03');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P12','E04');
Query OK, 1 row affected (0.001 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P01','E05');
Query OK, 1 row affected (0.001 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P02','E06');
Query OK, 1 row affected (0.001 sec)

MariaDB [DBUrgencias]> insert into paciexamen(codpaciente, codexamen) values('P03','E01');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into plantadoc(codplanta, coddoctor) values('PL01','D01');
Query OK, 1 row affected (0.004 sec)

MariaDB [DBUrgencias]> insert into plantadoc(codplanta, coddoctor) values('PL02','D02');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into plantadoc(codplanta, coddoctor) values('PL03','D03');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into plantadoc(codplanta, coddoctor) values('PL04','D04');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into plantadoc(codplanta, coddoctor) values('PL05','D05');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into plantadoc(codplanta, coddoctor) values('PL06','D06');
Query OK, 1 row affected (0.001 sec)

MariaDB [DBUrgencias]> insert into plantadoc(codplanta, coddoctor) values('PL07','D07');
Query OK, 1 row affected (0.001 sec)

MariaDB [DBUrgencias]> insert into plantadoc(codplanta, coddoctor) values('PL08','D08');
Query OK, 1 row affected (0.001 sec)

MariaDB [DBUrgencias]> insert into plantadoc(codplanta, coddoctor) values('PL09','D01');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> insert into plantadoc(codplanta, coddoctor) values('PL10','D02');
Query OK, 1 row affected (0.002 sec)

MariaDB [DBUrgencias]> show tables;
+-----------------------+
| Tables_in_dburgencias |
+-----------------------+
| doctor                |
| examen                |
| paciente              |
| paciexamen            |
| planta                |
| plantadoc             |
+-----------------------+
6 rows in set (0.001 sec)

MariaDB [DBUrgencias]> select * from paciente;
+-------------+---------------------------------+------+----------------------+----------+----------------------+
| codpaciente | nombre                          | edad | direccion            | telefono | email                |
+-------------+---------------------------------+------+----------------------+----------+----------------------+
| P01         | ACEVEDO BURITICA JUAN ESTEBAN   | 20   | Barrio la pradera    | 5846069  | juanestebacardona@gm |
| P02         | ALVAREZ AGUDELO ESTEBAN         | 5    | Barrio rosaleda      | 5882104  | estebanlavarez@gmail |
| P03         | ZAPATA CAMPIÑO ISABEL           | 45   | Barrio Aragon        | 5841998  | zapataisabel@gmail.c |
| P04         | VALLE VELASQUEZ SOFIA           | 32   | Barrio la pradera    | 2791469  | sofiavelasquez@gmail |
| P05         | MORENO POSADA DIEGO ALEJANDRO   | 48   | Urbanizacion compart | 2868617  | diegomoreno@gmail.co |
| P06         | LZATE ORTIZ JORGE MARIO         | 10   | Urbanización ciudade | 5841497  | marioalzae@gmail.com |
| P07         | ZAPATA QUINTERO JOSE MARIA      | 24   | Barrio Sangabriel    | 5840570  | josezapata@gmail.com |
| P08         | MNTOYA MONTOYA AEJANDRO         | 79   | Barrio la pradera    | 3767289  | alejandromontoya@gma |
| P09         | LOPERA CARTAGENA LUISA FENANADA | 28   | Barrio el limonar 1  | 5709957  | luisalopera@gmail.co |
| P10         | JARAMILLO HENAO JOSE LUIS       | 3    | Barrio el limonar2   | 2866222  | josearamillo@gmail.c |
| P11         | ALVAREZ AGUDELO LUNA            | 18   | Barrio rosaleda      | 5882104  | lunaalvarez@gmail.co |
| P12         | ALVAREZ AGUDELO XAVIER          | 15   | Barrio rosaleda      | 5882104  | xavieralvarez@gmail. |
+-------------+---------------------------------+------+----------------------+----------+----------------------+
12 rows in set (0.001 sec)

MariaDB [DBUrgencias]> select * from examen;
+-----------+-------------------+
| codexamen | descripcion       |
+-----------+-------------------+
| E01       | RESFRIADO         |
| E02       | CONTUSION         |
| E03       | DOLOR ESTOMAGO    |
| E04       | FRACTURA          |
| E05       | PARO RESPIRATORIO |
| E06       | PARO CARDIACO     |
| E07       | INFECCION         |
| E08       | HEMORRAGIA        |
| E09       | HERIDA ABIERTA    |
| E10       | ALERGIA           |
+-----------+-------------------+
10 rows in set (0.001 sec)

MariaDB [DBUrgencias]> select * from planta;
+-----------+----------------+-----------+
| codplanta | descripcion    | codexamen |
+-----------+----------------+-----------+
| PL01      | CARDOLOGIA     | E06       |
| PL02      | PEDIATRIA      | E01       |
| PL03      | CIRUGIA        | E04       |
| PL04      | DERMATOLOGIA   | E10       |
| PL05      | HEMATOLOGIA    | E08       |
| PL06      | REHABILITACION | E05       |
| PL07      | NEUROLOGIA     | E07       |
| PL08      | ODONTOLOGIA    | E09       |
| PL09      | ORTOPEDIA      | E02       |
| PL10      | PSIQUIATRIA    | E03       |
+-----------+----------------+-----------+
10 rows in set (0.001 sec)

MariaDB [DBUrgencias]> select * from doctor;
+-----------+-------------------------------+--------------+----------+----------------------+
| coddoctor | nombre                        | especialidad | telefono | email                |
+-----------+-------------------------------+--------------+----------+----------------------+
| D01       | CIFUENTES MESA MYEIDY MARIA   | ODONTOLOGA   | 5846069  | myleidym.iearm@gmail |
| D02       | CUADRADO PEREZ ADRID JOSE     | PEDIATRA     | 5882104  | adrid.iearm@gmail.co |
| D03       | DUQUE RESTREPO ESTER LUCIA    | NEUROLOGO    | 5841998  | esterl.iearm@gmail.c |
| D04       | GUIRALES MAURICIO             | GINECOLOGO   | 2791469  | mauriciog.iearm@gmai |
| D05       | VERA DAZA MARIA ELENA         | PSIQUIATRA   | 2868617  | mariae.iearm@gmail.c |
| D06       | PALACIO TOMAS FELIPE          | CIRUJANO     | 5841497  | tomasf.iearm@gmail.c |
| D07       | MOSUERA OSORIO MARYETH        | GENERAL      | 5840570  | maryeth.iearm@gmail. |
| D08       | ARBOLEDA VARGAS MARIA OFELIA  | GENERAL      | 3767289  | ofeliaa.iearm@gmail. |
| D09       | MOSCOTE MARULANDA YANET MARIA | GENERAL      | 5709957  | yanetm.iearm@gmail.c |
| D10       | MACIAS EDGAR ALBERTO          | GENERAL      | 2866222  | edgarm.iearm@gmail.c |
+-----------+-------------------------------+--------------+----------+----------------------+
10 rows in set (0.001 sec)

MariaDB [DBUrgencias]> select * from paciexamen;
+-----------+-------------+
| codexamen | codpaciente |
+-----------+-------------+
| E01       | P01         |
| E02       | P02         |
| E03       | P03         |
| E04       | P04         |
| E05       | P05         |
| E06       | P06         |
| E07       | P07         |
| E08       | P08         |
| E09       | P09         |
| E10       | P10         |
| E03       | P11         |
| E04       | P12         |
| E05       | P01         |
| E06       | P02         |
| E01       | P03         |
+-----------+-------------+
15 rows in set (0.001 sec)

MariaDB [DBUrgencias]> select * from plantadoc;
+-----------+-----------+
| codplanta | coddoctor |
+-----------+-----------+
| PL01      | D01       |
| PL02      | D02       |
| PL03      | D03       |
| PL04      | D04       |
| PL05      | D05       |
| PL06      | D06       |
| PL07      | D07       |
| PL08      | D08       |
| PL09      | D01       |
| PL10      | D02       |
+-----------+-----------+
10 rows in set (0.001 sec)

MariaDB [DBUrgencias]> Delimiter //
MariaDB [DBUrgencias]> Create procedure insertar_paciente(in _codpaciente char(4), in _nombre char(50), in _edad char(3), in _direccion char(20), in _telefono char(10), in _email char(20))
    -> Begin
    -> Insert into paciente values(_codpaciente, _nombre, _edad, _direccion, _telefono, _email);
    -> End
    -> //
Query OK, 0 rows affected (0.006 sec)

MariaDB [DBUrgencias]> Call insertar_paciente('P13','MARTINEZ HAROLD','28','Barrio villapaula','3508771107','haroldm@gmail.com');
Query OK, 1 row affected (0.003 sec)

MariaDB [DBUrgencias]> select * from paciente;
+-------------+---------------------------------+------+----------------------+------------+----------------------+
| codpaciente | nombre                          | edad | direccion            | telefono   | email                |
+-------------+---------------------------------+------+----------------------+------------+----------------------+
| P01         | ACEVEDO BURITICA JUAN ESTEBAN   | 20   | Barrio la pradera    | 5846069    | juanestebacardona@gm |
| P02         | ALVAREZ AGUDELO ESTEBAN         | 5    | Barrio rosaleda      | 5882104    | estebanlavarez@gmail |
| P03         | ZAPATA CAMPIÑO ISABEL           | 45   | Barrio Aragon        | 5841998    | zapataisabel@gmail.c |
| P04         | VALLE VELASQUEZ SOFIA           | 32   | Barrio la pradera    | 2791469    | sofiavelasquez@gmail |
| P05         | MORENO POSADA DIEGO ALEJANDRO   | 48   | Urbanizacion compart | 2868617    | diegomoreno@gmail.co |
| P06         | LZATE ORTIZ JORGE MARIO         | 10   | Urbanización ciudade | 5841497    | marioalzae@gmail.com |
| P07         | ZAPATA QUINTERO JOSE MARIA      | 24   | Barrio Sangabriel    | 5840570    | josezapata@gmail.com |
| P08         | MNTOYA MONTOYA AEJANDRO         | 79   | Barrio la pradera    | 3767289    | alejandromontoya@gma |
| P09         | LOPERA CARTAGENA LUISA FENANADA | 28   | Barrio el limonar 1  | 5709957    | luisalopera@gmail.co |
| P10         | JARAMILLO HENAO JOSE LUIS       | 3    | Barrio el limonar2   | 2866222    | josearamillo@gmail.c |
| P11         | ALVAREZ AGUDELO LUNA            | 18   | Barrio rosaleda      | 5882104    | lunaalvarez@gmail.co |
| P12         | ALVAREZ AGUDELO XAVIER          | 15   | Barrio rosaleda      | 5882104    | xavieralvarez@gmail. |
| P13         | MARTINEZ HAROLD                 | 28   | Barrio villapaula    | 3508771107 | haroldm@gmail.com    |
+-------------+---------------------------------+------+----------------------+------------+----------------------+
13 rows in set (0.001 sec)

MariaDB [DBUrgencias]> Delimiter //
MariaDB [DBUrgencias]> Create procedure listar_paciente()
    -> Begin
    -> Select * from paciente;
    -> End
    -> //
Query OK, 0 rows affected (0.004 sec)

MariaDB [DBUrgencias]> Call listar_paciente;
+-------------+---------------------------------+------+----------------------+------------+----------------------+
| codpaciente | nombre                          | edad | direccion            | telefono   | email                |
+-------------+---------------------------------+------+----------------------+------------+----------------------+
| P01         | ACEVEDO BURITICA JUAN ESTEBAN   | 20   | Barrio la pradera    | 5846069    | juanestebacardona@gm |
| P02         | ALVAREZ AGUDELO ESTEBAN         | 5    | Barrio rosaleda      | 5882104    | estebanlavarez@gmail |
| P03         | ZAPATA CAMPIÑO ISABEL           | 45   | Barrio Aragon        | 5841998    | zapataisabel@gmail.c |
| P04         | VALLE VELASQUEZ SOFIA           | 32   | Barrio la pradera    | 2791469    | sofiavelasquez@gmail |
| P05         | MORENO POSADA DIEGO ALEJANDRO   | 48   | Urbanizacion compart | 2868617    | diegomoreno@gmail.co |
| P06         | LZATE ORTIZ JORGE MARIO         | 10   | Urbanización ciudade | 5841497    | marioalzae@gmail.com |
| P07         | ZAPATA QUINTERO JOSE MARIA      | 24   | Barrio Sangabriel    | 5840570    | josezapata@gmail.com |
| P08         | MNTOYA MONTOYA AEJANDRO         | 79   | Barrio la pradera    | 3767289    | alejandromontoya@gma |
| P09         | LOPERA CARTAGENA LUISA FENANADA | 28   | Barrio el limonar 1  | 5709957    | luisalopera@gmail.co |
| P10         | JARAMILLO HENAO JOSE LUIS       | 3    | Barrio el limonar2   | 2866222    | josearamillo@gmail.c |
| P11         | ALVAREZ AGUDELO LUNA            | 18   | Barrio rosaleda      | 5882104    | lunaalvarez@gmail.co |
| P12         | ALVAREZ AGUDELO XAVIER          | 15   | Barrio rosaleda      | 5882104    | xavieralvarez@gmail. |
| P13         | MARTINEZ HAROLD                 | 28   | Barrio villapaula    | 3508771107 | haroldm@gmail.com    |
+-------------+---------------------------------+------+----------------------+------------+----------------------+
13 rows in set (0.001 sec)

Query OK, 0 rows affected (0.064 sec)

MariaDB [DBUrgencias]> Delimiter //
MariaDB [DBUrgencias]> Create procedure consultar_paciente(in _codpaciente char(4))
    -> Begin
    -> Select * from paciente where codpaciente=_codpaciente;
    -> End
    -> //
Query OK, 0 rows affected (0.003 sec)

MariaDB [DBUrgencias]> Call consultar_paciente('P13');
    -> //
+-------------+-----------------+------+-------------------+------------+-------------------+
| codpaciente | nombre          | edad | direccion         | telefono   | email             |
+-------------+-----------------+------+-------------------+------------+-------------------+
| P13         | MARTINEZ HAROLD | 28   | Barrio villapaula | 3508771107 | haroldm@gmail.com |
+-------------+-----------------+------+-------------------+------------+-------------------+
1 row in set (0.001 sec)

Query OK, 0 rows affected (0.007 sec)

MariaDB [DBUrgencias]> Delimiter //
MariaDB [DBUrgencias]> Create procedure modificar_paciente(in _codpaciente char(4), in _nombre char(50), in _edad char(3), in _direccion char(20), in _telefono char(10), in _email char(20))
    -> Begin
    -> Update paciente set nombre=_nombre, edad=_edad, dirección=_direccion, teléfono=_telefono, email=_email where codpaciente=_codpaciente;
    -> End
    -> //
Query OK, 0 rows affected (0.003 sec)

MariaDB [DBUrgencias]> Call modificar_paciente('P13','MARTINEZ HAROLD SMITH','28','Barrio villapaula','3508771107','haroldm@gmail.com');
    -> //
ERROR 1054 (42S22): Unknown column 'dirección' in 'field list'
MariaDB [DBUrgencias]> Show procedure status;
    -> //
+-------------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db          | Name               | Type      | Definer        | Modified            | Created             | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+-------------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| dburgencias | consultar_paciente | PROCEDURE | root@localhost | 2023-08-06 17:17:39 | 2023-08-06 17:17:39 | DEFINER       |         | cp850
 | cp850_general_ci     | utf8mb4_general_ci |
| dburgencias | insertar_paciente  | PROCEDURE | root@localhost | 2023-08-06 17:08:09 | 2023-08-06 17:08:09 | DEFINER       |         | cp850
 | cp850_general_ci     | utf8mb4_general_ci |
| dburgencias | listar_paciente    | PROCEDURE | root@localhost | 2023-08-06 17:15:12 | 2023-08-06 17:15:12 | DEFINER       |         | cp850
 | cp850_general_ci     | utf8mb4_general_ci |
| dburgencias | modificar_paciente | PROCEDURE | root@localhost | 2023-08-06 17:22:19 | 2023-08-06 17:22:19 | DEFINER       |         | cp850
 | cp850_general_ci     | utf8mb4_general_ci |
+-------------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
4 rows in set (0.005 sec)

MariaDB [DBUrgencias]> Drop procedure modificar_paciente;
    -> //
Query OK, 0 rows affected (0.004 sec)

MariaDB [DBUrgencias]> Show procedure status;
    -> //
+-------------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db          | Name               | Type      | Definer        | Modified            | Created             | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+-------------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| dburgencias | consultar_paciente | PROCEDURE | root@localhost | 2023-08-06 17:17:39 | 2023-08-06 17:17:39 | DEFINER       |         | cp850
 | cp850_general_ci     | utf8mb4_general_ci |
| dburgencias | insertar_paciente  | PROCEDURE | root@localhost | 2023-08-06 17:08:09 | 2023-08-06 17:08:09 | DEFINER       |         | cp850
 | cp850_general_ci     | utf8mb4_general_ci |
| dburgencias | listar_paciente    | PROCEDURE | root@localhost | 2023-08-06 17:15:12 | 2023-08-06 17:15:12 | DEFINER       |         | cp850
 | cp850_general_ci     | utf8mb4_general_ci |
+-------------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
3 rows in set (0.004 sec)

MariaDB [DBUrgencias]> Delimiter //
MariaDB [DBUrgencias]> Create procedure modificar_paciente(in _codpaciente char(4), in _nombre char(50), in _edad char(3), in _direccion char(20), in _telefono char(10), in _email char(20))
    -> Begin
    -> Update paciente set nombre=_nombre, edad=_edad, direccion=_direccion, teléfono=_telefono, email=_email where codpaciente=_codpaciente;
    -> End
    -> //
Query OK, 0 rows affected (0.003 sec)

MariaDB [DBUrgencias]> Call modificar_paciente('P13','MARTINEZ HAROLD SMITH','28','Barrio villapaula','3508771107','haroldm@gmail.com');
    -> //
ERROR 1054 (42S22): Unknown column 'teléfono' in 'field list'
MariaDB [DBUrgencias]> Drop procedure modificar_paciente;
    -> //
Query OK, 0 rows affected (0.005 sec)

MariaDB [DBUrgencias]> Delimiter //
MariaDB [DBUrgencias]> Create procedure modificar_paciente(in _codpaciente char(4), in _nombre char(50), in _edad char(3), in _direccion char(20), in _telefono char(10), in _email char(20))
    -> Begin
    -> Update paciente set nombre=_nombre, edad=_edad, direccion=_direccion, telefono=_telefono, email=_email where codpaciente=_codpaciente;
    -> End
    -> //
Query OK, 0 rows affected (0.004 sec)

MariaDB [DBUrgencias]> Call modificar_paciente('P13','MARTINEZ HAROLD SMITH','28','Barrio villapaula','3508771107','haroldm@gmail.com');
    -> //
Query OK, 1 row affected (0.003 sec)

MariaDB [DBUrgencias]> Call listar_paciente;
    -> //
+-------------+---------------------------------+------+----------------------+------------+----------------------+
| codpaciente | nombre                          | edad | direccion            | telefono   | email                |
+-------------+---------------------------------+------+----------------------+------------+----------------------+
| P01         | ACEVEDO BURITICA JUAN ESTEBAN   | 20   | Barrio la pradera    | 5846069    | juanestebacardona@gm |
| P02         | ALVAREZ AGUDELO ESTEBAN         | 5    | Barrio rosaleda      | 5882104    | estebanlavarez@gmail |
| P03         | ZAPATA CAMPIÑO ISABEL           | 45   | Barrio Aragon        | 5841998    | zapataisabel@gmail.c |
| P04         | VALLE VELASQUEZ SOFIA           | 32   | Barrio la pradera    | 2791469    | sofiavelasquez@gmail |
| P05         | MORENO POSADA DIEGO ALEJANDRO   | 48   | Urbanizacion compart | 2868617    | diegomoreno@gmail.co |
| P06         | LZATE ORTIZ JORGE MARIO         | 10   | Urbanización ciudade | 5841497    | marioalzae@gmail.com |
| P07         | ZAPATA QUINTERO JOSE MARIA      | 24   | Barrio Sangabriel    | 5840570    | josezapata@gmail.com |
| P08         | MNTOYA MONTOYA AEJANDRO         | 79   | Barrio la pradera    | 3767289    | alejandromontoya@gma |
| P09         | LOPERA CARTAGENA LUISA FENANADA | 28   | Barrio el limonar 1  | 5709957    | luisalopera@gmail.co |
| P10         | JARAMILLO HENAO JOSE LUIS       | 3    | Barrio el limonar2   | 2866222    | josearamillo@gmail.c |
| P11         | ALVAREZ AGUDELO LUNA            | 18   | Barrio rosaleda      | 5882104    | lunaalvarez@gmail.co |
| P12         | ALVAREZ AGUDELO XAVIER          | 15   | Barrio rosaleda      | 5882104    | xavieralvarez@gmail. |
| P13         | MARTINEZ HAROLD SMITH           | 28   | Barrio villapaula    | 3508771107 | haroldm@gmail.com    |
+-------------+---------------------------------+------+----------------------+------------+----------------------+
13 rows in set (0.001 sec)

Query OK, 0 rows affected (0.061 sec)

MariaDB [DBUrgencias]> Delimiter //
MariaDB [DBUrgencias]> Create procedure eliminar_paciente(in _codpaciente char(4))
    -> Begin
    -> Delete from paciente where codpaciente=_codpaciente;
    -> End
    -> //
Query OK, 0 rows affected (0.004 sec)

MariaDB [DBUrgencias]> Call eliminar_paciente('P13');
    -> //
Query OK, 1 row affected (0.003 sec)

MariaDB [DBUrgencias]> Call listar_paciente;
    -> //
+-------------+---------------------------------+------+----------------------+----------+----------------------+
| codpaciente | nombre                          | edad | direccion            | telefono | email                |
+-------------+---------------------------------+------+----------------------+----------+----------------------+
| P01         | ACEVEDO BURITICA JUAN ESTEBAN   | 20   | Barrio la pradera    | 5846069  | juanestebacardona@gm |
| P02         | ALVAREZ AGUDELO ESTEBAN         | 5    | Barrio rosaleda      | 5882104  | estebanlavarez@gmail |
| P03         | ZAPATA CAMPIÑO ISABEL           | 45   | Barrio Aragon        | 5841998  | zapataisabel@gmail.c |
| P04         | VALLE VELASQUEZ SOFIA           | 32   | Barrio la pradera    | 2791469  | sofiavelasquez@gmail |
| P05         | MORENO POSADA DIEGO ALEJANDRO   | 48   | Urbanizacion compart | 2868617  | diegomoreno@gmail.co |
| P06         | LZATE ORTIZ JORGE MARIO         | 10   | Urbanización ciudade | 5841497  | marioalzae@gmail.com |
| P07         | ZAPATA QUINTERO JOSE MARIA      | 24   | Barrio Sangabriel    | 5840570  | josezapata@gmail.com |
| P08         | MNTOYA MONTOYA AEJANDRO         | 79   | Barrio la pradera    | 3767289  | alejandromontoya@gma |
| P09         | LOPERA CARTAGENA LUISA FENANADA | 28   | Barrio el limonar 1  | 5709957  | luisalopera@gmail.co |
| P10         | JARAMILLO HENAO JOSE LUIS       | 3    | Barrio el limonar2   | 2866222  | josearamillo@gmail.c |
| P11         | ALVAREZ AGUDELO LUNA            | 18   | Barrio rosaleda      | 5882104  | lunaalvarez@gmail.co |
| P12         | ALVAREZ AGUDELO XAVIER          | 15   | Barrio rosaleda      | 5882104  | xavieralvarez@gmail. |
+-------------+---------------------------------+------+----------------------+----------+----------------------+
12 rows in set (0.001 sec)

Query OK, 0 rows affected (0.053 sec)

MariaDB [DBUrgencias]> exit
Bye

C:\xampp\mysql\bin>mysqldump -B -uroot -p DBUrgencias>c:/xampp/DBUrgencias.sql
Enter password:

C:\xampp\mysql\bin>