MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | biblioteca | | bibliotecaax | | bibliotecaax2 | | escuela | | information_schema | | libreria | | matricula | | mysql | | performance_schema | | phpmyadmin | | taller2 | | test | +--------------------+ 12 rows in set (0.001 sec) MariaDB [(none)]> use escuela; Database changed MariaDB [escuela]> create table ACUDIENTE -> (idacudiente varchar(20) not null primary key, -> nombre varchar(60) not null, -> direccion varchar(60) not null, -> telefono varchar(15) not null, -> email varchar(60) not null); Query OK, 0 rows affected (0.405 sec) MariaDB [escuela]> describe acudiente; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | idacudiente | varchar(20) | NO | PRI | NULL | | | nombre | varchar(60) | NO | | NULL | | | direccion | varchar(60) | NO | | NULL | | | telefono | varchar(15) | NO | | NULL | | | email | varchar(60) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 5 rows in set (0.099 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('001','ACEVEDO CARDONA ESTEBAN','Barrio la pradera','5846069','estebacardona@gmail.com'); Query OK, 1 row affected (0.138 sec) MariaDB [escuela]> select * from acudiente; +-------------+-------------------------+-------------------+----------+-------------------------+ | idacudiente | nombre | direccion | telefono | email | +-------------+-------------------------+-------------------+----------+-------------------------+ | 001 | ACEVEDO CARDONA ESTEBAN | Barrio la pradera | 5846069 | estebacardona@gmail.com | +-------------+-------------------------+-------------------+----------+-------------------------+ 1 row in set (0.063 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('002','AGUDELO MANCO DIANA PATRICIA','Barrio rosaleda','5882104','dianapatricia@gmail.com'); Query OK, 1 row affected (0.087 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('003','ZAPATA VALENCIA JORGE','Barrio Aragon','5841998','jorgezapata@gmail.com'); Query OK, 1 row affected (0.281 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('004','VELASQUEZ CANO JENNY ASTRID','Barrio la pradera','2791469','jennyvelasquez@gmail.com'); Query OK, 1 row affected (0.147 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('005','POSADA VASCO ANA','Urbanizacion compartir','2868617','anaposada@gmail.com'); Query OK, 1 row affected (0.258 sec) MariaDB [escuela]> nsert into acudiente(idacudiente,nombre,direccion,telefono,email) values('006','ORTIZ PUERTA INDIRA','Urbanizaci½n ciudadela prado','5841497','indiraortiz@gmail.com'); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nsert into acudiente(idacudiente,nombre,direccion,telefono,email) values('006...' at line 1 MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('006','ORTIZ PUERTA INDIRA','Urbanizaci½n ciudadela prado','5841497','indiraortiz@gmail.com'); Query OK, 1 row affected (0.152 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('007','QUINTERO MENESES ADRIANA MARIA','Barrio Sangabriel','5840570','adrianaquintero@gmail.com'); Query OK, 1 row affected (0.087 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('008','MONTOYA RIVERA EDILMA','Barrio la pradera','3767289','edilmamontoya@gmail.com'); Query OK, 1 row affected (0.273 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('009','LOPERA MONSALVE FERNANDO ALONSO','Barrio el limonar 1','5709957','fernandolopera@gmail.com'); Query OK, 1 row affected (0.154 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('010','HENAO RIOS DORA EMILSE','Barrio el limonar2','2866222','dorahenao@gmail.com'); Query OK, 1 row affected (0.166 sec) MariaDB [escuela]> select * from acudiente; +-------------+---------------------------------+------------------------------+----------+---------------------------+ | idacudiente | nombre | direccion | telefono | email | +-------------+---------------------------------+------------------------------+----------+---------------------------+ | 001 | ACEVEDO CARDONA ESTEBAN | Barrio la pradera | 5846069 | estebacardona@gmail.com | | 002 | AGUDELO MANCO DIANA PATRICIA | Barrio rosaleda | 5882104 | dianapatricia@gmail.com | | 003 | ZAPATA VALENCIA JORGE | Barrio Aragon | 5841998 | jorgezapata@gmail.com | | 004 | VELASQUEZ CANO JENNY ASTRID | Barrio la pradera | 2791469 | jennyvelasquez@gmail.com | | 005 | POSADA VASCO ANA | Urbanizacion compartir | 2868617 | anaposada@gmail.com | | 006 | ORTIZ PUERTA INDIRA | Urbanizaci½n ciudadela prado | 5841497 | indiraortiz@gmail.com | | 007 | QUINTERO MENESES ADRIANA MARIA | Barrio Sangabriel | 5840570 | adrianaquintero@gmail.com | | 008 | MONTOYA RIVERA EDILMA | Barrio la pradera | 3767289 | edilmamontoya@gmail.com | | 009 | LOPERA MONSALVE FERNANDO ALONSO | Barrio el limonar 1 | 5709957 | fernandolopera@gmail.com | | 010 | HENAO RIOS DORA EMILSE | Barrio el limonar2 | 2866222 | dorahenao@gmail.com | +-------------+---------------------------------+------------------------------+----------+---------------------------+ 10 rows in set (0.000 sec) MariaDB [escuela]> create table ESTUDIANTE -> (idestudiante varchar(20) not null primary key, -> nombre varchar(60) not null, -> direccion varchar(60) not null, -> telefono varchar(15) not null, -> email varchar(60) not null); Query OK, 0 rows affected (0.374 sec) MariaDB [escuela]> show tables; +-------------------+ | Tables_in_escuela | +-------------------+ | acudiente | | estudiante | +-------------------+ 2 rows in set (0.001 sec) MariaDB [escuela]> describe estudiante; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | idestudiante | varchar(20) | NO | PRI | NULL | | | nombre | varchar(60) | NO | | NULL | | | direccion | varchar(60) | NO | | NULL | | | telefono | varchar(15) | NO | | NULL | | | email | varchar(60) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 5 rows in set (0.055 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('00001','ACEVEDO BURITICA JUAN ESTEBAN','Barrio la pradera','5846069','juanestebacardona@gmail.com'); Query OK, 1 row affected (0.145 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('00002','ALVAREZ AGUDELO ESTEBAN','Barrio rosaleda','5882104','estebanlavarez@gmail.com'); Query OK, 1 row affected (0.152 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('00003','ZAPATA CAMPI¾O ISABEL','Barrio Aragon','5841998','zapataisabel@gmail.com'); Query OK, 1 row affected (0.166 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('00004','VALLE VELASQUEZ SOFIA','Barrio la pradera','2791469','sofiavelasquez@gmail.com'); Query OK, 1 row affected (0.120 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('00005','MORENO POSADA DIEGO ALEJANDRO','Urbanizacion compartir','2868617','diegomoreno@gmail.com'); Query OK, 1 row affected (0.196 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('00006','LZATE ORTIZ JORGE MARIO','Urbanizaci½n ciudadela prado ','5841497','marioalzae@gmail.com'); Query OK, 1 row affected (0.171 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('00007','ZAPATA QUINTERO JOSE MARIA','Barrio Sangabriel','5840570','josezapata@gmail.com'); Query OK, 1 row affected (0.154 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('00008','MNTOYA MONTOYA AEJANDRO','Barrio la pradera','3767289','alejandromontoya@gmail.com'); Query OK, 1 row affected (0.044 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('00009','LOPERA CARTAGENA LUISA FENANADA','Barrio el limonar 1','5709957','luisalopera@gmail.com'); Query OK, 1 row affected (0.255 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('00010','JARAMILLO HENAO JOSE LUIS','Barrio el limonar2','2866222','josearamillo@gmail.com'); Query OK, 1 row affected (0.154 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('00011','ALVAREZ AGUDELO LUNA','Barrio rosaleda','5882104','lunaalvarez@gmail.com'); Query OK, 1 row affected (0.146 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('00012','ALVAREZ AGUDELO XAVIER','Barrio rosaleda','5882104','xavieralvarez@gmail.com'); Query OK, 1 row affected (0.158 sec) MariaDB [escuela]> select * from estudiante; Empty set (0.001 sec) MariaDB [escuela]> select * from acudiente; +-------------+---------------------------------+-------------------------------+----------+-----------------------------+ | idacudiente | nombre | direccion | telefono | email | +-------------+---------------------------------+-------------------------------+----------+-----------------------------+ | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | Barrio la pradera | 5846069 | juanestebacardona@gmail.com | | 00002 | ALVAREZ AGUDELO ESTEBAN | Barrio rosaleda | 5882104 | estebanlavarez@gmail.com | | 00003 | ZAPATA CAMPI¾O ISABEL | Barrio Aragon | 5841998 | zapataisabel@gmail.com | | 00004 | VALLE VELASQUEZ SOFIA | Barrio la pradera | 2791469 | sofiavelasquez@gmail.com | | 00005 | MORENO POSADA DIEGO ALEJANDRO | Urbanizacion compartir | 2868617 | diegomoreno@gmail.com | | 00006 | LZATE ORTIZ JORGE MARIO | Urbanizaci½n ciudadela prado | 5841497 | marioalzae@gmail.com | | 00007 | ZAPATA QUINTERO JOSE MARIA | Barrio Sangabriel | 5840570 | josezapata@gmail.com | | 00008 | MNTOYA MONTOYA AEJANDRO | Barrio la pradera | 3767289 | alejandromontoya@gmail.com | | 00009 | LOPERA CARTAGENA LUISA FENANADA | Barrio el limonar 1 | 5709957 | luisalopera@gmail.com | | 00010 | JARAMILLO HENAO JOSE LUIS | Barrio el limonar2 | 2866222 | josearamillo@gmail.com | | 00011 | ALVAREZ AGUDELO LUNA | Barrio rosaleda | 5882104 | lunaalvarez@gmail.com | | 00012 | ALVAREZ AGUDELO XAVIER | Barrio rosaleda | 5882104 | xavieralvarez@gmail.com | | 001 | ACEVEDO CARDONA ESTEBAN | Barrio la pradera | 5846069 | estebacardona@gmail.com | | 002 | AGUDELO MANCO DIANA PATRICIA | Barrio rosaleda | 5882104 | dianapatricia@gmail.com | | 003 | ZAPATA VALENCIA JORGE | Barrio Aragon | 5841998 | jorgezapata@gmail.com | | 004 | VELASQUEZ CANO JENNY ASTRID | Barrio la pradera | 2791469 | jennyvelasquez@gmail.com | | 005 | POSADA VASCO ANA | Urbanizacion compartir | 2868617 | anaposada@gmail.com | | 006 | ORTIZ PUERTA INDIRA | Urbanizaci½n ciudadela prado | 5841497 | indiraortiz@gmail.com | | 007 | QUINTERO MENESES ADRIANA MARIA | Barrio Sangabriel | 5840570 | adrianaquintero@gmail.com | | 008 | MONTOYA RIVERA EDILMA | Barrio la pradera | 3767289 | edilmamontoya@gmail.com | | 009 | LOPERA MONSALVE FERNANDO ALONSO | Barrio el limonar 1 | 5709957 | fernandolopera@gmail.com | | 010 | HENAO RIOS DORA EMILSE | Barrio el limonar2 | 2866222 | dorahenao@gmail.com | +-------------+---------------------------------+-------------------------------+----------+-----------------------------+ 22 rows in set (0.001 sec) MariaDB [escuela]> drop table acudiente; Query OK, 0 rows affected (0.327 sec) MariaDB [escuela]> insert into estudiante(idestudiante,nombre,direccion,telefono,email) values('00001','ACEVEDO BURITICA JUAN ESTEBAN','Barrio la pradera','5846069','juanestebacardona@gmail.com'); Query OK, 1 row affected (0.129 sec) MariaDB [escuela]> insert into estudiante(idestudiante,nombre,direccion,telefono,email) values('00002','ALVAREZ AGUDELO ESTEBAN','Barrio rosaleda','5882104','estebanlavarez@gmail.com'); Query OK, 1 row affected (0.151 sec) MariaDB [escuela]> insert into estudiante(idestudiante,nombre,direccion,telefono,email) values('00003','ZAPATA CAMPI¾O ISABEL','Barrio Aragon','5841998','zapataisabel@gmail.com'); Query OK, 1 row affected (0.152 sec) MariaDB [escuela]> insert into estudiante(idestudiante,nombre,direccion,telefono,email) values('00004','VALLE VELASQUEZ SOFIA','Barrio la pradera','2791469','sofiavelasquez@gmail.com'); Query OK, 1 row affected (0.043 sec) MariaDB [escuela]> insert into estudiante(idestudiante,nombre,direccion,telefono,email) values('00005','MORENO POSADA DIEGO ALEJANDRO','Urbanizacion compartir','2868617','diegomoreno@gmail.com'); Query OK, 1 row affected (0.078 sec) MariaDB [escuela]> insert into estudiante(idestudiante,nombre,direccion,telefono,email) values('00006','LZATE ORTIZ JORGE MARIO','Urbanizaci½n ciudadela prado ','5841497','marioalzae@gmail.com'); Query OK, 1 row affected (0.153 sec) MariaDB [escuela]> insert into estudiante(idestudiante,nombre,direccion,telefono,email) values('00007','ZAPATA QUINTERO JOSE MARIA','Barrio Sangabriel','5840570','josezapata@gmail.com'); Query OK, 1 row affected (0.155 sec) MariaDB [escuela]> insert into estudiante(idestudiante,nombre,direccion,telefono,email) values('00008','MNTOYA MONTOYA AEJANDRO','Barrio la pradera','3767289','alejandromontoya@gmail.com'); Query OK, 1 row affected (0.155 sec) MariaDB [escuela]> insert into estudiante(idestudiante,nombre,direccion,telefono,email) values('00009','LOPERA CARTAGENA LUISA FENANADA','Barrio el limonar 1','5709957','luisalopera@gmail.com'); Query OK, 1 row affected (0.094 sec) MariaDB [escuela]> insert into estudiante(idestudiante,nombre,direccion,telefono,email) values('00010','JARAMILLO HENAO JOSE LUIS','Barrio el limonar2','2866222','josearamillo@gmail.com'); Query OK, 1 row affected (0.147 sec) MariaDB [escuela]> insert into estudiante(idestudiante,nombre,direccion,telefono,email) values('00011','ALVAREZ AGUDELO LUNA','Barrio rosaleda','5882104','lunaalvarez@gmail.com'); Query OK, 1 row affected (0.147 sec) MariaDB [escuela]> insert into estudiante(idestudiante,nombre,direccion,telefono,email) values('00012','ALVAREZ AGUDELO XAVIER','Barrio rosaleda','5882104','xavieralvarez@gmail.com'); Query OK, 1 row affected (0.153 sec) MariaDB [escuela]> select * from estudiante; +--------------+---------------------------------+-------------------------------+----------+-----------------------------+ | idestudiante | nombre | direccion | telefono | email | +--------------+---------------------------------+-------------------------------+----------+-----------------------------+ | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | Barrio la pradera | 5846069 | juanestebacardona@gmail.com | | 00002 | ALVAREZ AGUDELO ESTEBAN | Barrio rosaleda | 5882104 | estebanlavarez@gmail.com | | 00003 | ZAPATA CAMPI¾O ISABEL | Barrio Aragon | 5841998 | zapataisabel@gmail.com | | 00004 | VALLE VELASQUEZ SOFIA | Barrio la pradera | 2791469 | sofiavelasquez@gmail.com | | 00005 | MORENO POSADA DIEGO ALEJANDRO | Urbanizacion compartir | 2868617 | diegomoreno@gmail.com | | 00006 | LZATE ORTIZ JORGE MARIO | Urbanizaci½n ciudadela prado | 5841497 | marioalzae@gmail.com | | 00007 | ZAPATA QUINTERO JOSE MARIA | Barrio Sangabriel | 5840570 | josezapata@gmail.com | | 00008 | MNTOYA MONTOYA AEJANDRO | Barrio la pradera | 3767289 | alejandromontoya@gmail.com | | 00009 | LOPERA CARTAGENA LUISA FENANADA | Barrio el limonar 1 | 5709957 | luisalopera@gmail.com | | 00010 | JARAMILLO HENAO JOSE LUIS | Barrio el limonar2 | 2866222 | josearamillo@gmail.com | | 00011 | ALVAREZ AGUDELO LUNA | Barrio rosaleda | 5882104 | lunaalvarez@gmail.com | | 00012 | ALVAREZ AGUDELO XAVIER | Barrio rosaleda | 5882104 | xavieralvarez@gmail.com | +--------------+---------------------------------+-------------------------------+----------+-----------------------------+ 12 rows in set (0.001 sec) MariaDB [escuela]> show tables; +-------------------+ | Tables_in_escuela | +-------------------+ | estudiante | +-------------------+ 1 row in set (0.001 sec) MariaDB [escuela]> create table ACUDIENTE -> (idacudiente varchar(20) not null primary key, -> nombre varchar(60) not null, -> direccion varchar(60) not null, -> telefono varchar(15) not null, -> email varchar(60) not null); Query OK, 0 rows affected (0.342 sec) MariaDB [escuela]> create table PROFESOR -> (idprofesor varchar(20) not null primary key, -> nombre varchar(60) not null, -> direccion varchar(60) not null, -> telefono varchar(15) not null, -> email varchar(60) not null); Query OK, 0 rows affected (0.445 sec) MariaDB [escuela]> show tables; +-------------------+ | Tables_in_escuela | +-------------------+ | acudiente | | estudiante | | profesor | +-------------------+ 3 rows in set (0.001 sec) MariaDB [escuela]> create table MATERIA -> (idmateria varchar(20) not null primary key, -> nombre varchar(60) not null); Query OK, 0 rows affected (0.581 sec) MariaDB [escuela]> show tables; +-------------------+ | Tables_in_escuela | +-------------------+ | acudiente | | estudiante | | materia | | profesor | +-------------------+ 4 rows in set (0.001 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('001','ACEVEDO CARDONA ESTEBAN','Barrio la pradera','5846069','estebacardona@gmail.com'); Query OK, 1 row affected (0.156 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('002','AGUDELO MANCO DIANA PATRICIA','Barrio rosaleda','5882104','dianapatricia@gmail.com'); Query OK, 1 row affected (0.148 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('003','ZAPATA VALENCIA JORGE','Barrio Aragon','5841998','jorgezapata@gmail.com'); Query OK, 1 row affected (0.133 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('004','VELASQUEZ CANO JENNY ASTRID','Barrio la pradera','2791469','jennyvelasquez@gmail.com'); Query OK, 1 row affected (0.109 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('005','POSADA VASCO ANA','Urbanizacion compartir','2868617','anaposada@gmail.com'); Query OK, 1 row affected (0.090 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('006','ORTIZ PUERTA INDIRA','Urbanizaci½n ciudadela prado ','5841497','indiraortiz@gmail.com'); Query OK, 1 row affected (0.090 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('007','QUINTERO MENESES ADRIANA MARIA','Barrio Sangabriel','5840570','adrianaquintero@gmail.com'); Query OK, 1 row affected (0.139 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('008','MONTOYA RIVERA EDILMA','Barrio la pradera','3767289','edilmamontoya@gmail.com'); Query OK, 1 row affected (0.084 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('009','LOPERA MONSALVE FERNANDO ALONSO','Barrio el limonar 1','5709957','fernandolopera@gmail.com'); Query OK, 1 row affected (0.048 sec) MariaDB [escuela]> insert into acudiente(idacudiente,nombre,direccion,telefono,email) values('010','HENAO RIOS DORA EMILSE','Barrio el limonar2','2866222','dorahenao@gmail.com'); Query OK, 1 row affected (0.081 sec) MariaDB [escuela]> select * from acudiente; +-------------+---------------------------------+-------------------------------+----------+---------------------------+ | idacudiente | nombre | direccion | telefono | email | +-------------+---------------------------------+-------------------------------+----------+---------------------------+ | 001 | ACEVEDO CARDONA ESTEBAN | Barrio la pradera | 5846069 | estebacardona@gmail.com | | 002 | AGUDELO MANCO DIANA PATRICIA | Barrio rosaleda | 5882104 | dianapatricia@gmail.com | | 003 | ZAPATA VALENCIA JORGE | Barrio Aragon | 5841998 | jorgezapata@gmail.com | | 004 | VELASQUEZ CANO JENNY ASTRID | Barrio la pradera | 2791469 | jennyvelasquez@gmail.com | | 005 | POSADA VASCO ANA | Urbanizacion compartir | 2868617 | anaposada@gmail.com | | 006 | ORTIZ PUERTA INDIRA | Urbanizaci½n ciudadela prado | 5841497 | indiraortiz@gmail.com | | 007 | QUINTERO MENESES ADRIANA MARIA | Barrio Sangabriel | 5840570 | adrianaquintero@gmail.com | | 008 | MONTOYA RIVERA EDILMA | Barrio la pradera | 3767289 | edilmamontoya@gmail.com | | 009 | LOPERA MONSALVE FERNANDO ALONSO | Barrio el limonar 1 | 5709957 | fernandolopera@gmail.com | | 010 | HENAO RIOS DORA EMILSE | Barrio el limonar2 | 2866222 | dorahenao@gmail.com | +-------------+---------------------------------+-------------------------------+----------+---------------------------+ 10 rows in set (0.000 sec) MariaDB [escuela]> select * from estudiante; +--------------+---------------------------------+-------------------------------+----------+-----------------------------+ | idestudiante | nombre | direccion | telefono | email | +--------------+---------------------------------+-------------------------------+----------+-----------------------------+ | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | Barrio la pradera | 5846069 | juanestebacardona@gmail.com | | 00002 | ALVAREZ AGUDELO ESTEBAN | Barrio rosaleda | 5882104 | estebanlavarez@gmail.com | | 00003 | ZAPATA CAMPI¾O ISABEL | Barrio Aragon | 5841998 | zapataisabel@gmail.com | | 00004 | VALLE VELASQUEZ SOFIA | Barrio la pradera | 2791469 | sofiavelasquez@gmail.com | | 00005 | MORENO POSADA DIEGO ALEJANDRO | Urbanizacion compartir | 2868617 | diegomoreno@gmail.com | | 00006 | LZATE ORTIZ JORGE MARIO | Urbanizaci½n ciudadela prado | 5841497 | marioalzae@gmail.com | | 00007 | ZAPATA QUINTERO JOSE MARIA | Barrio Sangabriel | 5840570 | josezapata@gmail.com | | 00008 | MNTOYA MONTOYA AEJANDRO | Barrio la pradera | 3767289 | alejandromontoya@gmail.com | | 00009 | LOPERA CARTAGENA LUISA FENANADA | Barrio el limonar 1 | 5709957 | luisalopera@gmail.com | | 00010 | JARAMILLO HENAO JOSE LUIS | Barrio el limonar2 | 2866222 | josearamillo@gmail.com | | 00011 | ALVAREZ AGUDELO LUNA | Barrio rosaleda | 5882104 | lunaalvarez@gmail.com | | 00012 | ALVAREZ AGUDELO XAVIER | Barrio rosaleda | 5882104 | xavieralvarez@gmail.com | +--------------+---------------------------------+-------------------------------+----------+-----------------------------+ 12 rows in set (0.000 sec) MariaDB [escuela]> insert into profesor(idprofesor,nombre,direccion,telefono,email) values('001','','CIFUENTES MESA MYEIDY MARIA','','myleidym.iearm@gmail.com'); Query OK, 1 row affected (0.057 sec) MariaDB [escuela]> select * from profesor; +------------+--------+-----------------------------+----------+--------------------------+ | idprofesor | nombre | direccion | telefono | email | +------------+--------+-----------------------------+----------+--------------------------+ | 001 | | CIFUENTES MESA MYEIDY MARIA | | myleidym.iearm@gmail.com | +------------+--------+-----------------------------+----------+--------------------------+ 1 row in set (0.000 sec) MariaDB [escuela]> drop table profesor; Query OK, 0 rows affected (0.200 sec) MariaDB [escuela]> show tables; +-------------------+ | Tables_in_escuela | +-------------------+ | acudiente | | estudiante | | materia | +-------------------+ 3 rows in set (0.001 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('01','EspaÏol'); Query OK, 1 row affected (0.165 sec) MariaDB [escuela]> select * from materia; +-----------+---------+ | idmateria | nombre | +-----------+---------+ | 01 | EspaÏol | +-----------+---------+ 1 row in set (0.001 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('02','Lectoescritura'); Query OK, 1 row affected (0.079 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('03','Matematicas'); Query OK, 1 row affected (0.086 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('04','Ciencias Naturales'); Query OK, 1 row affected (0.083 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('05','Investigacion'); Query OK, 1 row affected (0.044 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('06','Fisica'); Query OK, 1 row affected (0.092 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('07','Filosofia'); Query OK, 1 row affected (0.091 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('08','Educacion Fisica'); Query OK, 1 row affected (0.164 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('09','Etica'); Query OK, 1 row affected (0.088 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('10','Artistica'); Query OK, 1 row affected (0.087 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('11','Tecnologia'); Query OK, 1 row affected (0.078 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('12','Informatica'); Query OK, 1 row affected (0.082 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('13','Religion'); Query OK, 1 row affected (0.093 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('14','Sociales'); Query OK, 1 row affected (0.160 sec) MariaDB [escuela]> insert into materia(idmateria,nombre) values('15','Ingles'); Query OK, 1 row affected (0.048 sec) MariaDB [escuela]> select * from materia; +-----------+--------------------+ | idmateria | nombre | +-----------+--------------------+ | 01 | EspaÏol | | 02 | Lectoescritura | | 03 | Matematicas | | 04 | Ciencias Naturales | | 05 | Investigacion | | 06 | Fisica | | 07 | Filosofia | | 08 | Educacion Fisica | | 09 | Etica | | 10 | Artistica | | 11 | Tecnologia | | 12 | Informatica | | 13 | Religion | | 14 | Sociales | | 15 | Ingles | +-----------+--------------------+ 15 rows in set (0.000 sec) MariaDB [escuela]> show tables; +-------------------+ | Tables_in_escuela | +-------------------+ | acudiente | | estudiante | | materia | +-------------------+ 3 rows in set (0.001 sec) MariaDB [escuela]> create table PROFESOR -> (idprofesor varchar(20) not null primary key, -> nombre varchar(60) not null, -> direccion varchar(60) not null, -> telefono varchar(15) not null, -> email varchar(60) not null); Query OK, 0 rows affected (0.405 sec) MariaDB [escuela]> insert into profesor(idprofesor,nombre,direccion,telefono,email) values('001','CIFUENTES MESA MYEIDY MARIA','','','myleidym.iearm@gmail.com'); Query OK, 1 row affected (0.151 sec) MariaDB [escuela]> select * from profesor; +------------+-----------------------------+-----------+----------+--------------------------+ | idprofesor | nombre | direccion | telefono | email | +------------+-----------------------------+-----------+----------+--------------------------+ | 001 | CIFUENTES MESA MYEIDY MARIA | | | myleidym.iearm@gmail.com | +------------+-----------------------------+-----------+----------+--------------------------+ 1 row in set (0.000 sec) MariaDB [escuela]> insert into profesor(idprofesor,nombre,direccion,telefono,email) values('002','CUADRADO PEREZ ADRID JOSE','','','adrid.iearm@gmail.com'); Query OK, 1 row affected (0.095 sec) MariaDB [escuela]> insert into profesor(idprofesor,nombre,direccion,telefono,email) values('003','DUQUE RESTREPO ESTER LUCIA','','','esterl.iearm@gmail.com'); Query OK, 1 row affected (0.041 sec) MariaDB [escuela]> insert into profesor(idprofesor,nombre,direccion,telefono,email) values('004','GUIRALES MAURICIO','','','mauriciog.iearm@gmail.com'); Query OK, 1 row affected (0.042 sec) MariaDB [escuela]> insert into profesor(idprofesor,nombre,direccion,telefono,email) values('005','VERA DAZA MARIA ELENA','','','mauriciog.iearm@gmail.com'); Query OK, 1 row affected (0.031 sec) MariaDB [escuela]> insert into profesor(idprofesor,nombre,direccion,telefono,email) values('006','PALACIO TOMAS FELIPE','','','tomasf.iearm@gmail.com'); Query OK, 1 row affected (0.144 sec) MariaDB [escuela]> insert into profesor(idprofesor,nombre,direccion,telefono,email) values('007','MOSUERA OSORIO MARYETH','','','maryeth.iearm@gmail.com'); Query OK, 1 row affected (0.033 sec) MariaDB [escuela]> insert into profesor(idprofesor,nombre,direccion,telefono,email) values('008','ARBOLEDA VARGAS MARIA OFELIA','','','ofeliaa.iearm@gmail.com'); Query OK, 1 row affected (0.156 sec) MariaDB [escuela]> insert into profesor(idprofesor,nombre,direccion,telefono,email) values('009','MOSCOTE MARULANDA YANET MARIA','','','yanetm.iearm@gmail.com'); Query OK, 1 row affected (0.151 sec) MariaDB [escuela]> insert into profesor(idprofesor,nombre,direccion,telefono,email) values('010','MACIAS EDGAR ALBERTO','','','edgarm.iearm@gmail.com'); Query OK, 1 row affected (0.145 sec) MariaDB [escuela]> select * from profesor; +------------+-------------------------------+-----------+----------+---------------------------+ | idprofesor | nombre | direccion | telefono | email | +------------+-------------------------------+-----------+----------+---------------------------+ | 001 | CIFUENTES MESA MYEIDY MARIA | | | myleidym.iearm@gmail.com | | 002 | CUADRADO PEREZ ADRID JOSE | | | adrid.iearm@gmail.com | | 003 | DUQUE RESTREPO ESTER LUCIA | | | esterl.iearm@gmail.com | | 004 | GUIRALES MAURICIO | | | mauriciog.iearm@gmail.com | | 005 | VERA DAZA MARIA ELENA | | | mauriciog.iearm@gmail.com | | 006 | PALACIO TOMAS FELIPE | | | tomasf.iearm@gmail.com | | 007 | MOSUERA OSORIO MARYETH | | | maryeth.iearm@gmail.com | | 008 | ARBOLEDA VARGAS MARIA OFELIA | | | ofeliaa.iearm@gmail.com | | 009 | MOSCOTE MARULANDA YANET MARIA | | | yanetm.iearm@gmail.com | | 010 | MACIAS EDGAR ALBERTO | | | edgarm.iearm@gmail.com | +------------+-------------------------------+-----------+----------+---------------------------+ 10 rows in set (0.000 sec) MariaDB [escuela]> show tables; +-------------------+ | Tables_in_escuela | +-------------------+ | acudiente | | estudiante | | materia | | profesor | +-------------------+ 4 rows in set (0.001 sec) MariaDB [escuela]> select * from acudiente; +-------------+---------------------------------+-------------------------------+----------+---------------------------+ | idacudiente | nombre | direccion | telefono | email | +-------------+---------------------------------+-------------------------------+----------+---------------------------+ | 001 | ACEVEDO CARDONA ESTEBAN | Barrio la pradera | 5846069 | estebacardona@gmail.com | | 002 | AGUDELO MANCO DIANA PATRICIA | Barrio rosaleda | 5882104 | dianapatricia@gmail.com | | 003 | ZAPATA VALENCIA JORGE | Barrio Aragon | 5841998 | jorgezapata@gmail.com | | 004 | VELASQUEZ CANO JENNY ASTRID | Barrio la pradera | 2791469 | jennyvelasquez@gmail.com | | 005 | POSADA VASCO ANA | Urbanizacion compartir | 2868617 | anaposada@gmail.com | | 006 | ORTIZ PUERTA INDIRA | Urbanizaci½n ciudadela prado | 5841497 | indiraortiz@gmail.com | | 007 | QUINTERO MENESES ADRIANA MARIA | Barrio Sangabriel | 5840570 | adrianaquintero@gmail.com | | 008 | MONTOYA RIVERA EDILMA | Barrio la pradera | 3767289 | edilmamontoya@gmail.com | | 009 | LOPERA MONSALVE FERNANDO ALONSO | Barrio el limonar 1 | 5709957 | fernandolopera@gmail.com | | 010 | HENAO RIOS DORA EMILSE | Barrio el limonar2 | 2866222 | dorahenao@gmail.com | +-------------+---------------------------------+-------------------------------+----------+---------------------------+ 10 rows in set (0.001 sec) MariaDB [escuela]> select * from estudiante; +--------------+---------------------------------+-------------------------------+----------+-----------------------------+ | idestudiante | nombre | direccion | telefono | email | +--------------+---------------------------------+-------------------------------+----------+-----------------------------+ | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | Barrio la pradera | 5846069 | juanestebacardona@gmail.com | | 00002 | ALVAREZ AGUDELO ESTEBAN | Barrio rosaleda | 5882104 | estebanlavarez@gmail.com | | 00003 | ZAPATA CAMPI¾O ISABEL | Barrio Aragon | 5841998 | zapataisabel@gmail.com | | 00004 | VALLE VELASQUEZ SOFIA | Barrio la pradera | 2791469 | sofiavelasquez@gmail.com | | 00005 | MORENO POSADA DIEGO ALEJANDRO | Urbanizacion compartir | 2868617 | diegomoreno@gmail.com | | 00006 | LZATE ORTIZ JORGE MARIO | Urbanizaci½n ciudadela prado | 5841497 | marioalzae@gmail.com | | 00007 | ZAPATA QUINTERO JOSE MARIA | Barrio Sangabriel | 5840570 | josezapata@gmail.com | | 00008 | MNTOYA MONTOYA AEJANDRO | Barrio la pradera | 3767289 | alejandromontoya@gmail.com | | 00009 | LOPERA CARTAGENA LUISA FENANADA | Barrio el limonar 1 | 5709957 | luisalopera@gmail.com | | 00010 | JARAMILLO HENAO JOSE LUIS | Barrio el limonar2 | 2866222 | josearamillo@gmail.com | | 00011 | ALVAREZ AGUDELO LUNA | Barrio rosaleda | 5882104 | lunaalvarez@gmail.com | | 00012 | ALVAREZ AGUDELO XAVIER | Barrio rosaleda | 5882104 | xavieralvarez@gmail.com | +--------------+---------------------------------+-------------------------------+----------+-----------------------------+ 12 rows in set (0.001 sec) MariaDB [escuela]> select * from profesor; +------------+-------------------------------+-----------+----------+---------------------------+ | idprofesor | nombre | direccion | telefono | email | +------------+-------------------------------+-----------+----------+---------------------------+ | 001 | CIFUENTES MESA MYEIDY MARIA | | | myleidym.iearm@gmail.com | | 002 | CUADRADO PEREZ ADRID JOSE | | | adrid.iearm@gmail.com | | 003 | DUQUE RESTREPO ESTER LUCIA | | | esterl.iearm@gmail.com | | 004 | GUIRALES MAURICIO | | | mauriciog.iearm@gmail.com | | 005 | VERA DAZA MARIA ELENA | | | mauriciog.iearm@gmail.com | | 006 | PALACIO TOMAS FELIPE | | | tomasf.iearm@gmail.com | | 007 | MOSUERA OSORIO MARYETH | | | maryeth.iearm@gmail.com | | 008 | ARBOLEDA VARGAS MARIA OFELIA | | | ofeliaa.iearm@gmail.com | | 009 | MOSCOTE MARULANDA YANET MARIA | | | yanetm.iearm@gmail.com | | 010 | MACIAS EDGAR ALBERTO | | | edgarm.iearm@gmail.com | +------------+-------------------------------+-----------+----------+---------------------------+ 10 rows in set (0.001 sec) MariaDB [escuela]> select * from materia; +-----------+--------------------+ | idmateria | nombre | +-----------+--------------------+ | 01 | EspaÏol | | 02 | Lectoescritura | | 03 | Matematicas | | 04 | Ciencias Naturales | | 05 | Investigacion | | 06 | Fisica | | 07 | Filosofia | | 08 | Educacion Fisica | | 09 | Etica | | 10 | Artistica | | 11 | Tecnologia | | 12 | Informatica | | 13 | Religion | | 14 | Sociales | | 15 | Ingles | +-----------+--------------------+ 15 rows in set (0.001 sec) MariaDB [escuela]> create table ESTUDIANTE_ACUDIENTE -> (idacudiente varchar(20) not null, -> idestudiante varchar(20) not null, -> foreign key(idacudiente) references acudiente(idacudiente) 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 '' at line 4 MariaDB [escuela]> show tables; +-------------------+ | Tables_in_escuela | +-------------------+ | acudiente | | estudiante | | materia | | profesor | +-------------------+ 4 rows in set (0.001 sec) MariaDB [escuela]> create table ESTUDIANTE_ACUDIENTE -> (idacudiente varchar(20) not null, -> idestudiante varchar(20) not null, -> foreign key(idacudiente) references acudiente(idacudiente) on delete cascade on update cascade, -> foreign key(idestudiante) references estudiante(idestudiante) on delete cascade on update cascade); Query OK, 0 rows affected (0.347 sec) MariaDB [escuela]> create table MATERIA_PROFESOR -> (idmateria varchar(20) not null, -> idprofesor varchar(20) not null, -> foreign key(idmateria) references materia(idmateria) on delete cascade on update cascade, -> foreign key(idprofesor) references profesor(idprofesor) on delete cascade on update cascade); Query OK, 0 rows affected (0.354 sec) MariaDB [escuela]> show tables; +----------------------+ | Tables_in_escuela | +----------------------+ | acudiente | | estudiante | | estudiante_acudiente | | materia | | materia_profesor | | profesor | +----------------------+ 6 rows in set (0.001 sec) MariaDB [escuela]> describe estudiante_acudiente; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | idacudiente | varchar(20) | NO | MUL | NULL | | | idestudiante | varchar(20) | NO | MUL | NULL | | +--------------+-------------+------+-----+---------+-------+ 2 rows in set (1.093 sec) MariaDB [escuela]> insert into estudiante_acudiente(idacudiente,idestudiante) values('001','00001'); Query OK, 1 row affected (0.217 sec) MariaDB [escuela]> select * from estudiante_acudiente; +-------------+--------------+ | idacudiente | idestudiante | +-------------+--------------+ | 001 | 00001 | +-------------+--------------+ 1 row in set (0.000 sec) MariaDB [escuela]> insert into estudiante_acudiente(idacudiente,idestudiante) values('002','00002'); Query OK, 1 row affected (0.149 sec) MariaDB [escuela]> insert into estudiante_acudiente(idacudiente,idestudiante) values('003','00003'); Query OK, 1 row affected (0.148 sec) MariaDB [escuela]> insert into estudiante_acudiente(idacudiente,idestudiante) values('004','00004'); Query OK, 1 row affected (0.147 sec) MariaDB [escuela]> insert into estudiante_acudiente(idacudiente,idestudiante) values('005','00005'); Query OK, 1 row affected (0.044 sec) MariaDB [escuela]> insert into estudiante_acudiente(idacudiente,idestudiante) values('006','00006'); Query OK, 1 row affected (0.166 sec) MariaDB [escuela]> insert into estudiante_acudiente(idacudiente,idestudiante) values('007','00007'); Query OK, 1 row affected (0.146 sec) MariaDB [escuela]> insert into estudiante_acudiente(idacudiente,idestudiante) values('008','00008'); Query OK, 1 row affected (0.037 sec) MariaDB [escuela]> insert into estudiante_acudiente(idacudiente,idestudiante) values('009','00009'); Query OK, 1 row affected (0.030 sec) MariaDB [escuela]> insert into estudiante_acudiente(idacudiente,idestudiante) values('010','00010'); Query OK, 1 row affected (0.147 sec) MariaDB [escuela]> insert into estudiante_acudiente(idacudiente,idestudiante) values('001','00011'); Query OK, 1 row affected (0.163 sec) MariaDB [escuela]> insert into estudiante_acudiente(idacudiente,idestudiante) values('001','00012'); Query OK, 1 row affected (0.148 sec) MariaDB [escuela]> select * from estudiante_acudiente; +-------------+--------------+ | idacudiente | idestudiante | +-------------+--------------+ | 001 | 00001 | | 002 | 00002 | | 003 | 00003 | | 004 | 00004 | | 005 | 00005 | | 006 | 00006 | | 007 | 00007 | | 008 | 00008 | | 009 | 00009 | | 010 | 00010 | | 001 | 00011 | | 001 | 00012 | +-------------+--------------+ 12 rows in set (0.000 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('01','005'); Query OK, 1 row affected (0.149 sec) MariaDB [escuela]> select * from materia_profesor; +-----------+------------+ | idmateria | idprofesor | +-----------+------------+ | 01 | 005 | +-----------+------------+ 1 row in set (0.001 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('02','007'); Query OK, 1 row affected (0.070 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('03','009'); Query OK, 1 row affected (0.145 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('04','003'); Query OK, 1 row affected (0.165 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('05','003'); Query OK, 1 row affected (0.095 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('06','003'); Query OK, 1 row affected (0.145 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('07','001'); Query OK, 1 row affected (0.049 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('08','010'); Query OK, 1 row affected (0.161 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('09','006'); Query OK, 1 row affected (0.082 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('10','004'); Query OK, 1 row affected (0.084 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('11','002'); Query OK, 1 row affected (0.120 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('12','002'); Query OK, 1 row affected (0.050 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('13','006'); Query OK, 1 row affected (0.140 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('14','007'); Query OK, 1 row affected (0.115 sec) MariaDB [escuela]> insert into materia_profesor(idmateria,idprofesor) values('15','008'); Query OK, 1 row affected (0.086 sec) MariaDB [escuela]> select * from materia_profesor; +-----------+------------+ | idmateria | idprofesor | +-----------+------------+ | 01 | 005 | | 02 | 007 | | 03 | 009 | | 04 | 003 | | 05 | 003 | | 06 | 003 | | 07 | 001 | | 08 | 010 | | 09 | 006 | | 10 | 004 | | 11 | 002 | | 12 | 002 | | 13 | 006 | | 14 | 007 | | 15 | 008 | +-----------+------------+ 15 rows in set (0.000 sec) MariaDB [escuela]> show tables; +----------------------+ | Tables_in_escuela | +----------------------+ | acudiente | | estudiante | | estudiante_acudiente | | materia | | materia_profesor | | profesor | +----------------------+ 6 rows in set (0.001 sec) MariaDB [escuela]> create table ESTUDIANTE_MATERIA -> (idestudiante varchar(20) not null, -> idmateria varchar(20) not null, -> foreign key(idestudiante) references estudiante(idestudiante) on delete cascade on update cascade, -> foreign key(idmateria) references materia(idmateria) on delete cascade on update cascade); Query OK, 0 rows affected (0.482 sec) MariaDB [escuela]> show tables; +----------------------+ | Tables_in_escuela | +----------------------+ | acudiente | | estudiante | | estudiante_acudiente | | estudiante_materia | | materia | | materia_profesor | | profesor | +----------------------+ 7 rows in set (0.001 sec) MariaDB [escuela]> describe estudiante_materia01 -> describe estudiante_materia; 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 'describe estudiante_materia' at line 2 MariaDB [escuela]> describe ESTUDIANTE_MATERIA; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | idestudiante | varchar(20) | NO | MUL | NULL | | | idmateria | varchar(20) | NO | MUL | NULL | | +--------------+-------------+------+-----+---------+-------+ 2 rows in set (0.052 sec) MariaDB [escuela]> insert into estudiante_materia01(idestudiante,idmateria) values('00001','01'); ERROR 1146 (42S02): Table 'escuela.estudiante_materia01' doesn't exist MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','01'); Query OK, 1 row affected (0.121 sec) MariaDB [escuela]> from estudiante_materia; 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 estudiante_materia' at line 1 MariaDB [escuela]> select * from estudiante_materia; +--------------+-----------+ | idestudiante | idmateria | +--------------+-----------+ | 00001 | 01 | +--------------+-----------+ 1 row in set (0.001 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','02'); Query OK, 1 row affected (0.045 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','03'); Query OK, 1 row affected (0.095 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','04'); Query OK, 1 row affected (0.150 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','05'); Query OK, 1 row affected (0.156 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','06'); Query OK, 1 row affected (0.304 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','07'); Query OK, 1 row affected (0.046 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','08'); Query OK, 1 row affected (0.039 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','09'); Query OK, 1 row affected (0.154 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','10'); Query OK, 1 row affected (0.046 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','11'); Query OK, 1 row affected (0.062 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','12'); Query OK, 1 row affected (0.149 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','13'); Query OK, 1 row affected (0.042 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','14'); Query OK, 1 row affected (0.150 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00001','15'); Query OK, 1 row affected (0.157 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00002','01'); Query OK, 1 row affected (0.155 sec) MariaDB [escuela]> insert into estudiante_materia(idestudiante,idmateria) values('00002','03'); Query OK, 1 row affected (0.163 sec) MariaDB [escuela]> describe estudiante_materia01 -> ; ERROR 1146 (42S02): Table 'escuela.estudiante_materia01' doesn't exist MariaDB [escuela]> describe estudiante_materia; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | idestudiante | varchar(20) | NO | MUL | NULL | | | idmateria | varchar(20) | NO | MUL | NULL | | +--------------+-------------+------+-----+---------+-------+ 2 rows in set (0.048 sec) MariaDB [escuela]> select * from estudiante_materia; +--------------+-----------+ | idestudiante | idmateria | +--------------+-----------+ | 00001 | 01 | | 00001 | 02 | | 00001 | 03 | | 00001 | 04 | | 00001 | 05 | | 00001 | 06 | | 00001 | 07 | | 00001 | 08 | | 00001 | 09 | | 00001 | 10 | | 00001 | 11 | | 00001 | 12 | | 00001 | 13 | | 00001 | 14 | | 00001 | 15 | | 00002 | 01 | | 00002 | 03 | +--------------+-----------+ 17 rows in set (0.001 sec) MariaDB [escuela]> exit