MariaDB [(none)]> drop database Bdmoldes; Query OK, 1 row affected (0.045 sec) MariaDB [(none)]> create database Bdmoldes; Query OK, 1 row affected (0.001 sec) MariaDB [(none)]> use Bdmoldes; Database changed MariaDB [Bdmoldes]> create table molde -> (numeromolde varchar(5) not null primary key, -> descripcion varchar(50) not null, -> medidas varchar(30), -> tipo set('Molde','Perfil') not null, -> fechaelaboracion date, -> material varchar(40) not null, -> valor int(7) not null); Query OK, 0 rows affected (0.059 sec) MariaDB [Bdmoldes]> describe molde; +------------------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-----------------------+------+-----+---------+-------+ | numeromolde | varchar(5) | NO | PRI | NULL | | | descripcion | varchar(50) | NO | | NULL | | | medidas | varchar(30) | YES | | NULL | | | tipo | set('Molde','Perfil') | NO | | NULL | | | fechaelaboracion | date | YES | | NULL | | | material | varchar(40) | NO | | NULL | | | valor | int(7) | NO | | NULL | | +------------------+-----------------------+------+-----+---------+-------+ 7 rows in set (0.030 sec) MariaDB [Bdmoldes]> create table zona -> (codigozona varchar(4) not null primary key, -> descripcion varchar(40) not null, -> jefeinmediato varchar(40) not null, -> piso varchar(20) not null); Query OK, 0 rows affected (0.061 sec) MariaDB [Bdmoldes]> describe zona; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | codigozona | varchar(4) | NO | PRI | NULL | | | descripcion | varchar(40) | NO | | NULL | | | jefeinmediato | varchar(40) | NO | | NULL | | | piso | varchar(20) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 4 rows in set (0.011 sec) MariaDB [Bdmoldes]> create table maquina -> (numero varchar(10) not null primary key, -> nombre varchar(40) not null, -> descripcion blob, -> codigozona varchar(4) not null, -> foreign key(codigozona) references zona(codigozona) on delete cascade on update cascade); Query OK, 0 rows affected (0.060 sec) MariaDB [Bdmoldes]> describe maquina; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | numero | varchar(10) | NO | PRI | NULL | | | nombre | varchar(40) | NO | | NULL | | | descripcion | blob | YES | | NULL | | | codigozona | varchar(4) | NO | MUL | NULL | | +-------------+-------------+------+-----+---------+-------+ 4 rows in set (0.008 sec) MariaDB [Bdmoldes]> create table cargo -> (codigocargo varchar(4) not null primary key, -> nombre varchar(30) not null, -> descripcion varchar(40) not null, -> horario enum ('Maana','Tarde','Dia Completo') not null, -> codigozona varchar(4) not null, -> foreign key(codigozona) references zona(codigozona) on delete cascade on update cascade); Query OK, 0 rows affected (0.067 sec) MariaDB [Bdmoldes]> describe cargo; +-------------+---------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------------------------------+------+-----+---------+-------+ | codigocargo | varchar(4) | NO | PRI | NULL | | | nombre | varchar(30) | NO | | NULL | | | descripcion | varchar(40) | NO | | NULL | | | horario | enum('Maana','Tarde','Dia Completo') | NO | | NULL | | | codigozona | varchar(4) | NO | MUL | NULL | | +-------------+---------------------------------------+------+-----+---------+-------+ 5 rows in set (0.037 sec) MariaDB [Bdmoldes]> show tables; +--------------------+ | Tables_in_bdmoldes | +--------------------+ | cargo | | maquina | | molde | | zona | +--------------------+ 4 rows in set (0.013 sec) MariaDB [Bdmoldes]> create table operario -> (codoperario varchar(5) not null primary key, -> nombre varchar(40) not null, -> edad int(3) not null, -> celular varchar(20), -> codigocargo varchar(4) not null, -> foreign key(codigocargo) references cargo(codigocargo) on delete cascade on update cascade); Query OK, 0 rows affected (0.047 sec) MariaDB [Bdmoldes]> describe opearario; ERROR 1146 (42S02): Table 'bdmoldes.opearario' doesn't exist MariaDB [Bdmoldes]> describe operario; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | codoperario | varchar(5) | NO | PRI | NULL | | | nombre | varchar(40) | NO | | NULL | | | edad | int(3) | NO | | NULL | | | celular | varchar(20) | YES | | NULL | | | codigocargo | varchar(4) | NO | MUL | NULL | | +-------------+-------------+------+-----+---------+-------+ 5 rows in set (0.011 sec) MariaDB [Bdmoldes]> create table moldeoperario -> (numeromolde varchar(5) not null, -> codoperario varchar(5) not null, -> fechaultimavez datel, -> foreign key(numeromolde) references molde(numeromolde) on delete cascade on update cascade, -> foreign key(codoperario) references operario(codoperario) on delete cascade on update cascade); 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 ' foreign key(numeromolde) references molde(numeromolde) on delete cascade on ...' at line 4 MariaDB [Bdmoldes]> describe molde; +------------------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-----------------------+------+-----+---------+-------+ | numeromolde | varchar(5) | NO | PRI | NULL | | | descripcion | varchar(50) | NO | | NULL | | | medidas | varchar(30) | YES | | NULL | | | tipo | set('Molde','Perfil') | NO | | NULL | | | fechaelaboracion | date | YES | | NULL | | | material | varchar(40) | NO | | NULL | | | valor | int(7) | NO | | NULL | | +------------------+-----------------------+------+-----+---------+-------+ 7 rows in set (0.017 sec) MariaDB [Bdmoldes]> create table moldeoperario -> (numeromolde varchar(5) not null, -> codoperario varchar(5) not null, -> fechaultimavez date, -> foreign key(numeromolde) references molde(numeromolde) on delete cascade on update cascade, -> foreign key(codoperario) references operario(codoperario) on delete cascade on update cascade); Query OK, 0 rows affected (0.025 sec) MariaDB [Bdmoldes]> describe moldeoperario; +----------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------+------+-----+---------+-------+ | numeromolde | varchar(5) | NO | MUL | NULL | | | codoperario | varchar(5) | NO | MUL | NULL | | | fechaultimavez | date | YES | | NULL | | +----------------+------------+------+-----+---------+-------+ 3 rows in set (0.018 sec) MariaDB [Bdmoldes]> show tables; +--------------------+ | Tables_in_bdmoldes | +--------------------+ | cargo | | maquina | | molde | | moldeoperario | | operario | | zona | +--------------------+ 6 rows in set (0.001 sec) MariaDB [Bdmoldes]> create table reutilizado -> (codigo varchar(5) not null primary key, -> fecha date, -> nuevonumeromolde varchar(5) not null, -> numeromolde varchar(5) not null, -> foreign key(numeromolde) references molde(numeromolde) on delete cascade on update cascade); Query OK, 0 rows affected (0.050 sec) MariaDB [Bdmoldes]> create table desechado -> (codigo varchar(5) not null primary key, -> fecha date, -> numeromolde varchar(5) not null, -> foreign key(numeromolde) references molde(numeromolde) on delete cascade on update cascade) -> ; Query OK, 0 rows affected (0.053 sec) MariaDB [Bdmoldes]> create table reparacion -> (codigo varchar(6) not null primary key, -> descripcion set('Chocado','Rayado','Faltan piezas','Modificacion'), -> fechareparacion date, -> numeromolde varchar(5) not null, -> foreign key(numeromolde) references molde(numeromolde) on delete cascade on update cascade); Query OK, 0 rows affected (0.053 sec) MariaDB [Bdmoldes]> describe reparacion; +-----------------+--------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------------------------------------------------+------+-----+---------+-------+ | codigo | varchar(6) | NO | PRI | NULL | | | descripcion | set('Chocado','Rayado','Faltan piezas','Modificacion') | YES | | NULL | | | fechareparacion | date | YES | | NULL | | | numeromolde | varchar(5) | NO | MUL | NULL | | +-----------------+--------------------------------------------------------+------+-----+---------+-------+ 4 rows in set (0.017 sec) MariaDB [Bdmoldes]> create table orden -> (numeroorden varchar(6) not null primary key, -> temperatura int(4), -> tiempo int(4)); Query OK, 0 rows affected (0.054 sec) MariaDB [Bdmoldes]> create table cliente -> (codcliente varchar(6) not null primary key, -> nombrecliente varchar(40) not null, -> ubicacion varchar(30), -> nit varchar(15) not null); Query OK, 0 rows affected (0.054 sec) MariaDB [Bdmoldes]> describe cliente; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | codcliente | varchar(6) | NO | PRI | NULL | | | nombrecliente | varchar(40) | NO | | NULL | | | ubicacion | varchar(30) | YES | | NULL | | | nit | varchar(15) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 4 rows in set (0.043 sec) MariaDB [Bdmoldes]> create table climolorden -> (numeroorden varchar(6) not null, -> codcliente varchar(6) not null, -> numeromolde varchar(5) not null, -> foreign key(numeroorden) references orden(numeroorden) on delete cascade on update cascade, -> foreign key(codcliente) references cliente(codcliente) on delete cascade on update cascade, -> foreign key(numeromolde) references molde(numeromolde) on delete cascade on update cascade); Query OK, 0 rows affected (0.066 sec) MariaDB [Bdmoldes]> describe climolorden; +-------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------+------+-----+---------+-------+ | numeroorden | varchar(6) | NO | MUL | NULL | | | codcliente | varchar(6) | NO | MUL | NULL | | | numeromolde | varchar(5) | NO | MUL | NULL | | +-------------+------------+------+-----+---------+-------+ 3 rows in set (0.011 sec) MariaDB [Bdmoldes]> show tables; +--------------------+ | Tables_in_bdmoldes | +--------------------+ | cargo | | cliente | | climolorden | | desechado | | maquina | | molde | | moldeoperario | | operario | | orden | | reparacion | | reutilizado | | zona | +--------------------+ 12 rows in set (0.001 sec) MariaDB [Bdmoldes]> exit MariaDB [(none)]> use Bdmoldes; Database changed MariaDB [Bdmoldes]> describe molde; +------------------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-----------------------+------+-----+---------+-------+ | numeromolde | varchar(5) | NO | PRI | NULL | | | descripcion | varchar(50) | NO | | NULL | | | medidas | varchar(30) | YES | | NULL | | | tipo | set('Molde','Perfil') | NO | | NULL | | | fechaelaboracion | date | YES | | NULL | | | material | varchar(40) | NO | | NULL | | | valor | int(7) | NO | | NULL | | +------------------+-----------------------+------+-----+---------+-------+ 7 rows in set (0.141 sec) MariaDB [Bdmoldes]> insert into molde(numeromolde,descripcion,medidas,tipo,fechaelaboracion,material,valor) values('35','oring','','Molde','20-9-2011','Silicona','300000'),('41','empaque autoclave','','Molde','20-9-2011','Silicona','300000'),('44','oring','205x4mm esp','Molde','20-11-2012','silicona','38000'),('52','amortiguador','','Molde','4-4-2005','croydon','55000'),('75','realce sencillo rdo','140x170x10mm','Molde','26-7-2019','croydon','3000'),('335','anillo guia raspador','12.7x3.3mm','Perfil','14-9-2017','nitrilo','390000'),('526','empaque manga lecho empalmado','41.5x31.5 perimetro 2380mm','Perfil','18-7-2017','silicona','600000'),('5161','banda en perfil','13x13mm','Perfil','18-9-2015','silicona','12000'),('5389','banda en perfil','150x4mm esp','Perfil','19-2-2015','chupo','25000'),('520','empaque autoclave','20.5mm empalmado','Perfil','4-07-2017','silicona','38000'); Query OK, 10 rows affected, 10 warnings (0.170 sec) Records: 10 Duplicates: 0 Warnings: 10 MariaDB [Bdmoldes]> select * from molde; +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | numeromolde | descripcion | medidas | tipo | fechaelaboracion | material | valor | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 0000-00-00 | nitrilo | 390000 | | 35 | oring | | Molde | 0000-00-00 | Silicona | 300000 | | 41 | empaque autoclave | | Molde | 0000-00-00 | Silicona | 300000 | | 44 | oring | 205x4mm esp | Molde | 0000-00-00 | silicona | 38000 | | 5161 | banda en perfil | 13x13mm | Perfil | 0000-00-00 | silicona | 12000 | | 52 | amortiguador | | Molde | 0000-00-00 | croydon | 55000 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 0000-00-00 | silicona | 38000 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 0000-00-00 | silicona | 600000 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 0000-00-00 | chupo | 25000 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 0000-00-00 | croydon | 3000 | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ 10 rows in set (0.043 sec) MariaDB [Bdmoldes]> delete * from molde; 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 '* from molde' at line 1 MariaDB [Bdmoldes]> delete from molde; Query OK, 10 rows affected (0.164 sec) MariaDB [Bdmoldes]> select * from molde; Empty set (0.000 sec) MariaDB [Bdmoldes]> insert into molde(numeromolde,descripcion,medidas,tipo,fechaelaboracion,material,valor) values('35','oring','','Molde','2011-9-20','Silicona','300000'),('41','empaque autoclave','','Molde','2012-5-18','Silicona','300000'),('44','oring','205x4mm esp','Molde','2012-11-20','silicona','38000'),('52','amortiguador','','Molde','2005-4-4','croydon','55000'),('75','realce sencillo rdo','140x170x10mm','Molde','2019-7-29,'croydon','3000'),('335','anillo guia raspador','12.7x3.3mm','Perfil','2017-9-14','nitrilo','390000'),('526','empaque manga lecho empalmado','41.5x31.5 perimetro 2380mm','Perfil','2017-7-18','silicona','600000'),('5161','banda en perfil','13x13mm','Perfil','2015-9-18','silicona','12000'),('5389','banda en perfil','150x4mm esp','Perfil','2015-2-19','chupo','25000'),('520','empaque autoclave','20.5mm empalmado','Perfil','2017-7-4','silicona','38000'); '> ; '> ' -> ; 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 'croydon','3000'),('335','anillo guia raspador','12.7x3.3mm','Perfil','2017-9-...' at line 1 MariaDB [Bdmoldes]> select * from molde; Empty set (0.000 sec) MariaDB [Bdmoldes]> insert into molde(numeromolde,descripcion,medidas,tipo,fechaelaboracion,material,valor) values('35','oring','','Molde','2011-9-20','Silicona','300000'),('41','empaque autoclave','','Molde','2012-5-18','Silicona','300000'),('44','oring','205x4mm esp','Molde','2012-11-20','silicona','38000'),('52','amortiguador','','Molde','2005-4-4','croydon','55000'),('75','realce sencillo rdo','140x170x10mm','Molde','2019-7-29','croydon','3000'),('335','anillo guia raspador','12.7x3.3mm','Perfil','2017-9-14','nitrilo','390000'),('526','empaque manga lecho empalmado','41.5x31.5 perimetro 2380mm','Perfil','2017-7-18','silicona','600000'),('5161','banda en perfil','13x13mm','Perfil','2015-9-18','silicona','12000'),('5389','banda en perfil','150x4mm esp','Perfil','2015-2-19','chupo','25000'),('520','empaque autoclave','20.5mm empalmado','Perfil','2017-7-4','silicona','38000'); Query OK, 10 rows affected (0.022 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> select * from molde; +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | numeromolde | descripcion | medidas | tipo | fechaelaboracion | material | valor | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ 10 rows in set (0.001 sec) MariaDB [Bdmoldes]> insert into moldeoperario(numeromolde,codoperario,fechaultimavez) values('335','006','20/11/2019'),('35','001','25/11/2012'),('41','009','15/01/2016'),('5161','010','12/05/2018'),('52','002','16/11/2016'),('520','007','10/07/2008'),('526','003','01/07/2020'),('5389','004','25/05/2020'),('75','005','03/01/2017'),('44','008','04/05/2020'); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`bdmoldes`.`moldeoperario`, CONSTRAINT `moldeoperario_ibfk_2` FOREIGN KEY (`codoperario`) REFERENCES `operario` (`codoperario`) ON DELETE CASCADE ON UPDATE CASCADE) MariaDB [Bdmoldes]> describe reutilizado; +------------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------+------+-----+---------+-------+ | codigo | varchar(5) | NO | PRI | NULL | | | fecha | date | YES | | NULL | | | nuevonumeromolde | varchar(5) | NO | | NULL | | | numeromolde | varchar(5) | NO | MUL | NULL | | +------------------+------------+------+-----+---------+-------+ 4 rows in set (0.037 sec) MariaDB [Bdmoldes]> insert into reutilizado(codigo,fecha,nuevonumeromolde,numeromolde) values('001','16/04/2009','6167','335'), -> ('002','2005-8-29','1235','35'),('003','2017-9-26','1253','41'),('004','2018-7-19','6105','5161'),('005','2017-9-4','60','52'),('006','2018-9-25','1382','520'),('007','2020-11-23','5854','526'),('008','2020-8-20','14','5389'), -> ('009','2020-10-5','130','75'),('010','2019-8-15','240','44'); Query OK, 10 rows affected, 1 warning (0.048 sec) Records: 10 Duplicates: 0 Warnings: 1 MariaDB [Bdmoldes]> select * from reutilizado; +--------+------------+------------------+-------------+ | codigo | fecha | nuevonumeromolde | numeromolde | +--------+------------+------------------+-------------+ | 001 | 0000-00-00 | 6167 | 335 | | 002 | 2005-08-29 | 1235 | 35 | | 003 | 2017-09-26 | 1253 | 41 | | 004 | 2018-07-19 | 6105 | 5161 | | 005 | 2017-09-04 | 60 | 52 | | 006 | 2018-09-25 | 1382 | 520 | | 007 | 2020-11-23 | 5854 | 526 | | 008 | 2020-08-20 | 14 | 5389 | | 009 | 2020-10-05 | 130 | 75 | | 010 | 2019-08-15 | 240 | 44 | +--------+------------+------------------+-------------+ 10 rows in set (0.001 sec) MariaDB [Bdmoldes]> insert into orden(numeroorden,temperatura,tiempo) values('24709',170,20),('41892',170,20),('33275',150,50),('45845',165,5),('32957',170,10),('28859',160,6),('37663',150,8),('28319',145,7),('38504',150,10),('32495',150,15); Query OK, 10 rows affected (0.023 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> select * from orden; +-------------+-------------+--------+ | numeroorden | temperatura | tiempo | +-------------+-------------+--------+ | 24709 | 170 | 20 | | 28319 | 145 | 7 | | 28859 | 160 | 6 | | 32495 | 150 | 15 | | 32957 | 170 | 10 | | 33275 | 150 | 50 | | 37663 | 150 | 8 | | 38504 | 150 | 10 | | 41892 | 170 | 20 | | 45845 | 165 | 5 | +-------------+-------------+--------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> insert into desechado(codigo,fecha,numeromolde) values('001','2020-12-4','335'), -> ('002','2020-12-20','526'),('003','2020-10-15','520'),('004','2021-1-22','5161'),('005','2021'-1-1,'5389'),('006','2021'-2-12,'41'),('007','2020-12-25','44'),('008','2020-12-25','44'),('009','2020-10-17','52'),('010','2020-9-12','35'); Query OK, 10 rows affected, 2 warnings (0.054 sec) Records: 10 Duplicates: 0 Warnings: 2 MariaDB [Bdmoldes]> select * from desechado, -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 MariaDB [Bdmoldes]> select * from desechado; +--------+------------+-------------+ | codigo | fecha | numeromolde | +--------+------------+-------------+ | 001 | 2020-12-04 | 335 | | 002 | 2020-12-20 | 526 | | 003 | 2020-10-15 | 520 | | 004 | 2021-01-22 | 5161 | | 005 | 0000-00-00 | 5389 | | 006 | 0000-00-00 | 41 | | 007 | 2020-12-25 | 44 | | 008 | 2020-12-25 | 44 | | 009 | 2020-10-17 | 52 | | 010 | 2020-09-12 | 35 | +--------+------------+-------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> delete from desechado; Query OK, 10 rows affected (0.006 sec) MariaDB [Bdmoldes]> insert into desechado(codigo,fecha,numeromolde) values('001','2020-12-4','335'), -> ('002','2020-12-20','526'),('003','2020-10-15','520'),('004','2021-1-22','5161'),('005','2021-1-1','5389'),('006','2021-2-12','41'),('007','2020-12-25','44'),('008','2020-12-25','44'),('009','2020-10-17','52'),('010','2020-9-12','35'); Query OK, 10 rows affected (0.044 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> select * from desechado; +--------+------------+-------------+ | codigo | fecha | numeromolde | +--------+------------+-------------+ | 001 | 2020-12-04 | 335 | | 002 | 2020-12-20 | 526 | | 003 | 2020-10-15 | 520 | | 004 | 2021-01-22 | 5161 | | 005 | 2021-01-01 | 5389 | | 006 | 2021-02-12 | 41 | | 007 | 2020-12-25 | 44 | | 008 | 2020-12-25 | 44 | | 009 | 2020-10-17 | 52 | | 010 | 2020-09-12 | 35 | +--------+------------+-------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> describe cliente; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | codcliente | varchar(6) | NO | PRI | NULL | | | nombrecliente | varchar(40) | NO | | NULL | | | ubicacion | varchar(30) | YES | | NULL | | | nit | varchar(15) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 4 rows in set (0.038 sec) MariaDB [Bdmoldes]> delete from reutilizado; Query OK, 10 rows affected (0.026 sec) MariaDB [Bdmoldes]> insert into reutilizado(codigo,fecha,nuevonumeromolde,numeromolde) values('001','2009-4-16','6167','335'), -> ('002','2005-8-29','1235','35'),('003','2017-9-26','1253','41'),('004','2018-7-19','6105','5161'),('005','2017-9-4','60','52'),('006','2018-9-25','1382','520'),('007','2020-11-23','5854','526'),('008','2020-8-20','14','5389'), -> ('009','2020-10-5','130','75'),('010','2019-8-15','240','44'); Query OK, 10 rows affected (0.028 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> select * from reutilizado; +--------+------------+------------------+-------------+ | codigo | fecha | nuevonumeromolde | numeromolde | +--------+------------+------------------+-------------+ | 001 | 2009-04-16 | 6167 | 335 | | 002 | 2005-08-29 | 1235 | 35 | | 003 | 2017-09-26 | 1253 | 41 | | 004 | 2018-07-19 | 6105 | 5161 | | 005 | 2017-09-04 | 60 | 52 | | 006 | 2018-09-25 | 1382 | 520 | | 007 | 2020-11-23 | 5854 | 526 | | 008 | 2020-08-20 | 14 | 5389 | | 009 | 2020-10-05 | 130 | 75 | | 010 | 2019-08-15 | 240 | 44 | +--------+------------+------------------+-------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> insert into cliente(codcliente,nombrecliente,ubicacion,nit) values('50077','cocacola medellin','Dg. 64e #180 Medelln-Antioquia','9005607272'),('90992','cnch','Cra 52 #124 Medelln-Antioquia','8110360309'),('50156','incametal','Cra. 45 #32d-135 Bello-Antioquia','8909001049'),('74419','mebum','050034 Medelln-Antioquia','8001313507'),('80012','epm','Carrera 58 # 42 - 125 Medelln-Antioquia','8909049961'),('13847','hernando orozco','Cra. 1 ##40-05 Cali-Valle del Cauca','9000224120'),('54500','proleche','Cl. 72 ##64-105 Medelln-Antioquia','9004015125'),('16804','manisol','CALLE 9 4 61 BARRIO BELLA VISTA-Manizales','8908013398'),('13020','golosinas trululu','VIA MAGDALENA KM 13 MANIZALES-CALDAS','9000797754'),('29975','exco','Calle 85 # 48-01 Central Mayorista de Antioquia','8600024453'); Query OK, 10 rows affected, 8 warnings (0.016 sec) Records: 10 Duplicates: 0 Warnings: 8 MariaDB [Bdmoldes]> select * from cliente; +------------+-------------------+--------------------------------+------------+ | codcliente | nombrecliente | ubicacion | nit | +------------+-------------------+--------------------------------+------------+ | 13020 | golosinas trululu | VIA MAGDALENA KM 13 MANIZALES- | 9000797754 | | 13847 | hernando orozco | Cra. 1 ##40-05 Cali-Valle del | 9000224120 | | 16804 | manisol | CALLE 9 4 61 BARRIO BELLA VIST | 8908013398 | | 29975 | exco | Calle 85 # 48-01 Central Mayor | 8600024453 | | 50077 | cocacola medellin | Dg. 64e #180 Medelln-Antioqui | 9005607272 | | 50156 | incametal | Cra. 45 #32d-135 Bello-Antioqu | 8909001049 | | 54500 | proleche | Cl. 72 ##64-105 Medelln-Antio | 9004015125 | | 74419 | mebum | 050034 Medelln-Antioquia | 8001313507 | | 80012 | epm | Carrera 58 # 42 - 125 Medelln | 8909049961 | | 90992 | cnch | Cra 52 #124 Medelln-Antioquia | 8110360309 | +------------+-------------------+--------------------------------+------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> insert into climolorden(numeroorden,codcliente,numeromolde) values('24709','13020','335'),('28319','13847','35'),('28859','16804','41'),('32495','29975','44'),('32957','50077','5161'),('33275','50156','52'),('38504','74419','520'),('41892','80012','5389'),('45845','90992','75'); Query OK, 9 rows affected (0.056 sec) Records: 9 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> select * from climolorden; +-------------+------------+-------------+ | numeroorden | codcliente | numeromolde | +-------------+------------+-------------+ | 24709 | 13020 | 335 | | 28319 | 13847 | 35 | | 28859 | 16804 | 41 | | 32495 | 29975 | 44 | | 32957 | 50077 | 5161 | | 33275 | 50156 | 52 | | 38504 | 74419 | 520 | | 41892 | 80012 | 5389 | | 45845 | 90992 | 75 | +-------------+------------+-------------+ 9 rows in set (0.000 sec) MariaDB [Bdmoldes]> describe zona; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | codigozona | varchar(4) | NO | PRI | NULL | | | descripcion | varchar(40) | NO | | NULL | | | jefeinmediato | varchar(40) | NO | | NULL | | | piso | varchar(20) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 4 rows in set (0.130 sec) MariaDB [Bdmoldes]> insert into zona(codigozona,descripcion,jefeinmediato,piso) values('001','2020-12-4','335'), -> ('0001','Prensado','Tereza Perez',Primer Piso'),('0003','Pulido','Mariana castaeda','Primer Piso'),('4125','Oficinas','Xiomara giraldo','Segundo Piso'),('0052','Fresadora','Hector salazar','Primer Piso'),('0351','Molino','Christian Rodriguez','Primer Piso'),('0048','Torno','kevin velz','Primer Piso'),('0008','Bodega','Elkin hoyos','Segundo Piso'),('0063','Recepcion','Stuart soteldo','Segundo Piso'); '> ' -> ; 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 'Piso'),('0003','Pulido','Mariana castaeda','Primer Piso'),('4125','Oficinas...' at line 2 MariaDB [Bdmoldes]> insert into zona(codigozona,descripcion,jefeinmediato,piso) values('0001','Prensado','Tereza Perez','Primer Piso'),('0003','Pulido','Mariana castaeda','Primer Piso'),('4125','Oficinas','Xiomara giraldo','Segundo Piso'),('0052','Fresadora','Hector salazar','Primer Piso'),('0351','Molino','Christian Rodriguez','Primer Piso'),('0048','Torno','kevin velez','Primer Piso'),('0008','Bodega','Elkin hoyos','Segundo Piso'),('0063','Recepcion','Stuart soteldo','Segundo Piso'); Query OK, 8 rows affected (0.005 sec) Records: 8 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> select * from zona; +------------+-------------+---------------------+--------------+ | codigozona | descripcion | jefeinmediato | piso | +------------+-------------+---------------------+--------------+ | 0001 | Prensado | Tereza Perez | Primer Piso | | 0003 | Pulido | Mariana castaeda | Primer Piso | | 0008 | Bodega | Elkin hoyos | Segundo Piso | | 0048 | Torno | kevin velez | Primer Piso | | 0052 | Fresadora | Hector salazar | Primer Piso | | 0063 | Recepcion | Stuart soteldo | Segundo Piso | | 0351 | Molino | Christian Rodriguez | Primer Piso | | 4125 | Oficinas | Xiomara giraldo | Segundo Piso | +------------+-------------+---------------------+--------------+ 8 rows in set (0.000 sec) MariaDB [Bdmoldes]>MariaDB [Bdmoldes]> create table maquina -> (numero varchar(10) not null primary key, -> nombre varchar(40) not null, -> descripcion varchar(100), -> codigozona varchar(4) not null, -> foreign key(codigozona) references zona(codigozona) on delete cascade on update cascade); Query OK, 0 rows affected (0.022 sec) MariaDB [Bdmoldes]> describe maquina; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | numero | varchar(10) | NO | PRI | NULL | | | nombre | varchar(40) | NO | | NULL | | | descripcion | varchar(100) | YES | | NULL | | | codigozona | varchar(4) | NO | MUL | NULL | | +-------------+--------------+------+-----+---------+-------+ 4 rows in set (0.013 sec) MariaDB [Bdmoldes]> insert into maquina(numero,nombre,descripcion,codigozona) values('01','Prensa','Uso de elementos de proteccin personal EPP,guantes de cuero,protector auditivo','0001'),('02','Torno','Uso de elementos de proteccin personal EPP,protector auditivo','0048'),('03','Esmeril','Uso de elementos de proteccin personal EPP,protector facial,protector auditivo','0003'),('04','Fresadora','Uso de elementos de proteccin personal EPP,protector facial','0052'),('05','Molino','Uso de elementos de proteccin personal EPP,protector auditivo','0351'),('06','CNC','Uso de elementos de proteccin personal EPP,protector facial','0052'),('07','Horno','Uso de elementos de proteccin personal EPP,guantes de cuero','0001'),('08','Soldador','Uso de elementos de proteccin personal EPP,guantes de cuero,protector auditivo','0048'),('09','Inyector','Uso de elementos de proteccin personal EPP,protector facial,guantes de cuero,protector auditivo','0008'),('10','Sellador','Uso de elementos de proteccin personal EPP,guantes de cuero','0063'); Query OK, 10 rows affected (0.007 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> select * from maquina; +--------+-----------+--------------------------------------------------------------------------------------------------+------------+ | numero | nombre | descripcion | codigozona | +--------+-----------+--------------------------------------------------------------------------------------------------+------------+ | 01 | Prensa | Uso de elementos de proteccin personal EPP,guantes de cuero,protector auditivo | 0001 | | 02 | Torno | Uso de elementos de proteccin personal EPP,protector auditivo | 0048 | | 03 | Esmeril | Uso de elementos de proteccin personal EPP,protector facial,protector auditivo | 0003 | | 04 | Fresadora | Uso de elementos de proteccin personal EPP,protector facial | 0052 | | 05 | Molino | Uso de elementos de proteccin personal EPP,protector auditivo | 0351 | | 06 | CNC | Uso de elementos de proteccin personal EPP,protector facial | 0052 | | 07 | Horno | Uso de elementos de proteccin personal EPP,guantes de cuero | 0001 | | 08 | Soldador | Uso de elementos de proteccin personal EPP,guantes de cuero,protector auditivo | 0048 | | 09 | Inyector | Uso de elementos de proteccin personal EPP,protector facial,guantes de cuero,protector auditivo | 0008 | | 10 | Sellador | Uso de elementos de proteccin personal EPP,guantes de cuero | 0063 | +--------+-----------+--------------------------------------------------------------------------------------------------+------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> delete from maquina; Query OK, 10 rows affected (0.032 sec) MariaDB [Bdmoldes]> select * from zona; +------------+-------------+---------------------+--------------+ | codigozona | descripcion | jefeinmediato | piso | +------------+-------------+---------------------+--------------+ | 0001 | Prensado | Tereza Perez | Primer Piso | | 0003 | Pulido | Mariana castaeda | Primer Piso | | 0008 | Bodega | Elkin hoyos | Segundo Piso | | 0048 | Torno | kevin velez | Primer Piso | | 0052 | Fresadora | Hector salazar | Primer Piso | | 0063 | Recepcion | Stuart soteldo | Segundo Piso | | 0351 | Molino | Christian Rodriguez | Primer Piso | | 4125 | Oficinas | Xiomara giraldo | Segundo Piso | +------------+-------------+---------------------+--------------+ 8 rows in set (0.000 sec) MariaDB [Bdmoldes]> insert into maquina(numero,nombre,descripcion,codigozona) values('01','Prensa','Uso de elementos de proteccin personal EPP,guantes de cuero,protector auditivo','0001'),('02','Torno','Uso de elementos de proteccin personal EPP,protector auditivo','0048'),('03','Esmeril','Uso de elementos de proteccin personal EPP,protector facial,protector auditivo','0003'),('04','Fresadora','Uso de elementos de proteccin personal EPP,protector facial','0052'),('05','Molino','Uso de elementos de proteccin personal EPP,protector auditivo','0351'),('06','CNC','Uso de elementos de proteccin personal EPP,protector facial','0052'),('07','Horno','Uso de elementos de proteccin personal EPP,guantes de cuero','0001'),('08','Soldador','Uso de elementos de proteccin personal EPP,guantes de cuero,protector auditivo','0048'),('09','Inyector','Uso de elementos de proteccin personal EPP,protector facial,guantes de cuero,protector auditivo','0008'),('10','Sellador','Uso de elementos de proteccin personal EPP,guantes de cuero','0063'); Query OK, 10 rows affected (0.006 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> delete from maquina; Query OK, 10 rows affected (0.002 sec) MariaDB [Bdmoldes]> insert into maquina(numero,nombre,descripcion,codigozona) values('01','Prensa','Uso de elementos de proteccin personal EPP,guantes de cuero,protector auditivo','0001'),('02','Torno','Uso de elementos de proteccin personal EPP,protector auditivo','0048'),('03','Esmeril','Uso de elementos de proteccin personal EPP,protector facial,protector auditivo','0003'),('04','Fresadora','Uso de elementos de proteccin personal EPP,protector facial','0052'),('05','Molino','Uso de elementos de proteccin personal EPP,protector auditivo','0351'),('06','CNC','Uso de elementos de proteccin personal EPP,protector facial','0052'),('07','Horno','Uso de elementos de proteccin personal EPP,guantes de cuero','0001'),('08','Soldador','Uso de elementos de proteccin personal EPP,guantes de cuero,protector auditivo','0048'),('09','Inyector','Uso de elementos de proteccin personal EPP,protector facial,guantes de cuero,protector auditivo','0008'),('10','Sellador','Uso de elementos de proteccin personal EPP,guantes de cuero','0063'); Query OK, 10 rows affected (0.003 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> select * from maquina; +--------+-----------+--------------------------------------------------------------------------------------------------+------------+ | numero | nombre | descripcion | codigozona | +--------+-----------+--------------------------------------------------------------------------------------------------+------------+ | 01 | Prensa | Uso de elementos de proteccin personal EPP,guantes de cuero,protector auditivo | 0001 | | 02 | Torno | Uso de elementos de proteccin personal EPP,protector auditivo | 0048 | | 03 | Esmeril | Uso de elementos de proteccin personal EPP,protector facial,protector auditivo | 0003 | | 04 | Fresadora | Uso de elementos de proteccin personal EPP,protector facial | 0052 | | 05 | Molino | Uso de elementos de proteccin personal EPP,protector auditivo | 0351 | | 06 | CNC | Uso de elementos de proteccin personal EPP,protector facial | 0052 | | 07 | Horno | Uso de elementos de proteccin personal EPP,guantes de cuero | 0001 | | 08 | Soldador | Uso de elementos de proteccin personal EPP,guantes de cuero,protector auditivo | 0048 | | 09 | Inyector | Uso de elementos de proteccin personal EPP,protector facial,guantes de cuero,protector auditivo | 0008 | | 10 | Sellador | Uso de elementos de proteccin personal EPP,guantes de cuero | 0063 | +--------+-----------+--------------------------------------------------------------------------------------------------+------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from cargo; Empty set (0.010 sec) MariaDB [Bdmoldes]> select * from zona; +------------+-------------+---------------------+--------------+ | codigozona | descripcion | jefeinmediato | piso | +------------+-------------+---------------------+--------------+ | 0001 | Prensado | Tereza Perez | Primer Piso | | 0003 | Pulido | Mariana castaeda | Primer Piso | | 0008 | Bodega | Elkin hoyos | Segundo Piso | | 0048 | Torno | kevin velez | Primer Piso | | 0052 | Fresadora | Hector salazar | Primer Piso | | 0063 | Recepcion | Stuart soteldo | Segundo Piso | | 0351 | Molino | Christian Rodriguez | Primer Piso | | 4125 | Oficinas | Xiomara giraldo | Segundo Piso | +------------+-------------+---------------------+--------------+ 8 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from reparacion; Empty set (0.034 sec) MariaDB [Bdmoldes]> select * from molde; +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | numeromolde | descripcion | medidas | tipo | fechaelaboracion | material | valor | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ 10 rows in set (0.033 sec) MariaDB [Bdmoldes]> describe cargo; +-------------+---------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------------------------------+------+-----+---------+-------+ | codigocargo | varchar(4) | NO | PRI | NULL | | | nombre | varchar(30) | NO | | NULL | | | descripcion | varchar(40) | NO | | NULL | | | horario | enum('Maana','Tarde','Dia Completo') | NO | | NULL | | | codigozona | varchar(4) | NO | MUL | NULL | | +-------------+---------------------------------------+------+-----+---------+-------+ 5 rows in set (0.015 sec) MariaDB [Bdmoldes]> insert into cargo(codigocargo,nombre,descripcion,horario,codigozona) values('001','Prensista','Fabricacin de repuestos de caucho','Maana','0001'),('002','Pulidor','Terminacin y empaque de productos','Tarde','0003'),('003','Tornero','Fabricacin de moldes','Dia completo','0048'),('004','Fresador','Acabado de laminas en metal','Dia completo','0052'),('005','Soldador','Realizar soldadura con proceso GTAW','Tarde','0048'),('006','Auxiliar de bodega','empaque y embalaje de mercancia','Tarde','0008'),('007','Recepcionista','ingreso y salida de los documentos','Maana','0063'),('008','Secretaria','Organizar, controlar y efectuar el seguimiento de la agenda','Dia completo','4125'),('009','Mensajero','Se encarga de entregar documentos, encargos o paquetes','Maana','0063'),('010','Vaciador','Fabricacin de repuestos en poliuretano','Maana','0001'), -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 MariaDB [Bdmoldes]> insert into cargo(codigocargo,nombre,descripcion,horario,codigozona) values('001','Prensista','Fabricacin de repuestos de caucho','Maana','0001'),('002','Pulidor','Terminacin y empaque de productos','Tarde','0003'),('003','Tornero','Fabricacin de moldes','Dia completo','0048'),('004','Fresador','Acabado de laminas en metal','Dia completo','0052'),('005','Soldador','Realizar soldadura con proceso GTAW','Tarde','0048'),('006','Auxiliar de bodega','empaque y embalaje de mercancia','Tarde','0008'),('007','Recepcionista','ingreso y salida de los documentos','Maana','0063'),('008','Secretaria','Organizar, controlar y efectuar el seguimiento de la agenda','Dia completo','4125'),('009','Mensajero','Se encarga de entregar documentos, encargos o paquetes','Maana','0063'),('010','Vaciador','Fabricacin de repuestos en poliuretano','Maana','0001'); Query OK, 10 rows affected, 2 warnings (0.007 sec) Records: 10 Duplicates: 0 Warnings: 2 MariaDB [Bdmoldes]> select * from cargo; +-------------+--------------------+------------------------------------------+--------------+------------+ | codigocargo | nombre | descripcion | horario | codigozona | +-------------+--------------------+------------------------------------------+--------------+------------+ | 001 | Prensista | Fabricacin de repuestos de caucho | Maana | 0001 | | 002 | Pulidor | Terminacin y empaque de productos | Tarde | 0003 | | 003 | Tornero | Fabricacin de moldes | Dia Completo | 0048 | | 004 | Fresador | Acabado de laminas en metal | Dia Completo | 0052 | | 005 | Soldador | Realizar soldadura con proceso GTAW | Tarde | 0048 | | 006 | Auxiliar de bodega | empaque y embalaje de mercancia | Tarde | 0008 | | 007 | Recepcionista | ingreso y salida de los documentos | Maana | 0063 | | 008 | Secretaria | Organizar, controlar y efectuar el segui | Dia Completo | 4125 | | 009 | Mensajero | Se encarga de entregar documentos, encar | Maana | 0063 | | 010 | Vaciador | Fabricacin de repuestos en poliuretano | Maana | 0001 | +-------------+--------------------+------------------------------------------+--------------+------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> describe operario; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | codoperario | varchar(5) | NO | PRI | NULL | | | nombre | varchar(40) | NO | | NULL | | | edad | int(3) | NO | | NULL | | | celular | varchar(20) | YES | | NULL | | | codigocargo | varchar(4) | NO | MUL | NULL | | +-------------+-------------+------+-----+---------+-------+ 5 rows in set (0.039 sec) MariaDB [Bdmoldes]> insert into operario(codoperario,nombre,edad,celular,codigocargo) values('001','juan david','45','311347907','010'),('002','alex restrepo','40','316227944','004'), -> ('003','edward orrego','28','321491518','001'),('004','edwin bedoya','25','322065856','003'),('005','elkin hoyos','56','311119904','006'),('006','wilmar campio','41','302100352','001'),('007','daniel hurtado','25','300731217','001'),('008','miguel angel guerra','21','314339229','005'),('009','stuart soteldo','33','312742887','002'),('010','pablo campio','20','322517748','001'); Query OK, 10 rows affected (0.032 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> insert into moldeoperario(numeromolde,codoperario,fechaultimavez) values('335','006','2019-11-20'),('35','001','2012-11-25'),('41','009','2016-01-15'),('5161','010','2018-05.12'),('52','002','2016-11-16'),('520','007','2008-07-10'),('526','003','2020-07-01'),('5389','004','2020-05-25'),('75','005','2017-01-03'),('44','008','2020-05-04'); Query OK, 10 rows affected (0.045 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> select * from moldeoperario; +-------------+-------------+----------------+ | numeromolde | codoperario | fechaultimavez | +-------------+-------------+----------------+ | 335 | 006 | 2019-11-20 | | 35 | 001 | 2012-11-25 | | 41 | 009 | 2016-01-15 | | 5161 | 010 | 2018-05-12 | | 52 | 002 | 2016-11-16 | | 520 | 007 | 2008-07-10 | | 526 | 003 | 2020-07-01 | | 5389 | 004 | 2020-05-25 | | 75 | 005 | 2017-01-03 | | 44 | 008 | 2020-05-04 | +-------------+-------------+----------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from reparacion; Empty set (0.000 sec) MariaDB [Bdmoldes]> describe reparacion; +-----------------+--------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------------------------------------------------+------+-----+---------+-------+ | codigo | varchar(6) | NO | PRI | NULL | | | descripcion | set('Chocado','Rayado','Faltan piezas','Modificacion') | YES | | NULL | | | fechareparacion | date | YES | | NULL | | | numeromolde | varchar(5) | NO | MUL | NULL | | +-----------------+--------------------------------------------------------+------+-----+---------+-------+ 4 rows in set (0.011 sec) MariaDB [Bdmoldes]> select * from molde; +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | numeromolde | descripcion | medidas | tipo | fechaelaboracion | material | valor | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> insert into reparacion(codigo,descripcion,fechareparacion,numeromolde) values('12402','Chocado','2020-2-12','335'),('51251','Faltan piezas','2021-9-12','75'),('12312','Modificacion','2021-2-12','52'),('41241','Chocado','2020-3-12','520'),('23312','Chocado','2020-4-12','44'),('12351','Modificacion','2021-1-12','35'),('12412','Chocado','2021-10-12','41'),('42342','Modificacion','2021-2-12','5161'),('15162','Chocado','2021-6-12','526'),('23423','Chocado','2020-4-12','5389'); Query OK, 10 rows affected (0.024 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> select * from reparacion; +--------+---------------+-----------------+-------------+ | codigo | descripcion | fechareparacion | numeromolde | +--------+---------------+-----------------+-------------+ | 12312 | Modificacion | 2021-02-12 | 52 | | 12351 | Modificacion | 2021-01-12 | 35 | | 12402 | Chocado | 2020-02-12 | 335 | | 12412 | Chocado | 2021-10-12 | 41 | | 15162 | Chocado | 2021-06-12 | 526 | | 23312 | Chocado | 2020-04-12 | 44 | | 23423 | Chocado | 2020-04-12 | 5389 | | 41241 | Chocado | 2020-03-12 | 520 | | 42342 | Modificacion | 2021-02-12 | 5161 | | 51251 | Faltan piezas | 2021-09-12 | 75 | +--------+---------------+-----------------+-------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> delete from reparacion; Query OK, 10 rows affected (0.035 sec) MariaDB [Bdmoldes]> insert into reparacion(codigo,descripcion,fechareparacion,numeromolde) values('12402','Chocado','2020-2-16','335'),('51251','Faltan piezas','2021-9-12','75'),('12312','Modificacion','2021-2-1','52'),('41241','Chocado','2020-3-12','520'),('23312','Chocado','2020-4-15','44'),('12351','Modificacion','2021-4-18','35'),('12412','Chocado','2021-10-18','41'),('42342','Modificacion','2021-2-3','5161'),('15162','Chocado','2021-6-8','526'),('23423','Chocado','2020-4-2','5389'); Query OK, 10 rows affected (0.035 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> select * from reparacion; +--------+---------------+-----------------+-------------+ | codigo | descripcion | fechareparacion | numeromolde | +--------+---------------+-----------------+-------------+ | 12312 | Modificacion | 2021-02-01 | 52 | | 12351 | Modificacion | 2021-04-18 | 35 | | 12402 | Chocado | 2020-02-16 | 335 | | 12412 | Chocado | 2021-10-18 | 41 | | 15162 | Chocado | 2021-06-08 | 526 | | 23312 | Chocado | 2020-04-15 | 44 | | 23423 | Chocado | 2020-04-02 | 5389 | | 41241 | Chocado | 2020-03-12 | 520 | | 42342 | Modificacion | 2021-02-03 | 5161 | | 51251 | Faltan piezas | 2021-09-12 | 75 | +--------+---------------+-----------------+-------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> show tables; +--------------------+ | Tables_in_bdmoldes | +--------------------+ | cargo | | cliente | | climolorden | | desechado | | maquina | | molde | | moldeoperario | | operario | | orden | | reparacion | | reutilizado | | zona | +--------------------+ 12 rows in set (0.001 sec) MariaDB [Bdmoldes]> select * from cargo; +-------------+--------------------+------------------------------------------+--------------+------------+ | codigocargo | nombre | descripcion | horario | codigozona | +-------------+--------------------+------------------------------------------+--------------+------------+ | 001 | Prensista | Fabricacin de repuestos de caucho | Maana | 0001 | | 002 | Pulidor | Terminacin y empaque de productos | Tarde | 0003 | | 003 | Tornero | Fabricacin de moldes | Dia Completo | 0048 | | 004 | Fresador | Acabado de laminas en metal | Dia Completo | 0052 | | 005 | Soldador | Realizar soldadura con proceso GTAW | Tarde | 0048 | | 006 | Auxiliar de bodega | empaque y embalaje de mercancia | Tarde | 0008 | | 007 | Recepcionista | ingreso y salida de los documentos | Maana | 0063 | | 008 | Secretaria | Organizar, controlar y efectuar el segui | Dia Completo | 4125 | | 009 | Mensajero | Se encarga de entregar documentos, encar | Maana | 0063 | | 010 | Vaciador | Fabricacin de repuestos en poliuretano | Maana | 0001 | +-------------+--------------------+------------------------------------------+--------------+------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from cliente; +------------+-------------------+--------------------------------+------------+ | codcliente | nombrecliente | ubicacion | nit | +------------+-------------------+--------------------------------+------------+ | 13020 | golosinas trululu | VIA MAGDALENA KM 13 MANIZALES- | 9000797754 | | 13847 | hernando orozco | Cra. 1 ##40-05 Cali-Valle del | 9000224120 | | 16804 | manisol | CALLE 9 4 61 BARRIO BELLA VIST | 8908013398 | | 29975 | exco | Calle 85 # 48-01 Central Mayor | 8600024453 | | 50077 | cocacola medellin | Dg. 64e #180 Medelln-Antioqui | 9005607272 | | 50156 | incametal | Cra. 45 #32d-135 Bello-Antioqu | 8909001049 | | 54500 | proleche | Cl. 72 ##64-105 Medelln-Antio | 9004015125 | | 74419 | mebum | 050034 Medelln-Antioquia | 8001313507 | | 80012 | epm | Carrera 58 # 42 - 125 Medelln | 8909049961 | | 90992 | cnch | Cra 52 #124 Medelln-Antioquia | 8110360309 | +------------+-------------------+--------------------------------+------------+ 10 rows in set (0.042 sec) MariaDB [Bdmoldes]> select * from climolorden; +-------------+------------+-------------+ | numeroorden | codcliente | numeromolde | +-------------+------------+-------------+ | 24709 | 13020 | 335 | | 28319 | 13847 | 35 | | 28859 | 16804 | 41 | | 32495 | 29975 | 44 | | 32957 | 50077 | 5161 | | 33275 | 50156 | 52 | | 38504 | 74419 | 520 | | 41892 | 80012 | 5389 | | 45845 | 90992 | 75 | +-------------+------------+-------------+ 9 rows in set (0.041 sec) MariaDB [Bdmoldes]> select * from desechado; +--------+------------+-------------+ | codigo | fecha | numeromolde | +--------+------------+-------------+ | 001 | 2020-12-04 | 335 | | 002 | 2020-12-20 | 526 | | 003 | 2020-10-15 | 520 | | 004 | 2021-01-22 | 5161 | | 005 | 2021-01-01 | 5389 | | 006 | 2021-02-12 | 41 | | 007 | 2020-12-25 | 44 | | 008 | 2020-12-25 | 44 | | 009 | 2020-10-17 | 52 | | 010 | 2020-09-12 | 35 | +--------+------------+-------------+ 10 rows in set (0.002 sec) MariaDB [Bdmoldes]> select * from maquina; +--------+-----------+--------------------------------------------------------------------------------------------------+------------+ | numero | nombre | descripcion | codigozona | +--------+-----------+--------------------------------------------------------------------------------------------------+------------+ | 01 | Prensa | Uso de elementos de proteccin personal EPP,guantes de cuero,protector auditivo | 0001 | | 02 | Torno | Uso de elementos de proteccin personal EPP,protector auditivo | 0048 | | 03 | Esmeril | Uso de elementos de proteccin personal EPP,protector facial,protector auditivo | 0003 | | 04 | Fresadora | Uso de elementos de proteccin personal EPP,protector facial | 0052 | | 05 | Molino | Uso de elementos de proteccin personal EPP,protector auditivo | 0351 | | 06 | CNC | Uso de elementos de proteccin personal EPP,protector facial | 0052 | | 07 | Horno | Uso de elementos de proteccin personal EPP,guantes de cuero | 0001 | | 08 | Soldador | Uso de elementos de proteccin personal EPP,guantes de cuero,protector auditivo | 0048 | | 09 | Inyector | Uso de elementos de proteccin personal EPP,protector facial,guantes de cuero,protector auditivo | 0008 | | 10 | Sellador | Uso de elementos de proteccin personal EPP,guantes de cuero | 0063 | +--------+-----------+--------------------------------------------------------------------------------------------------+------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from molde; +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | numeromolde | descripcion | medidas | tipo | fechaelaboracion | material | valor | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from moldeoperario; +-------------+-------------+----------------+ | numeromolde | codoperario | fechaultimavez | +-------------+-------------+----------------+ | 335 | 006 | 2019-11-20 | | 35 | 001 | 2012-11-25 | | 41 | 009 | 2016-01-15 | | 5161 | 010 | 2018-05-12 | | 52 | 002 | 2016-11-16 | | 520 | 007 | 2008-07-10 | | 526 | 003 | 2020-07-01 | | 5389 | 004 | 2020-05-25 | | 75 | 005 | 2017-01-03 | | 44 | 008 | 2020-05-04 | +-------------+-------------+----------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from operario; +-------------+---------------------+------+-----------+-------------+ | codoperario | nombre | edad | celular | codigocargo | +-------------+---------------------+------+-----------+-------------+ | 001 | juan david | 45 | 311347907 | 010 | | 002 | alex restrepo | 40 | 316227944 | 004 | | 003 | edward orrego | 28 | 321491518 | 001 | | 004 | edwin bedoya | 25 | 322065856 | 003 | | 005 | elkin hoyos | 56 | 311119904 | 006 | | 006 | wilmar campio | 41 | 302100352 | 001 | | 007 | daniel hurtado | 25 | 300731217 | 001 | | 008 | miguel angel guerra | 21 | 314339229 | 005 | | 009 | stuart soteldo | 33 | 312742887 | 002 | | 010 | pablo campio | 20 | 322517748 | 001 | +-------------+---------------------+------+-----------+-------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from orden; +-------------+-------------+--------+ | numeroorden | temperatura | tiempo | +-------------+-------------+--------+ | 24709 | 170 | 20 | | 28319 | 145 | 7 | | 28859 | 160 | 6 | | 32495 | 150 | 15 | | 32957 | 170 | 10 | | 33275 | 150 | 50 | | 37663 | 150 | 8 | | 38504 | 150 | 10 | | 41892 | 170 | 20 | | 45845 | 165 | 5 | +-------------+-------------+--------+ 10 rows in set (0.042 sec) MariaDB [Bdmoldes]> select * from reparacion; +--------+---------------+-----------------+-------------+ | codigo | descripcion | fechareparacion | numeromolde | +--------+---------------+-----------------+-------------+ | 12312 | Modificacion | 2021-02-01 | 52 | | 12351 | Modificacion | 2021-04-18 | 35 | | 12402 | Chocado | 2020-02-16 | 335 | | 12412 | Chocado | 2021-10-18 | 41 | | 15162 | Chocado | 2021-06-08 | 526 | | 23312 | Chocado | 2020-04-15 | 44 | | 23423 | Chocado | 2020-04-02 | 5389 | | 41241 | Chocado | 2020-03-12 | 520 | | 42342 | Modificacion | 2021-02-03 | 5161 | | 51251 | Faltan piezas | 2021-09-12 | 75 | +--------+---------------+-----------------+-------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from reutilizado; +--------+------------+------------------+-------------+ | codigo | fecha | nuevonumeromolde | numeromolde | +--------+------------+------------------+-------------+ | 001 | 2009-04-16 | 6167 | 335 | | 002 | 2005-08-29 | 1235 | 35 | | 003 | 2017-09-26 | 1253 | 41 | | 004 | 2018-07-19 | 6105 | 5161 | | 005 | 2017-09-04 | 60 | 52 | | 006 | 2018-09-25 | 1382 | 520 | | 007 | 2020-11-23 | 5854 | 526 | | 008 | 2020-08-20 | 14 | 5389 | | 009 | 2020-10-05 | 130 | 75 | | 010 | 2019-08-15 | 240 | 44 | +--------+------------+------------------+-------------+ 10 rows in set (0.010 sec) MariaDB [Bdmoldes]> select * from zona; +------------+-------------+---------------------+--------------+ | codigozona | descripcion | jefeinmediato | piso | +------------+-------------+---------------------+--------------+ | 0001 | Prensado | Tereza Perez | Primer Piso | | 0003 | Pulido | Mariana castaeda | Primer Piso | | 0008 | Bodega | Elkin hoyos | Segundo Piso | | 0048 | Torno | kevin velez | Primer Piso | | 0052 | Fresadora | Hector salazar | Primer Piso | | 0063 | Recepcion | Stuart soteldo | Segundo Piso | | 0351 | Molino | Christian Rodriguez | Primer Piso | | 4125 | Oficinas | Xiomara giraldo | Segundo Piso | +------------+-------------+---------------------+--------------+ 8 rows in set (0.000 sec) MariaDB [Bdmoldes]> exitMariaDB [Bdmoldes]> select * from operario; +-------------+---------------------+------+-----------+-------------+ | codoperario | nombre | edad | celular | codigocargo | +-------------+---------------------+------+-----------+-------------+ | 001 | juan david | 45 | 311347907 | 010 | | 002 | alex restrepo | 40 | 316227944 | 004 | | 003 | edward orrego | 28 | 321491518 | 001 | | 004 | edwin bedoya | 25 | 322065856 | 003 | | 005 | elkin hoyos | 56 | 311119904 | 006 | | 006 | wilmar campio | 41 | 302100352 | 001 | | 007 | daniel hurtado | 25 | 300731217 | 001 | | 008 | miguel angel guerra | 21 | 314339229 | 005 | | 009 | stuart soteldo | 33 | 312742887 | 002 | | 010 | pablo campio | 20 | 322517748 | 001 | +-------------+---------------------+------+-----------+-------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select nombre, descripcion, month(fechaultimavez) 'Mes' from operario,molde,moldeoperario where operario.codoperario = moldeoperario.codoperario and moldeoperario.numeromolde=molde.numeromolde; +---------------------+-------------------------------+------+ | nombre | descripcion | Mes | +---------------------+-------------------------------+------+ | wilmar campio | anillo guia raspador | 11 | | juan david | oring | 11 | | stuart soteldo | empaque autoclave | 1 | | pablo campio | banda en perfil | 5 | | alex restrepo | amortiguador | 11 | | daniel hurtado | empaque autoclave | 7 | | edward orrego | empaque manga lecho empalmado | 7 | | edwin bedoya | banda en perfil | 5 | | elkin hoyos | realce sencillo rdo | 1 | | miguel angel guerra | oring | 5 | +---------------------+-------------------------------+------+ 10 rows in set (0.002 sec) MariaDB [Bdmoldes]> select * from moldeoperario; +-------------+-------------+----------------+ | numeromolde | codoperario | fechaultimavez | +-------------+-------------+----------------+ | 335 | 006 | 2019-11-20 | | 35 | 001 | 2012-11-25 | | 41 | 009 | 2016-01-15 | | 5161 | 010 | 2018-05-12 | | 52 | 002 | 2016-11-16 | | 520 | 007 | 2008-07-10 | | 526 | 003 | 2020-07-01 | | 5389 | 004 | 2020-05-25 | | 75 | 005 | 2017-01-03 | | 44 | 008 | 2020-05-04 | +-------------+-------------+----------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from molde; +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | numeromolde | descripcion | medidas | tipo | fechaelaboracion | material | valor | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select year(fechaelaboracion) from molde; +------------------------+ | year(fechaelaboracion) | +------------------------+ | 2017 | | 2011 | | 2012 | | 2012 | | 2015 | | 2005 | | 2017 | | 2017 | | 2015 | | 2019 | +------------------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select descripcion, year(current_date()) - year(fechaelaboracion) from molde; +-------------------------------+-----------------------------------------------+ | descripcion | year(current_date()) - year(fechaelaboracion) | +-------------------------------+-----------------------------------------------+ | anillo guia raspador | 4 | | oring | 10 | | empaque autoclave | 9 | | oring | 9 | | banda en perfil | 6 | | amortiguador | 16 | | empaque autoclave | 4 | | empaque manga lecho empalmado | 4 | | banda en perfil | 6 | | realce sencillo rdo | 2 | +-------------------------------+-----------------------------------------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select descripcion, year(current_date()) - year(fechaelaboracion) 'Antiguedad en aos' from molde; +-------------------------------+--------------------+ | descripcion | Antiguedad en aos | +-------------------------------+--------------------+ | anillo guia raspador | 4 | | oring | 10 | | empaque autoclave | 9 | | oring | 9 | | banda en perfil | 6 | | amortiguador | 16 | | empaque autoclave | 4 | | empaque manga lecho empalmado | 4 | | banda en perfil | 6 | | realce sencillo rdo | 2 | +-------------------------------+--------------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from molde where year(current_date()) - year(fechaelaboracion) <=5; +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | numeromolde | descripcion | medidas | tipo | fechaelaboracion | material | valor | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ 4 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from molde; +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | numeromolde | descripcion | medidas | tipo | fechaelaboracion | material | valor | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select @var:=max(year(current_date()) - year(fechaelaboracion)) from molde; +----------------------------------------------------------+ | @var:=max(year(current_date()) - year(fechaelaboracion)) | +----------------------------------------------------------+ | 16 | +----------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [Bdmoldes]> select max(year(current_date()) - year(fechaelaboracion)) 'Antiguedad en aos' from molde; +--------------------+ | Antiguedad en aos | +--------------------+ | 16 | +--------------------+ 1 row in set (0.000 sec) MariaDB [Bdmoldes]> MariaDB [Bdmoldes]> MariaDB [Bdmoldes]> select descripcion from molde, moldeoperario where molde.numeromolde = moldeoperario.numeromolde and year(fechaultimavez) = '2020'; +-------------------------------+ | descripcion | +-------------------------------+ | empaque manga lecho empalmado | | banda en perfil | | oring | +-------------------------------+ 3 rows in set (0.000 sec) MariaDB [Bdmoldes]> MariaDB [Bdmoldes]> MariaDB [Bdmoldes]> MariaDB [Bdmoldes]> sele -> ; 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 'sele' at line 1 MariaDB [Bdmoldes]> select * from moldeoperario; +-------------+-------------+----------------+ | numeromolde | codoperario | fechaultimavez | +-------------+-------------+----------------+ | 335 | 006 | 2019-11-20 | | 35 | 001 | 2012-11-25 | | 41 | 009 | 2016-01-15 | | 5161 | 010 | 2018-05-12 | | 52 | 002 | 2016-11-16 | | 520 | 007 | 2008-07-10 | | 526 | 003 | 2020-07-01 | | 5389 | 004 | 2020-05-25 | | 75 | 005 | 2017-01-03 | | 44 | 008 | 2020-05-04 | +-------------+-------------+----------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from molde; +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | numeromolde | descripcion | medidas | tipo | fechaelaboracion | material | valor | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> MariaDB [Bdmoldes]> MariaDB [Bdmoldes]> MariaDB [Bdmoldes]> create view desechados as select descripcion,fechaelaboracion, year(fecha)' Ao desechado' from molde,desechado where molde.numeromolde = desechado.numeromolde; Query OK, 0 rows affected, 1 warning (0.005 sec) MariaDB [Bdmoldes]> select * from desechados; +-------------------------------+------------------+---------------+ | descripcion | fechaelaboracion | Ao desechado | +-------------------------------+------------------+---------------+ | anillo guia raspador | 2017-09-14 | 2020 | | empaque manga lecho empalmado | 2017-07-18 | 2020 | | empaque autoclave | 2017-07-04 | 2020 | | banda en perfil | 2015-09-18 | 2021 | | banda en perfil | 2015-02-19 | 2021 | | empaque autoclave | 2012-05-18 | 2021 | | oring | 2012-11-20 | 2020 | | oring | 2012-11-20 | 2020 | | amortiguador | 2005-04-04 | 2020 | | oring | 2011-09-20 | 2020 | +-------------------------------+------------------+---------------+ 10 rows in set (0.001 sec) MariaDB [Bdmoldes]> select nombrecliente, nit from cliente; +-------------------+------------+ | nombrecliente | nit | +-------------------+------------+ | golosinas trululu | 9000797754 | | hernando orozco | 9000224120 | | manisol | 8908013398 | | exco | 8600024453 | | cocacola medellin | 9005607272 | | incametal | 8909001049 | | proleche | 9004015125 | | mebum | 8001313507 | | epm | 8909049961 | | cnch | 8110360309 | +-------------------+------------+ 10 rows in set (0.002 sec) MariaDB [Bdmoldes]> select nombrecliente, nit from cliente where substr(nit,1,3) in ('900'); +-------------------+------------+ | nombrecliente | nit | +-------------------+------------+ | golosinas trululu | 9000797754 | | hernando orozco | 9000224120 | | cocacola medellin | 9005607272 | | proleche | 9004015125 | +-------------------+------------+ 4 rows in set (0.000 sec) MariaDB [Bdmoldes]> select nombrecliente, nit from cliente where substr(nit,1,3) in ('900') and substr(nit,10,1) in ('4','5'); +-------------------+------------+ | nombrecliente | nit | +-------------------+------------+ | golosinas trululu | 9000797754 | | proleche | 9004015125 | +-------------------+------------+ 2 rows in set (0.000 sec) MariaDB [Bdmoldes]> select nombre, descripcion from cargo where character_length(descripcion) <= 30; +----------+-----------------------------+ | nombre | descripcion | +----------+-----------------------------+ | Tornero | Fabricacin de moldes | | Fresador | Acabado de laminas en metal | +----------+-----------------------------+ 2 rows in set (0.000 sec) MariaDB [Bdmoldes]> select descripcion,if(valor>1000 and valor<=100000, 'Econmico','Costoso') Valoracion from molde; +-------------------------------+------------+ | descripcion | Valoracion | +-------------------------------+------------+ | anillo guia raspador | Costoso | | oring | Costoso | | empaque autoclave | Costoso | | oring | Econmico | | banda en perfil | Econmico | | amortiguador | Econmico | | empaque autoclave | Econmico | | empaque manga lecho empalmado | Costoso | | banda en perfil | Econmico | | realce sencillo rdo | Econmico | +-------------------------------+------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from molde; +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | numeromolde | descripcion | medidas | tipo | fechaelaboracion | material | valor | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select @fecha:=min(fechareparacion) from reparacion; +------------------------------+ | @fecha:=min(fechareparacion) | +------------------------------+ | 2020-02-16 | +------------------------------+ 1 row in set (0.002 sec) MariaDB [Bdmoldes]> select case(weekday(@fecha)) when 0 then 'lunes' when 1 then 'martes' when 2 then 'miercoles' when 3 then 'jueves' when 4 then 'viernes' when 5 then 'sabado' when 6 then 'domingo' end; +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | case(weekday(@fecha)) when 0 then 'lunes' when 1 then 'martes' when 2 then 'miercoles' when 3 then 'jueves' when 4 then 'viernes' when 5 then 'sabado' when 6 then 'domingo' end | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | domingo | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [Bdmoldes]> select @ubicacion:= ubicacion from cliente where nombrecliente ='Exco'; +--------------------------------+ | @ubicacion:= ubicacion | +--------------------------------+ | Calle 85 # 48-01 Central Mayor | +--------------------------------+ 1 row in set (0.000 sec) MariaDB [Bdmoldes]> MariaDB [Bdmoldes]> select encode('Ubicacion','dia'); +---------------------------+ | encode('Ubicacion','dia') | +---------------------------+ | Gw | +---------------------------+ 1 row in set (0.000 sec) MariaDB [Bdmoldes]> select encode(ubicacion,'123') 'Ubicacion' from cliente; +---------------------------------+ | Ubicacion | +---------------------------------+ | +B½h}T_RJŀ4+ouqqe5 W | | TEt>pDUjF.o8h}h | | H?9shRGCEqssc> | | їfЮ*'⛒%7.3wCAAQ | | цDZ6^fp]<(]<]/ | | 񫸜1YImK#ٯܷ | | TT{ _!kbhQ {ȟ | | їLB se1$͉) | +---------------------------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> create view encriptados as select encode(ubicacion,'123') 'Ubicacion' from cliente; Query OK, 0 rows affected (0.048 sec) MariaDB [Bdmoldes]> select * from encriptados; +---------------------------------+ | Ubicacion | +---------------------------------+ | +B½h}T_RJŀ4+ouqqe5 W | | TEt>pDUjF.o8h}h | | H?9shRGCEqssc> | | їfЮ*'⛒%7.3wCAAQ | | цDZ6^fp]<(]<]/ | | 񫸜1YImK#ٯܷ | | TT{ _!kbhQ {ȟ | | їLB se1$͉) | +---------------------------------+ 10 rows in set (0.001 sec) MariaDB [Bdmoldes]> select decode(ubicacion,1997) from encriptados; +---------------------------------+ | decode(ubicacion,1997) | +---------------------------------+ | 핓-=^;y"?#*) p | | DVdd%pQo!mU:P~LQ^j | | K,ҧN:lt'mK,>IDV | | M-yܡV퉧_}jP)z | | [WbӨc E(߾R _|u9ͼH | | D=w*+b U˰ri' | | T2^fUœ*L8y | | +\7b$51'y\IiB6> | | JNMWAN/գepX3 | | D';ku"ꮪ<ž4 | +---------------------------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select decode(ubicacion,123) from encriptados; +---------------------------------+ | decode(ubicacion,123) | +---------------------------------+ | VIA MAGDALENA KM 13 MANIZALES- | | Cra. 1 ##40-05 Cali-Valle del | | CALLE 9 4 61 BARRIO BELLA VIST | | Calle 85 # 48-01 Central Mayor | | Dg. 64e #180 Medellín-Antioqui | | Cra. 45 #32d-135 Bello-Antioqu | | Cl. 72 ##64-105 Medellín-Antio | | 050034 Medellín-Antioquia | | Carrera 58 # 42 - 125 Medellín | | Cra 52 #124 Medellín-Antioquia | +---------------------------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select position('o' in nombre)'Posicion' from cargo; +----------+ | Posicion | +----------+ | 0 | | 6 | | 2 | | 7 | | 2 | | 14 | | 8 | | 0 | | 9 | | 7 | +----------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from cargo; +-------------+--------------------+------------------------------------------+--------------+------------+ | codigocargo | nombre | descripcion | horario | codigozona | +-------------+--------------------+------------------------------------------+--------------+------------+ | 001 | Prensista | Fabricacin de repuestos de caucho | Maana | 0001 | | 002 | Pulidor | Terminacin y empaque de productos | Tarde | 0003 | | 003 | Tornero | Fabricacin de moldes | Dia Completo | 0048 | | 004 | Fresador | Acabado de laminas en metal | Dia Completo | 0052 | | 005 | Soldador | Realizar soldadura con proceso GTAW | Tarde | 0048 | | 006 | Auxiliar de bodega | empaque y embalaje de mercancia | Tarde | 0008 | | 007 | Recepcionista | ingreso y salida de los documentos | Maana | 0063 | | 008 | Secretaria | Organizar, controlar y efectuar el segui | Dia Completo | 4125 | | 009 | Mensajero | Se encarga de entregar documentos, encar | Maana | 0063 | | 010 | Vaciador | Fabricacin de repuestos en poliuretano | Maana | 0001 | +-------------+--------------------+------------------------------------------+--------------+------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from reparacion where descripcion=4; +--------+---------------+-----------------+-------------+ | codigo | descripcion | fechareparacion | numeromolde | +--------+---------------+-----------------+-------------+ | 51251 | Faltan piezas | 2021-09-12 | 75 | +--------+---------------+-----------------+-------------+ 1 row in set (0.000 sec) MariaDB [Bdmoldes]> select * from reparacion; +--------+---------------+-----------------+-------------+ | codigo | descripcion | fechareparacion | numeromolde | +--------+---------------+-----------------+-------------+ | 12312 | Modificacion | 2021-02-01 | 52 | | 12351 | Modificacion | 2021-04-18 | 35 | | 12402 | Chocado | 2020-02-16 | 335 | | 12412 | Chocado | 2021-10-18 | 41 | | 15162 | Chocado | 2021-06-08 | 526 | | 23312 | Chocado | 2020-04-15 | 44 | | 23423 | Chocado | 2020-04-02 | 5389 | | 41241 | Chocado | 2020-03-12 | 520 | | 42342 | Modificacion | 2021-02-03 | 5161 | | 51251 | Faltan piezas | 2021-09-12 | 75 | +--------+---------------+-----------------+-------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> describe reparacion; +-----------------+--------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------------------------------------------------+------+-----+---------+-------+ | codigo | varchar(6) | NO | PRI | NULL | | | descripcion | set('Chocado','Rayado','Faltan piezas','Modificacion') | YES | | NULL | | | fechareparacion | date | YES | | NULL | | | numeromolde | varchar(5) | NO | MUL | NULL | | +-----------------+--------------------------------------------------------+------+-----+---------+-------+ 4 rows in set (0.052 sec) MariaDB [Bdmoldes]> select * from reparacion where descripcion like'%Modificacion'%; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 MariaDB [Bdmoldes]> select * from reparacion where descripcion like'%Modificacion%'; +--------+--------------+-----------------+-------------+ | codigo | descripcion | fechareparacion | numeromolde | +--------+--------------+-----------------+-------------+ | 12312 | Modificacion | 2021-02-01 | 52 | | 12351 | Modificacion | 2021-04-18 | 35 | | 42342 | Modificacion | 2021-02-03 | 5161 | +--------+--------------+-----------------+-------------+ 3 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from molde where tipo=2; +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | numeromolde | descripcion | medidas | tipo | fechaelaboracion | material | valor | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ 5 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from molde; +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | numeromolde | descripcion | medidas | tipo | fechaelaboracion | material | valor | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from molde where tipo like'%Perfil%'; +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | numeromolde | descripcion | medidas | tipo | fechaelaboracion | material | valor | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+ 5 rows in set (0.000 sec) MariaDB [Bdmoldes]> select descripcion, tipo from molde where tipo like'%Perfil%'; +-------------------------------+--------+ | descripcion | tipo | +-------------------------------+--------+ | anillo guia raspador | Perfil | | banda en perfil | Perfil | | empaque autoclave | Perfil | | empaque manga lecho empalmado | Perfil | | banda en perfil | Perfil | +-------------------------------+--------+ 5 rows in set (0.000 sec) MariaDB [Bdmoldes]> select descripcion, tipo from molde where tipo =2; +-------------------------------+--------+ | descripcion | tipo | +-------------------------------+--------+ | anillo guia raspador | Perfil | | banda en perfil | Perfil | | empaque autoclave | Perfil | | empaque manga lecho empalmado | Perfil | | banda en perfil | Perfil | +-------------------------------+--------+ 5 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from cargo where horario like '%Dia completo%'; +-------------+------------+------------------------------------------+--------------+------------+ | codigocargo | nombre | descripcion | horario | codigozona | +-------------+------------+------------------------------------------+--------------+------------+ | 003 | Tornero | Fabricacin de moldes | Dia Completo | 0048 | | 004 | Fresador | Acabado de laminas en metal | Dia Completo | 0052 | | 008 | Secretaria | Organizar, controlar y efectuar el segui | Dia Completo | 4125 | +-------------+------------+------------------------------------------+--------------+------------+ 3 rows in set (0.000 sec) MariaDB [Bdmoldes]> select * from maquina where descripcion like '%protector facial%'; +--------+-----------+--------------------------------------------------------------------------------------------------+------------+ | numero | nombre | descripcion | codigozona | +--------+-----------+--------------------------------------------------------------------------------------------------+------------+ | 03 | Esmeril | Uso de elementos de proteccin personal EPP,protector facial,protector auditivo | 0003 | | 04 | Fresadora | Uso de elementos de proteccin personal EPP,protector facial | 0052 | | 06 | CNC | Uso de elementos de proteccin personal EPP,protector facial | 0052 | | 09 | Inyector | Uso de elementos de proteccin personal EPP,protector facial,guantes de cuero,protector auditivo | 0008 | +--------+-----------+--------------------------------------------------------------------------------------------------+------------+ 4 rows in set (0.000 sec) MariaDB [Bdmoldes]> describe maquina; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | numero | varchar(10) | NO | PRI | NULL | | | nombre | varchar(40) | NO | | NULL | | | descripcion | varchar(100) | YES | | NULL | | | codigozona | varchar(4) | NO | MUL | NULL | | +-------------+--------------+------+-----+---------+-------+ 4 rows in set (0.014 sec) MariaDB [Bdmoldes]> Create table cargos -> select distinct nombre as Cargo -> from cargo; Query OK, 10 rows affected (0.053 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> select * from cargos; +--------------------+ | Cargo | +--------------------+ | Prensista | | Pulidor | | Tornero | | Fresador | | Soldador | | Auxiliar de bodega | | Recepcionista | | Secretaria | | Mensajero | | Vaciador | +--------------------+ 10 rows in set (0.000 sec) MariaDB [Bdmoldes]> create table valortotal -> select tipo, sum(valor) 'Valor Total' from molde -> group by tipo; Query OK, 2 rows affected (0.041 sec) Records: 2 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> select * from valortotal; +--------+-------------+ | tipo | Valor Total | +--------+-------------+ | Molde | 696000 | | Perfil | 1065000 | +--------+-------------+ 2 rows in set (0.000 sec) MariaDB [Bdmoldes]> create table zona2 -> -> (jefeinmediato varchar(40), -> -> piso varchar(20)); Query OK, 0 rows affected (0.023 sec) MariaDB [Bdmoldes]> MariaDB [Bdmoldes]> insert into zona2 -> -> select z.jefeinmediato, z.piso -> -> from zona as z; Query OK, 8 rows affected (0.031 sec) Records: 8 Duplicates: 0 Warnings: 0 MariaDB [Bdmoldes]> select * from zona2; +---------------------+--------------+ | jefeinmediato | piso | +---------------------+--------------+ | Tereza Perez | Primer Piso | | Mariana castaeda | Primer Piso | | Elkin hoyos | Segundo Piso | | kevin velez | Primer Piso | | Hector salazar | Primer Piso | | Stuart soteldo | Segundo Piso | | Christian Rodriguez | Primer Piso | | Xiomara giraldo | Segundo Piso | +---------------------+--------------+ 8 rows in set (0.000 sec) MariaDB [Bdmoldes]> select m.*,c.* -> from molde as m -> cross join cliente as c; +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+------------+-------------------+--------------------------------+------------+ | numeromolde | descripcion | medidas | tipo | fechaelaboracion | material | valor | codcliente | nombrecliente | ubicacion | nit | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+------------+-------------------+--------------------------------+------------+ | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | 13020 | golosinas trululu | VIA MAGDALENA KM 13 MANIZALES- | 9000797754 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | 13020 | golosinas trululu | VIA MAGDALENA KM 13 MANIZALES- | 9000797754 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | 13020 | golosinas trululu | VIA MAGDALENA KM 13 MANIZALES- | 9000797754 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | 13020 | golosinas trululu | VIA MAGDALENA KM 13 MANIZALES- | 9000797754 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | 13020 | golosinas trululu | VIA MAGDALENA KM 13 MANIZALES- | 9000797754 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | 13020 | golosinas trululu | VIA MAGDALENA KM 13 MANIZALES- | 9000797754 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | 13020 | golosinas trululu | VIA MAGDALENA KM 13 MANIZALES- | 9000797754 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | 13020 | golosinas trululu | VIA MAGDALENA KM 13 MANIZALES- | 9000797754 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | 13020 | golosinas trululu | VIA MAGDALENA KM 13 MANIZALES- | 9000797754 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | 13020 | golosinas trululu | VIA MAGDALENA KM 13 MANIZALES- | 9000797754 | | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | 13847 | hernando orozco | Cra. 1 ##40-05 Cali-Valle del | 9000224120 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | 13847 | hernando orozco | Cra. 1 ##40-05 Cali-Valle del | 9000224120 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | 13847 | hernando orozco | Cra. 1 ##40-05 Cali-Valle del | 9000224120 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | 13847 | hernando orozco | Cra. 1 ##40-05 Cali-Valle del | 9000224120 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | 13847 | hernando orozco | Cra. 1 ##40-05 Cali-Valle del | 9000224120 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | 13847 | hernando orozco | Cra. 1 ##40-05 Cali-Valle del | 9000224120 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | 13847 | hernando orozco | Cra. 1 ##40-05 Cali-Valle del | 9000224120 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | 13847 | hernando orozco | Cra. 1 ##40-05 Cali-Valle del | 9000224120 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | 13847 | hernando orozco | Cra. 1 ##40-05 Cali-Valle del | 9000224120 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | 13847 | hernando orozco | Cra. 1 ##40-05 Cali-Valle del | 9000224120 | | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | 16804 | manisol | CALLE 9 4 61 BARRIO BELLA VIST | 8908013398 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | 16804 | manisol | CALLE 9 4 61 BARRIO BELLA VIST | 8908013398 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | 16804 | manisol | CALLE 9 4 61 BARRIO BELLA VIST | 8908013398 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | 16804 | manisol | CALLE 9 4 61 BARRIO BELLA VIST | 8908013398 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | 16804 | manisol | CALLE 9 4 61 BARRIO BELLA VIST | 8908013398 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | 16804 | manisol | CALLE 9 4 61 BARRIO BELLA VIST | 8908013398 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | 16804 | manisol | CALLE 9 4 61 BARRIO BELLA VIST | 8908013398 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | 16804 | manisol | CALLE 9 4 61 BARRIO BELLA VIST | 8908013398 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | 16804 | manisol | CALLE 9 4 61 BARRIO BELLA VIST | 8908013398 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | 16804 | manisol | CALLE 9 4 61 BARRIO BELLA VIST | 8908013398 | | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | 29975 | exco | Calle 85 # 48-01 Central Mayor | 8600024453 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | 29975 | exco | Calle 85 # 48-01 Central Mayor | 8600024453 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | 29975 | exco | Calle 85 # 48-01 Central Mayor | 8600024453 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | 29975 | exco | Calle 85 # 48-01 Central Mayor | 8600024453 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | 29975 | exco | Calle 85 # 48-01 Central Mayor | 8600024453 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | 29975 | exco | Calle 85 # 48-01 Central Mayor | 8600024453 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | 29975 | exco | Calle 85 # 48-01 Central Mayor | 8600024453 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | 29975 | exco | Calle 85 # 48-01 Central Mayor | 8600024453 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | 29975 | exco | Calle 85 # 48-01 Central Mayor | 8600024453 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | 29975 | exco | Calle 85 # 48-01 Central Mayor | 8600024453 | | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | 50077 | cocacola medellin | Dg. 64e #180 Medelln-Antioqui | 9005607272 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | 50077 | cocacola medellin | Dg. 64e #180 Medelln-Antioqui | 9005607272 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | 50077 | cocacola medellin | Dg. 64e #180 Medelln-Antioqui | 9005607272 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | 50077 | cocacola medellin | Dg. 64e #180 Medelln-Antioqui | 9005607272 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | 50077 | cocacola medellin | Dg. 64e #180 Medelln-Antioqui | 9005607272 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | 50077 | cocacola medellin | Dg. 64e #180 Medelln-Antioqui | 9005607272 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | 50077 | cocacola medellin | Dg. 64e #180 Medelln-Antioqui | 9005607272 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | 50077 | cocacola medellin | Dg. 64e #180 Medelln-Antioqui | 9005607272 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | 50077 | cocacola medellin | Dg. 64e #180 Medelln-Antioqui | 9005607272 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | 50077 | cocacola medellin | Dg. 64e #180 Medelln-Antioqui | 9005607272 | | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | 50156 | incametal | Cra. 45 #32d-135 Bello-Antioqu | 8909001049 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | 50156 | incametal | Cra. 45 #32d-135 Bello-Antioqu | 8909001049 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | 50156 | incametal | Cra. 45 #32d-135 Bello-Antioqu | 8909001049 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | 50156 | incametal | Cra. 45 #32d-135 Bello-Antioqu | 8909001049 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | 50156 | incametal | Cra. 45 #32d-135 Bello-Antioqu | 8909001049 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | 50156 | incametal | Cra. 45 #32d-135 Bello-Antioqu | 8909001049 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | 50156 | incametal | Cra. 45 #32d-135 Bello-Antioqu | 8909001049 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | 50156 | incametal | Cra. 45 #32d-135 Bello-Antioqu | 8909001049 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | 50156 | incametal | Cra. 45 #32d-135 Bello-Antioqu | 8909001049 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | 50156 | incametal | Cra. 45 #32d-135 Bello-Antioqu | 8909001049 | | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | 54500 | proleche | Cl. 72 ##64-105 Medelln-Antio | 9004015125 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | 54500 | proleche | Cl. 72 ##64-105 Medelln-Antio | 9004015125 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | 54500 | proleche | Cl. 72 ##64-105 Medelln-Antio | 9004015125 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | 54500 | proleche | Cl. 72 ##64-105 Medelln-Antio | 9004015125 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | 54500 | proleche | Cl. 72 ##64-105 Medelln-Antio | 9004015125 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | 54500 | proleche | Cl. 72 ##64-105 Medelln-Antio | 9004015125 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | 54500 | proleche | Cl. 72 ##64-105 Medelln-Antio | 9004015125 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | 54500 | proleche | Cl. 72 ##64-105 Medelln-Antio | 9004015125 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | 54500 | proleche | Cl. 72 ##64-105 Medelln-Antio | 9004015125 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | 54500 | proleche | Cl. 72 ##64-105 Medelln-Antio | 9004015125 | | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | 74419 | mebum | 050034 Medelln-Antioquia | 8001313507 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | 74419 | mebum | 050034 Medelln-Antioquia | 8001313507 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | 74419 | mebum | 050034 Medelln-Antioquia | 8001313507 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | 74419 | mebum | 050034 Medelln-Antioquia | 8001313507 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | 74419 | mebum | 050034 Medelln-Antioquia | 8001313507 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | 74419 | mebum | 050034 Medelln-Antioquia | 8001313507 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | 74419 | mebum | 050034 Medelln-Antioquia | 8001313507 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | 74419 | mebum | 050034 Medelln-Antioquia | 8001313507 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | 74419 | mebum | 050034 Medelln-Antioquia | 8001313507 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | 74419 | mebum | 050034 Medelln-Antioquia | 8001313507 | | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | 80012 | epm | Carrera 58 # 42 - 125 Medelln | 8909049961 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | 80012 | epm | Carrera 58 # 42 - 125 Medelln | 8909049961 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | 80012 | epm | Carrera 58 # 42 - 125 Medelln | 8909049961 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | 80012 | epm | Carrera 58 # 42 - 125 Medelln | 8909049961 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | 80012 | epm | Carrera 58 # 42 - 125 Medelln | 8909049961 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | 80012 | epm | Carrera 58 # 42 - 125 Medelln | 8909049961 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | 80012 | epm | Carrera 58 # 42 - 125 Medelln | 8909049961 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | 80012 | epm | Carrera 58 # 42 - 125 Medelln | 8909049961 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | 80012 | epm | Carrera 58 # 42 - 125 Medelln | 8909049961 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | 80012 | epm | Carrera 58 # 42 - 125 Medelln | 8909049961 | | 335 | anillo guia raspador | 12.7x3.3mm | Perfil | 2017-09-14 | nitrilo | 390000 | 90992 | cnch | Cra 52 #124 Medelln-Antioquia | 8110360309 | | 35 | oring | | Molde | 2011-09-20 | Silicona | 300000 | 90992 | cnch | Cra 52 #124 Medelln-Antioquia | 8110360309 | | 41 | empaque autoclave | | Molde | 2012-05-18 | Silicona | 300000 | 90992 | cnch | Cra 52 #124 Medelln-Antioquia | 8110360309 | | 44 | oring | 205x4mm esp | Molde | 2012-11-20 | silicona | 38000 | 90992 | cnch | Cra 52 #124 Medelln-Antioquia | 8110360309 | | 5161 | banda en perfil | 13x13mm | Perfil | 2015-09-18 | silicona | 12000 | 90992 | cnch | Cra 52 #124 Medelln-Antioquia | 8110360309 | | 52 | amortiguador | | Molde | 2005-04-04 | croydon | 55000 | 90992 | cnch | Cra 52 #124 Medelln-Antioquia | 8110360309 | | 520 | empaque autoclave | 20.5mm empalmado | Perfil | 2017-07-04 | silicona | 38000 | 90992 | cnch | Cra 52 #124 Medelln-Antioquia | 8110360309 | | 526 | empaque manga lecho empalmado | 41.5x31.5 perimetro 2380mm | Perfil | 2017-07-18 | silicona | 600000 | 90992 | cnch | Cra 52 #124 Medelln-Antioquia | 8110360309 | | 5389 | banda en perfil | 150x4mm esp | Perfil | 2015-02-19 | chupo | 25000 | 90992 | cnch | Cra 52 #124 Medelln-Antioquia | 8110360309 | | 75 | realce sencillo rdo | 140x170x10mm | Molde | 2019-07-29 | croydon | 3000 | 90992 | cnch | Cra 52 #124 Medelln-Antioquia | 8110360309 | +-------------+-------------------------------+----------------------------+--------+------------------+----------+--------+------------+-------------------+--------------------------------+------------+ 100 rows in set (0.018 sec) MariaDB [Bdmoldes]> select nombrecliente, descripcion from cliente inner join climolorden on cliente.codcliente=climolorden.codcliente inner join molde on climolorden.numeromolde=molde.numeromolde; +-------------------+----------------------+ | nombrecliente | descripcion | +-------------------+----------------------+ | golosinas trululu | anillo guia raspador | | hernando orozco | oring | | manisol | empaque autoclave | | exco | oring | | cocacola medellin | banda en perfil | | incametal | amortiguador | | mebum | empaque autoclave | | epm | banda en perfil | | cnch | realce sencillo rdo | +-------------------+----------------------+ 9 rows in set (0.000 sec) MariaDB [Bdmoldes]> select molde.nombre, reutilizado.fecha, reutilizado.numeromolde, reutilizado.nuevonumeromolde from molde left join reutilizado on molde.numeromolde=reutilizado.numeromolde where reutilizado.numeromolde is null; ERROR 1054 (42S22): Unknown column 'molde.nombre' in 'field list' MariaDB [Bdmoldes]> select molde.descripcion, reutilizado.fecha, reutilizado.numeromolde, reutilizado.nuevonumeromolde from molde left join reutilizado on molde.numeromolde=reutilizado.numeromolde where reutilizado.numeromolde is null; Empty set (0.000 sec) MariaDB [Bdmoldes]> select molde.descripcion, reutilizado.fecha, reutilizado.numeromolde, reutilizado.nuevonumeromolde from molde left join reutilizado on molde.numeromolde=reutilizado.numeromolde where reutilizado.numeromolde is no t null; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'no t null' at line 1 MariaDB [Bdmoldes]> select molde.descripcion, reutilizado.fecha, reutilizado.numeromolde, reutilizado.nuevonumeromolde from molde left join reutilizado on molde.numeromolde=reutilizado.numeromolde where reutilizado.numeromolde is not null; +-------------------------------+------------+-------------+------------------+ | descripcion | fecha | numeromolde | nuevonumeromolde | +-------------------------------+------------+-------------+------------------+ | anillo guia raspador | 2009-04-16 | 335 | 6167 | | oring | 2005-08-29 | 35 | 1235 | | empaque autoclave | 2017-09-26 | 41 | 1253 | | banda en perfil | 2018-07-19 | 5161 | 6105 | | amortiguador | 2017-09-04 | 52 | 60 | | empaque autoclave | 2018-09-25 | 520 | 1382 | | empaque manga lecho empalmado | 2020-11-23 | 526 | 5854 | | banda en perfil | 2020-08-20 | 5389 | 14 | | realce sencillo rdo | 2020-10-05 | 75 | 130 | | oring | 2019-08-15 | 44 | 240 | +-------------------------------+------------+-------------+------------------+ 10 rows in set (0.011 sec) MariaDB [Bdmoldes]> select molde.descripcion, reutilizado.fecha, reutilizado.numeromolde, reutilizado.nuevonumeromolde from molde left join reutilizado on molde.numeromolde=reutilizado.numeromolde where reutilizado.numeromolde is null; Empty set (0.000 sec) MariaDB [Bdmoldes]>