MariaDB [matricula]> change: alter table materia change cogidomat codigomat varchar(3) not null; 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 ': alter table materia change cogidomat codigomat varchar(3) not null' at line 1 MariaDB [matricula]> drop table materia; Query OK, 0 rows affected (0.015 sec) MariaDB [matricula]> create table materia(codigomat varchar(3) not null primary key, -> nombre varchar(20) not null); Query OK, 0 rows affected (0.036 sec) MariaDB [matricula]> create table estumadoc(codestudiante varchar(5) not null, -> codigomat varchar(3) not null, -> codocente varchar(3) not null, -> foreign key(codestudiante) references estudiante(codestudiante) on delete cascade on update cascade, -> foreign key(codigomat) references materia(codigomat) on delete cascade on update cascade, -> foreign key(codocente) references docente(codocente) on delete cascade on update cascade); Query OK, 0 rows affected (0.035 sec) MariaDB [matricula]> describe estumadoc; +---------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------+------+-----+---------+-------+ | codestudiante | varchar(5) | NO | MUL | NULL | | | codigomat | varchar(3) | NO | MUL | NULL | | | codocente | varchar(3) | NO | MUL | NULL | | +---------------+------------+------+-----+---------+-------+ 3 rows in set (0.021 sec) MariaDB [matricula]> describe estac; +---------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------+------+-----+---------+-------+ | codestudiante | varchar(5) | NO | MUL | NULL | | | codacudiente | varchar(4) | NO | MUL | NULL | | +---------------+------------+------+-----+---------+-------+ 2 rows in set (0.022 sec) MariaDB [matricula]> describe estudiante; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | codestudiante | varchar(5) | NO | PRI | NULL | | | nombre | varchar(30) | NO | | NULL | | | direccion | varchar(20) | NO | | NULL | | | email | varchar(15) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 4 rows in set (0.014 sec) MariaDB [matricula]> describe acudiente; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | codacudiente | varchar(4) | NO | PRI | NULL | | | nombre | varchar(30) | NO | | NULL | | | direccion | varchar(20) | NO | | NULL | | | telefono | varchar(9) | NO | | NULL | | | email | varchar(15) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 5 rows in set (0.027 sec) MariaDB [matricula]> describe docente; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codocente | varchar(3) | NO | PRI | NULL | | | nombre | varchar(30) | NO | | NULL | | | direccion | varchar(20) | NO | | NULL | | | telefono | varchar(9) | NO | | NULL | | | email | varchar(15) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.020 sec) MariaDB [matricula]> describe materia; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigomat | varchar(3) | NO | PRI | NULL | | | nombre | varchar(20) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.021 sec) MariaDB [matricula]> insert into estudiante(codestudiante, nombre, direccion, telefono, email) values('E0001', 'ACEVEDO BURITICA JUAN ESTEBAN', 'Barrio la pradera', '5846069', 'juanestebacardona@gmail.com'); ERROR 1054 (42S22): Unknown column 'telefono' in 'field list' MariaDB [matricula]> alter table estudiante add telefono varchar(9) not null after direccion; Query OK, 0 rows affected (0.021 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [matricula]> insert into estudiante(codestudiante, nombre, direccion, telefono, email) values('E0001', 'ACEVEDO BURITICA JUAN ESTEBAN', 'Barrio la pradera', '5846069', 'juanestebacardona@gmail.com'); Query OK, 1 row affected, 1 warning (0.009 sec) MariaDB [matricula]> insert into estudiante(codestudiante, nombre, direccion, telefono, email) values('E0002', 'ALVAREZ AGUDELO ESTEBAN', 'Barrio rosaleda', '5882104', 'estebanalvarez@gmail.com'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [matricula]> insert into estudiante(codestudiante, nombre, direccion, telefono, email) values('E0003', 'ZAPATA CAMPI令 ISABEL', 'Barrio Aragon', '5841998', 'zapataisabel@gmail.com'); Query OK, 1 row affected, 1 warning (0.008 sec) MariaDB [matricula]> insert into estudiante(codestudiante, nombre, direccion, telefono, email) values('E0004', 'VALLE VELASQUEZ SOFIA', 'Barrio la pradera', '2791469', 'sofiavelasquez@gmail.com'); Query OK, 1 row affected, 1 warning (0.008 sec) MariaDB [matricula]> insert into estudiante(codestudiante, nombre, direccion, telefono, email) values('E0005', 'MORENO POSADA DIEGO ALEJANDRO', 'Urbanizacion compartir', '2868617', 'diegomoreno@gmail.com'); Query OK, 1 row affected, 2 warnings (0.008 sec) MariaDB [matricula]> insert into estudiante(codestudiante, nombre, direccion, telefono, email) values('E0006', 'ALZATE ORTIZ JORGE MARIO', 'Urbanizacion ciudadela prado', '5841497', 'marioalzate@gmail.com'); Query OK, 1 row affected, 2 warnings (0.008 sec) MariaDB [matricula]> insert into estudiante(codestudiante, nombre, direccion, telefono, email) values('E0007', 'ZAPATA QUINTERO JOSE MARIA', 'Barrio sangabriel', '5840570', 'josezapata@gmail.com'); Query OK, 1 row affected, 1 warning (0.008 sec) MariaDB [matricula]> insert into estudiante(codestudiante, nombre, direccion, telefono, email) values('E0008', 'MONTOYA MONTOYA ALEJANDRO', 'Barrio la pradera', '3767289', 'alejandromontoya@gmail.com'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [matricula]> insert into estudiante(codestudiante, nombre, direccion, telefono, email) values('E0009', 'LOPERA CARTAGENA LUISA FERNANDA', 'Barrio el limonar 1', '5709957', 'luisalopera@gmail.com'); Query OK, 1 row affected, 2 warnings (0.003 sec) MariaDB [matricula]> insert into estudiante(codestudiante, nombre, direccion, telefono, email) values('E0010', 'JARAMILLO HENAO JOSE LUIS', 'Barrio el limonar 2', '2866222', 'josejaramillo@gmail.com'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [matricula]> insert into estudiante(codestudiante, nombre, direccion, telefono, email) values('E0011', 'ALVAREZ AGUDELO LUNA', 'Barrio rosaleda', '5882104', 'lunaalvarez@gmail.com'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [matricula]> insert into estudiante(codestudiante, nombre, direccion, telefono, email) values('E0012', 'ALVAREZ AGUDELO XAVIER', 'Barrio rosaleda', '5882104', 'xavieralvarez@gmail.com'); Query OK, 1 row affected, 1 warning (0.009 sec) MariaDB [matricula]> select * from estudiante; +---------------+--------------------------------+----------------------+----------+-----------------+ | codestudiante | nombre | direccion | telefono | email | +---------------+--------------------------------+----------------------+----------+-----------------+ | E0001 | ACEVEDO BURITICA JUAN ESTEBAN | Barrio la pradera | 5846069 | juanestebacardo | | E0002 | ALVAREZ AGUDELO ESTEBAN | Barrio rosaleda | 5882104 | estebanalvarez@ | | E0003 | ZAPATA CAMPI令 ISABEL | Barrio Aragon | 5841998 | zapataisabel@gm | | E0004 | VALLE VELASQUEZ SOFIA | Barrio la pradera | 2791469 | sofiavelasquez@ | | E0005 | MORENO POSADA DIEGO ALEJANDRO | Urbanizacion compart | 2868617 | diegomoreno@gma | | E0006 | ALZATE ORTIZ JORGE MARIO | Urbanizacion ciudade | 5841497 | marioalzate@gma | | E0007 | ZAPATA QUINTERO JOSE MARIA | Barrio sangabriel | 5840570 | josezapata@gmai | | E0008 | MONTOYA MONTOYA ALEJANDRO | Barrio la pradera | 3767289 | alejandromontoy | | E0009 | LOPERA CARTAGENA LUISA FERNAND | Barrio el limonar 1 | 5709957 | luisalopera@gma | | E0010 | JARAMILLO HENAO JOSE LUIS | Barrio el limonar 2 | 2866222 | josejaramillo@g | | E0011 | ALVAREZ AGUDELO LUNA | Barrio rosaleda | 5882104 | lunaalvarez@gma | | E0012 | ALVAREZ AGUDELO XAVIER | Barrio rosaleda | 5882104 | xavieralvarez@g | +---------------+--------------------------------+----------------------+----------+-----------------+ 12 rows in set (0.006 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M01', 'ESPA令L'); Query OK, 1 row affected (0.008 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M02', 'LECTOESCRITURA'); Query OK, 1 row affected (0.003 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M03', 'MATEMATICAS'); Query OK, 1 row affected (0.002 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M04', 'CIENCIAS NATURALES'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M05', 'INVESTIGACION'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M06', 'FISICA'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M07', 'FILOSOFIA'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M08', 'EDUCACION FISICA'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M09', 'ETICA'); Query OK, 1 row affected (0.002 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M10', 'ARTISITCA'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M11', 'TECNOLOGIA'); Query OK, 1 row affected (0.002 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M12', 'INFORMATICA'); Query OK, 1 row affected (0.002 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M13', 'RELIGION'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M14', 'SOCIALES'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into materia(codigomat, nombre) values('M15', 'INGLES'); Query OK, 1 row affected (0.002 sec) MariaDB [matricula]> select * from materia; +-----------+--------------------+ | codigomat | nombre | +-----------+--------------------+ | M01 | ESPA令L | | M02 | LECTOESCRITURA | | M03 | MATEMATICAS | | M04 | CIENCIAS NATURALES | | M05 | INVESTIGACION | | M06 | FISICA | | M07 | FILOSOFIA | | M08 | EDUCACION FISICA | | M09 | ETICA | | M10 | ARTISITCA | | M11 | TECNOLOGIA | | M12 | INFORMATICA | | M13 | RELIGION | | M14 | SOCIALES | | M15 | INGLES | +-----------+--------------------+ 15 rows in set (0.001 sec) MariaDB [matricula]> insert into docente(codocente, nombre, direccion, telefono, email) values('D01', 'CIFUENTES MESA MYEDI MARIA', 'Barrio el lindero', '2315347', '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 '' at line 1 MariaDB [matricula]> insert into docente(codocente, nombre, direccion, telefono, email) values('D01', 'CIFUENTES MESA MYEDI MARIA', 'Barrio el lindero', '2315347', 'myleidym.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.008 sec) MariaDB [matricula]> insert into docente(codocente, nombre, direccion, telefono, email) values('D01', 'CUADRADO PEREZ ADRID JOSE', 'Barrio belen 1', '3457667', 'adrid.iearm@gmail.com'); ERROR 1062 (23000): Duplicate entry 'D01' for key 'PRIMARY' MariaDB [matricula]> insert into docente(codocente, nombre, direccion, telefono, email) values('D02', 'CUADRADO PEREZ ADRID JOSE', 'Barrio belen 1', '3457667', 'adrid.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.007 sec) MariaDB [matricula]> insert into docente(codocente, nombre, direccion, telefono, email) values('D03', 'DUQUE RESTREPO ESTER LUCIA', 'Barrio mesa', '5437691', 'esterl.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.007 sec) MariaDB [matricula]> insert into docente(codocente, nombre, direccion, telefono, email) values('D04', 'GUIRALES MAURICIO', 'Urbanizacion valle azul', '3657691', 'mauriciog.iearm@gmail.com'); Query OK, 1 row affected, 2 warnings (0.007 sec) MariaDB [matricula]> insert into docente(codocente, nombre, direccion, telefono, email) values('D04', 'GUIRALES MAURICIO', 'Barrio esperanza', '3781256', 'mariae.iearm@gmail.com'); ERROR 1062 (23000): Duplicate entry 'D04' for key 'PRIMARY' MariaDB [matricula]> MariaDB [matricula]> insert into docente(codocente, nombre, direccion, telefono, email) values('D04', 'VERA DAZA MARIA ELENA', 'Barrio esperanza', '3781256', 'mariae.iearm@gmail.com'); ERROR 1062 (23000): Duplicate entry 'D04' for key 'PRIMARY' MariaDB [matricula]> insert into docente(codocente, nombre, direccion, telefono, email) values('D05', 'VERA DAZA MARIA ELENA', 'Barrio esperanza', '3781256', 'mariae.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.007 sec) MariaDB [matricula]> insert into docente(codocente, nombre, direccion, telefono, email) values('D06', 'PALACIO TOMAS FELIPE', 'Barrio belen 2', '4921256', 'tomasf.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [matricula]> insert into docente(codocente, nombre, direccion, telefono, email) values('D07', 'MOSQUERA OSORIO MARYETH', 'Urbanizacion central', '2576590', 'maryeth.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.006 sec) MariaDB [matricula]> insert into docente(codocente, nombre, direccion, telefono, email) values('D08', 'ARBOLEDA VARGAS MARIA OFELIA', 'Barrio colmenares', '5064532', 'ofeliaa.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.006 sec) MariaDB [matricula]> insert into docente(codocente, nombre, direccion, telefono, email) values('D09', 'MOSCOTE MARULANDA YANET MARIA', 'Barrio el virrey', '3956781', 'yanetm.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.007 sec) MariaDB [matricula]> insert into docente(codocente, nombre, direccion, telefono, email) values('D10', 'MACIAS EDGAR ALBERTO', 'Urbanizacion agua blanca', '3945612', 'edgarm.iearm@gmail.com'); Query OK, 1 row affected, 2 warnings (0.007 sec) MariaDB [matricula]> select * from docente; +-----------+-------------------------------+----------------------+----------+-----------------+ | codocente | nombre | direccion | telefono | email | +-----------+-------------------------------+----------------------+----------+-----------------+ | D01 | CIFUENTES MESA MYEDI MARIA | Barrio el lindero | 2315347 | myleidym.iearm@ | | D02 | CUADRADO PEREZ ADRID JOSE | Barrio belen 1 | 3457667 | adrid.iearm@gma | | D03 | DUQUE RESTREPO ESTER LUCIA | Barrio mesa | 5437691 | esterl.iearm@gm | | D04 | GUIRALES MAURICIO | Urbanizacion valle a | 3657691 | mauriciog.iearm | | D05 | VERA DAZA MARIA ELENA | Barrio esperanza | 3781256 | mariae.iearm@gm | | D06 | PALACIO TOMAS FELIPE | Barrio belen 2 | 4921256 | tomasf.iearm@gm | | D07 | MOSQUERA OSORIO MARYETH | Urbanizacion central | 2576590 | maryeth.iearm@g | | D08 | ARBOLEDA VARGAS MARIA OFELIA | Barrio colmenares | 5064532 | ofeliaa.iearm@g | | D09 | MOSCOTE MARULANDA YANET MARIA | Barrio el virrey | 3956781 | yanetm.iearm@gm | | D10 | MACIAS EDGAR ALBERTO | Urbanizacion agua bl | 3945612 | edgarm.iearm@gm | +-----------+-------------------------------+----------------------+----------+-----------------+ 10 rows in set (0.001 sec) MariaDB [matricula]> insert into acudiente(codacudiente, nombre, direccion, telefono, email) values('A001', 'ACEVEDO CARDONA ESTEBAN', 'Barrio la pradera', '5846069', 'estebancardona@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 '' at line 1 MariaDB [matricula]> insert into acudiente(codacudiente, nombre, direccion, telefono, email) values('A001', 'ACEVEDO CARDONA ESTEBAN', 'Barrio la pradera', '5846069', 'estebancardona@gmail.com'); Query OK, 1 row affected, 1 warning (0.008 sec) MariaDB [matricula]> insert into acudiente(codacudiente, nombre, direccion, telefono, email) values('A002', 'AGUDELO MANCO DIANA PATRICIA', 'Barrio rosaleda', '58821204', 'dianapatricia@gmail.com'); Query OK, 1 row affected, 1 warning (0.007 sec) MariaDB [matricula]> insert into acudiente(codacudiente, nombre, direccion, telefono, email) values('A003', 'ZAPATA VALENCIA JORGE', 'Barrio Aragon', '5841998', 'jorgezapata@gmail.com'); Query OK, 1 row affected, 1 warning (0.006 sec) MariaDB [matricula]> insert into acudiente(codacudiente, nombre, direccion, telefono, email) values('A004', 'VELASQUEZ CANO JENNY ASTRID', 'Barrio la pradera', '2791469', 'jennyvelasquez@gmail.com'); Query OK, 1 row affected, 1 warning (0.007 sec) MariaDB [matricula]> insert into acudiente(codacudiente, nombre, direccion, telefono, email) values('A005', 'POSADA VASCO ANA', 'Urbanizacion compartir', '2868617', 'anaposada@gmail.com'); Query OK, 1 row affected, 2 warnings (0.007 sec) MariaDB [matricula]> insert into acudiente(codacudiente, nombre, direccion, telefono, email) values('A006', 'ORTIZ PUERTA INDIRA', 'Urbanizacion ciudadela prado', '5841497', 'indiraortiz@gmail.com'); Query OK, 1 row affected, 2 warnings (0.006 sec) MariaDB [matricula]> insert into acudiente(codacudiente, nombre, direccion, telefono, email) values('A007', 'QUINTERO MENESES ADRIANA MARIA', 'Barrio sangabriel', '5840570', 'adrianaquintero@gmail.com'); Query OK, 1 row affected, 1 warning (0.007 sec) MariaDB [matricula]> insert into acudiente(codacudiente, nombre, direccion, telefono, email) values('A007', 'QUINTERO MENESES ADRIANA MARIA', 'Barrio sangabriel', '5840570', 'edilmamontoya@gmail.com'); ERROR 1062 (23000): Duplicate entry 'A007' for key 'PRIMARY' MariaDB [matricula]> insert into acudiente(codacudiente, nombre, direccion, telefono, email) values('A008', 'MONTOYA RIVERA EDILMA', 'Barrio la pradera', '3767289', 'edilmamontoya@gmail.com'); Query OK, 1 row affected, 1 warning (0.007 sec) MariaDB [matricula]> insert into acudiente(codacudiente, nombre, direccion, telefono, email) values('A009', 'LOPERA MONSALVE FERNANDO ALONSO', 'Barrio el limonar 1', '5709957', 'fernandolopera@gmail.com'); Query OK, 1 row affected, 2 warnings (0.007 sec) MariaDB [matricula]> insert into acudiente(codacudiente, nombre, direccion, telefono, email) values('A010', 'HENAO RIOS DORA EMILSE', 'Barrio el limonar 2', '2866222', 'dorahenao@gmail.com'); Query OK, 1 row affected, 1 warning (0.007 sec) MariaDB [matricula]> select * from acudiente; +--------------+--------------------------------+----------------------+----------+-----------------+ | codacudiente | nombre | direccion | telefono | email | +--------------+--------------------------------+----------------------+----------+-----------------+ | A001 | ACEVEDO CARDONA ESTEBAN | Barrio la pradera | 5846069 | estebancardona@ | | A002 | AGUDELO MANCO DIANA PATRICIA | Barrio rosaleda | 58821204 | dianapatricia@g | | A003 | ZAPATA VALENCIA JORGE | Barrio Aragon | 5841998 | jorgezapata@gma | | A004 | VELASQUEZ CANO JENNY ASTRID | Barrio la pradera | 2791469 | jennyvelasquez@ | | A005 | POSADA VASCO ANA | Urbanizacion compart | 2868617 | anaposada@gmail | | A006 | ORTIZ PUERTA INDIRA | Urbanizacion ciudade | 5841497 | indiraortiz@gma | | A007 | QUINTERO MENESES ADRIANA MARIA | Barrio sangabriel | 5840570 | adrianaquintero | | A008 | MONTOYA RIVERA EDILMA | Barrio la pradera | 3767289 | edilmamontoya@g | | A009 | LOPERA MONSALVE FERNANDO ALONS | Barrio el limonar 1 | 5709957 | fernandolopera@ | | A010 | HENAO RIOS DORA EMILSE | Barrio el limonar 2 | 2866222 | dorahenao@gmail | +--------------+--------------------------------+----------------------+----------+-----------------+ 10 rows in set (0.001 sec) MariaDB [matricula]> insert into estac(codestudiante, codacudiente) values('E0001','A001'); Query OK, 1 row affected (0.009 sec) MariaDB [matricula]> insert into estac(codestudiante, codacudiente) values('E0002','A002'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estac(codestudiante, codacudiente) values('E0003','A003'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estac(codestudiante, codacudiente) values('E0004','A004'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estac(codestudiante, codacudiente) values('E0005','A005'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estac(codestudiante, codacudiente) values('E0006','A006'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estac(codestudiante, codacudiente) values('E0007','A007'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estac(codestudiante, codacudiente) values('E0008','A008'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estac(codestudiante, codacudiente) values('E0009','A009'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estac(codestudiante, codacudiente) values('E0010','A010'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estac(codestudiante, codacudiente) values('E0011','A007'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estac(codestudiante, codacudiente) values('E0012','A002'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> select * from estac; +---------------+--------------+ | codestudiante | codacudiente | +---------------+--------------+ | E0001 | A001 | | E0002 | A002 | | E0003 | A003 | | E0004 | A004 | | E0005 | A005 | | E0006 | A006 | | E0007 | A007 | | E0008 | A008 | | E0009 | A009 | | E0010 | A010 | | E0011 | A007 | | E0012 | A002 | +---------------+--------------+ 12 rows in set (0.001 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M01','D05'); Query OK, 1 row affected (0.009 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M02','D07'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M03','D09'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M04','D03'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M05','D03'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M06','D03'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M07','D01'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M08','D10'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M09','D06'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M10','D04'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M11','D02'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M12','D02'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M13','D06'); Query OK, 1 row affected (0.008 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M14','D07'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0001','M15','D08'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M01','D05'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M02','D07'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M03','D09'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M04','D03'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M05','D03'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M06','D03'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M07','D01'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M08','D10'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M09','D06'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M10','D04'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M11','D02'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M12','D02'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M13','D06'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M14','D07'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0002','M15','D08'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M01','D05'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M02','D07'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M03','D09'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M04','D03'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M05','D03'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M06','D03'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M07','D01'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M08','D10'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M09','D06'); Query OK, 1 row affected (0.002 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M10','D04'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M11','D02'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M12','D02'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M13','D06'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M14','D07'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0003','M15','D08'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M01','D05'); Query OK, 1 row affected (0.002 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M02','D07'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M03','D09'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M04','D03'); Query OK, 1 row affected (0.002 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M05','D03'); Query OK, 1 row affected (0.002 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M06','D03'); Query OK, 1 row affected (0.001 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M07','D01'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M08','D10'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M09','D06'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M10','D04'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M11','D02'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M12','D02'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M13','D06'); Query OK, 1 row affected (0.002 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M14','D07'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0004','M15','D08'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M01','D05'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M02','D07'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M03','D09'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M04','D03'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M05','D03'); Query OK, 1 row affected (0.002 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M06','D03'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M07','D01'); Query OK, 1 row affected (0.008 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M08','D10'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M09','D06'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M10','D04'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M11','D02'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M12','D02'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M13','D06'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M14','D07'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0005','M15','D08'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M01','D05'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M02','D07'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M03','D09'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M04','D03'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M05','D03'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M06','D03'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M07','D01'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M08','D10'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M07','D06'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M08','D04'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M09','D02'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M09','D06'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M10','D04'); Query OK, 1 row affected (0.008 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M11','D02'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M12','D02'); Query OK, 1 row affected (0.002 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M13','D06'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M14','D07'); Query OK, 1 row affected (0.006 sec) MariaDB [matricula]> insert into estumadoc(codestudiante, codigomat, codocente) values('E0006','M15','D08'); Query OK, 1 row affected (0.007 sec) MariaDB [matricula]> select * from estudomac; ERROR 1146 (42S02): Table 'matricula.estudomac' doesn't exist MariaDB [matricula]> select * from estumadoc; +---------------+-----------+-----------+ | codestudiante | codigomat | codocente | +---------------+-----------+-----------+ | E0001 | M01 | D05 | | E0001 | M02 | D07 | | E0001 | M03 | D09 | | E0001 | M04 | D03 | | E0001 | M05 | D03 | | E0001 | M06 | D03 | | E0001 | M07 | D01 | | E0001 | M08 | D10 | | E0001 | M09 | D06 | | E0001 | M10 | D04 | | E0001 | M11 | D02 | | E0001 | M12 | D02 | | E0001 | M13 | D06 | | E0001 | M14 | D07 | | E0001 | M15 | D08 | | E0002 | M01 | D05 | | E0002 | M02 | D07 | | E0002 | M03 | D09 | | E0002 | M04 | D03 | | E0002 | M05 | D03 | | E0002 | M06 | D03 | | E0002 | M07 | D01 | | E0002 | M08 | D10 | | E0002 | M09 | D06 | | E0002 | M10 | D04 | | E0002 | M11 | D02 | | E0002 | M12 | D02 | | E0002 | M13 | D06 | | E0002 | M14 | D07 | | E0002 | M15 | D08 | | E0003 | M01 | D05 | | E0003 | M02 | D07 | | E0003 | M03 | D09 | | E0003 | M04 | D03 | | E0003 | M05 | D03 | | E0003 | M06 | D03 | | E0003 | M07 | D01 | | E0003 | M08 | D10 | | E0003 | M09 | D06 | | E0003 | M10 | D04 | | E0003 | M11 | D02 | | E0003 | M12 | D02 | | E0003 | M13 | D06 | | E0003 | M14 | D07 | | E0003 | M15 | D08 | | E0004 | M01 | D05 | | E0004 | M02 | D07 | | E0004 | M03 | D09 | | E0004 | M04 | D03 | | E0004 | M05 | D03 | | E0004 | M06 | D03 | | E0004 | M07 | D01 | | E0004 | M08 | D10 | | E0004 | M09 | D06 | | E0004 | M10 | D04 | | E0004 | M11 | D02 | | E0004 | M12 | D02 | | E0004 | M13 | D06 | | E0004 | M14 | D07 | | E0004 | M15 | D08 | | E0005 | M01 | D05 | | E0005 | M02 | D07 | | E0005 | M03 | D09 | | E0005 | M04 | D03 | | E0005 | M05 | D03 | | E0005 | M06 | D03 | | E0005 | M07 | D01 | | E0005 | M08 | D10 | | E0005 | M09 | D06 | | E0005 | M10 | D04 | | E0005 | M11 | D02 | | E0005 | M12 | D02 | | E0005 | M13 | D06 | | E0005 | M14 | D07 | | E0005 | M15 | D08 | | E0006 | M01 | D05 | | E0006 | M02 | D07 | | E0006 | M03 | D09 | | E0006 | M04 | D03 | | E0006 | M05 | D03 | | E0006 | M06 | D03 | | E0006 | M07 | D01 | | E0006 | M08 | D10 | | E0006 | M07 | D06 | | E0006 | M08 | D04 | | E0006 | M09 | D02 | | E0006 | M09 | D06 | | E0006 | M10 | D04 | | E0006 | M11 | D02 | | E0006 | M12 | D02 | | E0006 | M13 | D06 | | E0006 | M14 | D07 | | E0006 | M15 | D08 | +---------------+-----------+-----------+ 93 rows in set (0.001 sec) MariaDB [matricula]> exit