Microsoft Windows [Versión 10.0.17763.1] (c) 2018 Microsoft Corporation. Todos los derechos reservados. C:\Users\KHANDENY>C: C:\Users\KHANDENY>cd/xammp/mysql/bin El sistema no puede encontrar la ruta especificada. C:\Users\KHANDENY>cd/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.20-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 "C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql"; ERROR: Failed to open file '"C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql"', error: 13 MariaDB [(none)]> source "C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql" ERROR: Failed to open file '"C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql"', error: 13 MariaDB [(none)]> source "C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql"; ERROR: Failed to open file '"C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql"', error: 13 MariaDB [(none)]> "C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql" -> ; 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 '"C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql"' at line 1 MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | libreria | | libreria2 | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 7 rows in set (0.110 sec) MariaDB [(none)]> C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql ERROR: Unknown command '\U'. ERROR: Unknown command '\K'. ERROR: Unknown command '\D'. ERROR: Unknown command '\b'. ERROR: Unknown command '\i'. -> ; 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 'C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql' at line 1 MariaDB [(none)]> "C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql"; 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 '"C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql"' at line 1 MariaDB [(none)]> source "C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql"; ERROR: Failed to open file '"C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql"', error: 13 MariaDB [(none)]> source C:\Users\KHANDENY\Desktop\bd matricula\informacion_de_matricula.sql; ERROR: Unknown command '\U'. ERROR: Unknown command '\K'. ERROR: Unknown command '\D'. ERROR: Unknown command '\b'. ERROR: Unknown command '\i'. Query OK, 0 rows affected (0.106 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.014 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 1 row affected (0.011 sec) Database changed Query OK, 0 rows affected (0.065 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.212 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.003 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 10 rows affected (0.036 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.062 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.232 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.299 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.003 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.754 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.003 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.339 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.004 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.219 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (2.711 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.003 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) MariaDB [informacion_de_matricula]> show databases; +--------------------------+ | Database | +--------------------------+ | informacion_de_matricula | | information_schema | | libreria | | libreria2 | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------------+ 8 rows in set (0.001 sec) MariaDB [informacion_de_matricula]> use informacion_de_mazt ERROR 1049 (42000): Unknown database 'informacion_de_mazt' MariaDB [informacion_de_matricula]> use informacion_de_matricula; Database changed MariaDB [informacion_de_matricula]> show tables; +------------------------------------+ | Tables_in_informacion_de_matricula | +------------------------------------+ | acudiente | | estudiante | | estudiante_acudiente | | estudiante_materia | | materia | | materia_profesor | | profesor | +------------------------------------+ 7 rows in set (0.001 sec) MariaDB [informacion_de_matricula]> describe acudiente; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigo | int(16) | NO | | NULL | | | nombre | varchar(80) | NO | | NULL | | | direccion | varchar(45) | NO | | NULL | | | telefono | int(11) | NO | | NULL | | | mail | varchar(60) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.010 sec) MariaDB [informacion_de_matricula]> describe estudiante; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigo | int(16) | NO | | NULL | | | nombre | varchar(80) | NO | | NULL | | | direccion | varchar(45) | NO | | NULL | | | telefono | int(11) | NO | | NULL | | | mail | varchar(60) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.027 sec) MariaDB [informacion_de_matricula]> describe estudiante_acudiente; +----------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------+------+-----+---------+-------+ | cod_acudiente | varchar(5) | NO | | NULL | | | cod_estudiante | varchar(8) | NO | | NULL | | +----------------+------------+------+-----+---------+-------+ 2 rows in set (0.009 sec) MariaDB [informacion_de_matricula]> select * from acudiente; +--------+----------------------------------+------------------------------+----------+---------------------------+ | codigo | nombre | direccion | telefono | mail | +--------+----------------------------------+------------------------------+----------+---------------------------+ | 1 | ACEVEDO CARDONA ESTEBAN | Barrio la pradera | 5846069 | estebacardona@gmail.com | | 2 | AGUDELO MANCO DIANA PATRICIA | Barrio rosaleda | 5882104 | dianapatricia@gmail.com | | 3 | ZAPATA VALENCIA JORGE | Barrio Aragon | 5841998 | jorgezapata@gmail.com | | 4 | VELASQUEZ CANO JENNY ASTRID | Barrio la pradera | 2791469 | jennyvelasquez@gmail.com | | 5 | POSADA VASCO ANA | Urbanizacion compartir | 2868617 | anaposada@gmail.com | | 6 | ORTIZ PUERTA INDIRA | Urbanizacion ciudadela prado | 5841497 | indiraortiz@gmail.com | | 7 | QUINTERO MENESES ADRIANA MARIANA | Barrio Sangabriel | 5840570 | adrianaquintero@gmail.com | | 8 | MONTOYA RIVERA EDILMA | Barrio la pradera | 3767289 | edilmamontoya@gmail.com | | 9 | LOPERA MONSALVE FERNANDO ALONSO | Barrio el limonar 1 | 5709957 | fernandolopera@gmail.com | | 10 | HENAO RIOS DORA EMILSE | Barrio el limonar 2 | 2866222 | dorahenao@gmail.com | +--------+----------------------------------+------------------------------+----------+---------------------------+ 10 rows in set (0.065 sec) MariaDB [informacion_de_matricula]> select * from estudiante; Empty set (0.001 sec) MariaDB [informacion_de_matricula]> describe estudiante; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigo | int(16) | NO | | NULL | | | nombre | varchar(80) | NO | | NULL | | | direccion | varchar(45) | NO | | NULL | | | telefono | int(11) | NO | | NULL | | | mail | varchar(60) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.007 sec) MariaDB [informacion_de_matricula]> insert into estudiante(codigo,nombre,direccion,telefono,mail) values (00001, 'ACEVEDO BURITICA JUAN ESTEBAN','Barrio la pradera',5846069,'juanestebacardona@gmail.com'); Query OK, 1 row affected (0.114 sec) MariaDB [informacion_de_matricula]> insert into estudiante(codigo,nombre,direccion,telefono,mail) values (00002, 'ALVAREZ AGUDELO ESTEBAN','Barrio rosaleda',5882104,'estebanlavarez@gmail.com'); Query OK, 1 row affected (0.103 sec) MariaDB [informacion_de_matricula]> insert into estudiante(codigo,nombre,direccion,telefono,mail) values (00003, 'ZAPATA CAMPIÑO ISABEL','Barrio Aragon',5841998,'zapataisabel@gmail.com'); Query OK, 1 row affected (0.044 sec) MariaDB [informacion_de_matricula]> insert into estudiante(codigo,nombre,direccion,telefono,mail) values (00004, 'VALLE VELASQUEZ SOFIA','Barrio la pradera',2791469,'sofiavelasquez@gmail.com'); Query OK, 1 row affected (0.127 sec) MariaDB [informacion_de_matricula]> insert into estudiante(codigo,nombre,direccion,telefono,mail) values (00005, 'MORENO POSADA DIEGO ALEJANDRO','Urbanizacion compartir',2868617,'diegomoreno@gmail.com'); Query OK, 1 row affected (0.175 sec) MariaDB [informacion_de_matricula]> insert into estudiante(codigo,nombre,direccion,telefono,mail) values (00006,'ALZATE ORTIZ JORGE MARIO','Urbanizacion ciudadela prado',5841497,'marioalzae@gmail.com'); Query OK, 1 row affected (0.105 sec) MariaDB [informacion_de_matricula]> insert into estudiante(codigo,nombre,direccion,telefono,mail) values (00007,'ZAPATA QUINTERO JOSE MARIA','Barrio Sangabriel',5840570,'josezapata@gmail.com'); Query OK, 1 row affected (0.093 sec) MariaDB [informacion_de_matricula]> insert into estudiante(codigo,nombre,direccion,telefono,mail) values (00008,'MONTOYA MONTOYA ALEJANDRO','Barrio la pradera',3767289,'alejandromontoya@gmail.com'); Query OK, 1 row affected (0.099 sec) MariaDB [informacion_de_matricula]> insert into estudiante(codigo,nombre,direccion,telefono,mail) values (00009,'LOPERA CARTAGENA LUISA FERNANDA','Barrio el limonar 1',5709957,'luisalopera@gmail.com'); Query OK, 1 row affected (0.109 sec) MariaDB [informacion_de_matricula]> insert into estudiante(codigo,nombre,direccion,telefono,mail) values (00010,'JARAMILLO HENAO JOSE LUIS','Barrio el limonar 2',2866222,'josearamillo@gmail.com'); Query OK, 1 row affected (0.102 sec) MariaDB [informacion_de_matricula]> insert into estudiante(codigo,nombre,direccion,telefono,mail) values (00011,'ALVAREZ AGUDELO LUNA','Barrio rosaleda',5882104,'lunaalvarez@gmail.com'); Query OK, 1 row affected (0.102 sec) MariaDB [informacion_de_matricula]> insert into estudiante(codigo,nombre,direccion,telefono,mail) values (00012,'ALVAREZ AGUDELO XAVIER','Barrio rosaleda',5882104,'xavieralvarez@gmail.com'); Query OK, 1 row affected (0.102 sec) MariaDB [informacion_de_matricula]> select * from estudiantes; ERROR 1146 (42S02): Table 'informacion_de_matricula.estudiantes' doesn't exist MariaDB [informacion_de_matricula]> select * from estudiante; +--------+---------------------------------+------------------------------+----------+-----------------------------+ | codigo | nombre | direccion | telefono | mail | +--------+---------------------------------+------------------------------+----------+-----------------------------+ | 1 | ACEVEDO BURITICA JUAN ESTEBAN | Barrio la pradera | 5846069 | juanestebacardona@gmail.com | | 2 | ALVAREZ AGUDELO ESTEBAN | Barrio rosaleda | 5882104 | estebanlavarez@gmail.com | | 3 | ZAPATA CAMPIÑO ISABEL | Barrio Aragon | 5841998 | zapataisabel@gmail.com | | 4 | VALLE VELASQUEZ SOFIA | Barrio la pradera | 2791469 | sofiavelasquez@gmail.com | | 5 | MORENO POSADA DIEGO ALEJANDRO | Urbanizacion compartir | 2868617 | diegomoreno@gmail.com | | 6 | ALZATE ORTIZ JORGE MARIO | Urbanizacion ciudadela prado | 5841497 | marioalzae@gmail.com | | 7 | ZAPATA QUINTERO JOSE MARIA | Barrio Sangabriel | 5840570 | josezapata@gmail.com | | 8 | MONTOYA MONTOYA ALEJANDRO | Barrio la pradera | 3767289 | alejandromontoya@gmail.com | | 9 | LOPERA CARTAGENA LUISA FERNANDA | Barrio el limonar 1 | 5709957 | luisalopera@gmail.com | | 10 | JARAMILLO HENAO JOSE LUIS | Barrio el limonar 2 | 2866222 | josearamillo@gmail.com | | 11 | ALVAREZ AGUDELO LUNA | Barrio rosaleda | 5882104 | lunaalvarez@gmail.com | | 12 | ALVAREZ AGUDELO XAVIER | Barrio rosaleda | 5882104 | xavieralvarez@gmail.com | +--------+---------------------------------+------------------------------+----------+-----------------------------+ 12 rows in set (0.001 sec) MariaDB [informacion_de_matricula]> show tables; +------------------------------------+ | Tables_in_informacion_de_matricula | +------------------------------------+ | acudiente | | estudiante | | estudiante_acudiente | | estudiante_materia | | materia | | materia_profesor | | profesor | +------------------------------------+ 7 rows in set (0.001 sec) MariaDB [informacion_de_matricula]> describe estudiante_acudiente; +----------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------+------+-----+---------+-------+ | cod_acudiente | varchar(5) | NO | | NULL | | | cod_estudiante | varchar(8) | NO | | NULL | | +----------------+------------+------+-----+---------+-------+ 2 rows in set (0.005 sec) MariaDB [informacion_de_matricula]> insert into estudiante_acudiente(cod_acudiente,cod_estudiante) values ('001','00001'); Query OK, 1 row affected (0.157 sec) MariaDB [informacion_de_matricula]> insert into estudiante_acudiente(cod_acudiente,cod_estudiante) values ('002','00002'); Query OK, 1 row affected (0.130 sec) MariaDB [informacion_de_matricula]> insert into estudiante_acudiente(cod_acudiente,cod_estudiante) values ('003','00003'); Query OK, 1 row affected (0.098 sec) MariaDB [informacion_de_matricula]> insert into estudiante_acudiente(cod_acudiente,cod_estudiante) values ('004','00004'); Query OK, 1 row affected (0.105 sec) MariaDB [informacion_de_matricula]> insert into estudiante_acudiente(cod_acudiente,cod_estudiante) values ('005','00005'); Query OK, 1 row affected (0.101 sec) MariaDB [informacion_de_matricula]> insert into estudiante_acudiente(cod_acudiente,cod_estudiante) values ('006','00006'); Query OK, 1 row affected (0.117 sec) MariaDB [informacion_de_matricula]> MariaDB [informacion_de_matricula]> insert into estudiante_acudiente(cod_acudiente,cod_estudiante) values ('007','00007'); Query OK, 1 row affected (0.096 sec) MariaDB [informacion_de_matricula]> insert into estudiante_acudiente(cod_acudiente,cod_estudiante) values ('008','00008'); Query OK, 1 row affected (0.151 sec) MariaDB [informacion_de_matricula]> insert into estudiante_acudiente(cod_acudiente,cod_estudiante) values ('009','00009'); Query OK, 1 row affected (0.093 sec) MariaDB [informacion_de_matricula]> insert into estudiante_acudiente(cod_acudiente,cod_estudiante) values ('010','00010'); Query OK, 1 row affected (0.107 sec) MariaDB [informacion_de_matricula]> insert into estudiante_acudiente(cod_acudiente,cod_estudiante) values ('001','00011'); Query OK, 1 row affected (0.096 sec) MariaDB [informacion_de_matricula]> insert into estudiante_acudiente(cod_acudiente,cod_estudiante) values ('001','00012'); Query OK, 1 row affected (0.090 sec) MariaDB [informacion_de_matricula]> select * from estudiante_acudiente; +---------------+----------------+ | cod_acudiente | cod_estudiante | +---------------+----------------+ | 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.001 sec) MariaDB [informacion_de_matricula]> show tables; +------------------------------------+ | Tables_in_informacion_de_matricula | +------------------------------------+ | acudiente | | estudiante | | estudiante_acudiente | | estudiante_materia | | materia | | materia_profesor | | profesor | +------------------------------------+ 7 rows in set (0.001 sec) MariaDB [informacion_de_matricula]> describe estudiante_matria; ERROR 1146 (42S02): Table 'informacion_de_matricula.estudiante_matria' doesn't exist MariaDB [informacion_de_matricula]> describe estudiante_materia; +----------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------+------+-----+---------+-------+ | cod_estudiante | varchar(5) | NO | | NULL | | | cod_materia | varchar(8) | NO | | NULL | | +----------------+------------+------+-----+---------+-------+ 2 rows in set (0.062 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','01'); Query OK, 1 row affected (0.093 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','02'); Query OK, 1 row affected (0.090 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','03'); Query OK, 1 row affected (0.083 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','04'); Query OK, 1 row affected (0.083 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','05'); Query OK, 1 row affected (0.086 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','06'); Query OK, 1 row affected (0.130 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','07'); Query OK, 1 row affected (0.087 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','08'); Query OK, 1 row affected (0.101 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','09'); Query OK, 1 row affected (0.093 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','10'); Query OK, 1 row affected (0.086 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','11'); Query OK, 1 row affected (0.093 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','12'); Query OK, 1 row affected (0.087 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','13'); Query OK, 1 row affected (0.044 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','14'); Query OK, 1 row affected (0.098 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('001','15'); Query OK, 1 row affected (0.104 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','01'); Query OK, 1 row affected (0.122 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','02'); Query OK, 1 row affected (0.089 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','03'); Query OK, 1 row affected (0.096 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','04'); Query OK, 1 row affected (0.158 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','05'); Query OK, 1 row affected (0.088 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','06'); Query OK, 1 row affected (0.089 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','07'); Query OK, 1 row affected (0.097 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','08'); Query OK, 1 row affected (0.086 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','09'); Query OK, 1 row affected (0.090 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','10'); Query OK, 1 row affected (0.098 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','11'); Query OK, 1 row affected (0.089 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','12'); Query OK, 1 row affected (0.115 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','13'); Query OK, 1 row affected (0.097 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','14'); Query OK, 1 row affected (0.141 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('002','15'); Query OK, 1 row affected (0.091 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003',01'); '> ; '> ' -> ; 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 [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','01'); Query OK, 1 row affected (0.082 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','02'); Query OK, 1 row affected (0.058 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','03'); Query OK, 1 row affected (0.092 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','04'); Query OK, 1 row affected (0.103 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','05'); Query OK, 1 row affected (0.089 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','06'); Query OK, 1 row affected (0.090 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','07'); Query OK, 1 row affected (0.084 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','08'); Query OK, 1 row affected (0.100 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','09'); Query OK, 1 row affected (0.083 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','10'); Query OK, 1 row affected (0.083 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','11'); Query OK, 1 row affected (0.090 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','12'); Query OK, 1 row affected (0.098 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','13'); Query OK, 1 row affected (0.047 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','14'); Query OK, 1 row affected (0.087 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('003','15'); Query OK, 1 row affected (0.152 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','01'); Query OK, 1 row affected (0.094 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','02'); Query OK, 1 row affected (0.100 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','03'); Query OK, 1 row affected (0.088 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','04'); Query OK, 1 row affected (0.062 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','05'); Query OK, 1 row affected (0.089 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','06'); Query OK, 1 row affected (0.037 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','07'); Query OK, 1 row affected (0.040 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','08'); Query OK, 1 row affected (0.090 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','09'); Query OK, 1 row affected (0.093 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','10'); Query OK, 1 row affected (0.039 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','11'); Query OK, 1 row affected (0.094 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','12'); Query OK, 1 row affected (0.087 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','13'); Query OK, 1 row affected (0.091 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','14'); Query OK, 1 row affected (0.091 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('004','15'); Query OK, 1 row affected (0.095 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','01'); Query OK, 1 row affected (0.167 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','02'); Query OK, 1 row affected (0.092 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','03'); Query OK, 1 row affected (0.090 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','04'); Query OK, 1 row affected (0.036 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','05'); Query OK, 1 row affected (0.036 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','06'); Query OK, 1 row affected (0.088 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','07'); Query OK, 1 row affected (0.043 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','08'); Query OK, 1 row affected (0.135 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','09'); Query OK, 1 row affected (0.097 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','10'); Query OK, 1 row affected (0.092 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','11'); Query OK, 1 row affected (0.090 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','12'); Query OK, 1 row affected (0.048 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','13'); Query OK, 1 row affected (0.094 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','14'); Query OK, 1 row affected (0.087 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('005','15'); Query OK, 1 row affected (0.096 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','01'); Query OK, 1 row affected (0.093 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','02'); Query OK, 1 row affected (0.089 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','03'); Query OK, 1 row affected (0.095 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','04'); Query OK, 1 row affected (0.088 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','05'); Query OK, 1 row affected (0.097 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','06'); Query OK, 1 row affected (0.095 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','07'); Query OK, 1 row affected (0.054 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','08'); Query OK, 1 row affected (0.094 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','09'); Query OK, 1 row affected (0.095 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','10'); Query OK, 1 row affected (0.093 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','11'); Query OK, 1 row affected (0.090 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','12'); Query OK, 1 row affected (0.101 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','13'); Query OK, 1 row affected (0.088 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','14'); Query OK, 1 row affected (0.039 sec) MariaDB [informacion_de_matricula]> insert into estudiante_materia(cod_estudiante, cod_materia) values ('006','15'); Query OK, 1 row affected (0.108 sec) MariaDB [informacion_de_matricula]> select * from estudiante_materia; +----------------+-------------+ | cod_estudiante | cod_materia | +----------------+-------------+ | 001 | 01 | | 001 | 02 | | 001 | 03 | | 001 | 04 | | 001 | 05 | | 001 | 06 | | 001 | 07 | | 001 | 08 | | 001 | 09 | | 001 | 10 | | 001 | 11 | | 001 | 12 | | 001 | 13 | | 001 | 14 | | 001 | 15 | | 002 | 01 | | 002 | 02 | | 002 | 03 | | 002 | 04 | | 002 | 05 | | 002 | 06 | | 002 | 07 | | 002 | 08 | | 002 | 09 | | 002 | 10 | | 002 | 11 | | 002 | 12 | | 002 | 13 | | 002 | 14 | | 002 | 15 | | 003 | 01 | | 003 | 02 | | 003 | 03 | | 003 | 04 | | 003 | 05 | | 003 | 06 | | 003 | 07 | | 003 | 08 | | 003 | 09 | | 003 | 10 | | 003 | 11 | | 003 | 12 | | 003 | 13 | | 003 | 14 | | 003 | 15 | | 004 | 01 | | 004 | 02 | | 004 | 03 | | 004 | 04 | | 004 | 05 | | 004 | 06 | | 004 | 07 | | 004 | 08 | | 004 | 09 | | 004 | 10 | | 004 | 11 | | 004 | 12 | | 004 | 13 | | 004 | 14 | | 004 | 15 | | 005 | 01 | | 005 | 02 | | 005 | 03 | | 005 | 04 | | 005 | 05 | | 005 | 06 | | 005 | 07 | | 005 | 08 | | 005 | 09 | | 005 | 10 | | 005 | 11 | | 005 | 12 | | 005 | 13 | | 005 | 14 | | 005 | 15 | | 006 | 01 | | 006 | 02 | | 006 | 03 | | 006 | 04 | | 006 | 05 | | 006 | 06 | | 006 | 07 | | 006 | 08 | | 006 | 09 | | 006 | 10 | | 006 | 11 | | 006 | 12 | | 006 | 13 | | 006 | 14 | | 006 | 15 | +----------------+-------------+ 90 rows in set (0.001 sec) MariaDB [informacion_de_matricula]> show tables; +------------------------------------+ | Tables_in_informacion_de_matricula | +------------------------------------+ | acudiente | | estudiante | | estudiante_acudiente | | estudiante_materia | | materia | | materia_profesor | | profesor | +------------------------------------+ 7 rows in set (0.001 sec) MariaDB [informacion_de_matricula]> describe materia; +--------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+-------------+------+-----+---------+-------+ | codigo | int(16) | NO | | NULL | | | nombre | varchar(80) | NO | | NULL | | +--------+-------------+------+-----+---------+-------+ 2 rows in set (0.009 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (01,'ESPAÑOL'); Query OK, 1 row affected (0.110 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (02,'LECTOESCRITURA'); Query OK, 1 row affected (0.088 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (03,'MATEMATICAS'); Query OK, 1 row affected (0.045 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (04,'CIENCIAS NATURALES'); Query OK, 1 row affected (0.103 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (05,'INVESTIGACION'); Query OK, 1 row affected (0.091 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (06,'FISICA'); Query OK, 1 row affected (0.087 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (07,'FILOSOFIA'); Query OK, 1 row affected (0.092 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (08,'EDUCACION FISICA'); Query OK, 1 row affected (0.071 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (09,'ETICA'); Query OK, 1 row affected (0.089 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (10,'ARTISTICA'); Query OK, 1 row affected (0.036 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (11,'TECNOLOGIA'); Query OK, 1 row affected (0.091 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (11,'INFORMATICA'); Query OK, 1 row affected (0.092 sec) MariaDB [informacion_de_matricula]> drop table materia; Query OK, 0 rows affected (0.495 sec) MariaDB [informacion_de_matricula]> show tables; +------------------------------------+ | Tables_in_informacion_de_matricula | +------------------------------------+ | acudiente | | estudiante | | estudiante_acudiente | | estudiante_materia | | materia_profesor | | profesor | +------------------------------------+ 6 rows in set (0.001 sec) MariaDB [informacion_de_matricula]> create table materia; ERROR 1113 (42000): A table must have at least 1 column MariaDB [informacion_de_matricula]> create table materia -> (codigo int(5) not null, -> nombre varchar(45) not null); Query OK, 0 rows affected (0.250 sec) MariaDB [informacion_de_matricula]> show tables; +------------------------------------+ | Tables_in_informacion_de_matricula | +------------------------------------+ | acudiente | | estudiante | | estudiante_acudiente | | estudiante_materia | | materia | | materia_profesor | | profesor | +------------------------------------+ 7 rows in set (0.001 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (01,'ESPAÑOL'); Query OK, 1 row affected (0.100 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (02,'LECTOESCRITURA'); Query OK, 1 row affected (0.091 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (03,'MATEMATICAS'); Query OK, 1 row affected (0.157 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (04,'CIENCIAS NATURALES'); Query OK, 1 row affected (0.086 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (05,'INVESTIGACION'); Query OK, 1 row affected (0.086 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (06,'FISICA'); Query OK, 1 row affected (0.122 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (07,'FILOSOFIA'); Query OK, 1 row affected (0.085 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (08,'EDUCACION FISICA'); Query OK, 1 row affected (0.042 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (09,'ETICA'); Query OK, 1 row affected (0.029 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (10,'ARTISTICA'); Query OK, 1 row affected (0.094 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (11,'TECNOLOGIA'); Query OK, 1 row affected (0.083 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (12,'INFORMATICA'); Query OK, 1 row affected (0.096 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (13,'RELIGION'); Query OK, 1 row affected (0.094 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (14,'SOCIALES'); Query OK, 1 row affected (0.089 sec) MariaDB [informacion_de_matricula]> insert into materia (codigo,nombre) values (15,'INGLES'); Query OK, 1 row affected (0.091 sec) MariaDB [informacion_de_matricula]> show tables; +------------------------------------+ | Tables_in_informacion_de_matricula | +------------------------------------+ | acudiente | | estudiante | | estudiante_acudiente | | estudiante_materia | | materia | | materia_profesor | | profesor | +------------------------------------+ 7 rows in set (0.001 sec) MariaDB [informacion_de_matricula]> describe materia_profesor; +--------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------+------+-----+---------+-------+ | cod_materia | varchar(5) | NO | | NULL | | | cod_profespr | varchar(8) | NO | | NULL | | +--------------+------------+------+-----+---------+-------+ 2 rows in set (0.006 sec) MariaDB [informacion_de_matricula]> alter table materia_profesor change cod_profespr cod_profesor varchar(8) not null; Query OK, 0 rows affected (0.202 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [informacion_de_matricula]> describe materia_profesor; +--------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------+------+-----+---------+-------+ | cod_materia | varchar(5) | NO | | NULL | | | cod_profesor | varchar(8) | NO | | NULL | | +--------------+------------+------+-----+---------+-------+ 2 rows in set (0.022 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor); 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 [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('01','005'); Query OK, 1 row affected (0.130 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('02','007'); Query OK, 1 row affected (0.087 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('03','009'); Query OK, 1 row affected (0.037 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('04','003'); Query OK, 1 row affected (0.051 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('05','003'); Query OK, 1 row affected (0.091 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('06','003'); Query OK, 1 row affected (0.093 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('07','001'); Query OK, 1 row affected (0.087 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('08','010'); Query OK, 1 row affected (0.088 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('09','006'); Query OK, 1 row affected (0.090 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('10','004'); Query OK, 1 row affected (0.165 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('11','002'); Query OK, 1 row affected (0.092 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('12','002'); Query OK, 1 row affected (0.084 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('13','006'); Query OK, 1 row affected (0.084 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('14','007'); Query OK, 1 row affected (0.084 sec) MariaDB [informacion_de_matricula]> insert into materia_profesor(cod_materia,cod_profesor) values ('15','008'); Query OK, 1 row affected (0.091 sec) MariaDB [informacion_de_matricula]> select * from materia_profesor; +-------------+--------------+ | cod_materia | cod_profesor | +-------------+--------------+ | 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.001 sec) MariaDB [informacion_de_matricula]> show tables; +------------------------------------+ | Tables_in_informacion_de_matricula | +------------------------------------+ | acudiente | | estudiante | | estudiante_acudiente | | estudiante_materia | | materia | | materia_profesor | | profesor | +------------------------------------+ 7 rows in set (0.001 sec) MariaDB [informacion_de_matricula]> describe profesor; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigo | int(16) | NO | | NULL | | | nombre | varchar(80) | NO | | NULL | | | direccion | varchar(45) | NO | | NULL | | | telefono | int(11) | NO | | NULL | | | mail | varchar(60) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.006 sec) MariaDB [informacion_de_matricula]> insert into profesor(codigo,nombre,direccion,telefono,mail) values (001,'CIFUENTES MESA MYLEIDY MARIA','', ,'myleidym.iearm@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 ''myleidym.iearm@gmail.com')' at line 1 MariaDB [informacion_de_matricula]> insert into profesor(codigo,nombre,direccion,telefono,mail) values (001,'CIFUENTES MESA MYLEIDY MARIA','',,'myleidym.iearm@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 ''myleidym.iearm@gmail.com')' at line 1 MariaDB [informacion_de_matricula]> insert into profesor(codigo,nombre,direccion,telefono,mail) values (001,'CIFUENTES MESA MYLEIDY MARIA','','','myleidym.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.136 sec) MariaDB [informacion_de_matricula]> select * from profesor; +--------+------------------------------+-----------+----------+--------------------------+ | codigo | nombre | direccion | telefono | mail | +--------+------------------------------+-----------+----------+--------------------------+ | 1 | CIFUENTES MESA MYLEIDY MARIA | | 0 | myleidym.iearm@gmail.com | +--------+------------------------------+-----------+----------+--------------------------+ 1 row in set (0.001 sec) MariaDB [informacion_de_matricula]> insert into profesor(codigo,nombre,direccion,telefono,mail) values (002,'CUADRADO PEREZ ADRID JOSE','','','adrid.iearm@gmail.com');com'); Query OK, 1 row affected, 1 warning (0.074 sec) '> ' -> ; 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 'com'); '' at line 1 MariaDB [informacion_de_matricula]> select * from profesor; +--------+------------------------------+-----------+----------+--------------------------+ | codigo | nombre | direccion | telefono | mail | +--------+------------------------------+-----------+----------+--------------------------+ | 1 | CIFUENTES MESA MYLEIDY MARIA | | 0 | myleidym.iearm@gmail.com | | 2 | CUADRADO PEREZ ADRID JOSE | | 0 | adrid.iearm@gmail.com | +--------+------------------------------+-----------+----------+--------------------------+ 2 rows in set (0.001 sec) MariaDB [informacion_de_matricula]> insert into profesor(codigo,nombre,direccion,telefono,mail) values (003,'DUQUE RESTREPO ESTER LUCIA','','','esterl.iearm@gmail.com');com'); Query OK, 1 row affected, 1 warning (0.094 sec) '> ' -> ; 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 'com'); '' at line 1 MariaDB [informacion_de_matricula]> insert into profesor(codigo,nombre,direccion,telefono,mail) values (004,'GUIRALES MAURICIO','','','mauriciog.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.096 sec) MariaDB [informacion_de_matricula]> insert into profesor(codigo,nombre,direccion,telefono,mail) values (005,'VERA DAZA MARIA ELENA','','','mariae.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.101 sec) MariaDB [informacion_de_matricula]> insert into profesor(codigo,nombre,direccion,telefono,mail) values (006,'PALACIO TOMAS FELIPE','','','tomasf.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.098 sec) MariaDB [informacion_de_matricula]> insert into profesor(codigo,nombre,direccion,telefono,mail) values (007,'MOSQUERA OSORIO MARYETH','','','maryeth.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.096 sec) MariaDB [informacion_de_matricula]> insert into profesor(codigo,nombre,direccion,telefono,mail) values (008,'ARBOLEDA VARGAS MARIA OFELIA','','','ofeliaa.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.123 sec) MariaDB [informacion_de_matricula]> insert into profesor(codigo,nombre,direccion,telefono,mail) values (009,'MOSCOTE MARULANDA YANET MARIA','','','yanetm.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.088 sec) MariaDB [informacion_de_matricula]> insert into profesor(codigo,nombre,direccion,telefono,mail) values (010,'MACIAS EDGAR ALBERTO','','','edgarm.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.030 sec) MariaDB [informacion_de_matricula]> select * from profesor; +--------+-------------------------------+-----------+----------+---------------------------+ | codigo | nombre | direccion | telefono | mail | +--------+-------------------------------+-----------+----------+---------------------------+ | 1 | CIFUENTES MESA MYLEIDY MARIA | | 0 | myleidym.iearm@gmail.com | | 2 | CUADRADO PEREZ ADRID JOSE | | 0 | adrid.iearm@gmail.com | | 3 | DUQUE RESTREPO ESTER LUCIA | | 0 | esterl.iearm@gmail.com | | 4 | GUIRALES MAURICIO | | 0 | mauriciog.iearm@gmail.com | | 5 | VERA DAZA MARIA ELENA | | 0 | mariae.iearm@gmail.com | | 6 | PALACIO TOMAS FELIPE | | 0 | tomasf.iearm@gmail.com | | 7 | MOSQUERA OSORIO MARYETH | | 0 | maryeth.iearm@gmail.com | | 8 | ARBOLEDA VARGAS MARIA OFELIA | | 0 | ofeliaa.iearm@gmail.com | | 9 | MOSCOTE MARULANDA YANET MARIA | | 0 | yanetm.iearm@gmail.com | | 10 | MACIAS EDGAR ALBERTO | | 0 | edgarm.iearm@gmail.com | +--------+-------------------------------+-----------+----------+---------------------------+ 10 rows in set (0.001 sec) MariaDB [informacion_de_matricula]>