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

MariaDB [(none)]> use consulta_externa;
Database changed
MariaDB [consulta_externa]> show databases;
+--------------------+
| Database           |
+--------------------+
| academico          |
| consulta_externa   |
| facturacion        |
| information_schema |
| institucion        |
| institucion1       |
| libreria           |
| matricula2         |
| mysql              |
| performance_schema |
| phpmyadmin         |
| secundaria         |
| test               |
+--------------------+
13 rows in set (0.12 sec)

MariaDB [consulta_externa]> create table medico
    -> (idmedico varchar(10) not null primary key,
    -> idespecialidad varchar(10) not null,
    -> nombre varchar(60) not null,
    -> sede varchar(30) not null,
    -> estado boolean not null);
Query OK, 0 rows affected (0.49 sec)

MariaDB [consulta_externa]> describe medico;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| idmedico       | varchar(10) | NO   | PRI | NULL    |       |
| idespecialidad | varchar(10) | NO   |     | NULL    |       |
| nombre         | varchar(60) | NO   |     | NULL    |       |
| sede           | varchar(30) | NO   |     | NULL    |       |
| estado         | tinyint(1)  | NO   |     | NULL    |       |
+----------------+-------------+------+-----+---------+-------+
5 rows in set (0.08 sec)

MariaDB [consulta_externa]> create table especialidad
    -> (idespecialidad varchar(10) not null primary key,
    -> descripcion varchar(45) not null);
Query OK, 0 rows affected (0.28 sec)

MariaDB [consulta_externa]> describe especialidad;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| idespecialidad | varchar(10) | NO   | PRI | NULL    |       |
| descripcion    | varchar(45) | NO   |     | NULL    |       |
+----------------+-------------+------+-----+---------+-------+
2 rows in set (0.05 sec)

MariaDB [consulta_externa]> create table paciente
    ->  (idpaciente varchar(10) not null primary key,
    -> nombre varchar(60) not null,
    -> telefono varchar(15) not null,
    -> direccion varchar(20) not null,
    -> nom_aseguradora varchar(45) not null,
    -> fecha_nacimiento datetime not null);
Query OK, 0 rows affected (0.30 sec)

MariaDB [consulta_externa]> describe paciente;
+------------------+-------------+------+-----+---------+-------+
| Field            | Type        | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| idpaciente       | varchar(10) | NO   | PRI | NULL    |       |
| nombre           | varchar(60) | NO   |     | NULL    |       |
| telefono         | varchar(15) | NO   |     | NULL    |       |
| direccion        | varchar(20) | NO   |     | NULL    |       |
| nom_aseguradora  | varchar(45) | NO   |     | NULL    |       |
| fecha_nacimiento | datetime    | NO   |     | NULL    |       |
+------------------+-------------+------+-----+---------+-------+
6 rows in set (0.03 sec)

MariaDB [consulta_externa]> create table aseguradora
    -> (idaseguradora varchar(10) not null primary key,
    -> idpaciente varchar(10) not null,
    -> nom_aseguradora varchar(45) not null);
Query OK, 0 rows affected (0.23 sec)

MariaDB [consulta_externa]> describe aseguradora;
+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| idaseguradora   | varchar(10) | NO   | PRI | NULL    |       |
| idpaciente      | varchar(10) | NO   |     | NULL    |       |
| nom_aseguradora | varchar(45) | NO   |     | NULL    |       |
+-----------------+-------------+------+-----+---------+-------+
3 rows in set (0.07 sec)

MariaDB [consulta_externa]> create table agenda
    -> (idmedico varchar(10) not null,
    -> idespecialidad varchar(10) not null,
    -> idagenda varchar(10) not null,
    -> fecha_hora datetime not null,
    -> foreign key(idmedico) references medico(idmedico) on delete cascade on update cascade,
    -> foreign key(idespecialidad) references especialidad(idespecialidad) on delete cascade on update cascade);
Query OK, 0 rows affected (0.29 sec)

MariaDB [consulta_externa]> describe agenda;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| idmedico       | varchar(10) | NO   | MUL | NULL    |       |
| idespecialidad | varchar(10) | NO   | MUL | NULL    |       |
| idagenda       | varchar(10) | NO   |     | NULL    |       |
| fecha_hora     | datetime    | NO   |     | NULL    |       |
+----------------+-------------+------+-----+---------+-------+
4 rows in set (0.06 sec)

MariaDB [consulta_externa]> create table especial_paciente
    -> (idpaciente varchar(10) not null,
    -> idespecialidad varchar(10) not null,
    -> foreign key(idpaciente) references paciente(idpaciente) on delete cascade on update cascade,
    -> foreign key(idespecialidad) references especialidad(idespecialidad) on delete cascade on update cascade);
Query OK, 0 rows affected (0.26 sec)

MariaDB [consulta_externa]> describe especial_paciente;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| idpaciente     | varchar(10) | NO   | MUL | NULL    |       |
| idespecialidad | varchar(10) | NO   | MUL | NULL    |       |
+----------------+-------------+------+-----+---------+-------+
2 rows in set (0.10 sec)

MariaDB [consulta_externa]> create table paciente_aseguradora
    -> (idpaciente varchar(10) not null,
    -> idaseguradora varchar(10) not null,
    -> foreign key(idpaciente) references paciente(idpaciente) on delete cascade on update cascade,
    -> foreign key(idaseguradora) references aseguradora(idaseguradora) on delete cascade on update cascade);
Query OK, 0 rows affected (0.32 sec)

MariaDB [consulta_externa]> describe paciente_aseguradora;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| idpaciente    | varchar(10) | NO   | MUL | NULL    |       |
| idaseguradora | varchar(10) | NO   | MUL | NULL    |       |
+---------------+-------------+------+-----+---------+-------+
2 rows in set (0.06 sec)

MariaDB [consulta_externa]> insert into medico(idmedico,idespecialidad,nombre,sede,estado) values('98521478','3852','Juan Pablo Martinez','fundacion clinica del norte',1);
Query OK, 1 row affected (0.10 sec)

MariaDB [consulta_externa]> select * from medico;
+----------+----------------+---------------------+-----------------------------+--------+
| idmedico | idespecialidad | nombre              | sede                        | estado |
+----------+----------------+---------------------+-----------------------------+--------+
| 98521478 | 3852           | Juan Pablo Martinez | fundacion clinica del norte |      1 |
+----------+----------------+---------------------+-----------------------------+--------+
1 row in set (0.00 sec)

MariaDB [consulta_externa]> insert into medico(idmedico,idespecialidad,nombre,sede,estado) values('71658987','3689','Jose Alberto Ocampo','fundacion clinica del norte',1);
Query OK, 1 row affected (0.10 sec)

MariaDB [consulta_externa]> insert into medico(idmedico,idespecialidad,nombre,sede,estado) values('1128459874','3852','Juan Pablo Martinez','fundacion clinica del norte',1);
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> select * from medico;
+------------+----------------+---------------------+-----------------------------+--------+
| idmedico   | idespecialidad | nombre              | sede                        | estado |
+------------+----------------+---------------------+-----------------------------+--------+
| 1128459874 | 3852           | Juan Pablo Martinez | fundacion clinica del norte |      1 |
| 71658987   | 3689           | Jose Alberto Ocampo | fundacion clinica del norte |      1 |
| 98521478   | 3852           | Juan Pablo Martinez | fundacion clinica del norte |      1 |
+------------+----------------+---------------------+-----------------------------+--------+
3 rows in set (0.00 sec)

MariaDB [consulta_externa]> delete from medico where idmedico='1128459874';
Query OK, 1 row affected (0.09 sec)

MariaDB [consulta_externa]> select * from medico;
+----------+----------------+---------------------+-----------------------------+--------+
| idmedico | idespecialidad | nombre              | sede                        | estado |
+----------+----------------+---------------------+-----------------------------+--------+
| 71658987 | 3689           | Jose Alberto Ocampo | fundacion clinica del norte |      1 |
| 98521478 | 3852           | Juan Pablo Martinez | fundacion clinica del norte |      1 |
+----------+----------------+---------------------+-----------------------------+--------+
2 rows in set (0.00 sec)

MariaDB [consulta_externa]> insert into medico(idmedico,idespecialidad,nombre,sede,estado) values('1128459874','3847','Dario Mendoza','fundacion clinica del norte',1);
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> insert into medico(idmedico,idespecialidad,nombre,sede,estado) values('32598784','3852','Juan Jose Arboleda','fundacion clinica del norte',1);
Query OK, 1 row affected (0.10 sec)

MariaDB [consulta_externa]> insert into medico(idmedico,idespecialidad,nombre,sede,estado) values('98521470','9878','Gabriel Salazar Jimenez','fundacion clinica del norte',0);
Query OK, 1 row affected (0.08 sec)

MariaDB [consulta_externa]> insert into medico(idmedico,idespecialidad,nombre,sede,estado) values('98545912','8796','Hector Lopez Lopez','fundacion clinica del norte',1);
Query OK, 1 row affected (0.10 sec)

MariaDB [consulta_externa]> insert into medico(idmedico,idespecialidad,nombre,sede,estado) values('1126959873','2369','Maria Gabriela Quiroz','fundacion clinica del norte',1);
Query OK, 1 row affected (0.08 sec)

MariaDB [consulta_externa]> insert into medico(idmedico,idespecialidad,nombre,sede,estado) values('1042598789','2589','Nora Martinez Mu¤oz','fundacion clinica del norte',1);
Query OK, 1 row affected (0.08 sec)

MariaDB [consulta_externa]> insert into medico(idmedico,idespecialidad,nombre,sede,estado) values('71658963','8978','Daniel Hernandez Vega','fundacion clinica del norte',1);
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> insert into medico(idmedico,idespecialidad,nombre,sede,estado) values('42795698','9878','Camila Gil Lopera','fundacion clinica del norte',1);
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> select * from medico;
+------------+----------------+-------------------------+-----------------------------+--------+
| idmedico   | idespecialidad | nombre                  | sede                        | estado |
+------------+----------------+-------------------------+-----------------------------+--------+
| 1042598789 | 2589           | Nora Martinez Mu¤oz     | fundacion clinica del norte |      1 |
| 1126959873 | 2369           | Maria Gabriela Quiroz   | fundacion clinica del norte |      1 |
| 1128459874 | 3847           | Dario Mendoza           | fundacion clinica del norte |      1 |
| 32598784   | 3852           | Juan Jose Arboleda      | fundacion clinica del norte |      1 |
| 42795698   | 9878           | Camila Gil Lopera       | fundacion clinica del norte |      1 |
| 71658963   | 8978           | Daniel Hernandez Vega   | fundacion clinica del norte |      1 |
| 71658987   | 3689           | Jose Alberto Ocampo     | fundacion clinica del norte |      1 |
| 98521470   | 9878           | Gabriel Salazar Jimenez | fundacion clinica del norte |      0 |
| 98521478   | 3852           | Juan Pablo Martinez     | fundacion clinica del norte |      1 |
| 98545912   | 8796           | Hector Lopez Lopez      | fundacion clinica del norte |      1 |
+------------+----------------+-------------------------+-----------------------------+--------+
10 rows in set (0.00 sec)

MariaDB [consulta_externa]> insert into especialidad(idespecialidad,descripcion) values('9878','Cirugia general');
Query OK, 1 row affected (0.09 sec)

MariaDB [consulta_externa]> insert into especialidad(idespecialidad,descripcion) values('3852','neurologia');
Query OK, 1 row affected (0.31 sec)

MariaDB [consulta_externa]> insert into especialidad(idespecialidad,descripcion) values('3689','cardiologia');
Query OK, 1 row affected (0.11 sec)

MariaDB [consulta_externa]> insert into especialidad(idespecialidad,descripcion) values('3847','neurocirugia');
Query OK, 1 row affected (0.10 sec)

MariaDB [consulta_externa]> insert into especialidad(idespecialidad,descripcion) values('8796','ortopedia y traumatologia');
Query OK, 1 row affected (0.08 sec)

MariaDB [consulta_externa]> insert into especialidad(idespecialidad,descripcion) values('8978','urologia');
Query OK, 1 row affected (0.09 sec)

MariaDB [consulta_externa]> insert into especialidad(idespecialidad,descripcion) values('2589','anestesiologia');
Query OK, 1 row affected (0.09 sec)

MariaDB [consulta_externa]> insert into especialidad(idespecialidad,descripcion) values('2369','fisioterapia');
Query OK, 1 row affected (0.08 sec)

MariaDB [consulta_externa]> select * from especialidad;
+----------------+---------------------------+
| idespecialidad | descripcion               |
+----------------+---------------------------+
| 2369           | fisioterapia              |
| 2589           | anestesiologia            |
| 3689           | cardiologia               |
| 3847           | neurocirugia              |
| 3852           | neurologia                |
| 8796           | ortopedia y traumatologia |
| 8978           | urologia                  |
| 9878           | Cirugia general           |
+----------------+---------------------------+
8 rows in set (0.00 sec)

MariaDB [consulta_externa]> insert into paciente(idpaciente,nombre,telefono,direccion,nom_aseguradora,fecha_nacimiento) values('45987896','sofia morales','3225689','cra 39a poblado','nueva eps','01-02-1967');
Query OK, 1 row affected, 1 warning (0.32 sec)

MariaDB [consulta_externa]> select * from paciente;
+------------+---------------+----------+-----------------+-----------------+---------------------+
| idpaciente | nombre        | telefono | direccion       | nom_aseguradora | fecha_nacimiento    |
+------------+---------------+----------+-----------------+-----------------+---------------------+
| 45987896   | sofia morales | 3225689  | cra 39a poblado | nueva eps       | 0000-00-00 00:00:00 |
+------------+---------------+----------+-----------------+-----------------+---------------------+
1 row in set (0.00 sec)

MariaDB [consulta_externa]> delete from paciente where idpaciente='45987896';
Query OK, 1 row affected (0.08 sec)

MariaDB [consulta_externa]> select * from paciente;
Empty set (0.00 sec)

MariaDB [consulta_externa]> insert into paciente(idpaciente,nombre,telefono,direccion,nom_aseguradora,fecha_nacimiento) values('45987896','sofia morales','3225689','cra 39a poblado','nueva eps','1967-02-01');
Query OK, 1 row affected (0.08 sec)

MariaDB [consulta_externa]> select * from paciente;
+------------+---------------+----------+-----------------+-----------------+---------------------+
| idpaciente | nombre        | telefono | direccion       | nom_aseguradora | fecha_nacimiento    |
+------------+---------------+----------+-----------------+-----------------+---------------------+
| 45987896   | sofia morales | 3225689  | cra 39a poblado | nueva eps       | 1967-02-01 00:00:00 |
+------------+---------------+----------+-----------------+-----------------+---------------------+
1 row in set (0.00 sec)

MariaDB [consulta_externa]> insert into paciente(idpaciente,nombre,telefono,direccion,nom_aseguradora,fecha_nacimiento) values('112369874','alicia gutierrez salvado','4589878','cra 47 boston','sura','1965-11-02');
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> insert into paciente(idpaciente,nombre,telefono,direccion,nom_aseguradora,fecha_nacimiento) values('32569874','mateo ramirez yepes','3256987','cra 45 robledo','coosalud','1980-04-28');
Query OK, 1 row affected (0.08 sec)

MariaDB [consulta_externa]> insert into paciente(idpaciente,nombre,telefono,direccion,nom_aseguradora,fecha_nacimiento) values('369874','lucia bustamante','3006987896','cra 40 villahermosa','cruz blanca','1970-09-26');
Query OK, 1 row affected (0.08 sec)

MariaDB [consulta_externa]> insert into paciente(idpaciente,nombre,telefono,direccion,nom_aseguradora,fecha_nacimiento) values('259874','antonella gil','3205698745','cra 43 la estrella','sura','1981-12-08');
Query OK, 1 row affected (0.09 sec)

MariaDB [consulta_externa]> insert into paciente(idpaciente,nombre,telefono,direccion,nom_aseguradora,fecha_nacimiento) values('8974569','oscar hernandez','2369874','cra 42 envigado','salud total','1978-09-23');
Query OK, 1 row affected (0.09 sec)

MariaDB [consulta_externa]> insert into paciente(idpaciente,nombre,telefono,direccion,nom_aseguradora,fecha_nacimiento) values('98569874','luis carlos taborda','3504589874','cra 47 sabaneta','coomeva','1960-04-29');
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> insert into paciente(idpaciente,nombre,telefono,direccion,nom_aseguradora,fecha_nacimiento) values('42985630','maria fabiola sanchez','2774569','cra 44 calasanz','ecoosalud','1962-02-25');
Query OK, 1 row affected (0.31 sec)

MariaDB [consulta_externa]> select * from paciente;
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
| idpaciente | nombre                   | telefono   | direccion           | nom_aseguradora | fecha_nacimiento    |
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
| 112369874  | alicia gutierrez salvado | 4589878    | cra 47 boston       | sura            | 1965-11-02 00:00:00 |
| 259874     | antonella gil            | 3205698745 | cra 43 la estrella  | sura            | 1981-12-08 00:00:00 |
| 32569874   | mateo ramirez yepes      | 3256987    | cra 45 robledo      | coosalud        | 1980-04-28 00:00:00 |
| 369874     | lucia bustamante         | 3006987896 | cra 40 villahermosa | cruz blanca     | 1970-09-26 00:00:00 |
| 42985630   | maria fabiola sanchez    | 2774569    | cra 44 calasanz     | ecoosalud       | 1962-02-25 00:00:00 |
| 45987896   | sofia morales            | 3225689    | cra 39a poblado     | nueva eps       | 1967-02-01 00:00:00 |
| 8974569    | oscar hernandez          | 2369874    | cra 42 envigado     | salud total     | 1978-09-23 00:00:00 |
| 98569874   | luis carlos taborda      | 3504589874 | cra 47 sabaneta     | coomeva         | 1960-04-29 00:00:00 |
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
8 rows in set (0.00 sec)

MariaDB [consulta_externa]> insert into aseguradora(idaseguradora,idpaciente,nom_aseguradora) values('C456987','42985630','ecoosalud');
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> insert into aseguradora(idaseguradora,idpaciente,nom_aseguradora) values('E896324','45987896','nueva eps');
Query OK, 1 row affected (0.32 sec)

MariaDB [consulta_externa]> insert into aseguradora(idaseguradora,idpaciente,nom_aseguradora) values('T459874','369874','cruz blanca');
Query OK, 1 row affected (0.09 sec)

MariaDB [consulta_externa]> insert into aseguradora(idaseguradora,idpaciente,nom_aseguradora) values('U789654','112369874','sura');
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> 
MariaDB [(none)]> source C:\xampp\consulta_externa01.sql
Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.23 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.18 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 4 rows affected (0.07 sec)
Records: 4  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.16 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.16 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.03 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.24 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 10 rows affected (0.05 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.18 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.03 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.20 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [consulta_externa]> describe aseguradora;
+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| idaseguradora   | varchar(10) | NO   | PRI | NULL    |       |
| idpaciente      | varchar(10) | NO   |     | NULL    |       |
| nom_aseguradora | varchar(45) | NO   |     | NULL    |       |
+-----------------+-------------+------+-----+---------+-------+
3 rows in set (0.02 sec)

MariaDB [consulta_externa]> alter table aseguradora drop idpaciente;
Query OK, 0 rows affected (0.28 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [consulta_externa]> describe aseguradora;
+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| idaseguradora   | varchar(10) | NO   | PRI | NULL    |       |
| nom_aseguradora | varchar(45) | NO   |     | NULL    |       |
+-----------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

MariaDB [consulta_externa]> insert into aseguradora(idaseguradora,nom_aseguradora) values('C879652','coosalud');
Query OK, 1 row affected (0.03 sec)

MariaDB [consulta_externa]> insert into aseguradora(idaseguradora,nom_aseguradora) values('U785692','sanitas');
Query OK, 1 row affected (0.08 sec)

MariaDB [consulta_externa]> insert into aseguradora(idaseguradora,nom_aseguradora) values('G459633','salud total');
Query OK, 1 row affected (0.03 sec)

MariaDB [consulta_externa]> insert into aseguradora(idaseguradora,nom_aseguradora) values('Y456987','coomeva');
Query OK, 1 row affected (0.03 sec)

MariaDB [consulta_externa]> select * from aseguradora;
+---------------+-----------------+
| idaseguradora | nom_aseguradora |
+---------------+-----------------+
| C456987       | ecoosalud       |
| C879652       | coosalud        |
| E896324       | nueva eps       |
| G459633       | salud total     |
| T459874       | cruz blanca     |
| U785692       | sanitas         |
| U789654       | sura            |
| Y456987       | coomeva         |
+---------------+-----------------+
8 rows in set (0.00 sec)

MariaDB [consulta_externa]> Insert into agenda(idmedico,idespecialidad,idagenda,fecha_hora)values('98521478','3852','LCC450','2019-06-25 13:00:00');
Query OK, 1 row affected (0.03 sec)

MariaDB [consulta_externa]> select * from agenda;
+----------+----------------+----------+---------------------+
| idmedico | idespecialidad | idagenda | fecha_hora          |
+----------+----------------+----------+---------------------+
| 98521478 | 3852           | LCC450   | 2019-06-25 13:00:00 |
+----------+----------------+----------+---------------------+
1 row in set (0.00 sec)

exit

MariaDB [consulta_externa]> exit
MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| academico          |
| consulta_externa   |
| facturacion        |
| information_schema |
| institucion        |
| institucion1       |
| libreria           |
| matricula2         |
| mysql              |
| performance_schema |
| phpmyadmin         |
| secundaria         |
| test               |
+--------------------+
13 rows in set (0.14 sec)

MariaDB [(none)]> source C:\xampp\consulta_externa011.sql
Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Database changed
Query OK, 0 rows affected (0.38 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.35 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.05 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.13 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.24 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.02 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.18 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.32 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.15 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.29 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.02 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.15 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.22 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 10 rows affected (0.05 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.04 sec)

Query OK, 0 rows affected (0.11 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.32 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.04 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.12 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.24 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [consulta_externa]> select * from agenda;
+----------+----------------+----------+---------------------+
| idmedico | idespecialidad | idagenda | fecha_hora          |
+----------+----------------+----------+---------------------+
| 98521478 | 3852           | LCC450   | 2019-06-25 13:00:00 |
+----------+----------------+----------+---------------------+
1 row in set (0.04 sec)

MariaDB [consulta_externa]> update agenda set idagenda='LCC4501' where idmedico='98521470';
Query OK, 0 rows affected (0.07 sec)
Rows matched: 0  Changed: 0  Warnings: 0

MariaDB [consulta_externa]> select * from agenda;
+----------+----------------+----------+---------------------+
| idmedico | idespecialidad | idagenda | fecha_hora          |
+----------+----------------+----------+---------------------+
| 98521478 | 3852           | LCC450   | 2019-06-25 13:00:00 |
+----------+----------------+----------+---------------------+
1 row in set (0.00 sec)

MariaDB [consulta_externa]> update agenda set idagenda='LCC4501' where idmedico='98521478';
Query OK, 1 row affected (0.64 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [consulta_externa]> select * from agenda;
+----------+----------------+----------+---------------------+
| idmedico | idespecialidad | idagenda | fecha_hora          |
+----------+----------------+----------+---------------------+
| 98521478 | 3852           | LCC4501  | 2019-06-25 13:00:00 |
+----------+----------------+----------+---------------------+
1 row in set (0.00 sec)

MariaDB [consulta_externa]> Insert into agenda(idmedico,idespecialidad,idagenda,fecha_hora)values('42795698','9878','LCC4512','2019-07-26 09:00:00');
Query OK, 1 row affected (0.08 sec)

MariaDB [consulta_externa]> insert into agenda(idmedico,idespecialidad,idagenda,fecha_hora)values('98545912','8796','LCC4523','2019-08-13 12:00:00');
Query OK, 1 row affected (0.32 sec)

MariaDB [consulta_externa]> insert into agenda(idmedico,idespecialidad,idagenda,fecha_hora)values('32598784','3852','LCC4534','2019-08-16 16:00:00');
Query OK, 1 row affected (0.11 sec)

MariaDB [consulta_externa]> insert into agenda(idmedico,idespecialidad,idagenda,fecha_hora)values('98521470','9878','LCC4545','2019-06-15 15:00:00');
Query OK, 1 row affected (0.04 sec)

MariaDB [consulta_externa]> insert into agenda(idmedico,idespecialidad,idagenda,fecha_hora)values('1042598789','2589','LCC4556','2019-05-2907:30:00');
Query OK, 1 row affected, 1 warning (0.06 sec)

MariaDB [consulta_externa]> insert into agenda(idmedico,idespecialidad,idagenda,fecha_hora)values('1126959873','2369','LCC4567','2019-10-0409:30:00');
Query OK, 1 row affected, 1 warning (0.08 sec)

MariaDB [consulta_externa]> insert into agenda(idmedico,idespecialidad,idagenda,fecha_hora)values('1128459874','3847','LCC4578','2019-07-1211:15:00');
Query OK, 1 row affected, 1 warning (0.31 sec)

MariaDB [consulta_externa]> insert into agenda(idmedico,idespecialidad,idagenda,fecha_hora)values('71658963','8978','LCC4589','2019-08-08 14:20:00');
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> insert into agenda(idmedico,idespecialidad,idagenda,fecha_hora)values('71658987','3689','LCC4590','2019-09-14 17:45:00');
Query OK, 1 row affected (0.08 sec)

MariaDB [consulta_externa]> select * from agenda;
+------------+----------------+----------+---------------------+
| idmedico   | idespecialidad | idagenda | fecha_hora          |
+------------+----------------+----------+---------------------+
| 98521478   | 3852           | LCC4501  | 2019-06-25 13:00:00 |
| 42795698   | 9878           | LCC4512  | 2019-07-26 09:00:00 |
| 98545912   | 8796           | LCC4523  | 2019-08-13 12:00:00 |
| 32598784   | 3852           | LCC4534  | 2019-08-16 16:00:00 |
| 98521470   | 9878           | LCC4545  | 2019-06-15 15:00:00 |
| 1042598789 | 2589           | LCC4556  | 0000-00-00 00:00:00 |
| 1126959873 | 2369           | LCC4567  | 0000-00-00 00:00:00 |
| 1128459874 | 3847           | LCC4578  | 0000-00-00 00:00:00 |
| 71658963   | 8978           | LCC4589  | 2019-08-08 14:20:00 |
| 71658987   | 3689           | LCC4590  | 2019-09-14 17:45:00 |
+------------+----------------+----------+---------------------+
10 rows in set (0.00 sec)

MariaDB [consulta_externa]> insert into especial_paciente(idpaciente,idespecialidad)values('8974569','3852');
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> insert into especial_paciente(idpaciente,idespecialidad)values('45987896','3689');
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> insert into especial_paciente(idpaciente,idespecialidad)values('112369874','3847');
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> insert into especial_paciente(idpaciente,idespecialidad)values('369874','8978');
Query OK, 1 row affected (0.09 sec)

MariaDB [consulta_externa]> insert into especial_paciente(idpaciente,idespecialidad)values('42985630','9878');
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> insert into especial_paciente(idpaciente,idespecialidad)values('98569874','2589');
Query OK, 1 row affected (0.08 sec)

MariaDB [consulta_externa]> insert into especial_paciente(idpaciente,idespecialidad)values('259874','8796');
Query OK, 1 row affected (0.08 sec)

MariaDB [consulta_externa]> insert into especial_paciente(idpaciente,idespecialidad)values('32569874','2369');
Query OK, 1 row affected (0.12 sec)

MariaDB [consulta_externa]> select * from especial_paciente;
+------------+----------------+
| idpaciente | idespecialidad |
+------------+----------------+
| 8974569    | 3852           |
| 45987896   | 3689           |
| 112369874  | 3847           |
| 369874     | 8978           |
| 42985630   | 9878           |
| 98569874   | 2589           |
| 259874     | 8796           |
| 32569874   | 2369           |
+------------+----------------+
8 rows in set (0.00 sec)

MariaDB [consulta_externa]> insert into paciente_aseguradora(idpaciente,idaseguradora)values('42985630','C456987');
Query OK, 1 row affected (0.09 sec)

MariaDB [consulta_externa]> insert into paciente_aseguradora(idpaciente,idespecialidad)values('32569874','C879652');
ERROR 1054 (42S22): Unknown column 'idespecialidad' in 'field list'
MariaDB [consulta_externa]> insert into paciente_aseguradora(idpaciente,idaseguradora)values('32569874','C879652');
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> insert into paciente_aseguradora(idpaciente,idaseguradora)values('259874','U789654');
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> insert into paciente_aseguradora(idpaciente,idaseguradora)values('8974569','G459633');
Query OK, 1 row affected (0.10 sec)

MariaDB [consulta_externa]> insert into paciente_aseguradora(idpaciente,idaseguradora)values('45987896','E896324');
Query OK, 1 row affected (0.04 sec)

MariaDB [consulta_externa]> insert into paciente_aseguradora(idpaciente,idaseguradora)values('98569874','Y456987');
Query OK, 1 row affected (0.09 sec)

MariaDB [consulta_externa]> insert into paciente_aseguradora(idpaciente,idaseguradora)values('112369874','U789654');
Query OK, 1 row affected (0.07 sec)

MariaDB [consulta_externa]> insert into paciente_aseguradora(idpaciente,idaseguradora)values('369874','T459874');
Query OK, 1 row affected (0.09 sec)

MariaDB [consulta_externa]> select * from paciente_aseguradora;
+------------+---------------+
| idpaciente | idaseguradora |
+------------+---------------+
| 42985630   | C456987       |
| 32569874   | C879652       |
| 259874     | U789654       |
| 8974569    | G459633       |
| 45987896   | E896324       |
| 98569874   | Y456987       |
| 112369874  | U789654       |
| 369874     | T459874       |
+------------+---------------+
8 rows in set (0.00 sec)

MariaDB [consulta_externa]> select medico.idespecialidad,especialidad.descripcion from medico,especialidad where medico.nombre='Gabriel Salazar Jimenez' and especialidad.idespecialidad;
+----------------+---------------------------+
| idespecialidad | descripcion               |
+----------------+---------------------------+
| 9878           | fisioterapia              |
| 9878           | anestesiologia            |
| 9878           | cardiologia               |
| 9878           | neurocirugia              |
| 9878           | neurologia                |
| 9878           | ortopedia y traumatologia |
| 9878           | urologia                  |
| 9878           | Cirugia general           |
+----------------+---------------------------+
8 rows in set (0.10 sec)

MariaDB [consulta_externa]> select medico.idespecialidad,especialidad.descripcion from medico,especialidad where medico.nombre='Gabriel Salazar Jimenez' and especialidad.idespecialidad=idespecialidad.descripcion;
ERROR 1054 (42S22): Unknown column 'idespecialidad.descripcion' in 'where clause'
MariaDB [consulta_externa]> select medico.idespecialidad,especialidad.descripcion from medico,especialidad where medico.nombre='Gabriel Salazar Jimenez' and idespecialidad.descripcion;
ERROR 1054 (42S22): Unknown column 'idespecialidad.descripcion' in 'where clause'
MariaDB [consulta_externa]> select medico.idespecialidad,especialidad.descripcion from medico,especialidad where medico.nombre='Gabriel Salazar Jimenez';
+----------------+---------------------------+
| idespecialidad | descripcion               |
+----------------+---------------------------+
| 9878           | fisioterapia              |
| 9878           | anestesiologia            |
| 9878           | cardiologia               |
| 9878           | neurocirugia              |
| 9878           | neurologia                |
| 9878           | ortopedia y traumatologia |
| 9878           | urologia                  |
| 9878           | Cirugia general           |
+----------------+---------------------------+
8 rows in set (0.00 sec)

MariaDB [consulta_externa]> exit
MariaDB [(none)]> source C:\xampp\consulta_externa011.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.17 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.31 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 10 rows affected (0.12 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.10 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.17 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.04 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.10 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.21 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.16 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.10 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.18 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.03 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.10 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.40 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 10 rows affected (0.14 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.12 sec)

Query OK, 0 rows affected (0.30 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.63 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.06 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.11 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.20 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.02 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [consulta_externa]> show databases;
+--------------------+
| Database           |
+--------------------+
| academico          |
| consulta_externa   |
| facturacion        |
| information_schema |
| institucion        |
| institucion1       |
| libreria           |
| matricula2         |
| mysql              |
| performance_schema |
| phpmyadmin         |
| secundaria         |
| test               |
+--------------------+
13 rows in set (0.00 sec)

MariaDB [consulta_externa]> select idmedico,idespecialidad,nombre,sede,estado from medico where idmedico='98521470';
+----------+----------------+-------------------------+-----------------------------+--------+
| idmedico | idespecialidad | nombre                  | sede                        | estado |
+----------+----------------+-------------------------+-----------------------------+--------+
| 98521470 | 9878           | Gabriel Salazar Jimenez | fundacion clinica del norte |      0 |
+----------+----------------+-------------------------+-----------------------------+--------+
1 row in set (0.00 sec)

MariaDB [consulta_externa]> select * from paciente;
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
| idpaciente | nombre                   | telefono   | direccion           | nom_aseguradora | fecha_nacimiento    |
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
| 112369874  | alicia gutierrez salvado | 4589878    | cra 47 boston       | sura            | 1965-11-02 00:00:00 |
| 259874     | antonella gil            | 3205698745 | cra 43 la estrella  | sura            | 1981-12-08 00:00:00 |
| 32569874   | mateo ramirez yepes      | 3256987    | cra 45 robledo      | coosalud        | 1980-04-28 00:00:00 |
| 369874     | lucia bustamante         | 3006987896 | cra 40 villahermosa | cruz blanca     | 1970-09-26 00:00:00 |
| 42985630   | maria fabiola sanchez    | 2774569    | cra 44 calasanz     | ecoosalud       | 1962-02-25 00:00:00 |
| 45987896   | sofia morales            | 3225689    | cra 39a poblado     | nueva eps       | 1967-02-01 00:00:00 |
| 8974569    | oscar hernandez          | 2369874    | cra 42 envigado     | salud total     | 1978-09-23 00:00:00 |
| 98569874   | luis carlos taborda      | 3504589874 | cra 47 sabaneta     | coomeva         | 1960-04-29 00:00:00 |
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
8 rows in set (0.00 sec)

MariaDB [consulta_externa]> select * from paciente where nom_aseguradora='sura';
+------------+--------------------------+------------+--------------------+-----------------+---------------------+
| idpaciente | nombre                   | telefono   | direccion          | nom_aseguradora | fecha_nacimiento    |
+------------+--------------------------+------------+--------------------+-----------------+---------------------+
| 112369874  | alicia gutierrez salvado | 4589878    | cra 47 boston      | sura            | 1965-11-02 00:00:00 |
| 259874     | antonella gil            | 3205698745 | cra 43 la estrella | sura            | 1981-12-08 00:00:00 |
+------------+--------------------------+------------+--------------------+-----------------+---------------------+
2 rows in set (0.00 sec)

MariaDB [consulta_externa]> select * from medico where nombre like 'J%A';
+----------+----------------+--------------------+-----------------------------+--------+
| idmedico | idespecialidad | nombre             | sede                        | estado |
+----------+----------------+--------------------+-----------------------------+--------+
| 32598784 | 3852           | Juan Jose Arboleda | fundacion clinica del norte |      1 |
+----------+----------------+--------------------+-----------------------------+--------+
1 row in set (0.00 sec)

MariaDB [consulta_externa]> select * from medico;
+------------+----------------+-------------------------+-----------------------------+--------+
| idmedico   | idespecialidad | nombre                  | sede                        | estado |
+------------+----------------+-------------------------+-----------------------------+--------+
| 1042598789 | 2589           | Nora Martinez Mu?z     | fundacion clinica del norte |      1 |
| 1126959873 | 2369           | Maria Gabriela Quiroz   | fundacion clinica del norte |      1 |
| 1128459874 | 3847           | Dario Mendoza           | fundacion clinica del norte |      1 |
| 32598784   | 3852           | Juan Jose Arboleda      | fundacion clinica del norte |      1 |
| 42795698   | 9878           | Camila Gil Lopera       | fundacion clinica del norte |      1 |
| 71658963   | 8978           | Daniel Hernandez Vega   | fundacion clinica del norte |      1 |
| 71658987   | 3689           | Jose Alberto Ocampo     | fundacion clinica del norte |      1 |
| 98521470   | 9878           | Gabriel Salazar Jimenez | fundacion clinica del norte |      0 |
| 98521478   | 3852           | Juan Pablo Martinez     | fundacion clinica del norte |      1 |
| 98545912   | 8796           | Hector Lopez Lopez      | fundacion clinica del norte |      1 |
+------------+----------------+-------------------------+-----------------------------+--------+
10 rows in set (0.00 sec)

MariaDB [consulta_externa]> select * from paciente order by nombre asc;
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
| idpaciente | nombre                   | telefono   | direccion           | nom_aseguradora | fecha_nacimiento    |
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
| 112369874  | alicia gutierrez salvado | 4589878    | cra 47 boston       | sura            | 1965-11-02 00:00:00 |
| 259874     | antonella gil            | 3205698745 | cra 43 la estrella  | sura            | 1981-12-08 00:00:00 |
| 369874     | lucia bustamante         | 3006987896 | cra 40 villahermosa | cruz blanca     | 1970-09-26 00:00:00 |
| 98569874   | luis carlos taborda      | 3504589874 | cra 47 sabaneta     | coomeva         | 1960-04-29 00:00:00 |
| 42985630   | maria fabiola sanchez    | 2774569    | cra 44 calasanz     | ecoosalud       | 1962-02-25 00:00:00 |
| 32569874   | mateo ramirez yepes      | 3256987    | cra 45 robledo      | coosalud        | 1980-04-28 00:00:00 |
| 8974569    | oscar hernandez          | 2369874    | cra 42 envigado     | salud total     | 1978-09-23 00:00:00 |
| 45987896   | sofia morales            | 3225689    | cra 39a poblado     | nueva eps       | 1967-02-01 00:00:00 |
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
8 rows in set (0.00 sec)

MariaDB [consulta_externa]> exit
MariaDB [(none)]> source C:\xampp\consulta_externa111.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.24 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.22 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 10 rows affected (0.13 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.30 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.26 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.10 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.15 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.16 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.03 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.11 sec)

Query OK, 0 rows affected (0.11 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.22 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.08 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.14 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.20 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 10 rows affected (0.03 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.12 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.18 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.03 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.14 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.28 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 8 rows affected (0.10 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [consulta_externa]> select medico.idmedico,medico.nombre,especialidad.idespecialidad,especialidad.descripcion from medico,especialidad where medico.idmedico=especialidad.idespecialidad;
Empty set (0.01 sec)

MariaDB [consulta_externa]> select medico.idmedico,medico.nombre,especialidad.idespecialidad,especialidad.descripcion from medico,especialidad where medico.idespecialidad=especialidad.idespecialidad;
+------------+-------------------------+----------------+---------------------------+
| idmedico   | nombre                  | idespecialidad | descripcion               |
+------------+-------------------------+----------------+---------------------------+
| 1042598789 | Nora Martinez Mu?z     | 2589           | anestesiologia            |
| 1126959873 | Maria Gabriela Quiroz   | 2369           | fisioterapia              |
| 1128459874 | Dario Mendoza           | 3847           | neurocirugia              |
| 32598784   | Juan Jose Arboleda      | 3852           | neurologia                |
| 42795698   | Camila Gil Lopera       | 9878           | Cirugia general           |
| 71658963   | Daniel Hernandez Vega   | 8978           | urologia                  |
| 71658987   | Jose Alberto Ocampo     | 3689           | cardiologia               |
| 98521470   | Gabriel Salazar Jimenez | 9878           | Cirugia general           |
| 98521478   | Juan Pablo Martinez     | 3852           | neurologia                |
| 98545912   | Hector Lopez Lopez      | 8796           | ortopedia y traumatologia |
+------------+-------------------------+----------------+---------------------------+
10 rows in set (0.00 sec)

MariaDB [consulta_externa]> select especialidad.idespecialidad,especialidad.descripcion from paciente,especialidad,especial_paciente where paciente.idpaciente='112369874' and paciente.idpaciente=especial_paciente.idpaciente and especial_paciente.idespecialidad=especialidad.idespecialidad;
+----------------+--------------+
| idespecialidad | descripcion  |
+----------------+--------------+
| 3847           | neurocirugia |
+----------------+--------------+
1 row in set (0.00 sec)

MariaDB [consulta_externa]> describe paciente;
    -> 
    -> Insert into alumno(idpaciente,nombre,telefono,direccion,nom_aseguradora,fecha_nacimiento) values(_idpaciente,_nombre,_telefono,_direccion,_nom_aseguradora,_fecha_nacimiento);
    -> end
    -> //
+------------------+-------------+------+-----+---------+-------+
| Field            | Type        | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| idpaciente       | varchar(10) | NO   | PRI | NULL    |       |
| nombre           | varchar(60) | NO   |     | NULL    |       |
| telefono         | varchar(15) | NO   |     | NULL    |       |
| direccion        | varchar(20) | NO   |     | NULL    |       |
| nom_aseguradora  | varchar(45) | NO   |     | NULL    |       |
| fecha_nacimiento | datetime    | NO   |     | NULL    |       |
+------------------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)

MariaDB [consulta_externa]> Delimiter //
MariaDB [consulta_externa]> begin
    -> Create procedure insertarpaciente(in  _idpaciente char(10), in  _nombre char(60), in  _telefono char(15), in _direccion char(20), in _nom_aseguradora char(45), in _fecha_nacimiento date)
    -> begin
    -> Create procedure insertarpaciente(in  _idpaciente char(10), in  _nombre char(60), in  _telefono char(15), in _direccion char(20), in _nom_aseguradora char(45), in _fecha_nacimiento date)
    -> Insert into paciente(idpaciente,nombre,telefono,direccion,nom_aseguradora,fecha_nacimiento) values(_idpaciente,_nombre,_telefono,_direccion,_nom_aseguradora,_fecha_nacimiento);
    -> end
    -> //

MariaDB [consulta_externa]> Delimiter //
MariaDB [consulta_externa]> create procedure insertarpaciente(in  _idpaciente char(10), in  _nombre char(60), in  _telefono char(15), in _direccion char(20), in _nom_aseguradora char(45), in _fecha_nacimiento date)
    -> begin
    -> Insert into paciente(idpaciente,nombre,telefono,direccion,nom_aseguradora,fecha_nacimiento) values(_idpaciente,_nombre,_telefono,_direccion,_nom_aseguradora,_fecha_nacimiento);
    -> end
    -> //
Query OK, 0 rows affected (0.00 sec)

MariaDB [consulta_externa]> delimiter ;
MariaDB [consulta_externa]> show procedure status;
+------------------+------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db               | Name             | Type      | Definer        | Modified            | Created             | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+------------------+------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| consulta_externa | insertarpaciente | PROCEDURE | root@localhost | 2019-05-27 11:56:17 | 2019-05-27 11:56:17 | DEFINER       |         | cp850                | cp850_general_ci     | latin1_swedish_ci  |
+------------------+------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
1 row in set (0.01 sec)

MariaDB [consulta_externa]> call insertarpaciente('42793972','Liliana Taborda Sanchez','5670747','cra 47 samaria','sura','1978-01-30');
Query OK, 1 row affected (0.11 sec)

MariaDB [consulta_externa]> select * from  paciente;
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
| idpaciente | nombre                   | telefono   | direccion           | nom_aseguradora | fecha_nacimiento    |
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
| 112369874  | alicia gutierrez salvado | 4589878    | cra 47 boston       | sura            | 1965-11-02 00:00:00 |
| 259874     | antonella gil            | 3205698745 | cra 43 la estrella  | sura            | 1981-12-08 00:00:00 |
| 32569874   | mateo ramirez yepes      | 3256987    | cra 45 robledo      | coosalud        | 1980-04-28 00:00:00 |
| 369874     | lucia bustamante         | 3006987896 | cra 40 villahermosa | cruz blanca     | 1970-09-26 00:00:00 |
| 42793972   | Liliana Taborda Sanchez  | 5670747    | cra 47 samaria      | sura            | 1978-01-30 00:00:00 |
| 42985630   | maria fabiola sanchez    | 2774569    | cra 44 calasanz     | ecoosalud       | 1962-02-25 00:00:00 |
| 45987896   | sofia morales            | 3225689    | cra 39a poblado     | nueva eps       | 1967-02-01 00:00:00 |
| 8974569    | oscar hernandez          | 2369874    | cra 42 envigado     | salud total     | 1978-09-23 00:00:00 |
| 98569874   | luis carlos taborda      | 3504589874 | cra 47 sabaneta     | coomeva         | 1960-04-29 00:00:00 |
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
9 rows in set (0.00 sec)

MariaDB [consulta_externa]> delimiter //
MariaDB [consulta_externa]> create procedure listarpaciente()
    -> begin
    -> select * from paciente;
    -> end
    -> //
Query OK, 0 rows affected (0.04 sec)

MariaDB [consulta_externa]> delimiter ;
MariaDB [consulta_externa]> call listarpaciente();
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
| idpaciente | nombre                   | telefono   | direccion           | nom_aseguradora | fecha_nacimiento    |
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
| 112369874  | alicia gutierrez salvado | 4589878    | cra 47 boston       | sura            | 1965-11-02 00:00:00 |
| 259874     | antonella gil            | 3205698745 | cra 43 la estrella  | sura            | 1981-12-08 00:00:00 |
| 32569874   | mateo ramirez yepes      | 3256987    | cra 45 robledo      | coosalud        | 1980-04-28 00:00:00 |
| 369874     | lucia bustamante         | 3006987896 | cra 40 villahermosa | cruz blanca     | 1970-09-26 00:00:00 |
| 42793972   | Liliana Taborda Sanchez  | 5670747    | cra 47 samaria      | sura            | 1978-01-30 00:00:00 |
| 42985630   | maria fabiola sanchez    | 2774569    | cra 44 calasanz     | ecoosalud       | 1962-02-25 00:00:00 |
| 45987896   | sofia morales            | 3225689    | cra 39a poblado     | nueva eps       | 1967-02-01 00:00:00 |
| 8974569    | oscar hernandez          | 2369874    | cra 42 envigado     | salud total     | 1978-09-23 00:00:00 |
| 98569874   | luis carlos taborda      | 3504589874 | cra 47 sabaneta     | coomeva         | 1960-04-29 00:00:00 |
+------------+--------------------------+------------+---------------------+-----------------+---------------------+
9 rows in set (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

MariaDB [consulta_externa]> delimiter //
MariaDB [consulta_externa]> create procedure cons_paciente(in idpaciente char(10))
    -> begin
    -> Select *from paciente where idpaciente=idpaciente;
    -> end
    -> //
Query OK, 0 rows affected (0.07 sec)

MariaDB [consulta_externa]> delimiter ;
MariaDB [consulta_externa]> show procedure status;
+------------------+------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db               | Name             | Type      | Definer        | Modified            | Created             | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+------------------+------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| consulta_externa | cons_paciente    | PROCEDURE | root@localhost | 2019-05-27 13:13:23 | 2019-05-27 13:13:23 | DEFINER       |         | cp850                | cp850_general_ci     | latin1_swedish_ci  |
| consulta_externa | insertarpaciente | PROCEDURE | root@localhost | 2019-05-27 11:56:17 | 2019-05-27 11:56:17 | DEFINER       |         | cp850                | cp850_general_ci     | latin1_swedish_ci  |
| consulta_externa | listarpaciente   | PROCEDURE | root@localhost | 2019-05-27 13:01:03 | 2019-05-27 13:01:03 | DEFINER       |         | cp850                | cp850_general_ci     | latin1_swedish_ci  |
+------------------+------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
3 rows in set (0.01 sec)


MariaDB [consulta_externa]> exit