mysql> select * from estudiante where cod_Est in('00001','00002','00003'); +---------+-------------------------------+-------------------+---------+------- -----------------------+ | cod_Est | nom_estudiante | dir_est | tel_est | email_ est | +---------+-------------------------------+-------------------+---------+------- -----------------------+ | 00001 | acevedo buritica juan esteban | barrio la pradera | 5846069 | juanes tebancardona@gmail.com | | 00002 | alvarez agudelo esteban | barrio rosaleda | 5882104 | esteba nlavarez@gmail.com | | 00003 | zapata campiņo isabel | barrio aragon | 5841998 | zapata isabel@gmail.com | +---------+-------------------------------+-------------------+---------+------- -----------------------+ 3 rows in set (0.00 sec) mysql> mysql> select * from estudiante limit 5; +---------+-------------------------------+------------------------+---------+-- ----------------------------+ | cod_Est | nom_estudiante | dir_est | tel_est | e mail_est | +---------+-------------------------------+------------------------+---------+-- ----------------------------+ | 00001 | acevedo buritica juan esteban | barrio la pradera | 5846069 | j uanestebancardona@gmail.com | | 00002 | alvarez agudelo esteban | barrio rosaleda | 5882104 | e stebanlavarez@gmail.com | | 00003 | zapata campiņo isabel | barrio aragon | 5841998 | z apataisabel@gmail.com | | 00004 | valle velasquez sofia | barrio la pradera | 2791469 | s ofiavelasquez@gmail.com | | 00005 | moreno posada diego alejandro | urbanizacion compartir | 2868617 | d iegomoreno@gmail.com | +---------+-------------------------------+------------------------+---------+-- ----------------------------+ 5 rows in set (0.00 sec) mysql> select * from estudiante limit 3,5; +---------+-------------------------------+-------------------------------+----- ----+----------------------------+ | cod_Est | nom_estudiante | dir_est | tel_ est | email_est | +---------+-------------------------------+-------------------------------+----- ----+----------------------------+ | 00004 | valle velasquez sofia | barrio la pradera | 2791 469 | sofiavelasquez@gmail.com | | 00005 | moreno posada diego alejandro | urbanizacion compartir | 2868 617 | diegomoreno@gmail.com | | 00006 | lzate ortiz jorge mario | urbanizacion ciudadela prado | 5841 497 | marioalzate@gmail.com | | 00007 | zapata quintero jose maria | barrio sangabriel | 5840 570 | josezapata@gmail.com | | 00008 | montoya montoya alejandro | barrio la pradera | 3767 289 | alejandromontoya@gmail.com | +---------+-------------------------------+-------------------------------+----- ----+----------------------------+ 5 rows in set (0.00 sec) mysql> describe estudiante; +----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+----------+------+-----+---------+-------+ | cod_Est | char(8) | NO | PRI | NULL | | | nom_estudiante | char(40) | NO | | NULL | | | dir_est | char(40) | NO | | NULL | | | tel_est | char(10) | NO | | NULL | | | email_est | char(40) | NO | | NULL | | +----------------+----------+------+-----+---------+-------+ 5 rows in set (0.02 sec) mysql> mysql> alter table estudiante add cant_Est int(3) not null; Query OK, 0 rows affected (0.27 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> describe estudiante; +----------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+----------+------+-----+---------+-------+ | cod_Est | char(8) | NO | PRI | NULL | | | nom_estudiante | char(40) | NO | | NULL | | | dir_est | char(40) | NO | | NULL | | | tel_est | char(10) | NO | | NULL | | | email_est | char(40) | NO | | NULL | | | cant_Est | int(3) | NO | | NULL | | +----------------+----------+------+-----+---------+-------+ 6 rows in set (0.00 sec) mysql> mysql> select * from estudiante; +---------+---------------------------------+-------------------------------+--- ------+------------------------------+----------+ | cod_Est | nom_estudiante | dir_est | te l_est | email_est | cant_Est | +---------+---------------------------------+-------------------------------+--- ------+------------------------------+----------+ | 00001 | acevedo buritica juan esteban | barrio la pradera | 58 46069 | juanestebancardona@gmail.com | 0 | | 00002 | alvarez agudelo esteban | barrio rosaleda | 58 82104 | estebanlavarez@gmail.com | 0 | | 00003 | zapata campiņo isabel | barrio aragon | 58 41998 | zapataisabel@gmail.com | 0 | | 00004 | valle velasquez sofia | barrio la pradera | 27 91469 | sofiavelasquez@gmail.com | 0 | | 00005 | moreno posada diego alejandro | urbanizacion compartir | 28 68617 | diegomoreno@gmail.com | 0 | | 00006 | lzate ortiz jorge mario | urbanizacion ciudadela prado | 58 41497 | marioalzate@gmail.com | 0 | | 00007 | zapata quintero jose maria | barrio sangabriel | 58 40570 | josezapata@gmail.com | 0 | | 00008 | montoya montoya alejandro | barrio la pradera | 37 67289 | alejandromontoya@gmail.com | 0 | | 00009 | lopera cartagena luisa fernanda | barrio el limonar 1 | 57 09957 | luisalopera@gmail.com | 0 | | 00010 | jaramillo henao jose luis | barrio el limonar 2 | 28 66222 | josearamillo@gmail.com | 0 | | 00011 | alvarez agudelo luna | barrio rosaleda | 58 82104 | lunaalvarez@gmail.com | 0 | | 00012 | alvarez agudelo xavier | barrio rosaleda | 58 82104 | xavieralvarez@gmail.com | 0 | +---------+---------------------------------+-------------------------------+--- ------+------------------------------+----------+ 12 rows in set (0.00 sec) mysql> update estudiante set cant_Est=5 where cod_Est='0003'; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 mysql> select * from estudiante; +---------+---------------------------------+-------------------------------+--- ------+------------------------------+----------+ | cod_Est | nom_estudiante | dir_est | te l_est | email_est | cant_Est | +---------+---------------------------------+-------------------------------+--- ------+------------------------------+----------+ | 00001 | acevedo buritica juan esteban | barrio la pradera | 58 46069 | juanestebancardona@gmail.com | 0 | | 00002 | alvarez agudelo esteban | barrio rosaleda | 58 82104 | estebanlavarez@gmail.com | 0 | | 00003 | zapata campiņo isabel | barrio aragon | 58 41998 | zapataisabel@gmail.com | 0 | | 00004 | valle velasquez sofia | barrio la pradera | 27 91469 | sofiavelasquez@gmail.com | 0 | | 00005 | moreno posada diego alejandro | urbanizacion compartir | 28 68617 | diegomoreno@gmail.com | 0 | | 00006 | lzate ortiz jorge mario | urbanizacion ciudadela prado | 58 41497 | marioalzate@gmail.com | 0 | | 00007 | zapata quintero jose maria | barrio sangabriel | 58 40570 | josezapata@gmail.com | 0 | | 00008 | montoya montoya alejandro | barrio la pradera | 37 67289 | alejandromontoya@gmail.com | 0 | | 00009 | lopera cartagena luisa fernanda | barrio el limonar 1 | 57 09957 | luisalopera@gmail.com | 0 | | 00010 | jaramillo henao jose luis | barrio el limonar 2 | 28 66222 | josearamillo@gmail.com | 0 | | 00011 | alvarez agudelo luna | barrio rosaleda | 58 82104 | lunaalvarez@gmail.com | 0 | | 00012 | alvarez agudelo xavier | barrio rosaleda | 58 82104 | xavieralvarez@gmail.com | 0 | +---------+---------------------------------+-------------------------------+--- ------+------------------------------+----------+ 12 rows in set (0.00 sec) mysql> update libro estudiante set cant_Est=10 where cod_Est='00005'; ERROR 1146 (42S02): Table 'institucion_educativa.libro' doesn't exist mysql> update estudiante set cant_Est=10 where cod_Est='00005'; Query OK, 1 row affected (0.03 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> update estudiante set cant_Est=5 where cod_Est='00006'; Query OK, 1 row affected (0.03 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> update estudiante set cant_Est=20 where cod_Est='00008'; Query OK, 1 row affected (0.03 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> update estudiante set cant_Est=9 where cod_Est='00009'; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> update estudiante set cant_Est=30 where cod_Est='00004'; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> update estudiante set cant_Est=50 where cod_Est='00007'; Query OK, 1 row affected (0.03 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> mysql> select * from estudiante; +---------+---------------------------------+-------------------------------+--- ------+------------------------------+----------+ | cod_Est | nom_estudiante | dir_est | te l_est | email_est | cant_Est | +---------+---------------------------------+-------------------------------+--- ------+------------------------------+----------+ | 00001 | acevedo buritica juan esteban | barrio la pradera | 58 46069 | juanestebancardona@gmail.com | 0 | | 00002 | alvarez agudelo esteban | barrio rosaleda | 58 82104 | estebanlavarez@gmail.com | 0 | | 00003 | zapata campiņo isabel | barrio aragon | 58 41998 | zapataisabel@gmail.com | 0 | | 00004 | valle velasquez sofia | barrio la pradera | 27 91469 | sofiavelasquez@gmail.com | 30 | | 00005 | moreno posada diego alejandro | urbanizacion compartir | 28 68617 | diegomoreno@gmail.com | 10 | | 00006 | lzate ortiz jorge mario | urbanizacion ciudadela prado | 58 41497 | marioalzate@gmail.com | 5 | | 00007 | zapata quintero jose maria | barrio sangabriel | 58 40570 | josezapata@gmail.com | 50 | | 00008 | montoya montoya alejandro | barrio la pradera | 37 67289 | alejandromontoya@gmail.com | 20 | | 00009 | lopera cartagena luisa fernanda | barrio el limonar 1 | 57 09957 | luisalopera@gmail.com | 9 | | 00010 | jaramillo henao jose luis | barrio el limonar 2 | 28 66222 | josearamillo@gmail.com | 0 | | 00011 | alvarez agudelo luna | barrio rosaleda | 58 82104 | lunaalvarez@gmail.com | 0 | | 00012 | alvarez agudelo xavier | barrio rosaleda | 58 82104 | xavieralvarez@gmail.com | 0 | +---------+---------------------------------+-------------------------------+--- ------+------------------------------+----------+ 12 rows in set (0.01 sec) mysql>mysql> update estudiante set nom_estudiante='acevedo buritica juan esteban' wher e cod_Est='00001'; Query OK, 0 rows affected (0.02 sec) Rows matched: 1 Changed: 0 Warnings: 0 mysql> select * from estudiante; +---------+---------------------------------+-------------------------------+--- ------+------------------------------+----------+ | cod_Est | nom_estudiante | dir_est | te l_est | email_est | cant_Est | +---------+---------------------------------+-------------------------------+--- ------+------------------------------+----------+ | 00001 | acevedo buritica juan esteban | barrio la pradera | 58 46069 | juanestebancardona@gmail.com | 0 | | 00002 | alvarez agudelo esteban | barrio rosaleda | 58 82104 | estebanlavarez@gmail.com | 0 | | 00003 | zapata campiņo isabel | barrio aragon | 58 41998 | zapataisabel@gmail.com | 0 | | 00004 | valle velasquez sofia | barrio la pradera | 27 91469 | sofiavelasquez@gmail.com | 30 | | 00005 | moreno posada diego alejandro | urbanizacion compartir | 28 68617 | diegomoreno@gmail.com | 10 | | 00006 | lzate ortiz jorge mario | urbanizacion ciudadela prado | 58 41497 | marioalzate@gmail.com | 5 | | 00007 | zapata quintero jose maria | barrio sangabriel | 58 40570 | josezapata@gmail.com | 50 | | 00008 | montoya montoya alejandro | barrio la pradera | 37 67289 | alejandromontoya@gmail.com | 20 | | 00009 | lopera cartagena luisa fernanda | barrio el limonar 1 | 57 09957 | luisalopera@gmail.com | 9 | | 00010 | jaramillo henao jose luis | barrio el limonar 2 | 28 66222 | josearamillo@gmail.com | 0 | | 00011 | alvarez agudelo luna | barrio rosaleda | 58 82104 | lunaalvarez@gmail.com | 0 | | 00012 | alvarez agudelo xavier | barrio rosaleda | 58 82104 | xavieralvarez@gmail.com | 0 | +---------+---------------------------------+-------------------------------+--- ------+------------------------------+----------+ 12 rows in set (0.00 sec) mysql> mysql> update estudiante set cant_Est=100 where cod_Est='00005'; Query OK, 1 row affected (0.03 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from estudiante; +---------+---------------------------------+--------------------------- ------+------------------------------+----------+ | cod_Est | nom_estudiante | dir_est l_est | email_est | cant_Est | +---------+---------------------------------+--------------------------- ------+------------------------------+----------+ | 00001 | acevedo buritica juan esteban | barrio la pradera 46069 | juanestebancardona@gmail.com | 0 | | 00002 | alvarez agudelo esteban | barrio rosaleda 82104 | estebanlavarez@gmail.com | 0 | | 00003 | zapata campiņo isabel | barrio aragon 41998 | zapataisabel@gmail.com | 0 | | 00004 | valle velasquez sofia | barrio la pradera 91469 | sofiavelasquez@gmail.com | 30 | | 00005 | moreno posada diego alejandro | urbanizacion compartir 68617 | diegomoreno@gmail.com | 100 | | 00006 | lzate ortiz jorge mario | urbanizacion ciudadela pr 41497 | marioalzate@gmail.com | 5 | | 00007 | zapata quintero jose maria | barrio sangabriel 40570 | josezapata@gmail.com | 50 | | 00008 | montoya montoya alejandro | barrio la pradera 67289 | alejandromontoya@gmail.com | 20 | | 00009 | lopera cartagena luisa fernanda | barrio el limonar 1 09957 | luisalopera@gmail.com | 9 | | 00010 | jaramillo henao jose luis | barrio el limonar 2 66222 | josearamillo@gmail.com | 0 | | 00011 | alvarez agudelo luna | barrio rosaleda 82104 | lunaalvarez@gmail.com | 0 | | 00012 | alvarez agudelo xavier | barrio rosaleda 82104 | xavieralvarez@gmail.com | 0 | +---------+---------------------------------+--------------------------- ------+------------------------------+----------+ 12 rows in set (0.00 sec) mysql> mysql> select * from estudiante where cant_Est>20; +---------+-------------------------------+------------------------+---- ------------------------+----------+ | cod_Est | nom_estudiante | dir_est | tel mail_est | cant_Est | +---------+-------------------------------+------------------------+---- ------------------------+----------+ | 00004 | valle velasquez sofia | barrio la pradera | 279 ofiavelasquez@gmail.com | 30 | | 00005 | moreno posada diego alejandro | urbanizacion compartir | 286 iegomoreno@gmail.com | 100 | | 00007 | zapata quintero jose maria | barrio sangabriel | 584 osezapata@gmail.com | 50 | +---------+-------------------------------+------------------------+---- ------------------------+----------+ 3 rows in set (0.00 sec) mysql>