mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | autoincremento | | cdcol | | colegio | | fechas | | libreria | | mysql | | performance_schema | | phpmyadmin | | precios | | test | | turismo | | webauth | +--------------------+ 13 rows in set (0.31 sec) mysql> create database escoltar; Query OK, 1 row affected (0.02 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | autoincremento | | cdcol | | colegio | | escoltar | | fechas | | libreria | | mysql | | performance_schema | | phpmyadmin | | precios | | test | | turismo | | webauth | +--------------------+ 14 rows in set (0.00 sec) mysql> create table empleado -> (idemple char(10) not null primary key, -> nombre_apellido char(40) not null, -> gr char(3) not null, -> estciv char(15) not null, -> fecnac date not null, -> direccion char(30) not null, -> barrio char(20) not null, -> celular char(12) not null, -> fechingr date not null, -> e_mail char(40) not null); Query OK, 0 rows affected (0.39 sec) mysql> create table placa -> (idplaca char(6) not null primary key, -> idemple char(10) not null, -> tipo_placa char(12) not null); Query OK, 0 rows affected (0.23 sec) mysql> create table forma_acade -> (idemple char(10) not null primary key, -> nombre_apellido char(40) not null, -> titulo char(50) not null, -> idacade char(2) not null); Query OK, 0 rows affected (0.47 sec) mysql> create table beneficiarios -> (idbenef char(10) not null primary key, -> nombre_apellido char(40) not null, -> fecnac date not null, -> parentesco char(10) not null, -> direccion char(30) not null, -> barrio char(20) not null, -> celular char(12) not null); Query OK, 0 rows affected (0.25 sec) mysql> create table empbene -> (idemple char(10) not null, -> idbenef char(10) not null, -> foreign key (idemple) references empleado(idemple) on delete cascade on update cascade, -> foreign key (idbenef) references beneficiarios(idbenef) on delete cascade on update cascade); Query OK, 0 rows affected (0.23 sec) mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | forma_acade | | placa | +--------------------+ 5 rows in set (0.03 sec) mysql> describe forma_acade; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | PRI | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | titulo | char(50) | NO | | NULL | | | idacade | char(2) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 4 rows in set (0.05 sec) mysql> describe empleado; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | PRI | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | gr | char(3) | NO | | NULL | | | estciv | char(15) | NO | | NULL | | | fecnac | date | NO | | NULL | | | direccion | char(30) | NO | | NULL | | | barrio | char(20) | NO | | NULL | | | celular | char(12) | NO | | NULL | | | fechingr | date | NO | | NULL | | | e_mail | char(40) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 10 rows in set (0.02 sec) mysql> alter table empleado add idacade char(3) not null; Query OK, 0 rows affected (0.53 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> describe empleado; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | PRI | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | gr | char(3) | NO | | NULL | | | estciv | char(15) | NO | | NULL | | | fecnac | date | NO | | NULL | | | direccion | char(30) | NO | | NULL | | | barrio | char(20) | NO | | NULL | | | celular | char(12) | NO | | NULL | | | fechingr | date | NO | | NULL | | | e_mail | char(40) | NO | | NULL | | | idacade | char(3) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 11 rows in set (0.01 sec) mysql> alter table empleado modify idacade char(2) not null; Query OK, 0 rows affected (0.73 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> describe empleado; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | PRI | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | gr | char(3) | NO | | NULL | | | estciv | char(15) | NO | | NULL | | | fecnac | date | NO | | NULL | | | direccion | char(30) | NO | | NULL | | | barrio | char(20) | NO | | NULL | | | celular | char(12) | NO | | NULL | | | fechingr | date | NO | | NULL | | | e_mail | char(40) | NO | | NULL | | | idacade | char(2) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 11 rows in set (0.00 sec) mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | forma_acade | | placa | +--------------------+ 5 rows in set (0.00 sec) mysql> describe forma_acade; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | PRI | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | titulo | char(50) | NO | | NULL | | | idacade | char(2) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 4 rows in set (0.01 sec) mysql> exit mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | autoincremento | | cdcol | | colegio | | escoltar | | fechas | | libreria | | mysql | | performance_schema | | phpmyadmin | | precios | | test | | turismo | | webauth | +--------------------+ 14 rows in set (0.00 sec) mysql> source D:\escoltar.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.02 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, 0 rows affected (0.00 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.13 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.19 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.13 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, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.08 sec) 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.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.09 sec) 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.00 sec) 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.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, 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) mysql> use escoltar; Database changed mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | forma_acade | | placa | +--------------------+ 5 rows in set (0.00 sec) mysql> describe empleado; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | PRI | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | gr | char(3) | NO | | NULL | | | estciv | char(15) | NO | | NULL | | | fecnac | date | NO | | NULL | | | direccion | char(30) | NO | | NULL | | | barrio | char(20) | NO | | NULL | | | celular | char(12) | NO | | NULL | | | fechingr | date | NO | | NULL | | | e_mail | char(40) | NO | | NULL | | | idacade | char(2) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 11 rows in set (0.02 sec) mysql> describe forma_acade; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | PRI | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | titulo | char(50) | NO | | NULL | | | idacade | char(2) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 4 rows in set (0.00 sec) mysql> drop table forma_acade; Query OK, 0 rows affected (0.08 sec) mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | placa | +--------------------+ 4 rows in set (0.00 sec) mysql> create table estudios -> (idestudio char(2) not null primary key, -> idemple char(10) not null, -> nombre_apellido char(40) not null, -> carrera char(40) not null); Query OK, 0 rows affected (0.34 sec) mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | estudios | | placa | +--------------------+ 5 rows in set (0.00 sec) mysql> create table emplestudios -> (idemple char(10) not null, -> idestudio char(2) not null, -> foreign key (idemple) references empleado (idemple) on delete cascade on update cascade, -> foreign key (idestudio) references estudios(idestudio) on delete cascade on update cascade); Query OK, 0 rows affected (0.55 sec) mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | emplestudios | | estudios | | placa | +--------------------+ 6 rows in set (0.00 sec) mysql> describe empleado; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | PRI | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | gr | char(3) | NO | | NULL | | | estciv | char(15) | NO | | NULL | | | fecnac | date | NO | | NULL | | | direccion | char(30) | NO | | NULL | | | barrio | char(20) | NO | | NULL | | | celular | char(12) | NO | | NULL | | | fechingr | date | NO | | NULL | | | e_mail | char(40) | NO | | NULL | | | idacade | char(2) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 11 rows in set (0.00 sec) mysql> alter table empleado drop idacade; Query OK, 0 rows affected (0.39 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> describe empleado; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | PRI | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | gr | char(3) | NO | | NULL | | | estciv | char(15) | NO | | NULL | | | fecnac | date | NO | | NULL | | | direccion | char(30) | NO | | NULL | | | barrio | char(20) | NO | | NULL | | | celular | char(12) | NO | | NULL | | | fechingr | date | NO | | NULL | | | e_mail | char(40) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 10 rows in set (0.00 sec) mysql> delimiter // mysql> create procedure insertar_empleado(in idemple_ char(10),in nombre_apellido_ char(40), in gr_ char(3), in estciv_ char(15), in fecnac_ date, in direccion_ char(30), in barrio_ char(20), in celular_ char(12), in fechingr_ date, in e_mail_ char(40)) -> begin -> insert into empleado(idemple,nombre_apellido,gr,estciv,fecnac,direccion,barrio,celular,fechingr,e_mail) values (idemple_,nombre_apellido_,gr_,estciv_,fecnac_,direccion_,barrio_,celular_,fechingr_,e_mail_); -> end -> // Query OK, 0 rows affected (0.08 sec) mysql> delimiter ; mysql> describe beneficiarios; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idbenef | char(10) | NO | PRI | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | fecnac | date | NO | | NULL | | | parentesco | char(10) | NO | | NULL | | | direccion | char(30) | NO | | NULL | | | barrio | char(20) | NO | | NULL | | | celular | char(12) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 7 rows in set (0.00 sec) mysql> delimiter // mysql> create procedure insertar_beneficiarios(in idbenef_ char(10),in nombre_apellido_ char(40), in fecnac_ date, in parentesco_ char(10), in direccion_ char(30), in barrio_ char(20), in celular_ char(12)) -> begin -> insert into beneficiarios(idbenef,nombre_apellido,fecnac,parentesco,direccion,barrio,celular) values (idbenef_,nombre_apellido_,fecnac_,parentesco_,direccion_,barrio_,celular_); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> delimiter ; mysql> delimiter // mysql> create procedure insertar_placa(in idplaca_ char(6),in idemple_ char(10), in tipo_placa_ char(12)) -> begin -> insert into placa(idplaca,idemple,tipo_placa) values (idplaca_,idemple_,tipo_placa_); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | emplestudios | | estudios | | placa | +--------------------+ 6 rows in set (0.00 sec) mysql> describe estudios; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idestudio | char(2) | NO | PRI | NULL | | | idemple | char(10) | NO | | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | carrera | char(40) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 4 rows in set (0.00 sec) mysql> delimiter // mysql> create procedure insertar_estudios(in idestudio_ char(2),in idemple_ char(10), in nombre_apellido_ char(40), in carrera_ char(40)) -> begin -> insert into estudios(idestudio,idemple,nombre_apellido,carrera) values (idestudio_,idemple_,nombre_apellido_,carrera_); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> describe empbene; +---------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | MUL | NULL | | | idbenef | char(10) | NO | MUL | NULL | | +---------+----------+------+-----+---------+-------+ 2 rows in set (0.02 sec) mysql> delimiter // mysql> create procedure insertar_empbene(in idemple_ char(10), in idbenef_ char(10)) -> begin -> insert into empbene(idemple,idbenef) values (idemple_,idbenef_); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> describe emplestudios; +-----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | MUL | NULL | | | idestudio | char(2) | NO | MUL | NULL | | +-----------+----------+------+-----+---------+-------+ 2 rows in set (0.00 sec) mysql> delimiter // mysql> create procedure insertar_emplestudios(in idemple_ char(10),in idestudio_ char(2)) -> begin -> insert into emplestudios(idemple,idestudio) values (idemple_,idestudio_); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> show procedure status; +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | escoltar | insertar_beneficiarios | PROCEDURE | root@localhost | 2015-11-08 16:29:19 | 2015-11-08 16:29:19 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empbene | PROCEDURE | root@localhost | 2015-11-08 17:18:09 | 2015-11-08 17:18:09 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empleado | PROCEDURE | root@localhost | 2015-11-08 16:22:44 | 2015-11-08 16:22:44 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_emplestudios | PROCEDURE | root@localhost | 2015-11-08 17:20:50 | 2015-11-08 17:20:50 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_estudios | PROCEDURE | root@localhost | 2015-11-08 17:15:22 | 2015-11-08 17:15:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_placa | PROCEDURE | root@localhost | 2015-11-08 17:10:40 | 2015-11-08 17:10:40 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 6 rows in set (0.02 sec) mysql> show procedure status; +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | escoltar | insertar_beneficiarios | PROCEDURE | root@localhost | 2015-11-08 16:29:19 | 2015-11-08 16:29:19 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empbene | PROCEDURE | root@localhost | 2015-11-08 17:18:09 | 2015-11-08 17:18:09 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empleado | PROCEDURE | root@localhost | 2015-11-08 16:22:44 | 2015-11-08 16:22:44 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_emplestudios | PROCEDURE | root@localhost | 2015-11-08 17:20:50 | 2015-11-08 17:20:50 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_estudios | PROCEDURE | root@localhost | 2015-11-08 17:15:22 | 2015-11-08 17:15:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_placa | PROCEDURE | root@localhost | 2015-11-08 17:10:40 | 2015-11-08 17:10:40 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 6 rows in set (0.01 sec) mysql> show create procedure insertar_empleado; +-------------------+------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +-------------------+------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | insertar_empleado | NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`root`@`localhost` PROCEDURE `insertar_empleado`(in idemple_ char(10),in nombre_apellido_ char(40), in gr_ char(3), in estciv_ char(15), in fecnac_ date, in direccion_ char(30), in barrio_ char(20), in celular_ char(12), in fechingr_ date, in e_mail_ char(40)) begin insert into empleado(idemple,nombre_apellido,gr,estciv,fecnac,direccion,barrio,celular,fechingr,e_mail) values (idemple_,nombre_apellido_,gr_,estciv_,fecnac_,direccion_,barrio_,celular_,fechingr_,e_mail_); end | cp850 | cp850_general_ci | latin1_swedish_ci | +-------------------+------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.00 sec) mysql> describe empleado; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | PRI | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | gr | char(3) | NO | | NULL | | | estciv | char(15) | NO | | NULL | | | fecnac | date | NO | | NULL | | | direccion | char(30) | NO | | NULL | | | barrio | char(20) | NO | | NULL | | | celular | char(12) | NO | | NULL | | | fechingr | date | NO | | NULL | | | e_mail | char(40) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 10 rows in set (0.00 sec) mysql> show procedure status; +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | escoltar | insertar_beneficiarios | PROCEDURE | root@localhost | 2015-11-08 16:29:19 | 2015-11-08 16:29:19 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empbene | PROCEDURE | root@localhost | 2015-11-08 17:18:09 | 2015-11-08 17:18:09 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empleado | PROCEDURE | root@localhost | 2015-11-08 16:22:44 | 2015-11-08 16:22:44 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_emplestudios | PROCEDURE | root@localhost | 2015-11-08 17:20:50 | 2015-11-08 17:20:50 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_estudios | PROCEDURE | root@localhost | 2015-11-08 17:15:22 | 2015-11-08 17:15:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_placa | PROCEDURE | root@localhost | 2015-11-08 17:10:40 | 2015-11-08 17:10:40 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 6 rows in set (0.00 sec) mysql> exit mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | cdcol | | escoltar | | facturacion | | libreria | | mysql | | performance_schema | | phpmyadmin | | sistema_de_credito | | taller2 | | test | | vehiculo | | webauth | +--------------------+ 13 rows in set (0.12 sec) mysql> use escoltar; Database changed mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | emplestudios | | estudios | +--------------------+ 5 rows in set (0.00 sec) mysql> describe beneficiarios; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idbenef | char(10) | NO | PRI | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | fecnac | date | NO | | NULL | | | parentesco | char(10) | NO | | NULL | | | direccion | char(30) | NO | | NULL | | | barrio | char(20) | NO | | NULL | | | celular | char(12) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 7 rows in set (0.01 sec) mysql> describe emplestudios; +-------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | MUL | NULL | | | idestudio | char(2) | NO | MUL | NULL | | | descripcion | char(30) | NO | | NULL | | +-------------+----------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> describe estudios; +-----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------+------+-----+---------+-------+ | idestudio | char(2) | NO | PRI | NULL | | | idemple | char(10) | NO | | NULL | | | titulo | char(30) | NO | | NULL | | +-----------+----------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | cdcol | | escoltar | | facturacion | | libreria | | mysql | | performance_schema | | phpmyadmin | | sistema_de_credito | | taller2 | | test | | vehiculo | | webauth | +--------------------+ 13 rows in set (0.00 sec) mysql> use escoltar; Database changed mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | emplestudios | | estudios | | placa | +--------------------+ 6 rows in set (0.00 sec) mysql> describe placa; +------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+----------+------+-----+---------+-------+ | idplaca | char(6) | NO | PRI | NULL | | | idemple | char(10) | NO | | NULL | | | tipo_placa | char(12) | NO | | NULL | | +------------+----------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> drop table placa; Query OK, 0 rows affected (0.04 sec) mysql> create table placa -> (idplaca char(6) null primary key, -> idemple char(10) not null, -> tipoplaca char(12) null); Query OK, 0 rows affected (0.04 sec) mysql> describe placa; +-----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------+------+-----+---------+-------+ | idplaca | char(6) | NO | PRI | NULL | | | idemple | char(10) | NO | | NULL | | | tipoplaca | char(12) | YES | | NULL | | +-----------+----------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | cdcol | | escoltar | | facturacion | | libreria | | mysql | | performance_schema | | phpmyadmin | | sistema_de_credito | | taller2 | | test | | vehiculo | | webauth | +--------------------+ 13 rows in set (0.00 sec) mysql> use escoltar; Database changed mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | emplestudios | | estudios | | placa | +--------------------+ 6 rows in set (0.00 sec) mysql> describe placa; +------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+----------+------+-----+---------+-------+ | idplaca | char(6) | NO | PRI | | | | idemple | char(10) | NO | | NULL | | | tipo_placa | char(12) | YES | | NULL | | +------------+----------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> describe emplestudios; +-------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | MUL | NULL | | | idestudio | char(2) | NO | MUL | NULL | | | descripcion | char(30) | NO | | NULL | | +-------------+----------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> use escoltar; Database changed mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | emplestudios | | estudios | | placa | +--------------------+ 6 rows in set (0.00 sec) mysql> describe beneficiarios; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idbenef | char(10) | NO | PRI | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | fecnac | date | NO | | NULL | | | parentesco | char(10) | NO | | NULL | | | direccion | char(30) | NO | | NULL | | | barrio | char(20) | NO | | NULL | | | celular | char(12) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 7 rows in set (0.01 sec) mysql> show procedure status; +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | escoltar | insertar_beneficiarios | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empbene | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empleado | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_estudios | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_placa | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 5 rows in set (0.02 sec) mysql> call insertar_beneficiarios('1025484785','maria cristina perez','1979-10-14','compa¤era','calle 45 # 52-98','el picacho','321-8596741'); Query OK, 1 row affected (0.04 sec) mysql> call insertar_beneficiarios('71452366','martha graciela diaz','1959-03-10','madre','calle 5 # 152-98','el contento','300-4589745'); Query OK, 1 row affected (0.03 sec) mysql> call insertar_beneficiarios('76239101','carlos alberto corzo perez','1969-05-02','padre','calle 5 # 152-98','el contento','310-4152745'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_beneficiarios('43825002','carolina perez ortega','1989-12-10','conyuge','calle 41 # 78-89','floresta','311-5869417'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_beneficiarios('1032031134','jeronimo contreras ortega','2011-05-05','hijo','calle 104 # 86-17','centro','321-7885967'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_beneficiarios('1011458916','camilo andres cardenas perez','2000-08-13','hijo','calle 117 # 26-87','la america','315-7485216'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_beneficiarios('70451089','bernardo pineda ordo¤ez','1949-10-10','padre','calle 104b # 84-10','doce de octubre','350-1425368'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_beneficiarios('71286020','mario alberto corzo perez','1989-05-02','hermano','calle 32 # 10-15','bello','320-5847158'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_beneficiarios('88241906','juan pablo contreras ortega','2011-07-10','hijo','calle 82 # 50-47','cristobal','300-1145263'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_beneficiarios('1017456819','maria isabel cardenas','1999-10-10','amiga','calle 44 # 81-85','santa monica','311-8574891'); Query OK, 1 row affected (0.00 sec) mysql> select * from beneficiarios; +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ | idbenef | nombre_apellido | fecnac | parentesco | direccion | barrio | celular | +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ | 1011458916 | camilo andres cardenas perez | 2000-08-13 | hijo | calle 117 # 26-87 | la america | 315-7485216 | | 1017456819 | maria isabel cardenas | 1999-10-10 | amiga | calle 44 # 81-85 | santa monica | 311-8574891 | | 1025484785 | maria cristina perez | 1979-10-14 | compa¤era | calle 45 # 52-98 | el picacho | 321-8596741 | | 1032031134 | jeronimo contreras ortega | 2011-05-05 | hijo | calle 104 # 86-17 | centro | 321-7885967 | | 43825002 | carolina perez ortega | 1989-12-10 | conyuge | calle 41 # 78-89 | floresta | 311-5869417 | | 70451089 | bernardo pineda ordo¤ez | 1949-10-10 | padre | calle 104b # 84-10 | doce de octubre | 350-1425368 | | 71286020 | mario alberto corzo perez | 1989-05-02 | hermano | calle 32 # 10-15 | bello | 320-5847158 | | 71452366 | martha graciela diaz | 1959-03-10 | madre | calle 5 # 152-98 | el contento | 300-4589745 | | 76239101 | carlos alberto corzo perez | 1969-05-02 | padre | calle 5 # 152-98 | el contento | 310-4152745 | | 88241906 | juan pablo contreras ortega | 2011-07-10 | hijo | calle 82 # 50-47 | cristobal | 300-1145263 | +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ 10 rows in set (0.00 sec) mysql> describe empleado; +-----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | PRI | NULL | | | nombre_apellido | char(40) | NO | | NULL | | | gr | char(3) | NO | | NULL | | | estciv | char(15) | NO | | NULL | | | fecnac | date | NO | | NULL | | | direccion | char(30) | NO | | NULL | | | barrio | char(20) | NO | | NULL | | | celular | char(12) | NO | | NULL | | | fechingr | date | NO | | NULL | | | e_mail | char(40) | NO | | NULL | | +-----------------+----------+------+-----+---------+-------+ 10 rows in set (0.01 sec) mysql> call insertar_empleado('71312945','juan camilo cardenas ortega','vig','union libre','1979-10-24','calle 34 # 10-25','el pesebre','315-7485126','2000-10-05','juancamilo@gmail.com'); Query OK, 1 row affected (0.01 sec) mysql> call insertar_empleado('76319517','carlos corzo diaz','vig','soltero','1978-11-04','calle 38 # 110-25','centro','317-45124850','2001-08-05','carloscorzo@gmail.com'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_empleado('1001345216','william andres osorio','sup','soltero','1982-12-15','calle 10 # 10-25','el volador','317-5214578','2007-09-07','william@hotmail.com'); Query OK, 1 row affected (0.01 sec) mysql> call insertar_empleado('99327916','juan camilo perez','rec','casado','1983-12-15','calle 10 # 80-05','manrique','318-5254278','2005-09-07','juancamilo@hotmail.com'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_empleado('88254919','juan esteban contreras','vig','soltero','1984-12-04','calle 20 # 10-05','la estrella','300-5254278','2001-09-07','juanesteban@hotmail.com'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_empleado('76318941','camilo cardenas sanchez','sup','soltero','1972-11-24','calle 29 # 210-05','envigado','320-5252358','2000-09-01','camilo1542@hotmail.com'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_empleado('81616624','mario pineda cardona','vig','soltero','1982-11-04','calle 114 # 71-58','poblado','311-4252358','2008-09-01','mariopineda@hotmail.com'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_empleado('94316519','mario andres corzo perez','vig','soltero','1988-11-14','calle 4 # 1-5','maruchenga','319-4124538','2007-09-10','marioandres@hotmail.com'); Query OK, 1 row affected (0.02 sec) mysql> call insertar_empleado('70312916','jose contreras palomino','sup','soltero','1992-10-24','calle 114 # 541-55','sabaneta','300-4124538','2009-09-10','josecontreras@yahoo.es'); Query OK, 1 row affected (0.01 sec) mysql> call insertar_empleado('90310311','pedro nel ospina','vig','soltero','1994-10-24','calle 14 # 51-45','bello','310-1245685','200-09-10','josecontreras@yahoo.es'); Query OK, 1 row affected (0.00 sec) mysql> select * from empleado; +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+--------------+------------+-------------------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+--------------+------------+-------------------------+ | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-45124850 | 2001-08-05 | carloscorzo@gmail.com | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | | 90310311 | pedro nel ospina | vig | soltero | 1994-10-24 | calle 14 # 51-45 | bello | 310-1245685 | 0200-09-10 | josecontreras@yahoo.es | | 94316519 | mario andres corzo perez | vig | soltero | 1988-11-14 | calle 4 # 1-5 | maruchenga | 319-4124538 | 2007-09-10 | marioandres@hotmail.com | | 99327916 | juan camilo perez | rec | casado | 1983-12-15 | calle 10 # 80-05 | manrique | 318-5254278 | 2005-09-07 | juancamilo@hotmail.com | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+--------------+------------+-------------------------+ 10 rows in set (0.00 sec) mysql> describe empbene; +---------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | MUL | NULL | | | idbenef | char(10) | NO | MUL | NULL | | +---------+----------+------+-----+---------+-------+ 2 rows in set (0.01 sec) mysql> call insertar_empbene('71312945','1025484785'); Query OK, 1 row affected (0.02 sec) mysql> call insertar_empbene('76319517','71452366'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_empbene('76319517','76239101'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_empbene('99327916','43825002'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_empbene('88254919','1032031134'); Query OK, 1 row affected (0.01 sec) mysql> call insertar_empbene('76318941','1011458916'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_empbene('81616624','70451089'); Query OK, 1 row affected (0.01 sec) mysql> call insertar_empbene('94316519','71286020'); Query OK, 1 row affected (0.01 sec) mysql> call insertar_empbene('70312916','88241906'); Query OK, 1 row affected (0.02 sec) mysql> call insertar_empbene('90310311','1017456819'); Query OK, 1 row affected (0.00 sec) mysql> select * from empbene; +----------+------------+ | idemple | idbenef | +----------+------------+ | 71312945 | 1025484785 | | 76319517 | 71452366 | | 76319517 | 76239101 | | 99327916 | 43825002 | | 88254919 | 1032031134 | | 76318941 | 1011458916 | | 81616624 | 70451089 | | 94316519 | 71286020 | | 70312916 | 88241906 | | 90310311 | 1017456819 | +----------+------------+ 10 rows in set (0.00 sec) mysql> describe placa; +------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+----------+------+-----+---------+-------+ | idplaca | char(6) | NO | PRI | | | | idemple | char(10) | NO | | NULL | | | tipo_placa | char(12) | YES | | NULL | | +------------+----------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> call insertar_placa('129948','71312945','chip'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_placa('','76319517',''); Query OK, 1 row affected (0.00 sec) mysql> call insertar_placa('114563','1001345216','chip'); Query OK, 1 row affected (0.02 sec) mysql> call insertar_placa('504168','99327916','chip'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_placa('001478','88254919','tradicional'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_placa('001647','76318941','tradicional'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_placa('114578','81616624','chip'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_placa('','94316519',''); ERROR 1062 (23000): Duplicate entry '' for key 'PRIMARY' mysql> call insertar_placa('145874','94316519','chip'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_placa('129914','70312916','chip'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_placa('','90310311',''); ERROR 1062 (23000): Duplicate entry '' for key 'PRIMARY' mysql> call insertar_placa('145794','90310311','chip'); Query OK, 1 row affected (0.00 sec) mysql> select * from placa; +---------+------------+-------------+ | idplaca | idemple | tipo_placa | +---------+------------+-------------+ | | 76319517 | | | 001478 | 88254919 | tradicional | | 001647 | 76318941 | tradicional | | 114563 | 1001345216 | chip | | 114578 | 81616624 | chip | | 129914 | 70312916 | chip | | 129948 | 71312945 | chip | | 145794 | 90310311 | chip | | 145874 | 94316519 | chip | | 504168 | 99327916 | chip | +---------+------------+-------------+ 10 rows in set (0.00 sec) mysql> describe estudios; +-----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------+------+-----+---------+-------+ | idestudio | char(2) | NO | PRI | NULL | | | idemple | char(10) | NO | | NULL | | | titulo | char(30) | NO | | NULL | | +-----------+----------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> call insertar_estudios('01','71312945','tecnico'); Query OK, 1 row affected (0.01 sec) mysql> select * from estudios; +-----------+----------+---------+ | idestudio | idemple | titulo | +-----------+----------+---------+ | 01 | 71312945 | tecnico | +-----------+----------+---------+ 1 row in set (0.00 sec) mysql> describe estudios; +-----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------+------+-----+---------+-------+ | idestudio | char(2) | NO | PRI | NULL | | | idemple | char(10) | NO | | NULL | | | titulo | char(30) | NO | | NULL | | +-----------+----------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | emplestudios | | estudios | | placa | +--------------------+ 6 rows in set (0.00 sec) mysql> drop table emplestudios; Query OK, 0 rows affected (0.08 sec) mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | estudios | | placa | +--------------------+ 5 rows in set (0.00 sec) mysql> drop table estudios; Query OK, 0 rows affected (0.01 sec) mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | placa | +--------------------+ 4 rows in set (0.00 sec) mysql> create table estudios -> (idemple char(10) not null primary key, -> idestudio char(2) null, -> titulo char(30) null); Query OK, 0 rows affected (0.04 sec) mysql> create table emplestudios -> (idemple char(10) not null, -> idestudio char(2) not null, -> descripcion char(30) not null); Query OK, 0 rows affected (0.02 sec) mysql> drop table emplestudios; Query OK, 0 rows affected (0.03 sec) mysql> create table emplestudios -> (idemple char(10) not null, -> idestudio char(2) not null, -> descripcion char(30) not null, -> foreign key (idemple) references empleado (idemple) on delete cascade on update cascade, -> foreign key (idemple) references estudios (idemple) on delete cascade on update cascade); Query OK, 0 rows affected (0.07 sec) mysql> describe estudios; +-----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | PRI | NULL | | | idestudio | char(2) | YES | | NULL | | | titulo | char(30) | YES | | NULL | | +-----------+----------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> show procedure status; +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | escoltar | insertar_beneficiarios | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empbene | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empleado | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_estudios | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_placa | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 5 rows in set (0.01 sec) mysql> show create procedure insertar_estudios; +-------------------+------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +-------------------+------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | insertar_estudios | NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`root`@`localhost` PROCEDURE `insertar_estudios`(in idestudio_ char(2),in idemple_ char(10), in titulo_ char(30)) begin insert into estudios(idestudio,idemple,titulo) values (idestudio_,idemple_,titulo_); end | cp850 | cp850_general_ci | latin1_swedish_ci | +-------------------+------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.00 sec) mysql> show create procedure insertar_estudios; +-------------------+------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +-------------------+------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | insertar_estudios | NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`root`@`localhost` PROCEDURE `insertar_estudios`(in idestudio_ char(2),in idemple_ char(10), in titulo_ char(30)) begin insert into estudios(idestudio,idemple,titulo) values (idestudio_,idemple_,titulo_); end | cp850 | cp850_general_ci | latin1_swedish_ci | +-------------------+------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.00 sec) mysql> describe estudios; +-----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | PRI | NULL | | | idestudio | char(2) | YES | | NULL | | | titulo | char(30) | YES | | NULL | | +-----------+----------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> describe emplestudios -> ; +-------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | MUL | NULL | | | idestudio | char(2) | NO | | NULL | | | descripcion | char(30) | NO | | NULL | | +-------------+----------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> show procedure status; +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | escoltar | insertar_beneficiarios | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empbene | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empleado | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_estudios | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_placa | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 5 rows in set (0.01 sec) mysql> show create procedure insertar_estudios; +-------------------+------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +-------------------+------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | insertar_estudios | NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`root`@`localhost` PROCEDURE `insertar_estudios`(in idestudio_ char(2),in idemple_ char(10), in titulo_ char(30)) begin insert into estudios(idestudio,idemple,titulo) values (idestudio_,idemple_,titulo_); end | cp850 | cp850_general_ci | latin1_swedish_ci | +-------------------+------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.01 sec) mysql> describe estudios; +-----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | PRI | NULL | | | idestudio | char(2) | YES | | NULL | | | titulo | char(30) | YES | | NULL | | +-----------+----------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> call insertar_estudios('71312945','01','tecnico'); Query OK, 1 row affected, 1 warning (0.02 sec) mysql> call insertar_estudios('76319517','02','tecnologo'); Query OK, 1 row affected, 1 warning (0.02 sec) mysql> call insertar_estudios('1001345216','03','profesional'); Query OK, 1 row affected, 1 warning (0.00 sec) mysql> call insertar_estudios('1001345216','04','especializacion'); Query OK, 1 row affected, 1 warning (0.00 sec) mysql> select * from estudios; +---------+-----------+-----------------+ | idemple | idestudio | titulo | +---------+-----------+-----------------+ | 01 | 71 | tecnico | | 02 | 76 | tecnologo | | 03 | 10 | profesional | | 04 | 10 | especializacion | +---------+-----------+-----------------+ 4 rows in set (0.00 sec) mysql> drop procedure insertar_estudios; Query OK, 0 rows affected (0.00 sec) mysql> show procedure status; +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | escoltar | insertar_beneficiarios | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empbene | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empleado | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_placa | PROCEDURE | root@localhost | 2015-11-16 12:44:31 | 2015-11-16 12:44:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 4 rows in set (0.01 sec) mysql> delimiter // mysql> create procedure insertar_estudios(in idemple_ char(10), in idestudio_ char(2), in titulo_ char(30)) -> begin -> insert into estudios(idemple,idestudio,titulo) values (idemple_,idestudio_,titulo_); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> call insertar_estudios('71312945','01','tecnico'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_estudios('76319517','01','tecnico'); Query OK, 1 row affected (0.01 sec) mysql> call insertar_estudios('1001345216','02','tecnologo'); Query OK, 1 row affected (0.01 sec) mysql> call insertar_estudios('99327916','02','tecnologo'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_estudios('88254919','03','profesional'); Query OK, 1 row affected (0.01 sec) mysql> call insertar_estudios('76318941','04','especializacion'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_estudios('81616624','02','tecnologo'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_estudios('94316519','03','profesional'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_estudios('70312916','',''); Query OK, 1 row affected (0.00 sec) mysql> call insertar_estudios('90310311','',''); Query OK, 1 row affected (0.00 sec) mysql> select * from estudios; +------------+-----------+-----------------+ | idemple | idestudio | titulo | +------------+-----------+-----------------+ | 01 | 71 | tecnico | | 02 | 76 | tecnologo | | 03 | 10 | profesional | | 04 | 10 | especializacion | | 1001345216 | 02 | tecnologo | | 70312916 | | | | 71312945 | 01 | tecnico | | 76318941 | 04 | especializacion | | 76319517 | 01 | tecnico | | 81616624 | 02 | tecnologo | | 88254919 | 03 | profesional | | 90310311 | | | | 94316519 | 03 | profesional | | 99327916 | 02 | tecnologo | +------------+-----------+-----------------+ 14 rows in set (0.00 sec) mysql> delete from estudios where idemple='01'; Query OK, 1 row affected (0.04 sec) mysql> select * from estudios; +------------+-----------+-----------------+ | idemple | idestudio | titulo | +------------+-----------+-----------------+ | 02 | 76 | tecnologo | | 03 | 10 | profesional | | 04 | 10 | especializacion | | 1001345216 | 02 | tecnologo | | 70312916 | | | | 71312945 | 01 | tecnico | | 76318941 | 04 | especializacion | | 76319517 | 01 | tecnico | | 81616624 | 02 | tecnologo | | 88254919 | 03 | profesional | | 90310311 | | | | 94316519 | 03 | profesional | | 99327916 | 02 | tecnologo | +------------+-----------+-----------------+ 13 rows in set (0.00 sec) mysql> delete from estudios where idemple='02'; Query OK, 1 row affected (0.00 sec) mysql> delete from estudios where idemple='03'; Query OK, 1 row affected (0.00 sec) mysql> delete from estudios where idemple='04'; Query OK, 1 row affected (0.00 sec) mysql> select * from estudios; +------------+-----------+-----------------+ | idemple | idestudio | titulo | +------------+-----------+-----------------+ | 1001345216 | 02 | tecnologo | | 70312916 | | | | 71312945 | 01 | tecnico | | 76318941 | 04 | especializacion | | 76319517 | 01 | tecnico | | 81616624 | 02 | tecnologo | | 88254919 | 03 | profesional | | 90310311 | | | | 94316519 | 03 | profesional | | 99327916 | 02 | tecnologo | +------------+-----------+-----------------+ 10 rows in set (0.00 sec) mysql> describe emplestudios; +-------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------+------+-----+---------+-------+ | idemple | char(10) | NO | MUL | NULL | | | idestudio | char(2) | NO | | NULL | | | descripcion | char(30) | NO | | NULL | | +-------------+----------+------+-----+---------+-------+ 3 rows in set (0.01 sec) mysql> delimiter // mysql> create procedure insertar_emplestudios(in idemple_ char(10), in idestudio_ char(2), in descripcion_ char(30)) -> begin -> insert into emplestudios(idemple,idestudio,descripcion) values (idemple_,idestudio_,descripcion_); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> call insertar_emplestudios('71312945','01','sistemas'); Query OK, 1 row affected (0.01 sec) mysql> call insertar_emplestudios('71312945','01','contabilidad'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_emplestudios('71312945','01','redes'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_emplestudios('71312945','02','informatica'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_emplestudios('76319517','01','redes'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_emplestudios('1001345216','02','contaduria'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_emplestudios('88254919','03','derecho'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_emplestudios('76318941','04','seguridad informatica'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_emplestudios('70312916','01','software'); Query OK, 1 row affected (0.00 sec) mysql> call insertar_emplestudios('81616624','02','seguridad instalaciones'); Query OK, 1 row affected (0.01 sec) mysql> select * from emplestudios; +------------+-----------+-------------------------+ | idemple | idestudio | descripcion | +------------+-----------+-------------------------+ | 71312945 | 01 | sistemas | | 71312945 | 01 | contabilidad | | 71312945 | 01 | redes | | 71312945 | 02 | informatica | | 76319517 | 01 | redes | | 1001345216 | 02 | contaduria | | 88254919 | 03 | derecho | | 76318941 | 04 | seguridad informatica | | 70312916 | 01 | software | | 81616624 | 02 | seguridad instalaciones | +------------+-----------+-------------------------+ 10 rows in set (0.00 sec) mysql> exit mysql> show procedure status; +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | escoltar | insertar_beneficiarios | PROCEDURE | root@localhost | 2015-11-19 19:16:48 | 2015-11-19 19:16:48 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empbene | PROCEDURE | root@localhost | 2015-11-19 19:16:48 | 2015-11-19 19:16:48 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empleado | PROCEDURE | root@localhost | 2015-11-19 19:16:48 | 2015-11-19 19:16:48 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_emplestudios | PROCEDURE | root@localhost | 2015-11-19 19:16:48 | 2015-11-19 19:16:48 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_estudios | PROCEDURE | root@localhost | 2015-11-19 19:16:48 | 2015-11-19 19:16:48 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_placa | PROCEDURE | root@localhost | 2015-11-19 19:16:48 | 2015-11-19 19:16:48 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | listar_beneficiarios | PROCEDURE | root@localhost | 2015-11-19 19:22:00 | 2015-11-19 19:22:00 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | listar_empleado | PROCEDURE | root@localhost | 2015-11-19 19:25:28 | 2015-11-19 19:25:28 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | listar_estudios | PROCEDURE | root@localhost | 2015-11-19 19:28:26 | 2015-11-19 19:28:26 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | listar_placa | PROCEDURE | root@localhost | 2015-11-19 19:27:01 | 2015-11-19 19:27:01 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 10 rows in set (0.00 sec) mysql> call listar_estudios(); +------------+-----------+-----------------+ | idemple | idestudio | titulo | +------------+-----------+-----------------+ | 1001345216 | 02 | tecnologo | | 70312916 | | | | 71312945 | 01 | tecnico | | 76318941 | 04 | especializacion | | 76319517 | 01 | tecnico | | 81616624 | 02 | tecnologo | | 88254919 | 03 | profesional | | 90310311 | | | | 94316519 | 03 | profesional | | 99327916 | 02 | tecnologo | +------------+-----------+-----------------+ 10 rows in set (0.00 sec) Query OK, 0 rows affected (0.05 sec) mysql> call listar_placa(); +---------+------------+-------------+ | idplaca | idemple | tipo_placa | +---------+------------+-------------+ | | 76319517 | | | 001478 | 88254919 | tradicional | | 001647 | 76318941 | tradicional | | 114563 | 1001345216 | chip | | 114578 | 81616624 | chip | | 129914 | 70312916 | chip | | 129948 | 71312945 | chip | | 145794 | 90310311 | chip | | 145874 | 94316519 | chip | | 504168 | 99327916 | chip | +---------+------------+-------------+ 10 rows in set (0.00 sec) Query OK, 0 rows affected (0.05 sec) mysql> call listar_empleado(); +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+--------------+------------+-------------------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+--------------+------------+-------------------------+ | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-45124850 | 2001-08-05 | carloscorzo@gmail.com | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | | 90310311 | pedro nel ospina | vig | soltero | 1994-10-24 | calle 14 # 51-45 | bello | 310-1245685 | 0200-09-10 | josecontreras@yahoo.es | | 94316519 | mario andres corzo perez | vig | soltero | 1988-11-14 | calle 4 # 1-5 | maruchenga | 319-4124538 | 2007-09-10 | marioandres@hotmail.com | | 99327916 | juan camilo perez | rec | casado | 1983-12-15 | calle 10 # 80-05 | manrique | 318-5254278 | 2005-09-07 | juancamilo@hotmail.com | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+--------------+------------+-------------------------+ 10 rows in set (0.01 sec) Query OK, 0 rows affected (0.11 sec) mysql> call listar_beneficiarios(); +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ | idbenef | nombre_apellido | fecnac | parentesco | direccion | barrio | celular | +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ | 1011458916 | camilo andres cardenas perez | 2000-08-13 | hijo | calle 117 # 26-87 | la america | 315-7485216 | | 1017456819 | maria isabel cardenas | 1999-10-10 | amiga | calle 44 # 81-85 | santa monica | 311-8574891 | | 1025484785 | maria cristina perez | 1979-10-14 | compa¤era | calle 45 # 52-98 | el picacho | 321-8596741 | | 1032031134 | jeronimo contreras ortega | 2011-05-05 | hijo | calle 104 # 86-17 | centro | 321-7885967 | | 43825002 | carolina perez ortega | 1989-12-10 | conyuge | calle 41 # 78-89 | floresta | 311-5869417 | | 70451089 | bernardo pineda ordo¤ez | 1949-10-10 | padre | calle 104b # 84-10 | doce de octubre | 350-1425368 | | 71286020 | mario alberto corzo perez | 1989-05-02 | hermano | calle 32 # 10-15 | bello | 320-5847158 | | 71452366 | martha graciela diaz | 1959-03-10 | madre | calle 5 # 152-98 | el contento | 300-4589745 | | 76239101 | carlos alberto corzo perez | 1969-05-02 | padre | calle 5 # 152-98 | el contento | 310-4152745 | | 88241906 | juan pablo contreras ortega | 2011-07-10 | hijo | calle 82 # 50-47 | cristobal | 300-1145263 | +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ 10 rows in set (0.00 sec) Query OK, 0 rows affected (0.08 sec) mysql> exit mysql> source F:\escoltar.sql 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.02 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, 1 row affected (0.02 sec) Database changed 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.30 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.11 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.23 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.56 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.31 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.39 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.13 sec) Query OK, 0 rows affected (0.33 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.50 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.06 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.28 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.52 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.06 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.31 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 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.11 sec) Query OK, 0 rows affected (0.08 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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.02 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) mysql> use escoltar; Database changed mysql> show tables; +--------------------+ | Tables_in_escoltar | +--------------------+ | beneficiarios | | empbene | | empleado | | emplestudios | | estudios | | placa | +--------------------+ 6 rows in set (0.05 sec) mysql> show procedure status; +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | escoltar | insertar_beneficiarios | PROCEDURE | root@localhost | 2015-11-20 06:16:13 | 2015-11-20 06:16:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empbene | PROCEDURE | root@localhost | 2015-11-20 06:16:13 | 2015-11-20 06:16:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_empleado | PROCEDURE | root@localhost | 2015-11-20 06:16:13 | 2015-11-20 06:16:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_emplestudios | PROCEDURE | root@localhost | 2015-11-20 06:16:13 | 2015-11-20 06:16:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_estudios | PROCEDURE | root@localhost | 2015-11-20 06:16:13 | 2015-11-20 06:16:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | insertar_placa | PROCEDURE | root@localhost | 2015-11-20 06:16:13 | 2015-11-20 06:16:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | listar_beneficiarios | PROCEDURE | root@localhost | 2015-11-20 06:16:14 | 2015-11-20 06:16:14 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | listar_empleado | PROCEDURE | root@localhost | 2015-11-20 06:16:14 | 2015-11-20 06:16:14 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | listar_estudios | PROCEDURE | root@localhost | 2015-11-20 06:16:14 | 2015-11-20 06:16:14 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | escoltar | listar_placa | PROCEDURE | root@localhost | 2015-11-20 06:16:14 | 2015-11-20 06:16:14 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | +----------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 10 rows in set (0.05 sec) mysql> call listar_empleado(); +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+--------------+------------+-------------------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+--------------+------------+-------------------------+ | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-45124850 | 2001-08-05 | carloscorzo@gmail.com | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | | 90310311 | pedro nel ospina | vig | soltero | 1994-10-24 | calle 14 # 51-45 | bello | 310-1245685 | 0200-09-10 | josecontreras@yahoo.es | | 94316519 | mario andres corzo perez | vig | soltero | 1988-11-14 | calle 4 # 1-5 | maruchenga | 319-4124538 | 2007-09-10 | marioandres@hotmail.com | | 99327916 | juan camilo perez | rec | casado | 1983-12-15 | calle 10 # 80-05 | manrique | 318-5254278 | 2005-09-07 | juancamilo@hotmail.com | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+--------------+------------+-------------------------+ 10 rows in set (0.00 sec) Query OK, 0 rows affected (0.09 sec) mysql> update empleado set celular='317-4512485' where idemple='76319517'; Query OK, 1 row affected (0.06 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> call listar_empleado(); +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | | 90310311 | pedro nel ospina | vig | soltero | 1994-10-24 | calle 14 # 51-45 | bello | 310-1245685 | 0200-09-10 | josecontreras@yahoo.es | | 94316519 | mario andres corzo perez | vig | soltero | 1988-11-14 | calle 4 # 1-5 | maruchenga | 319-4124538 | 2007-09-10 | marioandres@hotmail.com | | 99327916 | juan camilo perez | rec | casado | 1983-12-15 | calle 10 # 80-05 | manrique | 318-5254278 | 2005-09-07 | juancamilo@hotmail.com | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ 10 rows in set (0.00 sec) Query OK, 0 rows affected (0.09 sec) mysql> select * from empleado order by nombre_apellido; +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 99327916 | juan camilo perez | rec | casado | 1983-12-15 | calle 10 # 80-05 | manrique | 318-5254278 | 2005-09-07 | juancamilo@hotmail.com | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | | 94316519 | mario andres corzo perez | vig | soltero | 1988-11-14 | calle 4 # 1-5 | maruchenga | 319-4124538 | 2007-09-10 | marioandres@hotmail.com | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | | 90310311 | pedro nel ospina | vig | soltero | 1994-10-24 | calle 14 # 51-45 | bello | 310-1245685 | 0200-09-10 | josecontreras@yahoo.es | | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ 10 rows in set (0.00 sec) mysql> select * from empleado where estciv='union libre'; +----------+-----------------------------+-----+-------------+------------+------------------+------------+-------------+------------+----------------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +----------+-----------------------------+-----+-------------+------------+------------------+------------+-------------+------------+----------------------+ | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | +----------+-----------------------------+-----+-------------+------------+------------------+------------+-------------+------------+----------------------+ 1 row in set (0.00 sec) mysql> select * from empleado where estciv='soltero'; +------------+--------------------------+-----+---------+------------+--------------------+-------------+-------------+------------+-------------------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +------------+--------------------------+-----+---------+------------+--------------------+-------------+-------------+------------+-------------------------+ | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | | 90310311 | pedro nel ospina | vig | soltero | 1994-10-24 | calle 14 # 51-45 | bello | 310-1245685 | 0200-09-10 | josecontreras@yahoo.es | | 94316519 | mario andres corzo perez | vig | soltero | 1988-11-14 | calle 4 # 1-5 | maruchenga | 319-4124538 | 2007-09-10 | marioandres@hotmail.com | +------------+--------------------------+-----+---------+------------+--------------------+-------------+-------------+------------+-------------------------+ 8 rows in set (0.00 sec) mysql> select * from empleado where estciv='casado'; +----------+-------------------+-----+--------+------------+------------------+----------+-------------+------------+------------------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +----------+-------------------+-----+--------+------------+------------------+----------+-------------+------------+------------------------+ | 99327916 | juan camilo perez | rec | casado | 1983-12-15 | calle 10 # 80-05 | manrique | 318-5254278 | 2005-09-07 | juancamilo@hotmail.com | +----------+-------------------+-----+--------+------------+------------------+----------+-------------+------------+------------------------+ 1 row in set (0.00 sec) mysql> select count(*) from empleado where year(current_date()) - year(fecnac) <=28 and estciv='soltero'; +----------+ | count(*) | +----------+ | 3 | +----------+ 1 row in set (0.03 sec) mysql> select * from beneficiarios; +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ | idbenef | nombre_apellido | fecnac | parentesco | direccion | barrio | celular | +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ | 1011458916 | camilo andres cardenas perez | 2000-08-13 | hijo | calle 117 # 26-87 | la america | 315-7485216 | | 1017456819 | maria isabel cardenas | 1999-10-10 | amiga | calle 44 # 81-85 | santa monica | 311-8574891 | | 1025484785 | maria cristina perez | 1979-10-14 | compa¤era | calle 45 # 52-98 | el picacho | 321-8596741 | | 1032031134 | jeronimo contreras ortega | 2011-05-05 | hijo | calle 104 # 86-17 | centro | 321-7885967 | | 43825002 | carolina perez ortega | 1989-12-10 | conyuge | calle 41 # 78-89 | floresta | 311-5869417 | | 70451089 | bernardo pineda ordo¤ez | 1949-10-10 | padre | calle 104b # 84-10 | doce de octubre | 350-1425368 | | 71286020 | mario alberto corzo perez | 1989-05-02 | hermano | calle 32 # 10-15 | bello | 320-5847158 | | 71452366 | martha graciela diaz | 1959-03-10 | madre | calle 5 # 152-98 | el contento | 300-4589745 | | 76239101 | carlos alberto corzo perez | 1969-05-02 | padre | calle 5 # 152-98 | el contento | 310-4152745 | | 88241906 | juan pablo contreras ortega | 2011-07-10 | hijo | calle 82 # 50-47 | cristobal | 300-1145263 | +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ 10 rows in set (0.00 sec) mysql> select * from beneficiarios where fecnac>='2000'; +------------+------------------------------+------------+------------+-------------------+------------+-------------+ | idbenef | nombre_apellido | fecnac | parentesco | direccion | barrio | celular | +------------+------------------------------+------------+------------+-------------------+------------+-------------+ | 1011458916 | camilo andres cardenas perez | 2000-08-13 | hijo | calle 117 # 26-87 | la america | 315-7485216 | | 1032031134 | jeronimo contreras ortega | 2011-05-05 | hijo | calle 104 # 86-17 | centro | 321-7885967 | | 88241906 | juan pablo contreras ortega | 2011-07-10 | hijo | calle 82 # 50-47 | cristobal | 300-1145263 | +------------+------------------------------+------------+------------+-------------------+------------+-------------+ 3 rows in set, 1 warning (0.00 sec) mysql> select nombre_apellido, year(current_date()) - year(fecnac) 'edad' from beneficiarios; +------------------------------+------+ | nombre_apellido | edad | +------------------------------+------+ | camilo andres cardenas perez | 15 | | maria isabel cardenas | 16 | | maria cristina perez | 36 | | jeronimo contreras ortega | 4 | | carolina perez ortega | 26 | | bernardo pineda ordo¤ez | 66 | | mario alberto corzo perez | 26 | | martha graciela diaz | 56 | | carlos alberto corzo perez | 46 | | juan pablo contreras ortega | 4 | +------------------------------+------+ 10 rows in set (0.00 sec) mysql> select nombre_apellido, year(current_date()) - year(fecnac) 'edad' from empleado; +-----------------------------+------+ | nombre_apellido | edad | +-----------------------------+------+ | william andres osorio | 33 | | jose contreras palomino | 23 | | juan camilo cardenas ortega | 36 | | camilo cardenas sanchez | 43 | | carlos corzo diaz | 37 | | mario pineda cardona | 33 | | juan esteban contreras | 31 | | pedro nel ospina | 21 | | mario andres corzo perez | 27 | | juan camilo perez | 32 | +-----------------------------+------+ 10 rows in set (0.00 sec) mysql> select * from beneficiarios; +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ | idbenef | nombre_apellido | fecnac | parentesco | direccion | barrio | celular | +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ | 1011458916 | camilo andres cardenas perez | 2000-08-13 | hijo | calle 117 # 26-87 | la america | 315-7485216 | | 1017456819 | maria isabel cardenas | 1999-10-10 | amiga | calle 44 # 81-85 | santa monica | 311-8574891 | | 1025484785 | maria cristina perez | 1979-10-14 | compa¤era | calle 45 # 52-98 | el picacho | 321-8596741 | | 1032031134 | jeronimo contreras ortega | 2011-05-05 | hijo | calle 104 # 86-17 | centro | 321-7885967 | | 43825002 | carolina perez ortega | 1989-12-10 | conyuge | calle 41 # 78-89 | floresta | 311-5869417 | | 70451089 | bernardo pineda ordo¤ez | 1949-10-10 | padre | calle 104b # 84-10 | doce de octubre | 350-1425368 | | 71286020 | mario alberto corzo perez | 1989-05-02 | hermano | calle 32 # 10-15 | bello | 320-5847158 | | 71452366 | martha graciela diaz | 1959-03-10 | madre | calle 5 # 152-98 | el contento | 300-4589745 | | 76239101 | carlos alberto corzo perez | 1969-05-02 | padre | calle 5 # 152-98 | el contento | 310-4152745 | | 88241906 | juan pablo contreras ortega | 2011-07-10 | hijo | calle 82 # 50-47 | cristobal | 300-1145263 | +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ 10 rows in set (0.00 sec) mysql> select * from beneficiarios where parentesco='hijo'; +------------+------------------------------+------------+------------+-------------------+------------+-------------+ | idbenef | nombre_apellido | fecnac | parentesco | direccion | barrio | celular | +------------+------------------------------+------------+------------+-------------------+------------+-------------+ | 1011458916 | camilo andres cardenas perez | 2000-08-13 | hijo | calle 117 # 26-87 | la america | 315-7485216 | | 1032031134 | jeronimo contreras ortega | 2011-05-05 | hijo | calle 104 # 86-17 | centro | 321-7885967 | | 88241906 | juan pablo contreras ortega | 2011-07-10 | hijo | calle 82 # 50-47 | cristobal | 300-1145263 | +------------+------------------------------+------------+------------+-------------------+------------+-------------+ 3 rows in set (0.00 sec) mysql> select * from beneficiarios where parentesco='amiga'; +------------+-----------------------+------------+------------+------------------+--------------+-------------+ | idbenef | nombre_apellido | fecnac | parentesco | direccion | barrio | celular | +------------+-----------------------+------------+------------+------------------+--------------+-------------+ | 1017456819 | maria isabel cardenas | 1999-10-10 | amiga | calle 44 # 81-85 | santa monica | 311-8574891 | +------------+-----------------------+------------+------------+------------------+--------------+-------------+ 1 row in set (0.00 sec) mysql> select * from beneficiarios where parentesco='conyuge'; +----------+-----------------------+------------+------------+------------------+----------+-------------+ | idbenef | nombre_apellido | fecnac | parentesco | direccion | barrio | celular | +----------+-----------------------+------------+------------+------------------+----------+-------------+ | 43825002 | carolina perez ortega | 1989-12-10 | conyuge | calle 41 # 78-89 | floresta | 311-5869417 | +----------+-----------------------+------------+------------+------------------+----------+-------------+ 1 row in set (0.00 sec) mysql> select * from beneficiarios where parentesco='compa¤era'; +------------+----------------------+------------+------------+------------------+------------+-------------+ | idbenef | nombre_apellido | fecnac | parentesco | direccion | barrio | celular | +------------+----------------------+------------+------------+------------------+------------+-------------+ | 1025484785 | maria cristina perez | 1979-10-14 | compa¤era | calle 45 # 52-98 | el picacho | 321-8596741 | +------------+----------------------+------------+------------+------------------+------------+-------------+ 1 row in set (0.00 sec) mysql> select * from placa; +---------+------------+-------------+ | idplaca | idemple | tipo_placa | +---------+------------+-------------+ | | 76319517 | | | 001478 | 88254919 | tradicional | | 001647 | 76318941 | tradicional | | 114563 | 1001345216 | chip | | 114578 | 81616624 | chip | | 129914 | 70312916 | chip | | 129948 | 71312945 | chip | | 145794 | 90310311 | chip | | 145874 | 94316519 | chip | | 504168 | 99327916 | chip | +---------+------------+-------------+ 10 rows in set (0.01 sec) mysql> select * from empleado; +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | | 90310311 | pedro nel ospina | vig | soltero | 1994-10-24 | calle 14 # 51-45 | bello | 310-1245685 | 0200-09-10 | josecontreras@yahoo.es | | 94316519 | mario andres corzo perez | vig | soltero | 1988-11-14 | calle 4 # 1-5 | maruchenga | 319-4124538 | 2007-09-10 | marioandres@hotmail.com | | 99327916 | juan camilo perez | rec | casado | 1983-12-15 | calle 10 # 80-05 | manrique | 318-5254278 | 2005-09-07 | juancamilo@hotmail.com | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ 10 rows in set (0.00 sec) mysql> select * from empleado inner join placa on empleado.idemple=placa.idemple; +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+---------+------------+-------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | idplaca | idemple | tipo_placa | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+---------+------------+-------------+ | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | | 76319517 | | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | 001478 | 88254919 | tradicional | | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | 001647 | 76318941 | tradicional | | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | 114563 | 1001345216 | chip | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | 114578 | 81616624 | chip | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | 129914 | 70312916 | chip | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | 129948 | 71312945 | chip | | 90310311 | pedro nel ospina | vig | soltero | 1994-10-24 | calle 14 # 51-45 | bello | 310-1245685 | 0200-09-10 | josecontreras@yahoo.es | 145794 | 90310311 | chip | | 94316519 | mario andres corzo perez | vig | soltero | 1988-11-14 | calle 4 # 1-5 | maruchenga | 319-4124538 | 2007-09-10 | marioandres@hotmail.com | 145874 | 94316519 | chip | | 99327916 | juan camilo perez | rec | casado | 1983-12-15 | calle 10 # 80-05 | manrique | 318-5254278 | 2005-09-07 | juancamilo@hotmail.com | 504168 | 99327916 | chip | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+---------+------------+-------------+ 10 rows in set (0.00 sec) mysql> select * from placa; +---------+------------+-------------+ | idplaca | idemple | tipo_placa | +---------+------------+-------------+ | | 76319517 | | | 001478 | 88254919 | tradicional | | 001647 | 76318941 | tradicional | | 114563 | 1001345216 | chip | | 114578 | 81616624 | chip | | 129914 | 70312916 | chip | | 129948 | 71312945 | chip | | 145794 | 90310311 | chip | | 145874 | 94316519 | chip | | 504168 | 99327916 | chip | +---------+------------+-------------+ 10 rows in set (0.00 sec) mysql> describe placa; +------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+----------+------+-----+---------+-------+ | idplaca | char(6) | NO | PRI | | | | idemple | char(10) | NO | | NULL | | | tipo_placa | char(12) | YES | | NULL | | +------------+----------+------+-----+---------+-------+ 3 rows in set (0.02 sec) mysql> select * from beneficiarios; +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ | idbenef | nombre_apellido | fecnac | parentesco | direccion | barrio | celular | +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ | 1011458916 | camilo andres cardenas perez | 2000-08-13 | hijo | calle 117 # 26-87 | la america | 315-7485216 | | 1017456819 | maria isabel cardenas | 1999-10-10 | amiga | calle 44 # 81-85 | santa monica | 311-8574891 | | 1025484785 | maria cristina perez | 1979-10-14 | compa¤era | calle 45 # 52-98 | el picacho | 321-8596741 | | 1032031134 | jeronimo contreras ortega | 2011-05-05 | hijo | calle 104 # 86-17 | centro | 321-7885967 | | 43825002 | carolina perez ortega | 1989-12-10 | conyuge | calle 41 # 78-89 | floresta | 311-5869417 | | 70451089 | bernardo pineda ordo¤ez | 1949-10-10 | padre | calle 104b # 84-10 | doce de octubre | 350-1425368 | | 71286020 | mario alberto corzo perez | 1989-05-02 | hermano | calle 32 # 10-15 | bello | 320-5847158 | | 71452366 | martha graciela diaz | 1959-03-10 | madre | calle 5 # 152-98 | el contento | 300-4589745 | | 76239101 | carlos alberto corzo perez | 1969-05-02 | padre | calle 5 # 152-98 | el contento | 310-4152745 | | 88241906 | juan pablo contreras ortega | 2011-07-10 | hijo | calle 82 # 50-47 | cristobal | 300-1145263 | +------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ 10 rows in set (0.00 sec) mysql> select * from empleado; +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | | 90310311 | pedro nel ospina | vig | soltero | 1994-10-24 | calle 14 # 51-45 | bello | 310-1245685 | 0200-09-10 | josecontreras@yahoo.es | | 94316519 | mario andres corzo perez | vig | soltero | 1988-11-14 | calle 4 # 1-5 | maruchenga | 319-4124538 | 2007-09-10 | marioandres@hotmail.com | | 99327916 | juan camilo perez | rec | casado | 1983-12-15 | calle 10 # 80-05 | manrique | 318-5254278 | 2005-09-07 | juancamilo@hotmail.com | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ 10 rows in set (0.00 sec) mysql> select * from empbene; +----------+------------+ | idemple | idbenef | +----------+------------+ | 71312945 | 1025484785 | | 76319517 | 71452366 | | 76319517 | 76239101 | | 99327916 | 43825002 | | 88254919 | 1032031134 | | 76318941 | 1011458916 | | 81616624 | 70451089 | | 94316519 | 71286020 | | 70312916 | 88241906 | | 90310311 | 1017456819 | +----------+------------+ 10 rows in set (0.03 sec) mysql> select * from empleado inner join empbene on empleado.idemple=empbene.idemple inner join beneficiarios on empbene.idbenef=beneficiarios.idbenef; +----------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+----------+------------+------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | idemple | idbenef | idbenef | nombre_apellido | fecnac | parentesco | direccion | barrio | celular | +----------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+----------+------------+------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | 70312916 | 88241906 | 88241906 | juan pablo contreras ortega | 2011-07-10 | hijo | calle 82 # 50-47 | cristobal | 300-1145263 | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | 71312945 | 1025484785 | 1025484785 | maria cristina perez | 1979-10-14 | compa¤era | calle 45 # 52-98 | el picacho | 321-8596741 | | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | 76318941 | 1011458916 | 1011458916 | camilo andres cardenas perez | 2000-08-13 | hijo | calle 117 # 26-87 | la america | 315-7485216 | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | 76319517 | 71452366 | 71452366 | martha graciela diaz | 1959-03-10 | madre | calle 5 # 152-98 | el contento | 300-4589745 | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | 76319517 | 76239101 | 76239101 | carlos alberto corzo perez | 1969-05-02 | padre | calle 5 # 152-98 | el contento | 310-4152745 | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | 81616624 | 70451089 | 70451089 | bernardo pineda ordo¤ez | 1949-10-10 | padre | calle 104b # 84-10 | doce de octubre | 350-1425368 | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | 88254919 | 1032031134 | 1032031134 | jeronimo contreras ortega | 2011-05-05 | hijo | calle 104 # 86-17 | centro | 321-7885967 | | 90310311 | pedro nel ospina | vig | soltero | 1994-10-24 | calle 14 # 51-45 | bello | 310-1245685 | 0200-09-10 | josecontreras@yahoo.es | 90310311 | 1017456819 | 1017456819 | maria isabel cardenas | 1999-10-10 | amiga | calle 44 # 81-85 | santa monica | 311-8574891 | | 94316519 | mario andres corzo perez | vig | soltero | 1988-11-14 | calle 4 # 1-5 | maruchenga | 319-4124538 | 2007-09-10 | marioandres@hotmail.com | 94316519 | 71286020 | 71286020 | mario alberto corzo perez | 1989-05-02 | hermano | calle 32 # 10-15 | bello | 320-5847158 | | 99327916 | juan camilo perez | rec | casado | 1983-12-15 | calle 10 # 80-05 | manrique | 318-5254278 | 2005-09-07 | juancamilo@hotmail.com | 99327916 | 43825002 | 43825002 | carolina perez ortega | 1989-12-10 | conyuge | calle 41 # 78-89 | floresta | 311-5869417 | +----------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+----------+------------+------------+------------------------------+------------+------------+--------------------+-----------------+-------------+ 10 rows in set (0.00 sec) mysql> select * from placa; +---------+------------+-------------+ | idplaca | idemple | tipo_placa | +---------+------------+-------------+ | | 76319517 | | | 001478 | 88254919 | tradicional | | 001647 | 76318941 | tradicional | | 114563 | 1001345216 | chip | | 114578 | 81616624 | chip | | 129914 | 70312916 | chip | | 129948 | 71312945 | chip | | 145794 | 90310311 | chip | | 145874 | 94316519 | chip | | 504168 | 99327916 | chip | +---------+------------+-------------+ 10 rows in set (0.00 sec) mysql> select * from empleado; +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | | 90310311 | pedro nel ospina | vig | soltero | 1994-10-24 | calle 14 # 51-45 | bello | 310-1245685 | 0200-09-10 | josecontreras@yahoo.es | | 94316519 | mario andres corzo perez | vig | soltero | 1988-11-14 | calle 4 # 1-5 | maruchenga | 319-4124538 | 2007-09-10 | marioandres@hotmail.com | | 99327916 | juan camilo perez | rec | casado | 1983-12-15 | calle 10 # 80-05 | manrique | 318-5254278 | 2005-09-07 | juancamilo@hotmail.com | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ 10 rows in set (0.01 sec) in empleado on empleado.idemple=placa.idplaca' at line 1 mysql> select * from placa where idplaca=" "; +---------+----------+------------+ | idplaca | idemple | tipo_placa | +---------+----------+------------+ | | 76319517 | | +---------+----------+------------+ 1 row in set (0.00 sec) mysql> select * from empleado right join placa on empleado.idemple=placa.idemple; +------------+-----------------------------+------+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+---------+------------+-------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | idplaca | idemple | tipo_placa | +------------+-----------------------------+------+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+---------+------------+-------------+ | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | | 76319517 | | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | 001478 | 88254919 | tradicional | | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | 001647 | 76318941 | tradicional | | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | 114563 | 1001345216 | chip | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | 114578 | 81616624 | chip | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | 129914 | 70312916 | chip | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | 129948 | 71312945 | chip | | 90310311 | pedro nel ospina | vig | soltero | 1994-10-24 | calle 14 # 51-45 | bello | 310-1245685 | 0200-09-10 | josecontreras@yahoo.es | 145794 | 90310311 | chip | | 94316519 | mario andres corzo perez | vig | soltero | 1988-11-14 | calle 4 # 1-5 | maruchenga | 319-4124538 | 2007-09-10 | marioandres@hotmail.com | 145874 | 94316519 | chip | | 99327916 | juan camilo perez | rec | casado | 1983-12-15 | calle 10 # 80-05 | manrique | 318-5254278 | 2005-09-07 | juancamilo@hotmail.com | 504168 | 99327916 | chip | +------------+-----------------------------+------+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+---------+------------+-------------+ 10 rows in set (0.01 sec) mysql> select * from empleado right join placa on empleado.idemple=placa.idplaca; +---------+-----------------+------+--------+--------+-----------+--------+---------+----------+--------+---------+------------+-------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | idplaca | idemple | tipo_placa | +---------+-----------------+------+--------+--------+-----------+--------+---------+----------+--------+---------+------------+-------------+ | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 76319517 | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 001478 | 88254919 | tradicional | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 001647 | 76318941 | tradicional | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 114563 | 1001345216 | chip | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 114578 | 81616624 | chip | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 129914 | 70312916 | chip | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 129948 | 71312945 | chip | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 145794 | 90310311 | chip | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 145874 | 94316519 | chip | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 504168 | 99327916 | chip | +---------+-----------------+------+--------+--------+-----------+--------+---------+----------+--------+---------+------------+-------------+ 10 rows in set (0.00 sec) mysql> select * from empleado left join placa on empleado.idemple=placa.idplaca; +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+---------+---------+------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | idplaca | idemple | tipo_placa | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+---------+---------+------------+ | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | NULL | NULL | NULL | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | NULL | NULL | NULL | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | NULL | NULL | NULL | | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | NULL | NULL | NULL | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | NULL | NULL | NULL | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | NULL | NULL | NULL | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | NULL | NULL | NULL | | 90310311 | pedro nel ospina | vig | soltero | 1994-10-24 | calle 14 # 51-45 | bello | 310-1245685 | 0200-09-10 | josecontreras@yahoo.es | NULL | NULL | NULL | | 94316519 | mario andres corzo perez | vig | soltero | 1988-11-14 | calle 4 # 1-5 | maruchenga | 319-4124538 | 2007-09-10 | marioandres@hotmail.com | NULL | NULL | NULL | | 99327916 | juan camilo perez | rec | casado | 1983-12-15 | calle 10 # 80-05 | manrique | 318-5254278 | 2005-09-07 | juancamilo@hotmail.com | NULL | NULL | NULL | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+---------+---------+------------+ 10 rows in set (0.00 sec) mysql> select * from empleado inner join placa on empleado.idemple=placa.idplaca; Empty set (0.00 sec) mysql> select * from empleado; +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | | 90310311 | pedro nel ospina | vig | soltero | 1994-10-24 | calle 14 # 51-45 | bello | 310-1245685 | 0200-09-10 | josecontreras@yahoo.es | | 94316519 | mario andres corzo perez | vig | soltero | 1988-11-14 | calle 4 # 1-5 | maruchenga | 319-4124538 | 2007-09-10 | marioandres@hotmail.com | | 99327916 | juan camilo perez | rec | casado | 1983-12-15 | calle 10 # 80-05 | manrique | 318-5254278 | 2005-09-07 | juancamilo@hotmail.com | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ 10 rows in set (0.00 sec) mysql> select * from estudios; +------------+-----------+-----------------+ | idemple | idestudio | titulo | +------------+-----------+-----------------+ | 1001345216 | 02 | tecnologo | | 70312916 | | | | 71312945 | 01 | tecnico | | 76318941 | 04 | especializacion | | 76319517 | 01 | tecnico | | 81616624 | 02 | tecnologo | | 88254919 | 03 | profesional | | 90310311 | | | | 94316519 | 03 | profesional | | 99327916 | 02 | tecnologo | +------------+-----------+-----------------+ 10 rows in set (0.03 sec) mysql> select * from estudios where idestudio=" "; +----------+-----------+--------+ | idemple | idestudio | titulo | +----------+-----------+--------+ | 70312916 | | | | 90310311 | | | +----------+-----------+--------+ 2 rows in set (0.00 sec) mysql> select * from estudios where idestudio=" " and titulo=" "; +----------+-----------+--------+ | idemple | idestudio | titulo | +----------+-----------+--------+ | 70312916 | | | | 90310311 | | | +----------+-----------+--------+ 2 rows in set (0.00 sec) mysql> select * from empleado inner join emplestudios on empleado.idemple=emplestudios.idemple inner join estudios on emplestudios.idestudio=estudios.idestudio; +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+------------+-----------+-------------------------+------------+-----------+-----------------+ | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | idemple | idestudio | descripcion | idemple | idestudio | titulo | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+------------+-----------+-------------------------+------------+-----------+-----------------+ | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | 1001345216 | 02 | contaduria | 1001345216 | 02 | tecnologo | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | 71312945 | 02 | informatica | 1001345216 | 02 | tecnologo | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | 81616624 | 02 | seguridad instalaciones | 1001345216 | 02 | tecnologo | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | 70312916 | 01 | software | 71312945 | 01 | tecnico | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | 71312945 | 01 | sistemas | 71312945 | 01 | tecnico | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | 71312945 | 01 | contabilidad | 71312945 | 01 | tecnico | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | 71312945 | 01 | redes | 71312945 | 01 | tecnico | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | 76319517 | 01 | redes | 71312945 | 01 | tecnico | | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | 76318941 | 04 | seguridad informatica | 76318941 | 04 | especializacion | | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | 70312916 | 01 | software | 76319517 | 01 | tecnico | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | 71312945 | 01 | sistemas | 76319517 | 01 | tecnico | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | 71312945 | 01 | contabilidad | 76319517 | 01 | tecnico | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | 71312945 | 01 | redes | 76319517 | 01 | tecnico | | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | 76319517 | 01 | redes | 76319517 | 01 | tecnico | | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | 1001345216 | 02 | contaduria | 81616624 | 02 | tecnologo | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | 71312945 | 02 | informatica | 81616624 | 02 | tecnologo | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | 81616624 | 02 | seguridad instalaciones | 81616624 | 02 | tecnologo | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | 88254919 | 03 | derecho | 88254919 | 03 | profesional | | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | 88254919 | 03 | derecho | 94316519 | 03 | profesional | | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | 1001345216 | 02 | contaduria | 99327916 | 02 | tecnologo | | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | 71312945 | 02 | informatica | 99327916 | 02 | tecnologo | | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | 81616624 | 02 | seguridad instalaciones | 99327916 | 02 | tecnologo | +------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+------------+-----------+-------------------------+------------+-----------+-----------------+ 22 rows in set (0.04 sec) mysql> select * from estudios inner join emplestudios on estudios.idemple=emplestudios.idemple inner join empleado on empleado.idemple=emplestudios.idemple; +------------+-----------+-----------------+------------+-----------+-------------------------+------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ | idemple | idestudio | titulo | idemple | idestudio | descripcion | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +------------+-----------+-----------------+------------+-----------+-------------------------+------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ | 1001345216 | 02 | tecnologo | 1001345216 | 02 | contaduria | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | | 70312916 | | | 70312916 | 01 | software | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | | 71312945 | 01 | tecnico | 71312945 | 01 | sistemas | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 71312945 | 01 | tecnico | 71312945 | 01 | contabilidad | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 71312945 | 01 | tecnico | 71312945 | 01 | redes | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 71312945 | 01 | tecnico | 71312945 | 02 | informatica | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 76318941 | 04 | especializacion | 76318941 | 04 | seguridad informatica | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | | 76319517 | 01 | tecnico | 76319517 | 01 | redes | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | | 81616624 | 02 | tecnologo | 81616624 | 02 | seguridad instalaciones | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | | 88254919 | 03 | profesional | 88254919 | 03 | derecho | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | +------------+-----------+-----------------+------------+-----------+-------------------------+------------+-----------------------------+-----+-------------+------------+--------------------+-------------+-------------+------------+-------------------------+ 10 rows in set (0.00 sec) mysql> select * from estudios inner join emplestudios on estudios.idemple=emplestudios.idemple inner join empleado on empleado.idemple=emplestudios.idemple where emplestudios.idestudio='01'; +----------+-----------+---------+----------+-----------+--------------+----------+-----------------------------+-----+-------------+------------+--------------------+------------+-------------+------------+------------------------+ | idemple | idestudio | titulo | idemple | idestudio | descripcion | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +----------+-----------+---------+----------+-----------+--------------+----------+-----------------------------+-----+-------------+------------+--------------------+------------+-------------+------------+------------------------+ | 70312916 | | | 70312916 | 01 | software | 70312916 | jose contreras palomino | sup | soltero | 1992-10-24 | calle 114 # 541-55 | sabaneta | 300-4124538 | 2009-09-10 | josecontreras@yahoo.es | | 71312945 | 01 | tecnico | 71312945 | 01 | sistemas | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 71312945 | 01 | tecnico | 71312945 | 01 | contabilidad | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 71312945 | 01 | tecnico | 71312945 | 01 | redes | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 76319517 | 01 | tecnico | 76319517 | 01 | redes | 76319517 | carlos corzo diaz | vig | soltero | 1978-11-04 | calle 38 # 110-25 | centro | 317-4512485 | 2001-08-05 | carloscorzo@gmail.com | +----------+-----------+---------+----------+-----------+--------------+----------+-----------------------------+-----+-------------+------------+--------------------+------------+-------------+------------+------------------------+ 5 rows in set (0.00 sec) mysql> select * from estudios inner join emplestudios on estudios.idemple=emplestudios.idemple inner join empleado on empleado.idemple=emplestudios.idemple where emplestudios.idestudio='02'; +------------+-----------+-----------+------------+-----------+-------------------------+------------+-----------------------------+-----+-------------+------------+-------------------+------------+-------------+------------+-------------------------+ | idemple | idestudio | titulo | idemple | idestudio | descripcion | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +------------+-----------+-----------+------------+-----------+-------------------------+------------+-----------------------------+-----+-------------+------------+-------------------+------------+-------------+------------+-------------------------+ | 1001345216 | 02 | tecnologo | 1001345216 | 02 | contaduria | 1001345216 | william andres osorio | sup | soltero | 1982-12-15 | calle 10 # 10-25 | el volador | 317-5214578 | 2007-09-07 | william@hotmail.com | | 71312945 | 01 | tecnico | 71312945 | 02 | informatica | 71312945 | juan camilo cardenas ortega | vig | union libre | 1979-10-24 | calle 34 # 10-25 | el pesebre | 315-7485126 | 2000-10-05 | juancamilo@gmail.com | | 81616624 | 02 | tecnologo | 81616624 | 02 | seguridad instalaciones | 81616624 | mario pineda cardona | vig | soltero | 1982-11-04 | calle 114 # 71-58 | poblado | 311-4252358 | 2008-09-01 | mariopineda@hotmail.com | +------------+-----------+-----------+------------+-----------+-------------------------+------------+-----------------------------+-----+-------------+------------+-------------------+------------+-------------+------------+-------------------------+ 3 rows in set (0.00 sec) mysql> select * from estudios inner join emplestudios on estudios.idemple=emplestudios.idemple inner join empleado on empleado.idemple=emplestudios.idemple where emplestudios.idestudio='03'; +----------+-----------+-------------+----------+-----------+-------------+----------+------------------------+-----+---------+------------+------------------+-------------+-------------+------------+-------------------------+ | idemple | idestudio | titulo | idemple | idestudio | descripcion | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +----------+-----------+-------------+----------+-----------+-------------+----------+------------------------+-----+---------+------------+------------------+-------------+-------------+------------+-------------------------+ | 88254919 | 03 | profesional | 88254919 | 03 | derecho | 88254919 | juan esteban contreras | vig | soltero | 1984-12-04 | calle 20 # 10-05 | la estrella | 300-5254278 | 2001-09-07 | juanesteban@hotmail.com | +----------+-----------+-------------+----------+-----------+-------------+----------+------------------------+-----+---------+------------+------------------+-------------+-------------+------------+-------------------------+ 1 row in set (0.00 sec) mysql> select * from estudios inner join emplestudios on estudios.idemple=emplestudios.idemple inner join empleado on empleado.idemple=emplestudios.idemple where emplestudios.idestudio='04'; +----------+-----------+-----------------+----------+-----------+-----------------------+----------+-------------------------+-----+---------+------------+-------------------+----------+-------------+------------+------------------------+ | idemple | idestudio | titulo | idemple | idestudio | descripcion | idemple | nombre_apellido | gr | estciv | fecnac | direccion | barrio | celular | fechingr | e_mail | +----------+-----------+-----------------+----------+-----------+-----------------------+----------+-------------------------+-----+---------+------------+-------------------+----------+-------------+------------+------------------------+ | 76318941 | 04 | especializacion | 76318941 | 04 | seguridad informatica | 76318941 | camilo cardenas sanchez | sup | soltero | 1972-11-24 | calle 29 # 210-05 | envigado | 320-5252358 | 2000-09-01 | camilo1542@hotmail.com | +----------+-----------+-----------------+----------+-----------+-----------------------+----------+-------------------------+-----+---------+------------+-------------------+----------+-------------+------------+------------------------+ 1 row in set (0.00 sec) mysql> exit