MariaDB [(none)]> source c:/xampp/ejercicio.sql Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 1 row affected (0.004 sec) Database changed Query OK, 0 rows affected (0.048 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.038 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 6 rows affected (0.006 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.023 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.019 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 4 rows affected (0.003 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) MariaDB [basedatosII]> show tables; +-----------------------+ | Tables_in_basedatosii | +-----------------------+ | cancion | | cantidadcasadisquera | | casadisquera | +-----------------------+ 3 rows in set (0.003 sec) MariaDB [basedatosII]> select * from cancion; +-----+------------------+-----------------+---------------+----------+ | cod | titulo | nomautor | idcasa_miusic | precioCD | +-----+------------------+-----------------+---------------+----------+ | 001 | Las tres rosas | Juan Belardo | 002 | 45000 | | 002 | Amores que matan | Adolfo Celdran | 002 | 35000 | | 003 | Pomopeya | Candido P‚rez | 001 | 40000 | | 004 | Porro Sabanero | Candido P‚rez | 003 | 70000 | | 005 | El guayaco | Nubia Costarica | 003 | 40000 | | 006 | La mara¤a | Nubia Costarica | 004 | 25000 | +-----+------------------+-----------------+---------------+----------+ 6 rows in set (0.000 sec) MariaDB [basedatosII]> select * from casadisquera; +---------------+-------------------+ | idcasa_miusic | nombre | +---------------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 003 | EMI | | 004 | Warner Music | +---------------+-------------------+ 4 rows in set (0.004 sec) MariaDB [basedatosII]> select * from cantidadcasadisquera; Empty set (0.003 sec) MariaDB [basedatosII]> describe cantidadcasadisquera; +----------+----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+----------------------+------+-----+---------+-------+ | nombre | varchar(30) | NO | | NULL | | | cantidad | smallint(5) unsigned | YES | | NULL | | +----------+----------------------+------+-----+---------+-------+ 2 rows in set (0.027 sec) MariaDB [basedatosII]> describe cancion; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | cod | varchar(12) | NO | PRI | NULL | | | titulo | varchar(30) | NO | | NULL | | | nomautor | varchar(30) | NO | | NULL | | | idcasa_miusic | varchar(12) | NO | MUL | NULL | | | precioCD | int(11) | YES | | NULL | | +---------------+-------------+------+-----+---------+-------+ 5 rows in set (0.024 sec) MariaDB [basedatosII]> describe casadisquera; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | idcasa_miusic | varchar(12) | NO | PRI | NULL | | | nombre | varchar(30) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 2 rows in set (0.025 sec) MariaDB [basedatosII]> show create table cancion; +---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | cancion | CREATE TABLE `cancion` ( `cod` varchar(12) NOT NULL, `titulo` varchar(30) NOT NULL, `nomautor` varchar(30) NOT NULL, `idcasa_miusic` varchar(12) NOT NULL, `precioCD` int(11) DEFAULT NULL, PRIMARY KEY (`cod`), KEY `idcasa_miusic` (`idcasa_miusic`), CONSTRAINT `cancion_ibfk_1` FOREIGN KEY (`idcasa_miusic`) REFERENCES `casadisquera` (`idcasa_miusic`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci | +---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [basedatosII]> select * from cancion; +-----+------------------+-----------------+---------------+----------+ | cod | titulo | nomautor | idcasa_miusic | precioCD | +-----+------------------+-----------------+---------------+----------+ | 001 | Las tres rosas | Juan Belardo | 002 | 45000 | | 002 | Amores que matan | Adolfo Celdran | 002 | 35000 | | 003 | Pomopeya | Candido P‚rez | 001 | 40000 | | 004 | Porro Sabanero | Candido P‚rez | 003 | 70000 | | 005 | El guayaco | Nubia Costarica | 003 | 40000 | | 006 | La mara¤a | Nubia Costarica | 004 | 25000 | +-----+------------------+-----------------+---------------+----------+ 6 rows in set (0.001 sec) MariaDB [basedatosII]> select * from casadisquera; +---------------+-------------------+ | idcasa_miusic | nombre | +---------------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 003 | EMI | | 004 | Warner Music | +---------------+-------------------+ 4 rows in set (0.000 sec) MariaDB [basedatosII]> select c.nombre, count(co.idcasa_miusic) -> from casadisquera as c -> left join cancion as co -> on c.idcasa_miusic=co.idcasa_miusic -> group by c.nombre; +-------------------+-------------------------+ | nombre | count(co.idcasa_miusic) | +-------------------+-------------------------+ | EMI | 2 | | Sony & BMG | 2 | | Universal Studios | 1 | | Warner Music | 1 | +-------------------+-------------------------+ 4 rows in set (0.001 sec) MariaDB [basedatosII]> insert into cantidadcasadisquera -> select c.nombre, count(co.idcasa_miusic) -> from casadisquera as c -> left join cancion as co -> on c.idcasa_miusic=co.idcasa_miusic -> group by c.nombre; Query OK, 4 rows affected (0.019 sec) Records: 4 Duplicates: 0 Warnings: 0 MariaDB [basedatosII]> select * from cantidadcasadisquera; +-------------------+----------+ | nombre | cantidad | +-------------------+----------+ | EMI | 2 | | Sony & BMG | 2 | | Universal Studios | 1 | | Warner Music | 1 | +-------------------+----------+ 4 rows in set (0.000 sec) MariaDB [basedatosII]> select * from cancion; +-----+------------------+-----------------+---------------+----------+ | cod | titulo | nomautor | idcasa_miusic | precioCD | +-----+------------------+-----------------+---------------+----------+ | 001 | Las tres rosas | Juan Belardo | 002 | 45000 | | 002 | Amores que matan | Adolfo Celdran | 002 | 35000 | | 003 | Pomopeya | Candido P‚rez | 001 | 40000 | | 004 | Porro Sabanero | Candido P‚rez | 003 | 70000 | | 005 | El guayaco | Nubia Costarica | 003 | 40000 | | 006 | La mara¤a | Nubia Costarica | 004 | 25000 | +-----+------------------+-----------------+---------------+----------+ 6 rows in set (0.001 sec) MariaDB [basedatosII]> alter table cancion add casadisquera varchar(30); Query OK, 0 rows affected (0.029 sec) Records: 0 Duplicates: 0 Warnings: 0 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.000 sec) MariaDB [basedatosII]> select * from casadisquera; +---------------+-------------------+ | idcasa_miusic | nombre | +---------------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 003 | EMI | | 004 | Warner Music | +---------------+-------------------+ 4 rows in set (0.000 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.014 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.000 sec) MariaDB [basedatosII]> source c:/xampp/ejercicio2.sql Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 1 row affected (0.004 sec) Database changed Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.029 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 6 rows affected (0.003 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.005 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.020 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 4 rows affected (0.003 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.005 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) MariaDB [basedatosiii]> select * from casadisquera; +--------+-------------------+ | codigo | nombre | +--------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 004 | Warner Music | | 015 | EMI | +--------+-------------------+ 4 rows in set (0.003 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 COLLATE=latin1_swedish_ci | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 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 COLLATE=latin1_swedish_ci | +---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.003 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.001 sec) MariaDB [basedatosiii]> select * from casadisquera; +--------+-------------------+ | codigo | nombre | +--------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 004 | Warner Music | | 015 | EMI | +--------+-------------------+ 4 rows in set (0.000 sec) MariaDB [basedatosiii]> select * from casadisquera; +--------+-------------------+ | codigo | nombre | +--------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 004 | Warner Music | | 015 | EMI | +--------+-------------------+ 4 rows in set (0.001 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.016 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.000 sec) MariaDB [basedatosiii]> select * from casadisquera; +--------+-------------------+ | codigo | nombre | +--------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 004 | Warner Music | | 16 | EMI | +--------+-------------------+ 4 rows in set (0.000 sec) MariaDB [basedatosiii]> delete cancion -> from cancion -> join casadisquera -> on cancion.enlacedisquera=casadisquera.codigo -> where casadisquera.nombre='EMI'; Query OK, 2 rows affected (0.004 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.000 sec) MariaDB [basedatosiii]> select * from casadisquera; +--------+-------------------+ | codigo | nombre | +--------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 004 | Warner Music | | 16 | EMI | +--------+-------------------+ 4 rows in set (0.000 sec) MariaDB [basedatosiii]> source c:/xampp/ejercicio2.sql Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.002 sec) Database changed Query OK, 0 rows affected (0.031 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.028 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 6 rows affected (0.003 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.004 sec) Query OK, 0 rows affected (0.016 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.020 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 4 rows affected (0.004 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.005 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 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.003 sec) MariaDB [basedatosiii]> insert into cancion values('007','Pajarando','Cargamo ODG','9'); Query OK, 1 row affected (0.006 sec) MariaDB [basedatosiii]> insert into cancion values('008','Violeta','SDRT','18'); Query OK, 1 row affected (0.014 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.001 sec) MariaDB [basedatosiii]> select c.* from cancion as c -> left join casadisquera as ca -> on c.enlacedisquera=ca.codigo -> where ca.codigo is null; +--------+-----------+-------------+----------------+ | codigo | titulo | nomautor | enlacedisquera | +--------+-----------+-------------+----------------+ | 007 | Pajarando | Cargamo ODG | 9 | | 008 | Violeta | SDRT | 18 | +--------+-----------+-------------+----------------+ 2 rows in set (0.003 sec) 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.015 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.000 sec) MariaDB [basedatosiii]> select * from casadisquera; +--------+-------------------+ | codigo | nombre | +--------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 004 | Warner Music | | 015 | EMI | +--------+-------------------+ 4 rows in set (0.001 sec) MariaDB [basedatosiii]> delete cancion,casadisquera -> from cancion -> join casadisquera -> on cancion.enlacedisquera=casadisquera.codigo -> where casadisquera.nombre='Sony & BMG'; Query OK, 3 rows affected (0.015 sec) MariaDB [basedatosiii]> select * from casadisquera; +--------+-------------------+ | codigo | nombre | +--------+-------------------+ | 001 | Universal Studios | | 004 | Warner Music | | 015 | EMI | +--------+-------------------+ 3 rows in set (0.001 sec) MariaDB [basedatosiii]> select * from cancion; +--------+----------------+-----------------+----------------+ | codigo | titulo | nomautor | enlacedisquera | +--------+----------------+-----------------+----------------+ | 003 | Pomopeya | Candido Perez | 1 | | 004 | Porro Sabanero | Candido Perez | 15 | | 005 | El Guayaco | Nubia Costarica | 15 | | 006 | La marana | Nubia Costarica | 4 | +--------+----------------+-----------------+----------------+ 4 rows in set (0.000 sec) MariaDB [basedatosiii]> select * from casadisquera; +--------+-------------------+ | codigo | nombre | +--------+-------------------+ | 001 | Universal Studios | | 004 | Warner Music | | 015 | EMI | +--------+-------------------+ 3 rows in set (0.000 sec) MariaDB [basedatosiii]> exit