MariaDB [(none)]> use parc2; Database changed MariaDB [parc2]> show tables; +---------------------+ | Tables_in_parc2 | +---------------------+ | acudiente | | estudiante | | estudianteacudiente | | estudiantemateria | | materia | | materiaprofesor | | profesor | +---------------------+ 7 rows in set (0.015 sec) MariaDB [parc2]> select * from acudiente; Empty set (0.014 sec) MariaDB [parc2]> describe table acudiente; 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 'table acudiente' at line 1 MariaDB [parc2]> describe acudiente; +-----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+-------+ | codigoAcudiente | int(30) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Direccion | varchar(60) | NO | | NULL | | | Telefono | int(11) | NO | | NULL | | | email | varchar(120) | NO | | NULL | | +-----------------+--------------+------+-----+---------+-------+ 5 rows in set (0.044 sec) MariaDB [parc2]> describe estudiante; +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+-------+ | CodigoEstudiante | int(30) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Direccion | varchar(60) | NO | | NULL | | | Telefono | int(11) | NO | | NULL | | | email | varchar(120) | NO | | NULL | | +------------------+--------------+------+-----+---------+-------+ 5 rows in set (0.028 sec) MariaDB [parc2]> describe estudianteacudiente; +-------------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------+------+-----+---------+-------+ | codigoacudiente1 | int(30) | NO | MUL | NULL | | | codigoestudiante1 | int(30) | NO | MUL | NULL | | +-------------------+---------+------+-----+---------+-------+ 2 rows in set (0.027 sec) MariaDB [parc2]> describe estudiantemateria; +-------------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------+------+-----+---------+-------+ | codigoestudiante2 | int(30) | NO | MUL | NULL | | | codigomateria1 | int(30) | NO | MUL | NULL | | +-------------------+---------+------+-----+---------+-------+ 2 rows in set (0.029 sec) MariaDB [parc2]> describe materia; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | CodigoMateria | int(30) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 2 rows in set (0.033 sec) MariaDB [parc2]> describe materiaprofesor; +-----------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------+------+-----+---------+-------+ | codigoprofesor1 | int(30) | NO | MUL | NULL | | | codigomateria2 | int(30) | NO | MUL | NULL | | +-----------------+---------+------+-----+---------+-------+ 2 rows in set (0.031 sec) MariaDB [parc2]> describe profesor; +----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+-------+ | codigoprofesor | int(30) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Direccion | varchar(60) | NO | | NULL | | | Telefono | int(11) | NO | | NULL | | | email | varchar(120) | NO | | NULL | | +----------------+--------------+------+-----+---------+-------+ 5 rows in set (0.023 sec) MariaDB [parc2]> insert into acudiente (codigoacudiente,nombre, direccion, telefono, email)values('001','acevedo cardona esteban', 'barrio la pradera','5846069', 'estebancardona@gmail.com'); Query OK, 1 row affected (0.015 sec) MariaDB [parc2]> insert into acudiente (codigoacudiente,nombre, direccion, telefono, email)values('002','agudelo manco diana patricia', 'barrio rosaledaď,'5882104','dianapatricia@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 '5882104','dianapatricia@gmail.com'); '' at line 1 MariaDB [parc2]> insert into acudiente (codigoacudiente,nombre, direccion, telefono, email)values('002','agudelo manco diana patricia', 'barrio rosaleda','5882104','dianapatricia@gmail.com'); Query OK, 1 row affected (0.013 sec) MariaDB [parc2]> select * from acudiente; +-----------------+------------------------------+-------------------+----------+--------------------------+ | codigoAcudiente | Nombre | Direccion | Telefono | email | +-----------------+------------------------------+-------------------+----------+--------------------------+ | 1 | acevedo cardona esteban | barrio la pradera | 5846069 | estebancardona@gmail.com | | 2 | agudelo manco diana patricia | barrio rosaleda | 5882104 | dianapatricia@gmail.com | +-----------------+------------------------------+-------------------+----------+--------------------------+ 2 rows in set (0.002 sec) MariaDB [parc2]> insert into acudiente (codigoacudiente,nombre, direccion, telefono, email)values('003','zapata valencia jorge', 'barrio aragon','5841998','jorgezapata@gmail.com'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into acudiente (codigoacudiente,nombre, direccion, telefono, email)values('004','velasquez cano jenny astrid', 'barrio la pradera','2791469','jennyvelasquez@gmail.com'); Query OK, 1 row affected (0.012 sec) MariaDB [parc2]> insert into acudiente (codigoacudiente,nombre, direccion, telefono, email)values('005','posada vasco ana', 'urbanizacion compartir','2868617','anaposada@gmail.com'); Query OK, 1 row affected (0.012 sec) MariaDB [parc2]> insert into acudiente (codigoacudiente,nombre, direccion, telefono, email)values('006','ortiz puerta indira', 'urbanizacion ciudadela prado','5841497','indiraortiz@gmail.com'); Query OK, 1 row affected (0.004 sec) MariaDB [parc2]> insert into acudiente (codigoacudiente,nombre, direccion, telefono, email)values('007','quintero meneses adriana maria', 'barrio san gabriel','5840570','adrianaquintero@gmail.com'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into acudiente (codigoacudiente,nombre, direccion, telefono, email)values('008','montoya rivera edilma', 'barrio la pradera','3767289','edilmamontoya@gmail.com'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into acudiente (codigoacudiente,nombre, direccion, telefono, email)values('009','lopera monsalve fernando alonso', 'barrio limonar1','5709957','fernandolopera@gmail.com'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into acudiente (codigoacudiente,nombre, direccion, telefono, email)values('010','henao rios dora emilse', 'barrio limonar2','2866222','dorahenao@gmail.com'); Query OK, 1 row affected (0.005 sec) MariaDB [parc2]> insert into estudiante (codigoestudiante,nombre, direccion, telefono, email)values('00001','acevedo buritica juan esteban', 'barrio limonar2','2866222','dorahenao@gmail.com'); Query OK, 1 row affected (0.036 sec) MariaDB [parc2]> delete from estudiante -> codigoestudiante = '00001'; 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 'codigoestudiante = '00001'' at line 2 MariaDB [parc2]> delete from estudiante -> where codigoestudiante = '00001'; Query OK, 1 row affected (0.057 sec) MariaDB [parc2]> select * from estudiante -> ; Empty set (0.009 sec) MariaDB [parc2]> insert into estudiante (codigoestudiante,nombre, direccion, telefono, email)values('00001','acevedo buritica juan esteban', 'barrio la pradera','5846069','juanestebacardona@gmail.com'); Query OK, 1 row affected (0.178 sec) MariaDB [parc2]> insert into estudiante (codigoestudiante,nombre, direccion, telefono, email)values('00002','alvarez agudelo esteban', 'barrio rosaleda','5882104','estebanalvarez@gmail.com'); Query OK, 1 row affected (0.059 sec) MariaDB [parc2]> select * from estudiante -> ; +------------------+-------------------------------+-------------------+----------+-----------------------------+ | CodigoEstudiante | Nombre | Direccion | Telefono | email | +------------------+-------------------------------+-------------------+----------+-----------------------------+ | 1 | acevedo buritica juan esteban | barrio la pradera | 5846069 | juanestebacardona@gmail.com | | 2 | alvarez agudelo esteban | barrio rosaleda | 5882104 | estebanalvarez@gmail.com | +------------------+-------------------------------+-------------------+----------+-----------------------------+ 2 rows in set (0.028 sec) MariaDB [parc2]> insert into estudiante (codigoestudiante,nombre, direccion, telefono, email)values('00003','zapata campi¤o isabel', 'barrio aragon','58419198','zapataisabel@gmail.com'); Query OK, 1 row affected (0.032 sec) MariaDB [parc2]> insert into estudiante (codigoestudiante,nombre, direccion, telefono, email)values('00004','valle velasquez sofia', 'barrio la pradera','2791469','sofiavelasquez@gmail.com'); Query OK, 1 row affected (0.004 sec) MariaDB [parc2]> insert into estudiante (codigoestudiante,nombre, direccion, telefono, email)values('00005','moreno posada diego alejandro', 'urbanizacion compartir','2868617','diegomoreno@gmail.com'); Query OK, 1 row affected (0.004 sec) MariaDB [parc2]> insert into estudiante (codigoestudiante,nombre, direccion, telefono, email)values('00006','alzate ortiz jorge mario', 'urbanizacion ciudadela prado','5841497','marioalzae@gmail.com'); Query OK, 1 row affected (0.004 sec) MariaDB [parc2]> insert into estudiante (codigoestudiante,nombre, direccion, telefono, email)values('00007','zapata quintero jose maria', 'barrio sangabriel','5840570','josezapata@gmail.com'); Query OK, 1 row affected (0.104 sec) MariaDB [parc2]> insert into estudiante (codigoestudiante,nombre, direccion, telefono, email)values('00008','montoya montoya alejandro', 'barriola pradera','3767289','alejandromontoya@gmail.com'); Query OK, 1 row affected (0.005 sec) MariaDB [parc2]> insert into estudiante (codigoestudiante,nombre, direccion, telefono, email)values('00009','lopera cartagena luisa fernanda', 'barrio el limonar 1','5709957','luisalopera@gmail.com'); Query OK, 1 row affected (0.005 sec) MariaDB [parc2]> insert into estudiante (codigoestudiante,nombre, direccion, telefono, email)values('00010','jaramillo henao jose luis', 'barrio el limonar 2','2866222','josearamillo@gmail.com'); Query OK, 1 row affected (0.004 sec) MariaDB [parc2]> insert into estudiante (codigoestudiante,nombre, direccion, telefono, email)values('00011','alvarez agudelo luna', 'barrio rosaleda','5882104','lunaalvarez@gmail.com'); Query OK, 1 row affected (0.004 sec) MariaDB [parc2]> insert into estudiante (codigoestudiante,nombre, direccion, telefono, email)values('00012','alvarez agudelo xavier', 'barrio rosaleda','5882104','xavieralvarez@gmail.com'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('01','espa¤ol'); Query OK, 1 row affected (0.015 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('02','lectoescritura'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('03','matematicas'); Query OK, 1 row affected (0.005 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('04','ciencias naturales'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('05','investigacion'); Query OK, 1 row affected (0.007 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('06','fisica'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('07','filosofia'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('08','educacion fisica'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('09','etica'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('10','artistica'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('11','tecnologia'); Query OK, 1 row affected (0.009 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('12','informatica'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('13','religion'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('14','sociales'); Query OK, 1 row affected (0.009 sec) MariaDB [parc2]> insert into materia (codigomateria, nombre)values('15','ingles'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into profesor (codigoprofesor,nombre, direccion, telefono, email)values('001','cifuentes mesa myeidy maria', '','','lunaalvarez@gmail.com'); Query OK, 1 row affected, 1 warning (0.005 sec) MariaDB [parc2]> select * from profesor; +----------------+-----------------------------+-----------+----------+-----------------------+ | codigoprofesor | Nombre | Direccion | Telefono | email | +----------------+-----------------------------+-----------+----------+-----------------------+ | 1 | cifuentes mesa myeidy maria | | 0 | lunaalvarez@gmail.com | +----------------+-----------------------------+-----------+----------+-----------------------+ 1 row in set (0.001 sec) MariaDB [parc2]> delete from profesor -> where codigoprofesor = '001'; Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into profesor (codigoprofesor,nombre, direccion, telefono, email)values('001','cifuentes mesa myeidy maria', '','','myleidym.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.010 sec) MariaDB [parc2]> insert into profesor (codigoprofesor,nombre, direccion, telefono, email)values('002','cuadrado perez astrid jose', '','','adrid.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.010 sec) MariaDB [parc2]> insert into profesor (codigoprofesor,nombre, direccion, telefono, email)values('003','duque restrepo ester lucia', '','','ester.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [parc2]> insert into profesor (codigoprofesor,nombre, direccion, telefono, email)values('004','guirales mauricio', '','','mauriciog.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [parc2]> insert into profesor (codigoprofesor,nombre, direccion, telefono, email)values('005','vera daza maria elena', '','','mariae.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [parc2]> insert into profesor (codigoprofesor,nombre, direccion, telefono, email)values('006','palacio tomas felipe', '','','tomasf.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.009 sec) MariaDB [parc2]> insert into profesor (codigoprofesor,nombre, direccion, telefono, email)values('007','mosquera osorio maryeth', '','','maryeth.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.007 sec) MariaDB [parc2]> insert into profesor (codigoprofesor,nombre, direccion, telefono, email)values('008','arboleda vargas maria ofelia', '','','ofeliaa.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [parc2]> insert into profesor (codigoprofesor,nombre, direccion, telefono, email)values('009','moscote marulanda yanet maria', '','','yanetm.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [parc2]> insert into profesor (codigoprofesor,nombre, direccion, telefono, email)values('010','macias edgar alberto', '','','edgarm.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [parc2]> insert into estudianteacudiente (codigoacudiente1,codigoestudiante1)values('001', '00001'); Query OK, 1 row affected (0.007 sec) MariaDB [parc2]> insert into estudianteacudiente (codigoacudiente1,codigoestudiante1)values('002', '00002'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudianteacudiente (codigoacudiente1,codigoestudiante1)values('003', '00003'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudianteacudiente (codigoacudiente1,codigoestudiante1)values('004', '00004'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudianteacudiente (codigoacudiente1,codigoestudiante1)values('005', '00005'); Query OK, 1 row affected (0.009 sec) MariaDB [parc2]> insert into estudianteacudiente (codigoacudiente1,codigoestudiante1)values('006', '00006'); Query OK, 1 row affected (0.009 sec) MariaDB [parc2]> insert into estudianteacudiente (codigoacudiente1,codigoestudiante1)values('007', '00007'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudianteacudiente (codigoacudiente1,codigoestudiante1)values('008', '00008'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudianteacudiente (codigoacudiente1,codigoestudiante1)values('009', '00009'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudianteacudiente (codigoacudiente1,codigoestudiante1)values('010', '00010'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudianteacudiente (codigoacudiente1,codigoestudiante1)values('001', '00011'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudianteacudiente (codigoacudiente1,codigoestudiante1)values('001', '00012'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> select * from estudianteacudiente; +------------------+-------------------+ | codigoacudiente1 | codigoestudiante1 | +------------------+-------------------+ | 1 | 1 | | 2 | 2 | | 3 | 3 | | 4 | 4 | | 5 | 5 | | 6 | 6 | | 7 | 7 | | 8 | 8 | | 9 | 9 | | 10 | 10 | | 1 | 11 | | 1 | 12 | +------------------+-------------------+ 12 rows in set (0.001 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('01','005'); Query OK, 1 row affected (0.013 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('02','007'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('03','009'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('04','003'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('05','003'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('06','003'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('07','001'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('08','010'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('09','006'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('10','004'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('11','002'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('12','002'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('13','006'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('14','007'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into materiaprofesor (codigomateria2, codigoprofesor1)values('15','008'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (cogidoestudiante2,codigomateria1)values('001','01'); ERROR 1054 (42S22): Unknown column 'cogidoestudiante2' in 'field list' MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','01'); Query OK, 1 row affected (0.013 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','02'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','03'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','04'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','05'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','06'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','07'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','08'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','09'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','10'); Query OK, 1 row affected (0.004 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','11'); Query OK, 1 row affected (0.004 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','12'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','13'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','14'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','15'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','01'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','02'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','03'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','04'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','05'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','06'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','07'); Query OK, 1 row affected (0.020 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','08'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','09'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','10'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','11'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','12'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','13'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','14'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','15'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','01'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','02'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','03'); Query OK, 1 row affected (0.009 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','04'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','05'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','06'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','07'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','08'); Query OK, 1 row affected (0.012 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','09'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','010'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','011'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','012'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','013'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','014'); Query OK, 1 row affected (0.009 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','015'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','01'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> delete from estudiantemateria -> ; Query OK, 46 rows affected (0.016 sec) MariaDB [parc2]> select * from estudiantemateria; Empty set (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','01'); Query OK, 1 row affected (0.004 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','02'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','03'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','04'); Query OK, 1 row affected (0.004 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','05'); Query OK, 1 row affected (0.005 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','06'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','07'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','08'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','09'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','10'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','11'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','12'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','13'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','14'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('001','15'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002,'01'); '> '> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','01'); '> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','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 '01'); insert into estudiantemateria (codigoestudiante2,codigomateria1)values...' at line 1 MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','01'); Query OK, 1 row affected (0.005 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','02'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','03'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','04'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','05'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','06'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','07'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','08'); Query OK, 1 row affected (0.009 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','09'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','10'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','11'); Query OK, 1 row affected (0.004 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','12'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','13'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','14'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('002','15'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','01'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','02'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','03'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','04'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','05'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','06'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','07'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','08'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','09'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','10'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','11'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','12'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','13'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','14'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('003','15'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','01'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','02'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','03'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','04'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','05'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','06'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','07'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','07'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> update estudiantemateria -> set codigomateria = '08' -> where codigoestudiante2 = '004' and codigomateria1 = '07'; ERROR 1054 (42S22): Unknown column 'codigomateria' in 'field list' MariaDB [parc2]> update estudiantemateria -> set codigomateria1 = '08' -> where codigoestudiante2 = '004' and codigomateria1 = '07'; Query OK, 2 rows affected (0.020 sec) Rows matched: 2 Changed: 2 Warnings: 0 MariaDB [parc2]> select * from estudiantemateria where codigoestudiante2= '004'; +-------------------+----------------+ | codigoestudiante2 | codigomateria1 | +-------------------+----------------+ | 4 | 1 | | 4 | 2 | | 4 | 3 | | 4 | 4 | | 4 | 5 | | 4 | 6 | | 4 | 8 | | 4 | 8 | +-------------------+----------------+ 8 rows in set (0.009 sec) MariaDB [parc2]> delete from estudiantemateria -> where codigoestudiante2 = '004' and codigomateria1 = '08' -> limit 2; Query OK, 2 rows affected (0.013 sec) MariaDB [parc2]> select * from estudiantemateria where codigoestudiante2 = '004'; +-------------------+----------------+ | codigoestudiante2 | codigomateria1 | +-------------------+----------------+ | 4 | 1 | | 4 | 2 | | 4 | 3 | | 4 | 4 | | 4 | 5 | | 4 | 6 | +-------------------+----------------+ 6 rows in set (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','07'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','08'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','09'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','10'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','11'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','12'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','13'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','14'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('004','15'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','01'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','02'); Query OK, 1 row affected (0.013 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','03'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','04'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','05'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','06'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','07'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','08'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','09'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','10'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','11'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','12'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','13'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','14'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('005','15'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','01'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','02'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','03'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','04'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','05'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','06'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','07'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','08'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','09'); Query OK, 1 row affected (0.003 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','10'); Query OK, 1 row affected (0.011 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','11'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','12'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','13'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','14'); Query OK, 1 row affected (0.010 sec) MariaDB [parc2]> insert into estudiantemateria (codigoestudiante2,codigomateria1)values('006','15'); Query OK, 1 row affected (0.002 sec) MariaDB [parc2]> select * from estudiantemateria -> ; +-------------------+----------------+ | codigoestudiante2 | codigomateria1 | +-------------------+----------------+ | 1 | 1 | | 1 | 2 | | 1 | 3 | | 1 | 4 | | 1 | 5 | | 1 | 6 | | 1 | 7 | | 1 | 8 | | 1 | 9 | | 1 | 10 | | 1 | 11 | | 1 | 12 | | 1 | 13 | | 1 | 14 | | 1 | 15 | | 2 | 1 | | 2 | 2 | | 2 | 3 | | 2 | 4 | | 2 | 5 | | 2 | 6 | | 2 | 7 | | 2 | 8 | | 2 | 9 | | 2 | 10 | | 2 | 11 | | 2 | 12 | | 2 | 13 | | 2 | 14 | | 2 | 15 | | 3 | 1 | | 3 | 2 | | 3 | 3 | | 3 | 4 | | 3 | 5 | | 3 | 6 | | 3 | 7 | | 3 | 8 | | 3 | 9 | | 3 | 10 | | 3 | 11 | | 3 | 12 | | 3 | 13 | | 3 | 14 | | 3 | 15 | | 4 | 1 | | 4 | 2 | | 4 | 3 | | 4 | 4 | | 4 | 5 | | 4 | 6 | | 4 | 7 | | 4 | 8 | | 4 | 9 | | 4 | 10 | | 4 | 11 | | 4 | 12 | | 4 | 13 | | 4 | 14 | | 4 | 15 | | 5 | 1 | | 5 | 2 | | 5 | 3 | | 5 | 4 | | 5 | 5 | | 5 | 6 | | 5 | 7 | | 5 | 8 | | 5 | 9 | | 5 | 10 | | 5 | 11 | | 5 | 12 | | 5 | 13 | | 5 | 14 | | 5 | 15 | | 6 | 1 | | 6 | 2 | | 6 | 3 | | 6 | 4 | | 6 | 5 | | 6 | 6 | | 6 | 7 | | 6 | 8 | | 6 | 9 | | 6 | 10 | | 6 | 11 | | 6 | 12 | | 6 | 13 | | 6 | 14 | | 6 | 15 | +-------------------+----------------+ 90 rows in set (0.001 sec) MariaDB [parc2]> select * from materiaprofesor; +-----------------+----------------+ | codigoprofesor1 | codigomateria2 | +-----------------+----------------+ | 5 | 1 | | 7 | 2 | | 9 | 3 | | 3 | 4 | | 3 | 5 | | 3 | 6 | | 1 | 7 | | 10 | 8 | | 6 | 9 | | 4 | 10 | | 2 | 11 | | 2 | 12 | | 6 | 13 | | 7 | 14 | | 8 | 15 | +-----------------+----------------+ 15 rows in set (0.010 sec) MariaDB [parc2]> select *from profesor; +----------------+-------------------------------+-----------+----------+---------------------------+ | codigoprofesor | Nombre | Direccion | Telefono | email | +----------------+-------------------------------+-----------+----------+---------------------------+ | 1 | cifuentes mesa myeidy maria | | 0 | myleidym.iearm@gmail.com | | 2 | cuadrado perez astrid jose | | 0 | adrid.iearm@gmail.com | | 3 | duque restrepo ester lucia | | 0 | ester.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.010 sec) MariaDB [parc2]> select * from materia; +---------------+--------------------+ | CodigoMateria | Nombre | +---------------+--------------------+ | 1 | espa¤ol | | 2 | lectoescritura | | 3 | matematicas | | 4 | ciencias naturales | | 5 | investigacion | | 6 | fisica | | 7 | filosofia | | 8 | educacion fisica | | 9 | etica | | 10 | artistica | | 11 | tecnologia | | 12 | informatica | | 13 | religion | | 14 | sociales | | 15 | ingles | +---------------+--------------------+ 15 rows in set (0.004 sec) MariaDB [parc2]> select * from estudiante; +------------------+---------------------------------+------------------------------+----------+-----------------------------+ | CodigoEstudiante | Nombre | Direccion | Telefono | email | +------------------+---------------------------------+------------------------------+----------+-----------------------------+ | 1 | acevedo buritica juan esteban | barrio la pradera | 5846069 | juanestebacardona@gmail.com | | 2 | alvarez agudelo esteban | barrio rosaleda | 5882104 | estebanalvarez@gmail.com | | 3 | zapata campi¤o isabel | barrio aragon | 58419198 | 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 | barriola 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.002 sec) MariaDB [parc2]> select * from acudiente; +-----------------+---------------------------------+------------------------------+----------+---------------------------+ | codigoAcudiente | Nombre | Direccion | Telefono | email | +-----------------+---------------------------------+------------------------------+----------+---------------------------+ | 1 | acevedo cardona esteban | barrio la pradera | 5846069 | estebancardona@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 maria | barrio san gabriel | 5840570 | adrianaquintero@gmail.com | | 8 | montoya rivera edilma | barrio la pradera | 3767289 | edilmamontoya@gmail.com | | 9 | lopera monsalve fernando alonso | barrio limonar1 | 5709957 | fernandolopera@gmail.com | | 10 | henao rios dora emilse | barrio limonar2 | 2866222 | dorahenao@gmail.com | +-----------------+---------------------------------+------------------------------+----------+---------------------------+ 10 rows in set (0.012 sec) MariaDB [parc2]> select estudiante.codigoestudiante, estudiante.nombre as 'nombre del estudiante', acudiente.codigoacudiente, acudiente.nombre as 'nombre del acudiente' from estudiante join estudianteacudiente on estudiante.codigoestudiante = estudianteacudiente.codigoestudiante1 join acudiente on acudiente.codigoacudiente = estudianteacudiente.codigoacudiente1; +------------------+---------------------------------+-----------------+---------------------------------+ | codigoestudiante | nombre del estudiante | codigoacudiente | nombre del acudiente | +------------------+---------------------------------+-----------------+---------------------------------+ | 1 | acevedo buritica juan esteban | 1 | acevedo cardona esteban | | 2 | alvarez agudelo esteban | 2 | agudelo manco diana patricia | | 3 | zapata campi¤o isabel | 3 | zapata valencia jorge | | 4 | valle velasquez sofia | 4 | velasquez cano jenny astrid | | 5 | moreno posada diego alejandro | 5 | posada vasco ana | | 6 | alzate ortiz jorge mario | 6 | ortiz puerta indira | | 7 | zapata quintero jose maria | 7 | quintero meneses adriana maria | | 8 | montoya montoya alejandro | 8 | montoya rivera edilma | | 9 | lopera cartagena luisa fernanda | 9 | lopera monsalve fernando alonso | | 10 | jaramillo henao jose luis | 10 | henao rios dora emilse | | 11 | alvarez agudelo luna | 1 | acevedo cardona esteban | | 12 | alvarez agudelo xavier | 1 | acevedo cardona esteban | +------------------+---------------------------------+-----------------+---------------------------------+ 12 rows in set (0.025 sec) MariaDB [parc2]> select estudiante.codigoestudiante,estudiante.nombre from estudiante left join estudianteacudiente on estudiante.codigoestudiante=estudianteacudiente.codigoestudiante1 where estudianteacudiente.codigoestudiante1 is null; Empty set (0.008 sec) MariaDB [parc2]> select acudiente.codigoacudiente, acudiente.nombre from acudiente left join estudianteacudiente on acudiente.codigoacudiente=estudianteacudiente.codigoacudiente1 wherer estudianteacudiente.codigoacudiente1 is 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 'wherer estudianteacudiente.codigoacudiente1 is null' at line 1 MariaDB [parc2]> select acudiente.codigoacudiente, acudiente.nombre from acudiente left join estudianteacudiente on acudiente.codigoacudiente=estudianteacudiente.codigoacudiente1 where estudianteacudiente.codigoacudiente1 is null; Empty set (0.007 sec) MariaDB [parc2]> select estudiante.codigoestudiante, materia.codigomateria, materia.nombre from estudiantemateria join materia on estudiantemateria.codigomateria1 = materia.codigomateria where estudiantemateria.codigoestudiante2 = '00001'; ERROR 1054 (42S22): Unknown column 'estudiante.codigoestudiante' in 'field list' MariaDB [parc2]> select estudiante.codigoestudiante, materia.codigomateria, materia.nombre from estudiantemateria join materia on estudiantemateria.codigomateria1 = materia.codigomateria where estudiantemateria.codigoestudiante2 = 00001; ERROR 1054 (42S22): Unknown column 'estudiante.codigoestudiante' in 'field list' MariaDB [parc2]> select estudiante.codigoestudiante, materia.codigomateria, materia.nombre from estudiantemateria join materia on estudiantemateria.codigomateria1 = materia.codigomateria where estudiantemateria.codigoestudiante2 = 1; ERROR 1054 (42S22): Unknown column 'estudiante.codigoestudiante' in 'field list' MariaDB [parc2]> select estudiante.codigoestudiante, materia.codigomateria, materia.nombre from estudiante join estudiantemateria on estudiante.codigoestudiante = estudiantemateria.codigoestudiante2 join materia on estudiantemateria.codigomateria1 = materia.codigomateria where estudiante.codigoestudiante = 1; +------------------+---------------+--------------------+ | codigoestudiante | codigomateria | nombre | +------------------+---------------+--------------------+ | 1 | 1 | espa¤ol | | 1 | 2 | lectoescritura | | 1 | 3 | matematicas | | 1 | 4 | ciencias naturales | | 1 | 5 | investigacion | | 1 | 6 | fisica | | 1 | 7 | filosofia | | 1 | 8 | educacion fisica | | 1 | 9 | etica | | 1 | 10 | artistica | | 1 | 11 | tecnologia | | 1 | 12 | informatica | | 1 | 13 | religion | | 1 | 14 | sociales | | 1 | 15 | ingles | +------------------+---------------+--------------------+ 15 rows in set (0.009 sec) MariaDB [parc2]> select estudiante.codigoestudiante,estudiante.nombre as 'Nombre del estudiante', materia.codigomateria, materia.nombre as 'materia' from estudiante join estudiantemateria on estudiante.codigoestudiante = estudiantemateria.codigoestudiante2 join materia on estudiantemateria.codigomateria1 = materia.codigomateria; +------------------+-------------------------------+---------------+--------------------+ | codigoestudiante | Nombre del estudiante | codigomateria | materia | +------------------+-------------------------------+---------------+--------------------+ | 1 | acevedo buritica juan esteban | 1 | espa¤ol | | 2 | alvarez agudelo esteban | 1 | espa¤ol | | 3 | zapata campi¤o isabel | 1 | espa¤ol | | 4 | valle velasquez sofia | 1 | espa¤ol | | 5 | moreno posada diego alejandro | 1 | espa¤ol | | 6 | alzate ortiz jorge mario | 1 | espa¤ol | | 1 | acevedo buritica juan esteban | 2 | lectoescritura | | 2 | alvarez agudelo esteban | 2 | lectoescritura | | 3 | zapata campi¤o isabel | 2 | lectoescritura | | 4 | valle velasquez sofia | 2 | lectoescritura | | 5 | moreno posada diego alejandro | 2 | lectoescritura | | 6 | alzate ortiz jorge mario | 2 | lectoescritura | | 1 | acevedo buritica juan esteban | 3 | matematicas | | 2 | alvarez agudelo esteban | 3 | matematicas | | 3 | zapata campi¤o isabel | 3 | matematicas | | 4 | valle velasquez sofia | 3 | matematicas | | 5 | moreno posada diego alejandro | 3 | matematicas | | 6 | alzate ortiz jorge mario | 3 | matematicas | | 1 | acevedo buritica juan esteban | 4 | ciencias naturales | | 2 | alvarez agudelo esteban | 4 | ciencias naturales | | 3 | zapata campi¤o isabel | 4 | ciencias naturales | | 4 | valle velasquez sofia | 4 | ciencias naturales | | 5 | moreno posada diego alejandro | 4 | ciencias naturales | | 6 | alzate ortiz jorge mario | 4 | ciencias naturales | | 1 | acevedo buritica juan esteban | 5 | investigacion | | 2 | alvarez agudelo esteban | 5 | investigacion | | 3 | zapata campi¤o isabel | 5 | investigacion | | 4 | valle velasquez sofia | 5 | investigacion | | 5 | moreno posada diego alejandro | 5 | investigacion | | 6 | alzate ortiz jorge mario | 5 | investigacion | | 1 | acevedo buritica juan esteban | 6 | fisica | | 2 | alvarez agudelo esteban | 6 | fisica | | 3 | zapata campi¤o isabel | 6 | fisica | | 4 | valle velasquez sofia | 6 | fisica | | 5 | moreno posada diego alejandro | 6 | fisica | | 6 | alzate ortiz jorge mario | 6 | fisica | | 1 | acevedo buritica juan esteban | 7 | filosofia | | 2 | alvarez agudelo esteban | 7 | filosofia | | 3 | zapata campi¤o isabel | 7 | filosofia | | 4 | valle velasquez sofia | 7 | filosofia | | 5 | moreno posada diego alejandro | 7 | filosofia | | 6 | alzate ortiz jorge mario | 7 | filosofia | | 1 | acevedo buritica juan esteban | 8 | educacion fisica | | 2 | alvarez agudelo esteban | 8 | educacion fisica | | 3 | zapata campi¤o isabel | 8 | educacion fisica | | 4 | valle velasquez sofia | 8 | educacion fisica | | 5 | moreno posada diego alejandro | 8 | educacion fisica | | 6 | alzate ortiz jorge mario | 8 | educacion fisica | | 1 | acevedo buritica juan esteban | 9 | etica | | 2 | alvarez agudelo esteban | 9 | etica | | 3 | zapata campi¤o isabel | 9 | etica | | 4 | valle velasquez sofia | 9 | etica | | 5 | moreno posada diego alejandro | 9 | etica | | 6 | alzate ortiz jorge mario | 9 | etica | | 1 | acevedo buritica juan esteban | 10 | artistica | | 2 | alvarez agudelo esteban | 10 | artistica | | 3 | zapata campi¤o isabel | 10 | artistica | | 4 | valle velasquez sofia | 10 | artistica | | 5 | moreno posada diego alejandro | 10 | artistica | | 6 | alzate ortiz jorge mario | 10 | artistica | | 1 | acevedo buritica juan esteban | 11 | tecnologia | | 2 | alvarez agudelo esteban | 11 | tecnologia | | 3 | zapata campi¤o isabel | 11 | tecnologia | | 4 | valle velasquez sofia | 11 | tecnologia | | 5 | moreno posada diego alejandro | 11 | tecnologia | | 6 | alzate ortiz jorge mario | 11 | tecnologia | | 1 | acevedo buritica juan esteban | 12 | informatica | | 2 | alvarez agudelo esteban | 12 | informatica | | 3 | zapata campi¤o isabel | 12 | informatica | | 4 | valle velasquez sofia | 12 | informatica | | 5 | moreno posada diego alejandro | 12 | informatica | | 6 | alzate ortiz jorge mario | 12 | informatica | | 1 | acevedo buritica juan esteban | 13 | religion | | 2 | alvarez agudelo esteban | 13 | religion | | 3 | zapata campi¤o isabel | 13 | religion | | 4 | valle velasquez sofia | 13 | religion | | 5 | moreno posada diego alejandro | 13 | religion | | 6 | alzate ortiz jorge mario | 13 | religion | | 1 | acevedo buritica juan esteban | 14 | sociales | | 2 | alvarez agudelo esteban | 14 | sociales | | 3 | zapata campi¤o isabel | 14 | sociales | | 4 | valle velasquez sofia | 14 | sociales | | 5 | moreno posada diego alejandro | 14 | sociales | | 6 | alzate ortiz jorge mario | 14 | sociales | | 1 | acevedo buritica juan esteban | 15 | ingles | | 2 | alvarez agudelo esteban | 15 | ingles | | 3 | zapata campi¤o isabel | 15 | ingles | | 4 | valle velasquez sofia | 15 | ingles | | 5 | moreno posada diego alejandro | 15 | ingles | | 6 | alzate ortiz jorge mario | 15 | ingles | +------------------+-------------------------------+---------------+--------------------+ 90 rows in set (0.004 sec) MariaDB [parc2]> select estudiante.codigoestudiante, estudiante.nombre from estudiante left join estudiantemateria on estudiante.codigoestudiante = estudiantemateria.codigoestudiante2 where estudiantemateria.codigoestudiante2 is null; +------------------+---------------------------------+ | codigoestudiante | nombre | +------------------+---------------------------------+ | 7 | zapata quintero jose maria | | 8 | montoya montoya alejandro | | 9 | lopera cartagena luisa fernanda | | 10 | jaramillo henao jose luis | | 11 | alvarez agudelo luna | | 12 | alvarez agudelo xavier | +------------------+---------------------------------+ 6 rows in set (0.002 sec) MariaDB [parc2]> select materia.codigomateria, materia.nombre from materia left join estudiantemateria on materia.codigomateria = estudiantemateria.codigomateria1 where estudiantemateria.codigomateria1 is null; Empty set (0.001 sec) MariaDB [parc2]> select profesor.codigoprofesor, profesor.nombre as 'Nombre del profesor', materia.codigomateria, materia.nombre as 'materia' from profesor join materiaprofesor on profesor.codigoprofesor = materiaprofesor.codigoprofesor1 join materia on materiaprofesor.codigomateria2 = materia.codigomateria; +----------------+-------------------------------+---------------+--------------------+ | codigoprofesor | Nombre del profesor | codigomateria | materia | +----------------+-------------------------------+---------------+--------------------+ | 1 | cifuentes mesa myeidy maria | 7 | filosofia | | 2 | cuadrado perez astrid jose | 11 | tecnologia | | 2 | cuadrado perez astrid jose | 12 | informatica | | 3 | duque restrepo ester lucia | 4 | ciencias naturales | | 3 | duque restrepo ester lucia | 5 | investigacion | | 3 | duque restrepo ester lucia | 6 | fisica | | 4 | guirales mauricio | 10 | artistica | | 5 | vera daza maria elena | 1 | espa¤ol | | 6 | palacio tomas felipe | 9 | etica | | 6 | palacio tomas felipe | 13 | religion | | 7 | mosquera osorio maryeth | 2 | lectoescritura | | 7 | mosquera osorio maryeth | 14 | sociales | | 8 | arboleda vargas maria ofelia | 15 | ingles | | 9 | moscote marulanda yanet maria | 3 | matematicas | | 10 | macias edgar alberto | 8 | educacion fisica | +----------------+-------------------------------+---------------+--------------------+ 15 rows in set (0.004 sec) MariaDB [parc2]> select materia.codigomateria, materia.nombre from materia left join materiaprofesor on materia.codigomateria= materiaprofesor.codigomateria2 where materiaprofesor.codigomateria2 is null; Empty set (0.003 sec) MariaDB [parc2]> select profesor.codigoprofesor, profesor.nombre from profesor left join materiaprofesor on profesor.codigoprofesor = materiaprofesor.codigoprofesor1 where materiaprofesor.codigoprofesor1 is null; Empty set (0.001 sec) MariaDB [parc2]> select estudiante.codigoestudiante, estudiante.nombre as 'Nombre del estudiante', materia.codigomateria, materia.nombre as 'materia', profesor.codigoprofesor, profesor.nombre as 'profesor' from estudiante join estudiantemateria on estudiante.codigoestudiante = estudiantemateria.codigoestudiante2 join materia on estudiantemateria.codigomateria1=materia.codigomateria join materiaprofesor on materia.codigomateria = materiaprofesor.codigomateria2 join profesor on materiaprofesor.codigoprofesor1 = profesor.codigoprofesor; +------------------+-------------------------------+---------------+--------------------+----------------+-------------------------------+ | codigoestudiante | Nombre del estudiante | codigomateria | materia | codigoprofesor | profesor | +------------------+-------------------------------+---------------+--------------------+----------------+-------------------------------+ | 1 | acevedo buritica juan esteban | 7 | filosofia | 1 | cifuentes mesa myeidy maria | | 2 | alvarez agudelo esteban | 7 | filosofia | 1 | cifuentes mesa myeidy maria | | 3 | zapata campi¤o isabel | 7 | filosofia | 1 | cifuentes mesa myeidy maria | | 4 | valle velasquez sofia | 7 | filosofia | 1 | cifuentes mesa myeidy maria | | 5 | moreno posada diego alejandro | 7 | filosofia | 1 | cifuentes mesa myeidy maria | | 6 | alzate ortiz jorge mario | 7 | filosofia | 1 | cifuentes mesa myeidy maria | | 1 | acevedo buritica juan esteban | 11 | tecnologia | 2 | cuadrado perez astrid jose | | 2 | alvarez agudelo esteban | 11 | tecnologia | 2 | cuadrado perez astrid jose | | 3 | zapata campi¤o isabel | 11 | tecnologia | 2 | cuadrado perez astrid jose | | 4 | valle velasquez sofia | 11 | tecnologia | 2 | cuadrado perez astrid jose | | 5 | moreno posada diego alejandro | 11 | tecnologia | 2 | cuadrado perez astrid jose | | 6 | alzate ortiz jorge mario | 11 | tecnologia | 2 | cuadrado perez astrid jose | | 1 | acevedo buritica juan esteban | 12 | informatica | 2 | cuadrado perez astrid jose | | 2 | alvarez agudelo esteban | 12 | informatica | 2 | cuadrado perez astrid jose | | 3 | zapata campi¤o isabel | 12 | informatica | 2 | cuadrado perez astrid jose | | 4 | valle velasquez sofia | 12 | informatica | 2 | cuadrado perez astrid jose | | 5 | moreno posada diego alejandro | 12 | informatica | 2 | cuadrado perez astrid jose | | 6 | alzate ortiz jorge mario | 12 | informatica | 2 | cuadrado perez astrid jose | | 1 | acevedo buritica juan esteban | 4 | ciencias naturales | 3 | duque restrepo ester lucia | | 2 | alvarez agudelo esteban | 4 | ciencias naturales | 3 | duque restrepo ester lucia | | 3 | zapata campi¤o isabel | 4 | ciencias naturales | 3 | duque restrepo ester lucia | | 4 | valle velasquez sofia | 4 | ciencias naturales | 3 | duque restrepo ester lucia | | 5 | moreno posada diego alejandro | 4 | ciencias naturales | 3 | duque restrepo ester lucia | | 6 | alzate ortiz jorge mario | 4 | ciencias naturales | 3 | duque restrepo ester lucia | | 1 | acevedo buritica juan esteban | 5 | investigacion | 3 | duque restrepo ester lucia | | 2 | alvarez agudelo esteban | 5 | investigacion | 3 | duque restrepo ester lucia | | 3 | zapata campi¤o isabel | 5 | investigacion | 3 | duque restrepo ester lucia | | 4 | valle velasquez sofia | 5 | investigacion | 3 | duque restrepo ester lucia | | 5 | moreno posada diego alejandro | 5 | investigacion | 3 | duque restrepo ester lucia | | 6 | alzate ortiz jorge mario | 5 | investigacion | 3 | duque restrepo ester lucia | | 1 | acevedo buritica juan esteban | 6 | fisica | 3 | duque restrepo ester lucia | | 2 | alvarez agudelo esteban | 6 | fisica | 3 | duque restrepo ester lucia | | 3 | zapata campi¤o isabel | 6 | fisica | 3 | duque restrepo ester lucia | | 4 | valle velasquez sofia | 6 | fisica | 3 | duque restrepo ester lucia | | 5 | moreno posada diego alejandro | 6 | fisica | 3 | duque restrepo ester lucia | | 6 | alzate ortiz jorge mario | 6 | fisica | 3 | duque restrepo ester lucia | | 1 | acevedo buritica juan esteban | 10 | artistica | 4 | guirales mauricio | | 2 | alvarez agudelo esteban | 10 | artistica | 4 | guirales mauricio | | 3 | zapata campi¤o isabel | 10 | artistica | 4 | guirales mauricio | | 4 | valle velasquez sofia | 10 | artistica | 4 | guirales mauricio | | 5 | moreno posada diego alejandro | 10 | artistica | 4 | guirales mauricio | | 6 | alzate ortiz jorge mario | 10 | artistica | 4 | guirales mauricio | | 1 | acevedo buritica juan esteban | 1 | espa¤ol | 5 | vera daza maria elena | | 2 | alvarez agudelo esteban | 1 | espa¤ol | 5 | vera daza maria elena | | 3 | zapata campi¤o isabel | 1 | espa¤ol | 5 | vera daza maria elena | | 4 | valle velasquez sofia | 1 | espa¤ol | 5 | vera daza maria elena | | 5 | moreno posada diego alejandro | 1 | espa¤ol | 5 | vera daza maria elena | | 6 | alzate ortiz jorge mario | 1 | espa¤ol | 5 | vera daza maria elena | | 1 | acevedo buritica juan esteban | 9 | etica | 6 | palacio tomas felipe | | 2 | alvarez agudelo esteban | 9 | etica | 6 | palacio tomas felipe | | 3 | zapata campi¤o isabel | 9 | etica | 6 | palacio tomas felipe | | 4 | valle velasquez sofia | 9 | etica | 6 | palacio tomas felipe | | 5 | moreno posada diego alejandro | 9 | etica | 6 | palacio tomas felipe | | 6 | alzate ortiz jorge mario | 9 | etica | 6 | palacio tomas felipe | | 1 | acevedo buritica juan esteban | 13 | religion | 6 | palacio tomas felipe | | 2 | alvarez agudelo esteban | 13 | religion | 6 | palacio tomas felipe | | 3 | zapata campi¤o isabel | 13 | religion | 6 | palacio tomas felipe | | 4 | valle velasquez sofia | 13 | religion | 6 | palacio tomas felipe | | 5 | moreno posada diego alejandro | 13 | religion | 6 | palacio tomas felipe | | 6 | alzate ortiz jorge mario | 13 | religion | 6 | palacio tomas felipe | | 1 | acevedo buritica juan esteban | 2 | lectoescritura | 7 | mosquera osorio maryeth | | 2 | alvarez agudelo esteban | 2 | lectoescritura | 7 | mosquera osorio maryeth | | 3 | zapata campi¤o isabel | 2 | lectoescritura | 7 | mosquera osorio maryeth | | 4 | valle velasquez sofia | 2 | lectoescritura | 7 | mosquera osorio maryeth | | 5 | moreno posada diego alejandro | 2 | lectoescritura | 7 | mosquera osorio maryeth | | 6 | alzate ortiz jorge mario | 2 | lectoescritura | 7 | mosquera osorio maryeth | | 1 | acevedo buritica juan esteban | 14 | sociales | 7 | mosquera osorio maryeth | | 2 | alvarez agudelo esteban | 14 | sociales | 7 | mosquera osorio maryeth | | 3 | zapata campi¤o isabel | 14 | sociales | 7 | mosquera osorio maryeth | | 4 | valle velasquez sofia | 14 | sociales | 7 | mosquera osorio maryeth | | 5 | moreno posada diego alejandro | 14 | sociales | 7 | mosquera osorio maryeth | | 6 | alzate ortiz jorge mario | 14 | sociales | 7 | mosquera osorio maryeth | | 1 | acevedo buritica juan esteban | 15 | ingles | 8 | arboleda vargas maria ofelia | | 2 | alvarez agudelo esteban | 15 | ingles | 8 | arboleda vargas maria ofelia | | 3 | zapata campi¤o isabel | 15 | ingles | 8 | arboleda vargas maria ofelia | | 4 | valle velasquez sofia | 15 | ingles | 8 | arboleda vargas maria ofelia | | 5 | moreno posada diego alejandro | 15 | ingles | 8 | arboleda vargas maria ofelia | | 6 | alzate ortiz jorge mario | 15 | ingles | 8 | arboleda vargas maria ofelia | | 1 | acevedo buritica juan esteban | 3 | matematicas | 9 | moscote marulanda yanet maria | | 2 | alvarez agudelo esteban | 3 | matematicas | 9 | moscote marulanda yanet maria | | 3 | zapata campi¤o isabel | 3 | matematicas | 9 | moscote marulanda yanet maria | | 4 | valle velasquez sofia | 3 | matematicas | 9 | moscote marulanda yanet maria | | 5 | moreno posada diego alejandro | 3 | matematicas | 9 | moscote marulanda yanet maria | | 6 | alzate ortiz jorge mario | 3 | matematicas | 9 | moscote marulanda yanet maria | | 1 | acevedo buritica juan esteban | 8 | educacion fisica | 10 | macias edgar alberto | | 2 | alvarez agudelo esteban | 8 | educacion fisica | 10 | macias edgar alberto | | 3 | zapata campi¤o isabel | 8 | educacion fisica | 10 | macias edgar alberto | | 4 | valle velasquez sofia | 8 | educacion fisica | 10 | macias edgar alberto | | 5 | moreno posada diego alejandro | 8 | educacion fisica | 10 | macias edgar alberto | | 6 | alzate ortiz jorge mario | 8 | educacion fisica | 10 | macias edgar alberto | +------------------+-------------------------------+---------------+--------------------+----------------+-------------------------------+ 90 rows in set (0.006 sec) MariaDB [parc2]> exit