MariaDB [tipodatos]> select from control_usuario where estadocivil='casado'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'from control_usuario where estadocivil='casado'' at line 1 MariaDB [tipodatos]> select * from control_usuario where estadocivil='casado'; +--------+----------------+-----------+-------------+------------------+---------+---------------------------------+---------+------------------------------------------------------+ | codigo | nombre | sexo | estadocivil | hobby | salario | dias_labora | jornada | observacion | +--------+----------------+-----------+-------------+------------------+---------+---------------------------------+---------+------------------------------------------------------+ | 1 | Adrid Cuadrado | masculino | casado | deportes | 2400000 | lunes,martes,viernes | diurna | trabajador,colaborador,creativo,comunicador | | 6 | Juan Aguilar | masculino | casado | juegos de logica | 7500000 | viernes | diurna | trabajadora,colaboradora,comunicadora | | 8 | Maira Arrieta | masculino | casado | bailar | 1000000 | martes,miercoles,jueves,viernes | diurna | comunicadora,socializadora,defensora de los derechos | +--------+----------------+-----------+-------------+------------------+---------+---------------------------------+---------+------------------------------------------------------+ 3 rows in set (0.00 sec) MariaDB [tipodatos]> describe control_usuario; +-------------+----------------------------------------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------------------------------------------------------+------+-----+---------+----------------+ | codigo | int(10) | NO | PRI | NULL | auto_increment | | nombre | varchar(30) | NO | | NULL | | | sexo | varchar(10) | NO | | NULL | | | estadocivil | enum('separado','viudo','divorciado','casado','soltero') | YES | | NULL | | | hobby | enum('juegos de logica','bailar','leer','deportes') | YES | | NULL | | | salario | float | NO | | NULL | | | dias_labora | set('lunes','martes','miercoles','jueves','viernes') | YES | | NULL | | | jornada | enum('diurna','nocturna') | YES | | NULL | | | observacion | blob | YES | | NULL | | +-------------+----------------------------------------------------------+------+-----+---------+----------------+ 9 rows in set (0.00 sec) MariaDB [tipodatos]> select * from control_usuario where estadocivil=4; +--------+----------------+-----------+-------------+------------------+---------+---------------------------------+---------+------------------------------------------------------+ | codigo | nombre | sexo | estadocivil | hobby | salario | dias_labora | jornada | observacion | +--------+----------------+-----------+-------------+------------------+---------+---------------------------------+---------+------------------------------------------------------+ | 1 | Adrid Cuadrado | masculino | casado | deportes | 2400000 | lunes,martes,viernes | diurna | trabajador,colaborador,creativo,comunicador | | 6 | Juan Aguilar | masculino | casado | juegos de logica | 7500000 | viernes | diurna | trabajadora,colaboradora,comunicadora | | 8 | Maira Arrieta | masculino | casado | bailar | 1000000 | martes,miercoles,jueves,viernes | diurna | comunicadora,socializadora,defensora de los derechos | +--------+----------------+-----------+-------------+------------------+---------+---------------------------------+---------+------------------------------------------------------+ 3 rows in set (0.00 sec) MariaDB [tipodatos]> select * from control_usuario where estadocivil=5; +--------+----------------+-----------+-------------+----------+---------+-----------------------------+----------+-------------------------------------------+ | codigo | nombre | sexo | estadocivil | hobby | salario | dias_labora | jornada | observacion | +--------+----------------+-----------+-------------+----------+---------+-----------------------------+----------+-------------------------------------------+ | 2 | Camila Velez | femenino | soltero | deportes | 3800000 | lunes,martes,viernes | diurna | trabajador,colaborador,paciente | | 3 | Luis Lopez | masculino | soltero | leer | 800000 | martes,miercoles,viernes | nocturna | creativo,trabajador,colaborador,optimista | | 7 | Carolina Perez | femenino | soltero | leer | 1350000 | lunes,martes,jueves,viernes | diurna | trabajadora,colaboradora,comunicadora | +--------+----------------+-----------+-------------+----------+---------+-----------------------------+----------+-------------------------------------------+ 3 rows in set (0.00 sec) MariaDB [tipodatos]> select * from control_usuario where estadocivil=2; +--------+--------------------+----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ | codigo | nombre | sexo | estadocivil | hobby | salario | dias_labora | jornada | observacion | +--------+--------------------+----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ | 4 | Alejandra Martinez | femenino | viudo | deportes | 5500000 | lunes,martes,miercoles,viernes | diurna | innovadora,trabajadora,colaboradora,expontanea | +--------+--------------------+----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [tipodatos]> select * from control_usuario where hobby=1 and estadocivil=5 and dias_labora like '%miercoles%'; Empty set (0.00 sec) MariaDB [tipodatos]> select * from control_usuario where hobby=1 and estadocivil=5 and dias_labora like '%miercoles%'; Empty set (0.00 sec) MariaDB [tipodatos]> select * from control_usuario where salario between 750000 and 2400000 and sexo='femenino'and jornada=2 and dias_labora not like '%jueves%' and observacion like '%trabajadora%' or observacion like '%trabajador%'; +--------+--------------------+-----------+-------------+------------------+---------+--------------------------------+----------+------------------------------------------------+ | codigo | nombre | sexo | estadocivil | hobby | salario | dias_labora | jornada | observacion | +--------+--------------------+-----------+-------------+------------------+---------+--------------------------------+----------+------------------------------------------------+ | 1 | Adrid Cuadrado | masculino | casado | deportes | 2400000 | lunes,martes,viernes | diurna | trabajador,colaborador,creativo,comunicador | | 2 | Camila Velez | femenino | soltero | deportes | 3800000 | lunes,martes,viernes | diurna | trabajador,colaborador,paciente | | 3 | Luis Lopez | masculino | soltero | leer | 800000 | martes,miercoles,viernes | nocturna | creativo,trabajador,colaborador,optimista | | 4 | Alejandra Martinez | femenino | viudo | deportes | 5500000 | lunes,martes,miercoles,viernes | diurna | innovadora,trabajadora,colaboradora,expontanea | | 5 | Magnolia Velez | femenino | | juegos de logica | 1500000 | lunes,miercoles,viernes | nocturna | calculadora,trabajadora,colaboradora | | 6 | Juan Aguilar | masculino | casado | juegos de logica | 7500000 | viernes | diurna | trabajadora,colaboradora,comunicadora | | 7 | Carolina Perez | femenino | soltero | leer | 1350000 | lunes,martes,jueves,viernes | diurna | trabajadora,colaboradora,comunicadora | +--------+--------------------+-----------+-------------+------------------+---------+--------------------------------+----------+------------------------------------------------+ 7 rows in set (0.00 sec) MariaDB [tipodatos]> select * from control_usuario where salario between 750000 and 2400000 and sexo='femenino'and jornada=2 and dias_labora not like '%jueves%' and observacion like '%trabajadora%'; +--------+----------------+----------+-------------+------------------+---------+-------------------------+----------+--------------------------------------+ | codigo | nombre | sexo | estadocivil | hobby | salario | dias_labora | jornada | observacion | +--------+----------------+----------+-------------+------------------+---------+-------------------------+----------+--------------------------------------+ | 5 | Magnolia Velez | femenino | | juegos de logica | 1500000 | lunes,miercoles,viernes | nocturna | calculadora,trabajadora,colaboradora | +--------+----------------+----------+-------------+------------------+---------+-------------------------+----------+--------------------------------------+ 1 row in set (0.00 sec) MariaDB [tipodatos]> select * from control_usuario where hobby=4 and observacion like '%trabajadora%' and '%colaboradora%'; Empty set, 4 warnings (0.00 sec) MariaDB [tipodatos]> select * from control_usuario where hobby like '%deportes%' and like '%trabajador%' or '%trabajador%' or %'colaborador%'; 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 'like '%trabajador%' or '%trabajador%' or %'colaborador%'' at line 1 MariaDB [tipodatos]> select * from control_usuario where hobby like '%deportes%' and like '%trabajador%' or '%trabajador%' or %'colaborador%'; 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 'like '%trabajador%' or '%trabajador%' or %'colaborador%'' at line 1 MariaDB [tipodatos]> select * from control_usuario where hobby like '%deportes%' and like '%trabajador%' or '%trabajadora%' or %'colaborador%'; 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 'like '%trabajador%' or '%trabajadora%' or %'colaborador%'' at line 1 MariaDB [tipodatos]> select * from control_usuario where hobby like '%deportes%' and observacion like '%trabajador%' or '%trabajadora%' or %'colaborador%'; 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 '%'colaborador%'' at line 1 MariaDB [tipodatos]> select * from control_usuario where hobby like '%deportes%' and observacion like '%trabajadora%' or %'colaborador%'; 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 '%'colaborador%'' at line 1 MariaDB [tipodatos]> select * from control_usuario where hobby like '%deportes%' and observacion like '%trabajadora%' or '%colaborador%'; +--------+--------------------+----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ | codigo | nombre | sexo | estadocivil | hobby | salario | dias_labora | jornada | observacion | +--------+--------------------+----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ | 4 | Alejandra Martinez | femenino | viudo | deportes | 5500000 | lunes,martes,miercoles,viernes | diurna | innovadora,trabajadora,colaboradora,expontanea | +--------+--------------------+----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ 1 row in set, 4 warnings (0.00 sec) MariaDB [tipodatos]> select * from control_usuario where hobby like '%deportes%' and observacion like '%trabajadora%' or '%trabajador%' or '%colaborador%'; +--------+--------------------+----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ | codigo | nombre | sexo | estadocivil | hobby | salario | dias_labora | jornada | observacion | +--------+--------------------+----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ | 4 | Alejandra Martinez | femenino | viudo | deportes | 5500000 | lunes,martes,miercoles,viernes | diurna | innovadora,trabajadora,colaboradora,expontanea | +--------+--------------------+----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ 1 row in set, 8 warnings (0.00 sec) MariaDB [tipodatos]> select * from control_usuario where hobby=4 and observacion like '%trabajadora%' or '%trabajador%' or '%colaborador%'; +--------+--------------------+----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ | codigo | nombre | sexo | estadocivil | hobby | salario | dias_labora | jornada | observacion | +--------+--------------------+----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ | 4 | Alejandra Martinez | femenino | viudo | deportes | 5500000 | lunes,martes,miercoles,viernes | diurna | innovadora,trabajadora,colaboradora,expontanea | +--------+--------------------+----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ 1 row in set, 8 warnings (0.00 sec) MariaDB [tipodatos]> select * from control_usuario where hobby=4 and observacion like '%trabajador%' or '%colaborador%'; +--------+--------------------+-----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ | codigo | nombre | sexo | estadocivil | hobby | salario | dias_labora | jornada | observacion | +--------+--------------------+-----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ | 1 | Adrid Cuadrado | masculino | casado | deportes | 2400000 | lunes,martes,viernes | diurna | trabajador,colaborador,creativo,comunicador | | 2 | Camila Velez | femenino | soltero | deportes | 3800000 | lunes,martes,viernes | diurna | trabajador,colaborador,paciente | | 4 | Alejandra Martinez | femenino | viudo | deportes | 5500000 | lunes,martes,miercoles,viernes | diurna | innovadora,trabajadora,colaboradora,expontanea | +--------+--------------------+-----------+-------------+----------+---------+--------------------------------+---------+------------------------------------------------+ 3 rows in set, 4 warnings (0.00 sec) MariaDB [tipodatos]> source C:\Users\A01-1-0604-18\Desktop\Practica1\practica1.sql Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 1 row affected (0.00 sec) Database changed Query OK, 0 rows affected (0.13 sec) Query OK, 0 rows affected, 1 warning (0.00 sec) Query OK, 9 rows affected (0.04 sec) Records: 9 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected, 1 warning (0.12 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) MariaDB [practica1]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | phpmyadmin | | practica1 | | test | | tipodatos | +--------------------+ 7 rows in set (0.00 sec) MariaDB [practica1]> show tables; +---------------------+ | Tables_in_practica1 | +---------------------+ | estudiante | +---------------------+ 1 row in set (0.00 sec) MariaDB [practica1]> select * from estudiante; +--------+-------------------------+------+---------------------+-------------------------------------+--------------+-------------+---------------------------------------+---------+-------------------------------------------------------------+ | carnet | nombre | sexo | car_infom | deporte | Religion | valor_semes | dias_clase | jornada | detalles | +--------+-------------------------+------+---------------------+-------------------------------------+--------------+-------------+---------------------------------------+---------+-------------------------------------------------------------+ | 681010 | Mario Luis Arroyave | m | Tecnico profesional | Ciclismo,Voleibol,otro | Cristianismo | 1100000.00 | lunes,martes,miercoles,jueves,viernes | am | individualista | | 701002 | Gloria Maria Zabaleta | f | Tec_DesarrolloS | Ciclismo,Beisbol,Voleibol,otro | Cristianismo | 1820000.00 | lunes,viernes,sabado | am | intelectual,le gusta el trabajo en equipo | | 701962 | Roberto Carlos Porro | m | Tec_DesarrolloS | Baloncesto,Ciclismo,otro | Hinduismo | 1820000.00 | lunes,viernes,sabado | am | intelectual,le gusta el trabajo en equipo | | 702240 | Jairo Harley Usuga | m | Tec_DesarrolloS | Baloncesto,Futbol,Ciclismo,Voleibol | Cristianismo | 1600000.00 | lunes,martes,miercoles,viernes | am | no viene a clases, es individualista | | 752040 | Maria Camila Zapata | f | Ing_sistemas | Baloncesto,Natacion,otro | Hinduismo | 2450000.00 | lunes,martes,viernes | am | buen estudiante, colaborador, le gusta el trabajo en equipo | | 752314 | Gloria Zamora Perez | f | Ing_sistemas | Natacion,otro | Cristianismo | 2800000.00 | lunes,miercoles,sabado | am | Buena estudiante,creativa,dinamica,colaboradora | | 758962 | Margarita Julio Beltran | f | Ing_sistemas | Baloncesto,otro | Cristianismo | 2450000.00 | martes,jueves,viernes | pm | intelectual,colaboradora,creativa | | 901112 | Jorge Luis Arroyo | m | Espec_seguridad | Natacion,Ciclismo,Beisbol,Voleibol | Islam | 4200000.00 | viernes,sabado | am | intelectual,le gusta el trabajo en equipo,colaborador | | 902031 | Samuel Julio Beltran | m | Espec_seguridad | Natacion,Ciclismo,Voleibol | Sijismo | 4200000.00 | sabado | am | Le gusta el trabajo en equipo,intelectual | +--------+-------------------------+------+---------------------+-------------------------------------+--------------+-------------+---------------------------------------+---------+-------------------------------------------------------------+ 9 rows in set (0.00 sec)