C:\Users\A01-1-0504-05>cd c:/xampp/mysql/bin/ c:\xampp\mysql\bin>mysql -uroot -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 10.4.32-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> source ejercicio.sql; ERROR: Failed to open file 'ejercicio.sql', error: 2 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.001 sec) Database changed Query OK, 0 rows affected (0.034 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.025 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.002 sec) Records: 6 Duplicates: 0 Warnings: 0 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, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.010 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.009 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.002 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.003 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]> 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 cantidadcasadisquera; Empty set (0.002 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.017 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) ; show create table casadisquera; +--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | casadisquera | CREATE TABLE `casadisquera` ( `idcasa_miusic` varchar(12) NOT NULL, `nombre` varchar(30) NOT NULL, PRIMARY KEY (`idcasa_miusic`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci | +--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.001 sec) select * from cancion; MariaDB [basedatosII]> disquera; 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.001 sec) MariaDB [basedatosII]> show tables; +-----------------------+ | Tables_in_basedatosii | +-----------------------+ | cancion | | cantidadcasadisquera | | casadisquera | +-----------------------+ 3 rows in set (0.001 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.010 sec) Records: 4 Duplicates: 0 Warnings: 0 MariaDB [basedatosII]> describe cantidad cantidadcasadisquera; ERROR 1146 (42S02): Table 'basedatosii.cantidad' doesn't exist 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.014 sec) 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]> 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.016 sec) MariaDB [basedatosII]> alter table cancion add casadisquera varchar(30); Query OK, 0 rows affected (0.022 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.001 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.007 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.001 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.039 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.008 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.015 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.030 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.002 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.003 sec) Query OK, 0 rows affected (0.000 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) MariaDB [basedatosiii]> select * from casadisquera; +--------+-------------------+ | codigo | nombre | +--------+-------------------+ | 001 | Universal Studios | | 002 | Sony & BMG | | 004 | Warner Music | | 015 | EMI | +--------+-------------------+ 4 rows in set (0.002 sec) MariaDB [basedatosiii]> describe cancion; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | codigo | varchar(12) | NO | PRI | NULL | | | titulo | varchar(30) | NO | | NULL | | | nomautor | varchar(30) | NO | | NULL | | | enlacedisquera | tinyint(3) unsigned | YES | | NULL | | +----------------+---------------------+------+-----+---------+-------+ 4 rows in set (0.020 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.000 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]> 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.005 sec) Rows matched: 3 Changed: 3 Warnings: 0 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]> 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.001 sec) MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> delete cancion -> from cancion -> join casadisquera -> on cancion.enlacedisquera=casadisquera.codigo -> where casadisquera.nombre='EMI'; Query OK, 2 rows affected (0.011 sec) MariaDB [basedatosiii]> select * from -> -> ; 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 [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> MariaDB [basedatosiii]> 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.001 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.000 sec) Database changed Query OK, 0 rows affected (0.044 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.043 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.008 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.016 sec) Query OK, 0 rows affected (0.028 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.036 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.003 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]> show tables; +------------------------+ | Tables_in_basedatosiii | +------------------------+ | cancion | | casadisquera | +------------------------+ 2 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.002 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.002 sec) MariaDB [basedatosiii]> insert into cancion values('007','Pajarando','Cargamo ODG','9'); Query OK, 1 row affected (0.009 sec) MariaDB [basedatosiii]> insert into cancion values('008','Violeta','SDRT','18'); Query OK, 1 row affected (0.008 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.000 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.000 sec) MariaDB [basedatosiii]> 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.010 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]> delete cancion,casadisquera -> from cancion -> join casadisquera -> on cancion.enlacedisquera=casadisquera.codigo -> where casadisquera.nombre='Sony & BMG'; Query OK, 3 rows affected (0.007 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.001 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]>