Microsoft Windows [Versión 10.0.22621.3007]
(c) Microsoft Corporation. Todos los derechos reservados.
C:\Users\A01-1-0502-12>cd/xampp/mysql/bin
C:\xampp\mysql\bin>mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.4.21-MariaDB mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use tipodatos;
Database changed
MariaDB [tipodatos]> create table control_usuario (codigo int(10) auto_increment primary key,
-> nombre varchar(30) not null,
-> sexo varchar(10) not null,
-> estadocivil enum('separado','viudo','divorciado','casado','soltero'),
-> hobby enum('juegos de logica','bailar','leer','deportes'),
-> salario float not null,
-> dias_labora set('lunes','martes','miercoles','jueves','viernes'),
-> jornada enum('diurna','nocturna'),
-> observacion blob);
Query OK, 0 rows affected (0.018 sec)
MariaDB [tipodatos]> select*from tipodatos;
ERROR 1146 (42S02): Table 'tipodatos.tipodatos' doesn't exist
MariaDB [tipodatos]> show tables;
+---------------------+
| Tables_in_tipodatos |
+---------------------+
| control_usuario |
+---------------------+
1 row in set (0.000 sec)
MariaDB [tipodatos]> select*from control_usuario;
Empty set (0.031 sec)
MariaDB [tipodatos]> insert into control_usuario(nombre,sexo,estadocivil,hobby,salario,dias_labora,jornada,observacion) values('Adrid Cuadrado','masculino','casado','deportes',2400000,'lunes,martes,viernes','diurna','trabajador,colaborador,creativo,comunicador');
Query OK, 1 row affected (0.003 sec)
MariaDB [tipodatos]> select*from control_usuario;
+--------+----------------+-----------+-------------+----------+---------+----------------------+---------+---------------------------------------------+
| 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 |
+--------+----------------+-----------+-------------+----------+---------+----------------------+---------+---------------------------------------------+
1 row in set (0.000 sec)
MariaDB [tipodatos]> insert into control_usuario(nombre,sexo,estadocivil,hobby,salario,dias_labora,jornada,observacion) values('Camila Velez','femenino','soltero','deportes',3800000,'lunes,martes,viernes','diurna','trabajadora,colaboradora,paciente');
Query OK, 1 row affected (0.003 sec)
MariaDB [tipodatos]> insert into control_usuario(nombre,sexo,estadocivil,hobby,salario,dias_labora,jornada,observacion) values('LuisLopez ','masculino','soltero','leer',800000,'lunes,martes,miercoles,viernes','nocturna','creativo,trabajador,colaborador,optimista');
Query OK, 1 row affected (0.003 sec)
MariaDB [tipodatos]> insert into control_usuario(nombre,sexo,estadocivil,hobby,salario,dias_labora,jornada,observacion) values('Alejandra Martinez','femenino','viudo','deportes',5500000,'lunes,martes,miercoles,viernes','diurna','innovadora,trabajadora,colaboradora,expontanea');
Query OK, 1 row affected (0.003 sec)
MariaDB [tipodatos]> insert into control_usuario(nombre,sexo,estadocivil,hobby,salario,dias_labora,jornada,observacion) values('Magnolia Velez','femenino','soltero','juegos de logica',1500000,'lunes,miercoles,viernes','nocturna','Calculadora,trabajadora,colaboradora');
Query OK, 1 row affected (0.003 sec)
MariaDB [tipodatos]> insert into control_usuario(nombre,sexo,estadocivil,hobby,salario,dias_labora,jornada,observacion) values('Juan Aguilar','masculino','casado','juegos de logica',750000,'viernes','diurna','trabajador,colaborador,comunicador');
Query OK, 1 row affected (0.002 sec)
MariaDB [tipodatos]> insert into control_usuario(nombre,sexo,estadocivil,hobby,salario,dias_labora,jornada,observacion) values('Carolina Perez','femenino','soltero','leer',1350000,'lunes,martes,jueves,viernes','diurna','trabajadora,colaboradora,comunicadora');
Query OK, 1 row affected (0.003 sec)
MariaDB [tipodatos]> insert into control_usuario(nombre,sexo,estadocivil,hobby,salario,dias_labora,jornada,observacion) values('Maira Arrieta','femenino','casado','bailar',1000000,'martes,miercoles,jueves,viernes','diurna','comunicadora,socializadora,defensora de derechos humanos');
Query OK, 1 row affected (0.003 sec)
MariaDB [tipodatos]> select *from control_usuario;
+--------+--------------------+-----------+-------------+------------------+---------+---------------------------------+----------+----------------------------------------------------------+
| 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 | trabajadora,colaboradora,paciente |
| 3 | LuisLopez | masculino | soltero | leer | 800000 | lunes,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 | soltero | juegos de logica | 1500000 | lunes,miercoles,viernes | nocturna | Calculadora,trabajadora,colaboradora |
| 6 | Juan Aguilar | masculino | casado | juegos de logica | 750000 | viernes | diurna | trabajador,colaborador,comunicador |
| 7 | Carolina Perez | femenino | soltero | leer | 1350000 | lunes,martes,jueves,viernes | diurna | trabajadora,colaboradora,comunicadora |
| 8 | Maira Arrieta | femenino | casado | bailar | 1000000 | martes,miercoles,jueves,viernes | diurna | comunicadora,socializadora,defensora de derechos humanos |
+--------+--------------------+-----------+-------------+------------------+---------+---------------------------------+----------+----------------------------------------------------------+
8 rows in set (0.000 sec)
MariaDB [tipodatos]> select * from control_usuario where estadocivil='casaso';
Empty set (0.000 sec)
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 | 750000 | viernes | diurna | trabajador,colaborador,comunicador |
| 8 | Maira Arrieta | femenino | casado | bailar | 1000000 | martes,miercoles,jueves,viernes | diurna | comunicadora,socializadora,defensora de derechos humanos |
+--------+----------------+-----------+-------------+------------------+---------+---------------------------------+---------+----------------------------------------------------------+
3 rows in set (0.000 sec)
MariaDB [tipodatos]> select * from control_usuario where estadocivil='soltero';
+--------+----------------+-----------+-------------+------------------+---------+--------------------------------+----------+-------------------------------------------+
| codigo | nombre | sexo | estadocivil | hobby | salario | dias_labora | jornada | observacion |
+--------+----------------+-----------+-------------+------------------+---------+--------------------------------+----------+-------------------------------------------+
| 2 | Camila Velez | femenino | soltero | deportes | 3800000 | lunes,martes,viernes | diurna | trabajadora,colaboradora,paciente |
| 3 | LuisLopez | masculino | soltero | leer | 800000 | lunes,martes,miercoles,viernes | nocturna | creativo,trabajador,colaborador,optimista |
| 5 | Magnolia Velez | femenino | soltero | juegos de logica | 1500000 | lunes,miercoles,viernes | nocturna | Calculadora,trabajadora,colaboradora |
| 7 | Carolina Perez | femenino | soltero | leer | 1350000 | lunes,martes,jueves,viernes | diurna | trabajadora,colaboradora,comunicadora |
+--------+----------------+-----------+-------------+------------------+---------+--------------------------------+----------+-------------------------------------------+
4 rows in set (0.000 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 | trabajadora,colaboradora,paciente |
| 3 | LuisLopez | masculino | soltero | leer | 800000 | lunes,martes,miercoles,viernes | nocturna | creativo,trabajador,colaborador,optimista |
| 5 | Magnolia Velez | femenino | soltero | juegos de logica | 1500000 | lunes,miercoles,viernes | nocturna | Calculadora,trabajadora,colaboradora |
| 7 | Carolina Perez | femenino | soltero | leer | 1350000 | lunes,martes,jueves,viernes | diurna | trabajadora,colaboradora,comunicadora |
+--------+----------------+-----------+-------------+------------------+---------+--------------------------------+----------+-------------------------------------------+
4 rows in set (0.000 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.000 sec)
MariaDB [tipodatos]> select*from control_usuario;
+--------+--------------------+-----------+-------------+------------------+---------+---------------------------------+----------+----------------------------------------------------------+
| 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 | trabajadora,colaboradora,paciente |
| 3 | LuisLopez | masculino | soltero | leer | 800000 | lunes,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 | soltero | juegos de logica | 1500000 | lunes,miercoles,viernes | nocturna | Calculadora,trabajadora,colaboradora |
| 6 | Juan Aguilar | masculino | casado | juegos de logica | 750000 | viernes | diurna | trabajador,colaborador,comunicador |
| 7 | Carolina Perez | femenino | soltero | leer | 1350000 | lunes,martes,jueves,viernes | diurna | trabajadora,colaboradora,comunicadora |
| 8 | Maira Arrieta | femenino | casado | bailar | 1000000 | martes,miercoles,jueves,viernes | diurna | comunicadora,socializadora,defensora de derechos humanos |
+--------+--------------------+-----------+-------------+------------------+---------+---------------------------------+----------+----------------------------------------------------------+
8 rows in set (0.000 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.010 sec)
MariaDB [tipodatos]> select * from control_usuario where estadocivil=3 and hobby =1 and dias_labora<>miercoles;
ERROR 1054 (42S22): Unknown column 'miercoles' in 'where clause'
MariaDB [tipodatos]> select * from control_usuario where estadocivil=3 and hobby =1 and dias_labora<>3;
Empty set (0.000 sec)
MariaDB [tipodatos]> select * from control_usuario where estadocivil=5 and hobby =1 and dias_labora like %;miercoles%;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%' at line 1
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 'miercoles%' at line 1
MariaDB [tipodatos]> select * from control_usuario where estadocivil=5 and hobby =1 and dias_labora like %miercoles%;
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 '%miercoles%' at line 1
MariaDB [tipodatos]> select * from control_usuario where estadocivil=5 and hobby =1 and dias_labora= like %miercoles%;
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 %miercoles%' at line 1
MariaDB [tipodatos]> select * from control_usuario where estadocivil=5 and hobby =1 and dias_labora=3;
Empty set (0.000 sec)
MariaDB [tipodatos]> select * from control_usuario where estadocivil=5 and hobby =1 and dias_labora like '%miercoles%';
+--------+----------------+----------+-------------+------------------+---------+-------------------------+----------+--------------------------------------+
| codigo | nombre | sexo | estadocivil | hobby | salario | dias_labora | jornada | observacion |
+--------+----------------+----------+-------------+------------------+---------+-------------------------+----------+--------------------------------------+
| 5 | Magnolia Velez | femenino | soltero | juegos de logica | 1500000 | lunes,miercoles,viernes | nocturna | Calculadora,trabajadora,colaboradora |
+--------+----------------+----------+-------------+------------------+---------+-------------------------+----------+--------------------------------------+
1 row in set (0.000 sec)
MariaDB [tipodatos]> select * from control_usuario where sexo='femenino' and jornada=2 and dias_labora like '%jueves%' and salario between(750000,2400000);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
MariaDB [tipodatos]> select * from control_usuario where sexo='femenino' and jornada=2 and dias_labora like '%jueves%' and salario between(750000-2400000);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
MariaDB [tipodatos]> select * from control_usuario where sexo='femenino' and jornada=2 and dias_labora like '%jueves%' and salario between 750000 and 2400000;
Empty set (0.000 sec)
MariaDB [tipodatos]> select * from control_usuario where sexo='femenino' and jornada=2 and dias_labora not like '%jueves%' and salario between 750000 and 2400000;
+--------+----------------+----------+-------------+------------------+---------+-------------------------+----------+--------------------------------------+
| codigo | nombre | sexo | estadocivil | hobby | salario | dias_labora | jornada | observacion |
+--------+----------------+----------+-------------+------------------+---------+-------------------------+----------+--------------------------------------+
| 5 | Magnolia Velez | femenino | soltero | juegos de logica | 1500000 | lunes,miercoles,viernes | nocturna | Calculadora,trabajadora,colaboradora |
+--------+----------------+----------+-------------+------------------+---------+-------------------------+----------+--------------------------------------+
1 row in set (0.000 sec)
MariaDB [tipodatos]> select * from control_usuario where sexo='femenino' and jornada=2 and dias_labora not like '%jueves%' and salario between 750000 and 2400000 observacion like '%trabajadora%';
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 'observacion like '%trabajadora%'' at line 1
MariaDB [tipodatos]> select * from control_usuario where sexo='femenino' and jornada=2 and dias_labora not like '%jueves%' and salario between 750000 and 2400000 observacion like '%trabajadora%';
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 'observacion like '%trabajadora%'' at line 1
MariaDB [tipodatos]> select * from control_usuario where sexo='femenino' and jornada=2 and dias_labora not like '%jueves%' and salario between 750000 and 2400000 and observacion like '%trabajadora%';
+--------+----------------+----------+-------------+------------------+---------+-------------------------+----------+--------------------------------------+
| codigo | nombre | sexo | estadocivil | hobby | salario | dias_labora | jornada | observacion |
+--------+----------------+----------+-------------+------------------+---------+-------------------------+----------+--------------------------------------+
| 5 | Magnolia Velez | femenino | soltero | juegos de logica | 1500000 | lunes,miercoles,viernes | nocturna | Calculadora,trabajadora,colaboradora |
+--------+----------------+----------+-------------+------------------+---------+-------------------------+----------+--------------------------------------+
1 row in set (0.000 sec)
MariaDB [tipodatos]> select * from control_usuario where sexo='femenino' and jornada=2 and dias_labora not like '%jueves%' and salario between 750000 and 2400000 and observacion like '%trabajadora%';