MariaDB [basedatosII]> alter table cancion add casadisquera varchar(30); Query OK, 0 rows affected (0.47 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [basedatosII]> select * from casadisquera; +---------------+-------------------+ | idcasa_miusic | nombre | +---------------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 003 | EMI | | 004 | Warner Music | +---------------+-------------------+ 4 rows in set (0.00 sec) MariaDB [basedatosII]> select * from cancion; +-----+------------------+-----------------+---------------+----------+--------------+ | cod | titulo | nomautor | idcasa_miusic | precioCD | casadisquera | +-----+------------------+-----------------+---------------+----------+--------------+ | 001 | Las tres rosas | Juan Belardo | 002 | 45000 | NULL | | 002 | Amores que matan | Adolfo Celdran | 002 | 35000 | NULL | | 003 | Pomopeya | Candido P‚rez | 001 | 40000 | NULL | | 004 | Porro Sabanero | Candido P‚rez | 003 | 70000 | NULL | | 005 | El guayaco | Nubia Costarica | 003 | 40000 | NULL | | 006 | La mara¤a | Nubia Costarica | 004 | 25000 | NULL | +-----+------------------+-----------------+---------------+----------+--------------+ 6 rows in set (0.00 sec) MariaDB [basedatosII]> select * from cancion; +-----+------------------+-----------------+---------------+----------+--------------+ | cod | titulo | nomautor | idcasa_miusic | precioCD | casadisquera | +-----+------------------+-----------------+---------------+----------+--------------+ | 001 | Las tres rosas | Juan Belardo | 002 | 45000 | NULL | | 002 | Amores que matan | Adolfo Celdran | 002 | 35000 | NULL | | 003 | Pomopeya | Candido P‚rez | 001 | 40000 | NULL | | 004 | Porro Sabanero | Candido P‚rez | 003 | 70000 | NULL | | 005 | El guayaco | Nubia Costarica | 003 | 40000 | NULL | | 006 | La mara¤a | Nubia Costarica | 004 | 25000 | NULL | +-----+------------------+-----------------+---------------+----------+--------------+ 6 rows in set (0.00 sec) MariaDB [basedatosII]> update cancion -> join casadisquera -> on cancion.idcasa_miusic=casadisquera.idcasa_miusic -> set cancion.casadisquera=casadisquera.nombre; Query OK, 6 rows affected (0.04 sec) Rows matched: 6 Changed: 6 Warnings: 0 MariaDB [basedatosII]> select * from cancion; +-----+------------------+-----------------+---------------+----------+-------------------+ | cod | titulo | nomautor | idcasa_miusic | precioCD | casadisquera | +-----+------------------+-----------------+---------------+----------+-------------------+ | 001 | Las tres rosas | Juan Belardo | 002 | 45000 | Sony & BMG | | 002 | Amores que matan | Adolfo Celdran | 002 | 35000 | Sony & BMG | | 003 | Pomopeya | Candido P‚rez | 001 | 40000 | Universal Studios | | 004 | Porro Sabanero | Candido P‚rez | 003 | 70000 | EMI | | 005 | El guayaco | Nubia Costarica | 003 | 40000 | EMI | | 006 | La mara¤a | Nubia Costarica | 004 | 25000 | Warner Music | +-----+------------------+-----------------+---------------+----------+-------------------+ 6 rows in set (0.00 sec) MariaDB [basedatosII]> source C:\Users\A01-1-0604-18\Downloads\ejercicio2.sql Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 1 row affected (0.00 sec) Database changed Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.15 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 6 rows affected (0.03 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.11 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.16 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 4 rows affected (0.04 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) MariaDB [basedatosiii]> show tables; +------------------------+ | Tables_in_basedatosiii | +------------------------+ | cancion | | casadisquera | +------------------------+ 2 rows in set (0.00 sec) MariaDB [basedatosiii]> show create table cancion; +---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | cancion | CREATE TABLE `cancion` ( `codigo` varchar(12) NOT NULL, `titulo` varchar(30) NOT NULL, `nomautor` varchar(30) NOT NULL, `enlacedisquera` tinyint(3) unsigned DEFAULT NULL, PRIMARY KEY (`codigo`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [basedatosiii]> show create table casadisquera; +--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+ | casadisquera | CREATE TABLE `casadisquera` ( `codigo` varchar(12) NOT NULL, `nombre` varchar(30) NOT NULL, PRIMARY KEY (`codigo`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [basedatosiii]> select * from cancion; +--------+------------------+-----------------+----------------+ | codigo | titulo | nomautor | enlacedisquera | +--------+------------------+-----------------+----------------+ | 001 | Las tres rosas | Juan Belardo | 2 | | 002 | Amores que matan | Adolfo Cedran | 2 | | 003 | Pomopeya | Candido Perez | 1 | | 004 | Porro Sabanero | Candido Perez | 15 | | 005 | El Guayaco | Nubia Costarica | 15 | | 006 | La marana | Nubia Costarica | 4 | +--------+------------------+-----------------+----------------+ 6 rows in set (0.00 sec) MariaDB [basedatosiii]> select * from casadisquera; +--------+-------------------+ | codigo | nombre | +--------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 004 | Warner Music | | 015 | EMI | +--------+-------------------+ 4 rows in set (0.00 sec) MariaDB [basedatosiii]> update cancion as n -> join casadisquera as c -> on n.enlacedisquera=c.codigo -> set n.enlacedisquera='16',c.codigo='16' -> where c.nombre='EMI'; Query OK, 3 rows affected (0.03 sec) Rows matched: 3 Changed: 3 Warnings: 0 MariaDB [basedatosiii]> select * from cancion; +--------+------------------+-----------------+----------------+ | codigo | titulo | nomautor | enlacedisquera | +--------+------------------+-----------------+----------------+ | 001 | Las tres rosas | Juan Belardo | 2 | | 002 | Amores que matan | Adolfo Cedran | 2 | | 003 | Pomopeya | Candido Perez | 1 | | 004 | Porro Sabanero | Candido Perez | 16 | | 005 | El Guayaco | Nubia Costarica | 16 | | 006 | La marana | Nubia Costarica | 4 | +--------+------------------+-----------------+----------------+ 6 rows in set (0.00 sec) MariaDB [basedatosiii]> select * from casadisquera; +--------+-------------------+ | codigo | nombre | +--------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 004 | Warner Music | | 16 | EMI | +--------+-------------------+ 4 rows in set (0.00 sec) MariaDB [basedatosiii]> delete cancion -> from cancion -> join casadisquera -> on cancion.enlacedisquera=casadisquera.codigo -> where casadisquera.nombre='EMI'; Query OK, 2 rows affected (0.05 sec) MariaDB [basedatosiii]> select * from cancion; +--------+------------------+-----------------+----------------+ | codigo | titulo | nomautor | enlacedisquera | +--------+------------------+-----------------+----------------+ | 001 | Las tres rosas | Juan Belardo | 2 | | 002 | Amores que matan | Adolfo Cedran | 2 | | 003 | Pomopeya | Candido Perez | 1 | | 006 | La marana | Nubia Costarica | 4 | +--------+------------------+-----------------+----------------+ 4 rows in set (0.00 sec) MariaDB [basedatosiii]> select * from casadisquera; +--------+-------------------+ | codigo | nombre | +--------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 004 | Warner Music | | 16 | EMI | +--------+-------------------+ 4 rows in set (0.00 sec) MariaDB [basedatosiii]> source C:\Users\A01-1-0604-18\Downloads\ejercicio2.sql Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Database changed Query OK, 0 rows affected (0.12 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.16 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 6 rows affected (0.04 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.08 sec) Query OK, 0 rows affected (0.15 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.17 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 4 rows affected (0.04 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) MariaDB [basedatosiii]> show tables; +------------------------+ | Tables_in_basedatosiii | +------------------------+ | cancion | | casadisquera | +------------------------+ 2 rows in set (0.00 sec) MariaDB [basedatosiii]> insert into cancion values('007','Pajarando','Cargamo ODG','9'); Query OK, 1 row affected (0.05 sec) MariaDB [basedatosiii]> insert into cancion values('008','Violeta','SDRT','18'); Query OK, 1 row affected (0.04 sec) MariaDB [basedatosiii]> select * from cancion; +--------+------------------+-----------------+----------------+ | codigo | titulo | nomautor | enlacedisquera | +--------+------------------+-----------------+----------------+ | 001 | Las tres rosas | Juan Belardo | 2 | | 002 | Amores que matan | Adolfo Cedran | 2 | | 003 | Pomopeya | Candido Perez | 1 | | 004 | Porro Sabanero | Candido Perez | 15 | | 005 | El Guayaco | Nubia Costarica | 15 | | 006 | La marana | Nubia Costarica | 4 | | 007 | Pajarando | Cargamo ODG | 9 | | 008 | Violeta | SDRT | 18 | +--------+------------------+-----------------+----------------+ 8 rows in set (0.00 sec) MariaDB [basedatosiii]> select * from cancion as c -> left join casadisquera as ca -> on c.enlacedisquera=ca.codigo -> where ca.codigo is null; +--------+-----------+-------------+----------------+--------+--------+ | codigo | titulo | nomautor | enlacedisquera | codigo | nombre | +--------+-----------+-------------+----------------+--------+--------+ | 007 | Pajarando | Cargamo ODG | 9 | NULL | NULL | | 008 | Violeta | SDRT | 18 | NULL | NULL | +--------+-----------+-------------+----------------+--------+--------+ 2 rows in set (0.00 sec) MariaDB [basedatosiii]> delete cancion from cancion -> left join casadisquera -> on c.enlacedisquera=casadisquera.codigo -> where casadisquera.codigo is null; ERROR 1054 (42S22): Unknown column 'c.enlacedisquera' in 'on clause' MariaDB [basedatosiii]> delete cancion from cancion -> left join casadisquera -> on cancion.enlacedisquera=casadisquera.codigo -> where casadisquera.codigo is null; Query OK, 2 rows affected (0.05 sec) MariaDB [basedatosiii]> select * from cancion; +--------+------------------+-----------------+----------------+ | codigo | titulo | nomautor | enlacedisquera | +--------+------------------+-----------------+----------------+ | 001 | Las tres rosas | Juan Belardo | 2 | | 002 | Amores que matan | Adolfo Cedran | 2 | | 003 | Pomopeya | Candido Perez | 1 | | 004 | Porro Sabanero | Candido Perez | 15 | | 005 | El Guayaco | Nubia Costarica | 15 | | 006 | La marana | Nubia Costarica | 4 | +--------+------------------+-----------------+----------------+ 6 rows in set (0.00 sec) MariaDB [basedatosiii]> select * from casadisquera; +--------+-------------------+ | codigo | nombre | +--------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 004 | Warner Music | | 015 | EMI | +--------+-------------------+ 4 rows in set (0.00 sec) MariaDB [basedatosiii]> delete cancion,casadisquera -> from cancion -> join casadisquera -> on cancion.enlacedisquera=casadisquera.codigo -> where casadisquera.nombre='Sony &BMG'; Query OK, 0 rows affected (0.00 sec) MariaDB [basedatosiii]> select * from cancion; +--------+------------------+-----------------+----------------+ | codigo | titulo | nomautor | enlacedisquera | +--------+------------------+-----------------+----------------+ | 001 | Las tres rosas | Juan Belardo | 2 | | 002 | Amores que matan | Adolfo Cedran | 2 | | 003 | Pomopeya | Candido Perez | 1 | | 004 | Porro Sabanero | Candido Perez | 15 | | 005 | El Guayaco | Nubia Costarica | 15 | | 006 | La marana | Nubia Costarica | 4 | +--------+------------------+-----------------+----------------+ 6 rows in set (0.00 sec) MariaDB [basedatosiii]> select * from casadisquera; +--------+-------------------+ | codigo | nombre | +--------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 004 | Warner Music | | 015 | EMI | +--------+-------------------+ 4 rows in set (0.00 sec) MariaDB [basedatosiii]> exit