MariaDB [(none)]> MariaDB [(none)]> create database callcenter; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> use callcenter; Database changed MariaDB [callcenter]> create table cliente -> (Idcliente varchar(10) not null primary key, -> Nombre varchar(50) not null, -> Direccion varchar(30) not null, -> Telefono varchar(10) not null, -> Email varchar(30) not null); Query OK, 0 rows affected (0.32 sec) MariaDB [callcenter]> create table sedes -> (Idsedes varchar(10) not null primary key, -> Nombre varchar(50) not null, -> Direccion varchar(30) not null, -> Telefono varchar(10) not null, -> Email varchar(30) not null); Query OK, 0 rows affected (0.26 sec) MariaDB [callcenter]> create table empleados -> (Idempleados varchar(10) not null primary key, -> Nombre varchar(50) not null, -> Direccion varchar(30) not null, -> Telefono varchar(10) not null, -> Email varchar(30) not null); Query OK, 0 rows affected (0.33 sec) MariaDB [callcenter]> drop table empleados; Query OK, 0 rows affected (0.35 sec) MariaDB [callcenter]> create table empleados -> (Idempleados varchar(10) not null primary key, -> Nombre varchar(50) not null, -> Direccion varchar(30) not null, -> Telefono varchar(10) not null, -> Email varchar(30) not null, -> Idsedes varchar(10) not null, -> Idcliente varchar(10) not null, -> foreign key(idsedes) references sedes(Idsedes) on delete cascade on update cascade, -> foreign key(idcliente) references cliente(Idcliente) on delete cascade on update cascade); Query OK, 0 rows affected (0.46 sec) MariaDB [callcenter]> create table transporte -> (Idconductor varchar(10) not null primary key, -> Nombre varchar(50) not null, -> Direccion varchar(30) not null, -> Telefono varchar(10) not null, -> Email varchar(30) not null, -> Tipocarro varchar(10) not null, -> Placa varchar(10) not null); Query OK, 0 rows affected (0.27 sec) MariaDB [callcenter]> create table producto -> (Idproducto varchar(10) not null primary key, -> Nombre varchar(50) not null, -> Descripcion varchar(200) not null, -> Precio varchar(10) not null, -> Idcliente varchar(10) not null, -> foreign key(idcliente) references cliente(Idcliente) on delete cascade on update cascade); Query OK, 0 rows affected (0.27 sec) MariaDB [callcenter]> create table usuariofinal -> (Idusuariofinal varchar(10) not null primary key, -> Nombre varchar(50) not null, -> Direccion varchar(30) not null, -> Telefono varchar(10) not null, -> Email varchar(30) not null); Query OK, 0 rows affected (0.30 sec) MariaDB [callcenter]> show tables; +----------------------+ | Tables_in_callcenter | +----------------------+ | cliente | | empleados | | producto | | sedes | | transporte | | usuariofinal | +----------------------+ 6 rows in set (0.00 sec) MariaDB [callcenter]> describe cliente; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Idcliente | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Direccion | varchar(30) | NO | | NULL | | | Telefono | varchar(10) | NO | | NULL | | | Email | varchar(30) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.04 sec) MariaDB [callcenter]> describe empleados; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Idempleados | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Direccion | varchar(30) | NO | | NULL | | | Telefono | varchar(10) | NO | | NULL | | | Email | varchar(30) | NO | | NULL | | | Idsedes | varchar(10) | NO | MUL | NULL | | | Idcliente | varchar(10) | NO | MUL | NULL | | +-------------+-------------+------+-----+---------+-------+ 7 rows in set (0.01 sec) MariaDB [callcenter]> describe sedes; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Idsedes | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Direccion | varchar(30) | NO | | NULL | | | Telefono | varchar(10) | NO | | NULL | | | Email | varchar(30) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.01 sec) MariaDB [callcenter]> describe transporte; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Idconductor | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Direccion | varchar(30) | NO | | NULL | | | Telefono | varchar(10) | NO | | NULL | | | Email | varchar(30) | NO | | NULL | | | Tipocarro | varchar(10) | NO | | NULL | | | Placa | varchar(10) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 7 rows in set (0.01 sec) MariaDB [callcenter]> describe producto; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | Idproducto | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Descripcion | varchar(200) | NO | | NULL | | | Precio | varchar(10) | NO | | NULL | | | Idcliente | varchar(10) | NO | MUL | NULL | | +-------------+--------------+------+-----+---------+-------+ 5 rows in set (0.01 sec) MariaDB [callcenter]> describe usuariofinal; +----------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+-------+ | Idusuariofinal | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Direccion | varchar(30) | NO | | NULL | | | Telefono | varchar(10) | NO | | NULL | | | Email | varchar(30) | NO | | NULL | | +----------------+-------------+------+-----+---------+-------+ 5 rows in set (0.01 sec) MariaDB [callcenter]> create table empletrans -> (Idempleados varchar(10) not null, -> (Idconductor varchar(10) not null, -> describe producto; MariaDB [callcenter]> create table empletrans -> (Idempleados varchar(10) not null, -> Idconductor varchar(10) not null, -> Fecharecoemple varchar(10) not null, -> foreign key(idempleados) references empleados(Idempleados) on delete cascade on update cascade, -> foreign key(idconductor) references transporte(Idconductor) on delete cascade on update cascade); Query OK, 0 rows affected (0.31 sec) MariaDB [callcenter]> create table prousofinal -> (Idproducto varchar(10) not null, -> Idusuariofinal varchar(10) not null, -> Permanencia varchar(10) not null, -> foreign key(idproducto) references producto(Idproducto) on delete cascade on update cascade, -> foreign key(idusuariofinal) references usuariofinal(Idusuariofinal) on delete cascade on update cascade); Query OK, 0 rows affected (0.28 sec) MariaDB [callcenter]> show tables; +----------------------+ | Tables_in_callcenter | +----------------------+ | cliente | | empleados | | empletrans | | producto | | prousofinal | | sedes | | transporte | | usuariofinal | +----------------------+ 8 rows in set (0.00 sec) MariaDB [callcenter]> describe empletrans; +----------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+-------+ | Idempleados | varchar(10) | NO | MUL | NULL | | | Idconductor | varchar(10) | NO | MUL | NULL | | | Fecharecoemple | varchar(10) | NO | | NULL | | +----------------+-------------+------+-----+---------+-------+ 3 rows in set (0.01 sec) MariaDB [callcenter]> describe prousofinal; +----------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+-------+ | Idproducto | varchar(10) | NO | MUL | NULL | | | Idusuariofinal | varchar(10) | NO | MUL | NULL | | | Permanencia | varchar(10) | NO | | NULL | | +----------------+-------------+------+-----+---------+-------+ 3 rows in set (0.01 sec) MariaDB [callcenter]> describe cliente; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Idcliente | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Direccion | varchar(30) | NO | | NULL | | | Telefono | varchar(10) | NO | | NULL | | | Email | varchar(30) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.01 sec) MariaDB [callcenter]> NSERT INTO cliente(Idcliente,Nombre,Direccion,Telefono,Email) VALUES('00001','Movistar','Cra 23 # 45 67 ','6543212','orangefide@gmail.com'); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NSERT INTO cliente(Idcliente,Nombre,Direccion,Telefono,Email) VALUES('00001','Mo' at line 1 MariaDB [callcenter]> select * from cliente; +-----------+----------+-----------------+----------+----------------------+ | Idcliente | Nombre | Direccion | Telefono | Email | +-----------+----------+-----------------+----------+----------------------+ | 00001 | Movistar | Cra 23 # 45 67 | 6543212 | orangefide@gmail.com | | 00002 | Movistar | Cra 23 # 45 67 | 6543212 | orangefide@gmail.com | +-----------+----------+-----------------+----------+----------------------+ 2 rows in set (0.00 sec) MariaDB [callcenter]> drop table cliente; ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails MariaDB [callcenter]> select * from cliente; +-----------+----------+-----------------+----------+----------------------+ | Idcliente | Nombre | Direccion | Telefono | Email | +-----------+----------+-----------------+----------+----------------------+ | 00001 | Movistar | Cra 23 # 45 67 | 6543212 | orangefide@gmail.com | | 00002 | Movistar | Cra 23 # 45 67 | 6543212 | orangefide@gmail.com | +-----------+----------+-----------------+----------+----------------------+ 2 rows in set (0.12 sec) MariaDB [callcenter]> select * from cliente; Empty set (0.00 sec) MariaDB [callcenter]> insert into cliente(Idcliente,Nombre,Direccion,Telefono,Email) VALUES('00001','Movistar','Cra 23 # 45 67','6543212','orangefide@gmail.com'); Query OK, 1 row affected (0.07 sec) MariaDB [callcenter]> insert into cliente(Idcliente,Nombre,Direccion,Telefono,Email) VALUES('00002','Vodafone','Calle 4norte #45 56','6547885','vodafne123@hotmail.com'); Query OK, 1 row affected (0.10 sec) MariaDB [callcenter]> insert into cliente(Idcliente,Nombre,Direccion,Telefono,Email) VALUES('00003','Babaria','Calle 6sur #25 34','6547885','vodafne123@hotmail.com'); Query OK, 1 row affected (0.12 sec) MariaDB [callcenter]> insert into cliente(Idcliente,Nombre,Direccion,Telefono,Email) VALUES('00004','Amena','Cra 34 #67 32','6457890','amena54@hotmial.com'); Query OK, 1 row affected (0.09 sec) MariaDB [callcenter]> insert into cliente(Idcliente,Nombre,Direccion,Telefono,Email) VALUES('00005','Claro','Cra 24 #89 05','6521345','claro257@gmail.com'); Query OK, 1 row affected (0.06 sec) MariaDB [callcenter]> select * from cliente; +-----------+----------+---------------------+----------+------------------------+ | Idcliente | Nombre | Direccion | Telefono | Email | +-----------+----------+---------------------+----------+------------------------+ | 00001 | Movistar | Cra 23 # 45 67 | 6543212 | orangefide@gmail.com | | 00002 | Vodafone | Calle 4norte #45 56 | 6547885 | vodafne123@hotmail.com | | 00003 | Babaria | Calle 6sur #25 34 | 6547885 | vodafne123@hotmail.com | | 00004 | Amena | Cra 34 #67 32 | 6457890 | amena54@hotmial.com | | 00005 | Claro | Cra 24 #89 05 | 6521345 | claro257@gmail.com | +-----------+----------+---------------------+----------+------------------------+ 5 rows in set (0.00 sec) MariaDB [callcenter]> insert into sedes(Idsedes,Nombre,Direccion,Telefono,Email) VALUES('01','Tepe_Aguacatala','Cra 23 # 45 67','6543212','tepeAguacatala@gmail.com'); Query OK, 1 row affected (0.08 sec) MariaDB [callcenter]> insert into sedes(Idsedes,Nombre,Direccion,Telefono,Email) VALUES('02','Tepe_Bizcaya','Cll 67 # 89 09','5679865','tepebizcaya@gmail.com'); Query OK, 1 row affected (0.08 sec) MariaDB [callcenter]> insert into sedes(Idsedes,Nombre,Direccion,Telefono,Email) VALUES('03','Tepe_Itagui','Cll 56 # 78 98','3498765','tepeitagui@hotmail.com'); Query OK, 1 row affected (0.14 sec) MariaDB [callcenter]> select * from sedes; +---------+-----------------+----------------+----------+--------------------------+ | Idsedes | Nombre | Direccion | Telefono | Email | +---------+-----------------+----------------+----------+--------------------------+ | 01 | Tepe_Aguacatala | Cra 23 # 45 67 | 6543212 | tepeAguacatala@gmail.com | | 02 | Tepe_Bizcaya | Cll 67 # 89 09 | 5679865 | tepebizcaya@gmail.com | | 03 | Tepe_Itagui | Cll 56 # 78 98 | 3498765 | tepeitagui@hotmail.com | +---------+-----------------+----------------+----------+--------------------------+ 3 rows in set (0.00 sec) MariaDB [callcenter]> insert into empleados(Idempleados,Nombre,Direccion,Telefono,Email,Idsedes,Idcliente) VALUES('1001','Elva','Cra 23 # 45 67','6543212','elvita@gmail.com','01','00001'); Query OK, 1 row affected (0.08 sec) MariaDB [callcenter]> insert into empleados(Idempleados,Nombre,Direccion,Telefono,Email,Idsedes,Idcliente) VALUES('1002','Maria','Cll 67 # 89 09','5679865','mari1987@gmail.com','01','00001'); Query OK, 1 row affected (0.07 sec) MariaDB [callcenter]> insert into empleados(Idempleados,Nombre,Direccion,Telefono,Email,Idsedes,Idcliente) VALUES('1003','Gregorio','Cll 56 # 78 98','3498765','grego2298@hotmail.com','02','00003'); Query OK, 1 row affected (0.06 sec) MariaDB [callcenter]> insert into empleados(Idempleados,Nombre,Direccion,Telefono,Email,Idsedes,Idcliente) VALUES('1004','Andres','Cll 67 # 89 77','2134567','andyuri23@gmail.com','01','00001'); Query OK, 1 row affected (0.07 sec) MariaDB [callcenter]> insert into empleados(Idempleados,Nombre,Direccion,Telefono,Email,Idsedes,Idcliente) VALUES('1005','Manuela','Cll 45 # 45 22','3457543','manuela123@hotmail.com','03','00005'); Query OK, 1 row affected (0.06 sec) MariaDB [callcenter]> select * from empleados; +-------------+----------+----------------+----------+------------------------+---------+-----------+ | Idempleados | Nombre | Direccion | Telefono | Email | Idsedes | Idcliente | +-------------+----------+----------------+----------+------------------------+---------+-----------+ | 1001 | Elva | Cra 23 # 45 67 | 6543212 | elvita@gmail.com | 01 | 00001 | | 1002 | Maria | Cll 67 # 89 09 | 5679865 | mari1987@gmail.com | 01 | 00001 | | 1003 | Gregorio | Cll 56 # 78 98 | 3498765 | grego2298@hotmail.com | 02 | 00003 | | 1004 | Andres | Cll 67 # 89 77 | 2134567 | andyuri23@gmail.com | 01 | 00001 | | 1005 | Manuela | Cll 45 # 45 22 | 3457543 | manuela123@hotmail.com | 03 | 00005 | +-------------+----------+----------------+----------+------------------------+---------+-----------+ 5 rows in set (0.00 sec) MariaDB [callcenter]> insert into transporte(Idconductor,Nombre,Direccion,Telefono,Email,Tipocarro,Placa) VALUES('002','Andres','Cra 25 # 45 67','6556212','andres23@gmail.com','Automovil','TCM059'); Query OK, 1 row affected (0.07 sec) MariaDB [callcenter]> insert into transporte(Idconductor,Nombre,Direccion,Telefono,Email,Tipocarro,Placa) VALUES('001','Camilo','Cll 34# 89 09','6789865','camil58@gmail.com','Autobus','TCS025'); Query OK, 1 row affected (0.08 sec) MariaDB [callcenter]> insert into transporte(Idconductor,Nombre,Direccion,Telefono,Email,Tipocarro,Placa) VALUES('003','Oscar','Cll 89# 78 98','6788765','oscar124@hotmail.com','Camioneta','OES032'); Query OK, 1 row affected (0.07 sec) MariaDB [callcenter]> insert into transporte(Idconductor,Nombre,Direccion,Telefono,Email,Tipocarro,Placa) VALUES('004','Daniel','Cll 110# 89 77','6904567','daniel124@gmail.com','Automovil','POD304'); Query OK, 1 row affected (0.05 sec) MariaDB [callcenter]> insert into transporte(Idconductor,Nombre,Direccion,Telefono,Email,Tipocarro,Placa) VALUES('005','Julian','Cll 39# 45 22','6423543','julian123@hotmail.com','Autobus','VTO987'); Query OK, 1 row affected (0.13 sec) MariaDB [callcenter]> select * from transporte; +-------------+--------+----------------+----------+-----------------------+-----------+--------+ | Idconductor | Nombre | Direccion | Telefono | Email | Tipocarro | Placa | +-------------+--------+----------------+----------+-----------------------+-----------+--------+ | 001 | Camilo | Cll 34# 89 09 | 6789865 | camil58@gmail.com | Autobus | TCS025 | | 002 | Andres | Cra 25 # 45 67 | 6556212 | andres23@gmail.com | Automovil | TCM059 | | 003 | Oscar | Cll 89# 78 98 | 6788765 | oscar124@hotmail.com | Camioneta | OES032 | | 004 | Daniel | Cll 110# 89 77 | 6904567 | daniel124@gmail.com | Automovil | POD304 | | 005 | Julian | Cll 39# 45 22 | 6423543 | julian123@hotmail.com | Autobus | VTO987 | +-------------+--------+----------------+----------+-----------------------+-----------+--------+ 5 rows in set (0.00 sec) MariaDB [callcenter]> insert into producto(Idproducto,Nombre,Descripcion,Precio,Idcliente) VALUES('10','DELFIN','llamada ilimitas,10GB','30 Euros','00001'); Query OK, 1 row affected (0.07 sec) MariaDB [callcenter]> insert into producto(Idproducto,Nombre,Descripcion,Precio,Idcliente) VALUES('20','ARDILLA','100 minutos,5GB','20 Euros','00001'); Query OK, 1 row affected (0.06 sec) MariaDB [callcenter]> insert into producto(Idproducto,Nombre,Descripcion,Precio,Idcliente) VALUES('30','CANGURO SIN LIMITES','llamada ilimitas,20GB','50 Euros','00001'); Query OK, 1 row affected (0.08 sec) MariaDB [callcenter]> insert into producto(Idproducto,Nombre,Descripcion,Precio,Idcliente) VALUES('40','CANGURO TOTAL','llamadas ilimitadas,50B','80 Euros','00001'); Query OK, 1 row affected (0.06 sec) MariaDB [callcenter]> insert into producto(Idproducto,Nombre,Descripcion,Precio,Idcliente) VALUES('50','CANGURO AHORRO','500 minutos,15GB','40 Euros','00001'); Query OK, 1 row affected (0.07 sec) MariaDB [callcenter]> select * from producto; +------------+---------------------+-------------------------+----------+-----------+ | Idproducto | Nombre | Descripcion | Precio | Idcliente | +------------+---------------------+-------------------------+----------+-----------+ | 10 | DELFIN | llamada ilimitas,10GB | 30 Euros | 00001 | | 20 | ARDILLA | 100 minutos,5GB | 20 Euros | 00001 | | 30 | CANGURO SIN LIMITES | llamada ilimitas,20GB | 50 Euros | 00001 | | 40 | CANGURO TOTAL | llamadas ilimitadas,50B | 80 Euros | 00001 | | 50 | CANGURO AHORRO | 500 minutos,15GB | 40 Euros | 00001 | +------------+---------------------+-------------------------+----------+-----------+ 5 rows in set (0.00 sec) MariaDB [callcenter]> insert into usuariofinal(Idusuariofinal,Nombre,Direccion,Telefono,Email) VALUES('100','Manuel','Cra 259 # 45 67 ','78956212','maune23@gmail.com'); Query OK, 1 row affected (0.09 sec) MariaDB [callcenter]> insert into usuariofinal(Idusuariofinal,Nombre,Direccion,Telefono,Email) VALUES('200','Cesar','Calle 4sur #45 56 ','76533865','cesarna23@gmail.com'); Query OK, 1 row affected (0.09 sec) MariaDB [callcenter]> insert into usuariofinal(Idusuariofinal,Nombre,Direccion,Telefono,Email) VALUES('300','Andrei','Calle 56nor #25 34','78664365','andrei453@gmail.com'); Query OK, 1 row affected (0.08 sec) MariaDB [callcenter]> insert into usuariofinal(Idusuariofinal,Nombre,Direccion,Telefono,Email) VALUES('400','Maria','Cra 23 #67 32','76453567','marias123@hotmial.com'); Query OK, 1 row affected (0.13 sec) MariaDB [callcenter]> insert into usuariofinal(Idusuariofinal,Nombre,Direccion,Telefono,Email) VALUES('500','Bego¤a','Cra 605 #89 05','74332543','bego¤a124@hotmail.com'); Query OK, 1 row affected (0.09 sec) MariaDB [callcenter]> select * from cliente; +-----------+----------+---------------------+----------+------------------------+ | Idcliente | Nombre | Direccion | Telefono | Email | +-----------+----------+---------------------+----------+------------------------+ | 00001 | Movistar | Cra 23 # 45 67 | 6543212 | orangefide@gmail.com | | 00002 | Vodafone | Calle 4norte #45 56 | 6547885 | vodafne123@hotmail.com | | 00003 | Babaria | Calle 6sur #25 34 | 6547885 | vodafne123@hotmail.com | | 00004 | Amena | Cra 34 #67 32 | 6457890 | amena54@hotmial.com | | 00005 | Claro | Cra 24 #89 05 | 6521345 | claro257@gmail.com | +-----------+----------+---------------------+----------+------------------------+ 5 rows in set (0.00 sec) MariaDB [callcenter]> select * from usuariofinal; +----------------+--------+--------------------+----------+-----------------------+ | Idusuariofinal | Nombre | Direccion | Telefono | Email | +----------------+--------+--------------------+----------+-----------------------+ | 100 | Manuel | Cra 259 # 45 67 | 78956212 | maune23@gmail.com | | 200 | Cesar | Calle 4sur #45 56 | 76533865 | cesarna23@gmail.com | | 300 | Andrei | Calle 56nor #25 34 | 78664365 | andrei453@gmail.com | | 400 | Maria | Cra 23 #67 32 | 76453567 | marias123@hotmial.com | | 500 | Bego¤a | Cra 605 #89 05 | 74332543 | bego¤a124@hotmail.com | +----------------+--------+--------------------+----------+-----------------------+ 5 rows in set (0.00 sec) MariaDB [(none)]> source C:\xampp\callcenter.sql 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.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.01 sec) Database changed Query OK, 0 rows affected (0.59 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.27 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.05 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 5 rows affected (0.05 sec) Records: 5 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.10 sec) Query OK, 0 rows affected (0.24 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.26 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 5 rows affected (0.07 sec) Records: 5 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.17 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.57 sec) Query OK, 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.22 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.25 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 5 rows affected (0.04 sec) Records: 5 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.33 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.29 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.22 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.22 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 3 rows affected (0.04 sec) Records: 3 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.08 sec) Query OK, 0 rows affected (0.21 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.27 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 5 rows affected (0.04 sec) Records: 5 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.19 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.23 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 5 rows affected (0.08 sec) Records: 5 Duplicates: 0 Warnings: 0 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.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) MariaDB [callcenter]> show tables; +----------------------+ | Tables_in_callcenter | +----------------------+ | cliente | | empleados | | empletrans | | producto | | prousofinal | | sedes | | transporte | | usuariofinal | +----------------------+ 8 rows in set (0.06 sec) MariaDB [callcenter]> INSERT INTO empletrans(Idempleados,Idconductor,Fecharecoemple) VALUES('1001','002','02/06/2019'); Query OK, 1 row affected (0.11 sec) MariaDB [callcenter]> INSERT INTO empletrans(Idempleados,Idconductor,Fecharecoemple) VALUES('1002','001','04/07/2019'); Query OK, 1 row affected (0.08 sec) MariaDB [callcenter]> INSERT INTO empletrans(Idempleados,Idconductor,Fecharecoemple) VALUES('1003','003','10/06/2019'); Query OK, 1 row affected (0.07 sec) MariaDB [callcenter]> INSERT INTO empletrans(Idempleados,Idconductor,Fecharecoemple) VALUES('1004','004','12/06/2019'); Query OK, 1 row affected (0.09 sec) MariaDB [callcenter]> INSERT INTO empletrans(Idempleados,Idconductor,Fecharecoemple) VALUES('1005','005','03/06/2019'); Query OK, 1 row affected (0.08 sec) MariaDB [callcenter]> INSERT INTO empletrans(Idempleados,Idconductor,Fecharecoemple) VALUES('1003','002','08/07/2019'); Query OK, 1 row affected (0.08 sec) MariaDB [callcenter]> INSERT INTO empletrans(Idempleados,Idconductor,Fecharecoemple) VALUES('1002','001','16/07/2019'); Query OK, 1 row affected (0.06 sec) MariaDB [callcenter]> INSERT INTO empletrans(Idempleados,Idconductor,Fecharecoemple) VALUES('1001','003','15/06/2019'); Query OK, 1 row affected (0.09 sec) MariaDB [callcenter]> INSERT INTO empletrans(Idempleados,Idconductor,Fecharecoemple) VALUES('1004','004','23/06/2019'); Query OK, 1 row affected (0.07 sec) MariaDB [callcenter]> select * from empletrans; +-------------+-------------+----------------+ | Idempleados | Idconductor | Fecharecoemple | +-------------+-------------+----------------+ | 1001 | 002 | 02/06/2019 | | 1002 | 001 | 04/07/2019 | | 1003 | 003 | 10/06/2019 | | 1004 | 004 | 12/06/2019 | | 1005 | 005 | 03/06/2019 | | 1003 | 002 | 08/07/2019 | | 1002 | 001 | 16/07/2019 | | 1001 | 003 | 15/06/2019 | | 1004 | 004 | 23/06/2019 | +-------------+-------------+----------------+ 9 rows in set (0.00 sec) MariaDB [callcenter]> INSERT INTO prousofinal(Idproducto,Idusuariofinal,Permanencia) VALUES('10','100','2 a¤os'); Query OK, 1 row affected (0.07 sec) MariaDB [callcenter]> INSERT INTO prousofinal(Idproducto,Idusuariofinal,Permanencia) VALUES('30','200','1 a¤o'); Query OK, 1 row affected (0.13 sec) MariaDB [callcenter]> INSERT INTO prousofinal(Idproducto,Idusuariofinal,Permanencia) VALUES('30','300','2 a¤os'); Query OK, 1 row affected (0.10 sec) MariaDB [callcenter]> INSERT INTO prousofinal(Idproducto,Idusuariofinal,Permanencia) VALUES('40','400','2 a¤os'); Query OK, 1 row affected (0.08 sec) MariaDB [callcenter]> INSERT INTO prousofinal(Idproducto,Idusuariofinal,Permanencia) VALUES('50','100','1 a¤o'); Query OK, 1 row affected (0.09 sec) MariaDB [callcenter]> INSERT INTO prousofinal(Idproducto,Idusuariofinal,Permanencia) VALUES('50','200','1 a¤o'); Query OK, 1 row affected (0.07 sec) MariaDB [callcenter]> INSERT INTO prousofinal(Idproducto,Idusuariofinal,Permanencia) VALUES('30','100','1 a¤o'); Query OK, 1 row affected (0.07 sec) MariaDB [callcenter]> INSERT INTO prousofinal(Idproducto,Idusuariofinal,Permanencia) VALUES('20','400','1 a¤o'); Query OK, 1 row affected (0.12 sec) MariaDB [callcenter]> INSERT INTO prousofinal(Idproducto,Idusuariofinal,Permanencia) VALUES('30','200','1 a¤o'); Query OK, 1 row affected (0.06 sec) MariaDB [callcenter]> select * from prousofinal; +------------+----------------+-------------+ | Idproducto | Idusuariofinal | Permanencia | +------------+----------------+-------------+ | 10 | 100 | 2 a¤os | | 30 | 200 | 1 a¤o | | 30 | 300 | 2 a¤os | | 40 | 400 | 2 a¤os | | 50 | 100 | 1 a¤o | | 50 | 200 | 1 a¤o | | 30 | 100 | 1 a¤o | | 20 | 400 | 1 a¤o | | 30 | 200 | 1 a¤o | +------------+----------------+-------------+ 9 rows in set (0.00 sec) MariaDB [callcenter]> select empleados.idempleados,empleados.nombre,transporte.idconductor,transporte.nombre from empleados inner join empletrans on empleados.idempleados=empletrans.idempleados inner join transporte on transporte.idconductor=empletrans.idconductor; +-------------+----------+-------------+--------+ | idempleados | nombre | idconductor | nombre | +-------------+----------+-------------+--------+ | 1001 | Elva | 002 | Andres | | 1002 | Maria | 001 | Camilo | | 1003 | Gregorio | 003 | Oscar | | 1004 | Andres | 004 | Daniel | | 1005 | Manuela | 005 | Julian | | 1003 | Gregorio | 002 | Andres | | 1002 | Maria | 001 | Camilo | | 1001 | Elva | 003 | Oscar | | 1004 | Andres | 004 | Daniel | +-------------+----------+-------------+--------+ 9 rows in set (0.00 sec) MariaDB [callcenter]> select producto.idproducto,producto.nombre,usuariofinal.idusuariofinal,usuariofinal.nombre from producto inner join prousofinal on producto.idproducto=prousofinal.idproducto inner join usuariofinal on usuariofinal.idusuariofinal =prousofinal.idusuariofinal; +------------+---------------------+----------------+--------+ | idproducto | nombre | idusuariofinal | nombre | +------------+---------------------+----------------+--------+ | 10 | DELFIN | 100 | Manuel | | 30 | CANGURO SIN LIMITES | 200 | Cesar | | 30 | CANGURO SIN LIMITES | 300 | Andrei | | 40 | CANGURO TOTAL | 400 | Maria | | 50 | CANGURO AHORRO | 100 | Manuel | | 50 | CANGURO AHORRO | 200 | Cesar | | 30 | CANGURO SIN LIMITES | 100 | Manuel | | 20 | ARDILLA | 400 | Maria | | 30 | CANGURO SIN LIMITES | 200 | Cesar | +------------+---------------------+----------------+--------+ 9 rows in set (0.00 sec) MariaDB [callcenter]> select empleados.idempleados,empleados.nombre,empletrans.idempleados from empleados left join empletrans ON empleados.idempleados=empletrans.idempleados where empletrans.idempleados is null; Empty set (0.00 sec) MariaDB [callcenter]> ; ERROR: No query specified MariaDB [callcenter]> select empleados.idempleados,empleados.nombre,empletrans.idempleados from empleados right join empletrans on empleados.idempleados=empletrans.idempleados; +-------------+----------+-------------+ | idempleados | nombre | idempleados | +-------------+----------+-------------+ | 1001 | Elva | 1001 | | 1001 | Elva | 1001 | | 1002 | Maria | 1002 | | 1002 | Maria | 1002 | | 1003 | Gregorio | 1003 | | 1003 | Gregorio | 1003 | | 1004 | Andres | 1004 | | 1004 | Andres | 1004 | | 1005 | Manuela | 1005 | +-------------+----------+-------------+ 9 rows in set (0.00 sec) MariaDB [callcenter]> exit