MariaDB [dualdelovepment]> show tables; +---------------------------+ | Tables_in_dualdelovepment | +---------------------------+ | activos | | aplicaciones | | descripcion | | empleados | | precios | | proyectos | | usuarios | | vendidos | +---------------------------+ 8 rows in set (0.002 sec) MariaDB [dualdelovepment]> select * from activos; +---------------------+-----------------------------+ | codigo_del_proyecto | nombre_del_proyecto | +---------------------+-----------------------------+ | 0001 | sistema activos | | 0012 | bienvenida | | 0100 | your apk | | 0500 | sistema antihacks | | 1000 | cumplea¤os | | 1452 | costing | | 1500 | legumbreria | | 2487 | medidor de campos electicos | | 2887 | app prueba | +---------------------+-----------------------------+ 9 rows in set (0.013 sec) MariaDB [dualdelovepment]> select * from aplicaciones; +----------------------+---------------+-------------+ | proximo_proyecto | fecha_inicial | fecha_final | +----------------------+---------------+-------------+ | calculadora | 2023-05-14 | 2023-05-30 | | costeador | 2023-06-01 | 2023-06-05 | | alquiler cancha | 2023-06-10 | 2023-06-20 | | empresiones | 2023-06-20 | 2023-06-30 | | lector de QR | 2023-07-01 | 2023-07-15 | | restaurante | 2023-07-15 | 2023-07-20 | | computos | 2023-07-20 | 2023-07-30 | | super mercado | 2023-08-10 | 2023-08-30 | | cumplea¤os D1 | 2023-09-01 | 2023-09-15 | | calculadora cuantica | 2023-09-15 | 2023-09-30 | +----------------------+---------------+-------------+ 10 rows in set (0.003 sec) MariaDB [dualdelovepment]> select * from descripcion; +-------------------+----------------------------------------------------+ | nombapk | descripcion | +-------------------+----------------------------------------------------+ | app prueba | informacion de apk no registrada | | bienvenida | software encargado de darle bienvenida a los nuevo | | costing | software encargado de costear el precio de otro so | | cumplea¤os | software encargado de felicitar a los trabajadores | | legumbreria | crea colas para compras y ventas en legumbreria | | medidor de campos | mide campos magneticos con la camara | | sistema activos | este software va a mostrar cuales son los que actu | | sistema antihack | software encargado de dar informacion al sistema d | | your apk | informacion de apk no registrada | +-------------------+----------------------------------------------------+ 9 rows in set (0.008 sec) MariaDB [dualdelovepment]> select * from empleados; +--------------+--------------------+-------------+-------------+---------------------------+--------------------+ | id_empleados | nombre | direccion | telefono | correo | apk_a_desarrollar | +--------------+--------------------+-------------+-------------+---------------------------+--------------------+ | 1025478566 | jhonnier palomeque | manrique | 3215488569 | jhonier@gmail.com | app prueba | | 1025489663 | mateo ortiz | la navarra | 3102556409 | mateoortiz@gmail.com | cumplea¤os | | 1047859512 | alejandro gimenez | san antonio | 3214782947 | gimenezgmail.com | your apk | | 1048956874 | alejandro duran | la playa | 3110254409 | alejadndroduran@gmail.com | legumbreria | | 1074554645 | andres blandon | girardot | 32458959519 | andres@gmail.com | sistema antihacks | | 1077896515 | luis quintero | poblado | 3145689569 | luisquintero@gmail.com | bienvenida | | 1078954489 | brianh lopez | bello | 31457814551 | lopez11@gmail.com | sistema activos | | 1155522222 | oscar cordoba | la navarra | 31457892209 | oscar@gmail.com | medidior de campos | +--------------+--------------------+-------------+-------------+---------------------------+--------------------+ 8 rows in set (0.006 sec) MariaDB [dualdelovepment]> select * from precios; +---------+-------------------+------------------------+-------+ | semanas | precio_por_semana | precio_por_elaboracion | total | +---------+-------------------+------------------------+-------+ | 1 | 1500000 | 0 | 0 | | 2 | 2000000 | 0 | 0 | | 3 | 2500000 | 0 | 0 | | 4 | 3000000 | 0 | 0 | | 5 | 3500000 | 0 | 0 | | 6 | 4000000 | 0 | 0 | | 7 | 4500000 | 0 | 0 | | 8 | 5000000 | 0 | 0 | | 9 | 5500000 | 0 | 0 | | 10 | 6000000 | 0 | 0 | +---------+-------------------+------------------------+-------+ 10 rows in set (0.001 sec) MariaDB [dualdelovepment]> select * from proyecto; ERROR 1146 (42S02): Table 'dualdelovepment.proyecto' doesn't exist MariaDB [dualdelovepment]> select * from proyectos; +-------------------+ | proyectos_activos | +-------------------+ | 9 | +-------------------+ 1 row in set (0.001 sec) MariaDB [dualdelovepment]> select * from usuarios; +------------+------------------+------------+-------------------+----------------+ | id_usuario | nombre | telefono | correo | direccion | +------------+------------------+------------+-------------------+----------------+ | 1014785994 | alirio valencia | 3214579522 | alirio@gmail.com | cra 20#31-11 | | 1015785956 | mario rodriguez | 3112456422 | mario@gmail.com | cll 35#10-01 | | 1025488963 | gerardo quintana | 3122156148 | gerardo@gmail.com | cra 70# 88-12 | | 1077895142 | david perez | 3101587923 | david@gmail.com | cll 40#10bb-30 | | 1088956489 | emilio gomez | 3301258792 | emilio@gmail.com | cra 20#15aa-30 | | 1414785951 | carlos gonzales | 3301258792 | carlos@gmail.com | cra 90#25aa-14 | | 356487985 | gustavo ordo¤ez | 3114578928 | gustavo@gmail.com | cll 45# 99a-17 | | 415895262 | maria renteria | 3101586548 | maria@gmail.com | cll 80# 39 | +------------+------------------+------------+-------------------+----------------+ 8 rows in set (0.001 sec) MariaDB [dualdelovepment]> select * from vendidos; +--------------------+ | proyectos_vendidos | +--------------------+ | 9 | +--------------------+ 1 row in set (0.001 sec) MariaDB [dualdelovepment]> delimiter // MariaDB [dualdelovepment]> create procedure precio_elaboracion(in precio_por_elaboracion int(11)) -> begin -> insert into total values(total); -> end -> // Query OK, 0 rows affected (0.044 sec) MariaDB [dualdelovepment]> delimiter ; MariaDB [dualdelovepment]> show procedure status; +-----------------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-----------------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | dualdelovepment | precio_elaboracion | PROCEDURE | root@localhost | 2023-05-26 21:19:23 | 2023-05-26 21:19:23 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | +-----------------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 1 row in set (0.020 sec) MariaDB [dualdelovepment]> select * from precios; +---------+-------------------+------------------------+-------+ | semanas | precio_por_semana | precio_por_elaboracion | total | +---------+-------------------+------------------------+-------+ | 1 | 1500000 | 0 | 0 | | 2 | 2000000 | 0 | 0 | | 3 | 2500000 | 0 | 0 | | 4 | 3000000 | 0 | 0 | | 5 | 3500000 | 0 | 0 | | 6 | 4000000 | 0 | 0 | | 7 | 4500000 | 0 | 0 | | 8 | 5000000 | 0 | 0 | | 9 | 5500000 | 0 | 0 | | 10 | 6000000 | 0 | 0 | +---------+-------------------+------------------------+-------+ 10 rows in set (0.001 sec) MariaDB [dualdelovepment]> inser into precios(precio_por_elaboracion) values('200000'); ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 10 Current database: dualdelovepment 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 'inser into precios(precio_por_elaboracion) values('200000')' at line 1 MariaDB [dualdelovepment]> drop table precios; Query OK, 0 rows affected (0.025 sec) MariaDB [dualdelovepment]> create table precios(cedula int not null primary key, -> fecha data, -> ); 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 2 MariaDB [dualdelovepment]> create table precios(cedula int not null primary key, -> fecha date, -> precio_semana int not null, -> precio_elaboracion int, -> total int); Query OK, 0 rows affected (0.025 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1014785994', 1992-01-01, '1500000', '1000000', '0'); Query OK, 1 row affected, 1 warning (0.006 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1015785956', 1987-05-02, '200000', '100000', '0'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1047859512', 1976-06-15, '450000', '500000', '0'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1025488963', 1977-07-15, '2000000', '1000000', '0'); Query OK, 1 row affected, 1 warning (0.004 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1088956489', 1999-11-12, '400000', '100000', '0'); Query OK, 1 row affected, 1 warning (0.010 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1414785951', 1989-10-20, '1500000', '1000000', '0'); Query OK, 1 row affected, 1 warning (0.004 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('356487985', 1975-40-30, '2500000', '2000000', '0'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('415895262', 1984-10-30, '2500000', '2000000', '0'); Query OK, 1 row affected, 1 warning (0.004 sec) MariaDB [dualdelovepment]> select * from precios; +------------+------------+---------------+--------------------+-------+ | cedula | fecha | precio_semana | precio_elaboracion | total | +------------+------------+---------------+--------------------+-------+ | 356487985 | 0000-00-00 | 2500000 | 2000000 | 0 | | 415895262 | 0000-00-00 | 2500000 | 2000000 | 0 | | 1014785994 | 0000-00-00 | 1500000 | 1000000 | 0 | | 1015785956 | 0000-00-00 | 200000 | 100000 | 0 | | 1025488963 | 0000-00-00 | 2000000 | 1000000 | 0 | | 1047859512 | 0000-00-00 | 450000 | 500000 | 0 | | 1088956489 | 0000-00-00 | 400000 | 100000 | 0 | | 1414785951 | 0000-00-00 | 1500000 | 1000000 | 0 | +------------+------------+---------------+--------------------+-------+ 8 rows in set (0.009 sec) MariaDB [dualdelovepment]> drop table precios; Query OK, 0 rows affected (0.025 sec) MariaDB [dualdelovepment]> create table precios(cedula int not null primary key, -> fecha date, -> precio_semana int not null, -> total int); Query OK, 0 rows affected (0.024 sec) MariaDB [dualdelovepment]> drop table precios; Query OK, 0 rows affected (0.014 sec) MariaDB [dualdelovepment]> create table precios(cedula int not null primary key, -> fecha date, -> precio_semana int not null, -> precio_elaboracion int, -> total int); Query OK, 0 rows affected (0.018 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1014785994', '1992-01-01', '1500000', '1000000', '0'); Query OK, 1 row affected (0.005 sec) MariaDB [dualdelovepment]> select * from precios; +------------+------------+---------------+--------------------+-------+ | cedula | fecha | precio_semana | precio_elaboracion | total | +------------+------------+---------------+--------------------+-------+ | 1014785994 | 1992-01-01 | 1500000 | 1000000 | 0 | +------------+------------+---------------+--------------------+-------+ 1 row in set (0.001 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1015785956', 1987-05-02, '200000', '100000', '0'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1047859512', 1976-06-15, '450000', '500000', '0'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1025488963', 1977-07-15, '2000000', '1000000', '0'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1088956489', 1999-11-12, '400000', '100000', '0'); Query OK, 1 row affected, 1 warning (0.004 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1414785951', 1989-10-20, '1500000', '1000000', '0'); Query OK, 1 row affected, 1 warning (0.006 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('356487985', 1975-05-30, '2500000', '2000000', '0'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('415895262', 1984-10-30, '2500000', '2000000', '0'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [dualdelovepment]> select * from precios; +------------+------------+---------------+--------------------+-------+ | cedula | fecha | precio_semana | precio_elaboracion | total | +------------+------------+---------------+--------------------+-------+ | 356487985 | 0000-00-00 | 2500000 | 2000000 | 0 | | 415895262 | 0000-00-00 | 2500000 | 2000000 | 0 | | 1014785994 | 1992-01-01 | 1500000 | 1000000 | 0 | | 1015785956 | 0000-00-00 | 200000 | 100000 | 0 | | 1025488963 | 0000-00-00 | 2000000 | 1000000 | 0 | | 1047859512 | 0000-00-00 | 450000 | 500000 | 0 | | 1088956489 | 0000-00-00 | 400000 | 100000 | 0 | | 1414785951 | 0000-00-00 | 1500000 | 1000000 | 0 | +------------+------------+---------------+--------------------+-------+ 8 rows in set (0.001 sec) MariaDB [dualdelovepment]> drop table precios; Query OK, 0 rows affected (0.014 sec) MariaDB [dualdelovepment]> create table precios(cedula int not null primary key, -> fecha date, -> precio_semana int not null, -> precio_elaboracion int, -> total int); Query OK, 0 rows affected (0.024 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1014785994', '1992-01-01', '1500000', '1000000', '0'); Query OK, 1 row affected (0.004 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1015785956', '1987-05-02', '200000', '100000', '0'); Query OK, 1 row affected (0.003 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1047859512', '1976-06-15', '450000', '500000', '0'); Query OK, 1 row affected (0.003 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1025488963', '1977-07-15', '2000000', '1000000', '0'); Query OK, 1 row affected (0.010 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1088956489', '1999-11-12', '400000', '100000', '0'); Query OK, 1 row affected (0.007 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1414785951', '1989-10-20', '1500000', '1000000', '0'); Query OK, 1 row affected (0.012 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('356487985', '1975-05-30', '2500000', '2000000', '0'); Query OK, 1 row affected (0.003 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('415895262', '1984-10-30', '2500000', '2000000', '0'); Query OK, 1 row affected (0.003 sec) MariaDB [dualdelovepment]> select * from precios; +------------+------------+---------------+--------------------+-------+ | cedula | fecha | precio_semana | precio_elaboracion | total | +------------+------------+---------------+--------------------+-------+ | 356487985 | 1975-05-30 | 2500000 | 2000000 | 0 | | 415895262 | 1984-10-30 | 2500000 | 2000000 | 0 | | 1014785994 | 1992-01-01 | 1500000 | 1000000 | 0 | | 1015785956 | 1987-05-02 | 200000 | 100000 | 0 | | 1025488963 | 1977-07-15 | 2000000 | 1000000 | 0 | | 1047859512 | 1976-06-15 | 450000 | 500000 | 0 | | 1088956489 | 1999-11-12 | 400000 | 100000 | 0 | | 1414785951 | 1989-10-20 | 1500000 | 1000000 | 0 | +------------+------------+---------------+--------------------+-------+ 8 rows in set (0.001 sec) MariaDB [dualdelovepment]> Select * from operario where year(current_date()) - year(fecha) < 35; ERROR 1146 (42S02): Table 'dualdelovepment.operario' doesn't exist MariaDB [dualdelovepment]> Select * from precios where year(current_date()) - year(fecha) < 35; +------------+------------+---------------+--------------------+-------+ | cedula | fecha | precio_semana | precio_elaboracion | total | +------------+------------+---------------+--------------------+-------+ | 1014785994 | 1992-01-01 | 1500000 | 1000000 | 0 | | 1088956489 | 1999-11-12 | 400000 | 100000 | 0 | | 1414785951 | 1989-10-20 | 1500000 | 1000000 | 0 | +------------+------------+---------------+--------------------+-------+ 3 rows in set (0.001 sec) MariaDB [dualdelovepment]> Select * from precios where year(current_date()) - year(fecha) < 25; +------------+------------+---------------+--------------------+-------+ | cedula | fecha | precio_semana | precio_elaboracion | total | +------------+------------+---------------+--------------------+-------+ | 1088956489 | 1999-11-12 | 400000 | 100000 | 0 | +------------+------------+---------------+--------------------+-------+ 1 row in set (0.001 sec) MariaDB [dualdelovepment]> Select * from precios where year(current_date()) - year(fecha) > 25; +------------+------------+---------------+--------------------+-------+ | cedula | fecha | precio_semana | precio_elaboracion | total | +------------+------------+---------------+--------------------+-------+ | 356487985 | 1975-05-30 | 2500000 | 2000000 | 0 | | 415895262 | 1984-10-30 | 2500000 | 2000000 | 0 | | 1014785994 | 1992-01-01 | 1500000 | 1000000 | 0 | | 1015785956 | 1987-05-02 | 200000 | 100000 | 0 | | 1025488963 | 1977-07-15 | 2000000 | 1000000 | 0 | | 1047859512 | 1976-06-15 | 450000 | 500000 | 0 | | 1414785951 | 1989-10-20 | 1500000 | 1000000 | 0 | +------------+------------+---------------+--------------------+-------+ 7 rows in set (0.001 sec) MariaDB [dualdelovepment]> delimiter // MariaDB [dualdelovepment]> create trigger caltotal before insert on precios -> for each row -> begin -> set new.total= new.precio_semana+new.precio_elaboracion; -> end -> // Query OK, 0 rows affected (0.017 sec) MariaDB [dualdelovepment]> delimiter ; MariaDB [dualdelovepment]> select * from precios; +------------+------------+---------------+--------------------+-------+ | cedula | fecha | precio_semana | precio_elaboracion | total | +------------+------------+---------------+--------------------+-------+ | 356487985 | 1975-05-30 | 2500000 | 2000000 | 0 | | 415895262 | 1984-10-30 | 2500000 | 2000000 | 0 | | 1014785994 | 1992-01-01 | 1500000 | 1000000 | 0 | | 1015785956 | 1987-05-02 | 200000 | 100000 | 0 | | 1025488963 | 1977-07-15 | 2000000 | 1000000 | 0 | | 1047859512 | 1976-06-15 | 450000 | 500000 | 0 | | 1088956489 | 1999-11-12 | 400000 | 100000 | 0 | | 1414785951 | 1989-10-20 | 1500000 | 1000000 | 0 | +------------+------------+---------------+--------------------+-------+ 8 rows in set (0.004 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('1047859650' -> , '1999-11-12', -> '1000000', '1000000', '0'); Query OK, 1 row affected (0.005 sec) MariaDB [dualdelovepment]> select * from precios; +------------+------------+---------------+--------------------+---------+ | cedula | fecha | precio_semana | precio_elaboracion | total | +------------+------------+---------------+--------------------+---------+ | 356487985 | 1975-05-30 | 2500000 | 2000000 | 0 | | 415895262 | 1984-10-30 | 2500000 | 2000000 | 0 | | 1014785994 | 1992-01-01 | 1500000 | 1000000 | 0 | | 1015785956 | 1987-05-02 | 200000 | 100000 | 0 | | 1025488963 | 1977-07-15 | 2000000 | 1000000 | 0 | | 1047859512 | 1976-06-15 | 450000 | 500000 | 0 | | 1047859650 | 1999-11-12 | 1000000 | 1000000 | 2000000 | | 1088956489 | 1999-11-12 | 400000 | 100000 | 0 | | 1414785951 | 1989-10-20 | 1500000 | 1000000 | 0 | +------------+------------+---------------+--------------------+---------+ 9 rows in set (0.001 sec) MariaDB [dualdelovepment]> update precios set total='4500000' where cedula='356487985'; Query OK, 1 row affected (0.004 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [dualdelovepment]> select * from precios; +------------+------------+---------------+--------------------+---------+ | cedula | fecha | precio_semana | precio_elaboracion | total | +------------+------------+---------------+--------------------+---------+ | 356487985 | 1975-05-30 | 2500000 | 2000000 | 4500000 | | 415895262 | 1984-10-30 | 2500000 | 2000000 | 0 | | 1014785994 | 1992-01-01 | 1500000 | 1000000 | 0 | | 1015785956 | 1987-05-02 | 200000 | 100000 | 0 | | 1025488963 | 1977-07-15 | 2000000 | 1000000 | 0 | | 1047859512 | 1976-06-15 | 450000 | 500000 | 0 | | 1047859650 | 1999-11-12 | 1000000 | 1000000 | 2000000 | | 1088956489 | 1999-11-12 | 400000 | 100000 | 0 | | 1414785951 | 1989-10-20 | 1500000 | 1000000 | 0 | +------------+------------+---------------+--------------------+---------+ 9 rows in set (0.001 sec) MariaDB [dualdelovepment]> update precios set total='4500000' where cedula='415895262'; Query OK, 1 row affected (0.003 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [dualdelovepment]> update precios set total='2500000' where cedula='1014785994'; Query OK, 1 row affected (0.003 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [dualdelovepment]> update precios set total='300000' where cedula='1015785956'; Query OK, 1 row affected (0.003 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [dualdelovepment]> update precios set total='3000000' where cedula='1025488963'; Query OK, 1 row affected (0.003 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [dualdelovepment]> update precios set total='950000' where cedula='1047859512'; Query OK, 1 row affected (0.003 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [dualdelovepment]> update precios set total='950000' where cedula='1088956489'; Query OK, 1 row affected (0.003 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [dualdelovepment]> update precios set total='2500000' where cedula='1414785951'; Query OK, 1 row affected (0.003 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [dualdelovepment]> select * from precios; +------------+------------+---------------+--------------------+---------+ | cedula | fecha | precio_semana | precio_elaboracion | total | +------------+------------+---------------+--------------------+---------+ | 356487985 | 1975-05-30 | 2500000 | 2000000 | 4500000 | | 415895262 | 1984-10-30 | 2500000 | 2000000 | 4500000 | | 1014785994 | 1992-01-01 | 1500000 | 1000000 | 2500000 | | 1015785956 | 1987-05-02 | 200000 | 100000 | 300000 | | 1025488963 | 1977-07-15 | 2000000 | 1000000 | 3000000 | | 1047859512 | 1976-06-15 | 450000 | 500000 | 950000 | | 1047859650 | 1999-11-12 | 1000000 | 1000000 | 2000000 | | 1088956489 | 1999-11-12 | 400000 | 100000 | 950000 | | 1414785951 | 1989-10-20 | 1500000 | 1000000 | 2500000 | +------------+------------+---------------+--------------------+---------+ 9 rows in set (0.001 sec) MariaDB [dualdelovepment]> insert into precios(cedula, fecha, precio_semana, precio_elaboracion, total) values('107778895', '1999-08-31', '1300000','500000','0'); Query OK, 1 row affected (0.011 sec) MariaDB [dualdelovepment]> select * from precios; +------------+------------+---------------+--------------------+---------+ | cedula | fecha | precio_semana | precio_elaboracion | total | +------------+------------+---------------+--------------------+---------+ | 107778895 | 1999-08-31 | 1300000 | 500000 | 1800000 | | 356487985 | 1975-05-30 | 2500000 | 2000000 | 4500000 | | 415895262 | 1984-10-30 | 2500000 | 2000000 | 4500000 | | 1014785994 | 1992-01-01 | 1500000 | 1000000 | 2500000 | | 1015785956 | 1987-05-02 | 200000 | 100000 | 300000 | | 1025488963 | 1977-07-15 | 2000000 | 1000000 | 3000000 | | 1047859512 | 1976-06-15 | 450000 | 500000 | 950000 | | 1047859650 | 1999-11-12 | 1000000 | 1000000 | 2000000 | | 1088956489 | 1999-11-12 | 400000 | 100000 | 950000 | | 1414785951 | 1989-10-20 | 1500000 | 1000000 | 2500000 | +------------+------------+---------------+--------------------+---------+ 10 rows in set (0.001 sec) MariaDB [dualdelovepment]> select * from usuarios; +------------+------------------+------------+-------------------+----------------+ | id_usuario | nombre | telefono | correo | direccion | +------------+------------------+------------+-------------------+----------------+ | 1014785994 | alirio valencia | 3214579522 | alirio@gmail.com | cra 20#31-11 | | 1015785956 | mario rodriguez | 3112456422 | mario@gmail.com | cll 35#10-01 | | 1025488963 | gerardo quintana | 3122156148 | gerardo@gmail.com | cra 70# 88-12 | | 1077895142 | david perez | 3101587923 | david@gmail.com | cll 40#10bb-30 | | 1088956489 | emilio gomez | 3301258792 | emilio@gmail.com | cra 20#15aa-30 | | 1414785951 | carlos gonzales | 3301258792 | carlos@gmail.com | cra 90#25aa-14 | | 356487985 | gustavo ordo¤ez | 3114578928 | gustavo@gmail.com | cll 45# 99a-17 | | 415895262 | maria renteria | 3101586548 | maria@gmail.com | cll 80# 39 | +------------+------------------+------------+-------------------+----------------+ 8 rows in set (0.012 sec) MariaDB [dualdelovepment]> select * from empleados; +--------------+--------------------+-------------+-------------+---------------------------+--------------------+ | id_empleados | nombre | direccion | telefono | correo | apk_a_desarrollar | +--------------+--------------------+-------------+-------------+---------------------------+--------------------+ | 1025478566 | jhonnier palomeque | manrique | 3215488569 | jhonier@gmail.com | app prueba | | 1025489663 | mateo ortiz | la navarra | 3102556409 | mateoortiz@gmail.com | cumplea¤os | | 1047859512 | alejandro gimenez | san antonio | 3214782947 | gimenezgmail.com | your apk | | 1048956874 | alejandro duran | la playa | 3110254409 | alejadndroduran@gmail.com | legumbreria | | 1074554645 | andres blandon | girardot | 32458959519 | andres@gmail.com | sistema antihacks | | 1077896515 | luis quintero | poblado | 3145689569 | luisquintero@gmail.com | bienvenida | | 1078954489 | brianh lopez | bello | 31457814551 | lopez11@gmail.com | sistema activos | | 1155522222 | oscar cordoba | la navarra | 31457892209 | oscar@gmail.com | medidior de campos | +--------------+--------------------+-------------+-------------+---------------------------+--------------------+ 8 rows in set (0.001 sec) MariaDB [dualdelovepment]> select id_empleado, nombre, direccion, telefono, correo, apk_a_desarrollar from empleados(id_empleado,1,3) in ('107') -> ; 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 '(id_empleado,1,3) in ('107')' at line 1 MariaDB [dualdelovepment]> select id_empleados, nombre, direccion, telefono, correo, apk_a_desarrollar from empleados(id_empleados,1,3) in ('107') -> ; 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 '(id_empleados,1,3) in ('107')' at line 1 MariaDB [dualdelovepment]> select id_empleados, nombre, direccion, telefono, correo, apk_a_desarrollar from empleados where substr(id_empleados,1,3) in ('107'); +--------------+----------------+-----------+-------------+------------------------+-------------------+ | id_empleados | nombre | direccion | telefono | correo | apk_a_desarrollar | +--------------+----------------+-----------+-------------+------------------------+-------------------+ | 1074554645 | andres blandon | girardot | 32458959519 | andres@gmail.com | sistema antihacks | | 1077896515 | luis quintero | poblado | 3145689569 | luisquintero@gmail.com | bienvenida | | 1078954489 | brianh lopez | bello | 31457814551 | lopez11@gmail.com | sistema activos | +--------------+----------------+-----------+-------------+------------------------+-------------------+ 3 rows in set (0.001 sec) MariaDB [dualdelovepment]> select id_usuario, nombre, telefono, correo, direccion from empleados where substr(direccion,1,3) in ('cra'); ERROR 1054 (42S22): Unknown column 'id_usuario' in 'field list' MariaDB [dualdelovepment]> select id_usuario, nombre, telefono, correo, direccion from usuarios where substr(direccion,1,3) in ('cra'); +------------+------------------+------------+-------------------+----------------+ | id_usuario | nombre | telefono | correo | direccion | +------------+------------------+------------+-------------------+----------------+ | 1014785994 | alirio valencia | 3214579522 | alirio@gmail.com | cra 20#31-11 | | 1025488963 | gerardo quintana | 3122156148 | gerardo@gmail.com | cra 70# 88-12 | | 1088956489 | emilio gomez | 3301258792 | emilio@gmail.com | cra 20#15aa-30 | | 1414785951 | carlos gonzales | 3301258792 | carlos@gmail.com | cra 90#25aa-14 | +------------+------------------+------------+-------------------+----------------+ 4 rows in set (0.001 sec) MariaDB [dualdelovepment]> updare precios -> join descripcion -> on usuarios.id_usuario=descripcion.descripcion; 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 'updare precios join descripcion on usuarios.id_usuario=descripcion.descripcion' at line 1 MariaDB [dualdelovepment]> update precios -> join descripcion -> on usuarios.id_usuario=descripcion.descripcion -> set usuario.descripcion= descripcion.descripcion; ERROR 1054 (42S22): Unknown column 'usuario.descripcion' in 'field list' MariaDB [dualdelovepment]> update precios -> join descripcion -> on usuarios.id_usuario=descripcion.descripcion -> set usuarios.descripcion= descripcion.descripcion; ERROR 1054 (42S22): Unknown column 'usuarios.descripcion' in 'field list' MariaDB [dualdelovepment]> alter table precios add descripcion varchar(50); Query OK, 0 rows affected (0.023 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [dualdelovepment]> describe precios; +--------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-------------+------+-----+---------+-------+ | cedula | int(11) | NO | PRI | NULL | | | fecha | date | YES | | NULL | | | precio_semana | int(11) | NO | | NULL | | | precio_elaboracion | int(11) | YES | | NULL | | | total | int(11) | YES | | NULL | | | descripcion | varchar(50) | YES | | NULL | | +--------------------+-------------+------+-----+---------+-------+ 6 rows in set (0.027 sec) MariaDB [dualdelovepment]> update precios -> join descripcion -> on usuarios.id_usuario=descripcion.descripcion -> set usuarios.descripcion= descripcion.descripcion; ERROR 1054 (42S22): Unknown column 'usuarios.descripcion' in 'field list' MariaDB [dualdelovepment]> update precios -> join descripcion -> on usuarios.id_usuario=descripcion.descripcion -> set precios.descripcion= descripcion.descripcion; ERROR 1054 (42S22): Unknown column 'usuarios.id_usuario' in 'on clause' MariaDB [dualdelovepment]> update precios -> join usuarios -> ; 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 2 MariaDB [dualdelovepment]> show tables; +---------------------------+ | Tables_in_dualdelovepment | +---------------------------+ | activos | | aplicaciones | | descripcion | | empleados | | precios | | proyectos | | usuarios | | vendidos | +---------------------------+ 8 rows in set (0.005 sec) MariaDB [dualdelovepment]> describe precios; +--------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-------------+------+-----+---------+-------+ | cedula | int(11) | NO | PRI | NULL | | | fecha | date | YES | | NULL | | | precio_semana | int(11) | NO | | NULL | | | precio_elaboracion | int(11) | YES | | NULL | | | total | int(11) | YES | | NULL | | | descripcion | varchar(50) | YES | | NULL | | +--------------------+-------------+------+-----+---------+-------+ 6 rows in set (0.022 sec) MariaDB [dualdelovepment]> select * from aplicacioneS; +----------------------+---------------+-------------+ | proximo_proyecto | fecha_inicial | fecha_final | +----------------------+---------------+-------------+ | calculadora | 2023-05-14 | 2023-05-30 | | costeador | 2023-06-01 | 2023-06-05 | | alquiler cancha | 2023-06-10 | 2023-06-20 | | empresiones | 2023-06-20 | 2023-06-30 | | lector de QR | 2023-07-01 | 2023-07-15 | | restaurante | 2023-07-15 | 2023-07-20 | | computos | 2023-07-20 | 2023-07-30 | | super mercado | 2023-08-10 | 2023-08-30 | | cumplea¤os D1 | 2023-09-01 | 2023-09-15 | | calculadora cuantica | 2023-09-15 | 2023-09-30 | +----------------------+---------------+-------------+ 10 rows in set (0.001 sec) MariaDB [dualdelovepment]> select p.cedula, total -> from precios as p -> group by p.cedula; +------------+---------+ | cedula | total | +------------+---------+ | 107778895 | 1800000 | | 356487985 | 4500000 | | 415895262 | 4500000 | | 1014785994 | 2500000 | | 1015785956 | 300000 | | 1025488963 | 3000000 | | 1047859512 | 950000 | | 1047859650 | 2000000 | | 1088956489 | 950000 | | 1414785951 | 2500000 | +------------+---------+ 10 rows in set (0.001 sec) MariaDB [dualdelovepment]> create table cedula_total -> select p.cedula, total -> from precios a p -> group by p.cedula; 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 'p group by p.cedula' at line 4 MariaDB [dualdelovepment]> create table cedula_total -> select p.cedula, total -> from precios as p -> group by p.cedula; Query OK, 10 rows affected (0.031 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [dualdelovepment]> select * from cedula_total; +------------+---------+ | cedula | total | +------------+---------+ | 107778895 | 1800000 | | 356487985 | 4500000 | | 415895262 | 4500000 | | 1014785994 | 2500000 | | 1015785956 | 300000 | | 1025488963 | 3000000 | | 1047859512 | 950000 | | 1047859650 | 2000000 | | 1088956489 | 950000 | | 1414785951 | 2500000 | +------------+---------+ 10 rows in set (0.001 sec) MariaDB [dualdelovepment]> show tables; +---------------------------+ | Tables_in_dualdelovepment | +---------------------------+ | activos | | aplicaciones | | cedula_total | | descripcion | | empleados | | precios | | proyectos | | usuarios | | vendidos | +---------------------------+ 9 rows in set (0.002 sec) MariaDB [dualdelovepment]> select * from activos -> ; +---------------------+-----------------------------+ | codigo_del_proyecto | nombre_del_proyecto | +---------------------+-----------------------------+ | 0001 | sistema activos | | 0012 | bienvenida | | 0100 | your apk | | 0500 | sistema antihacks | | 1000 | cumplea¤os | | 1452 | costing | | 1500 | legumbreria | | 2487 | medidor de campos electicos | | 2887 | app prueba | +---------------------+-----------------------------+ 9 rows in set (0.001 sec) MariaDB [dualdelovepment]> select * aplicaciones; 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 'aplicaciones' at line 1 MariaDB [dualdelovepment]> select * from aplicaciones; +----------------------+---------------+-------------+ | proximo_proyecto | fecha_inicial | fecha_final | +----------------------+---------------+-------------+ | calculadora | 2023-05-14 | 2023-05-30 | | costeador | 2023-06-01 | 2023-06-05 | | alquiler cancha | 2023-06-10 | 2023-06-20 | | empresiones | 2023-06-20 | 2023-06-30 | | lector de QR | 2023-07-01 | 2023-07-15 | | restaurante | 2023-07-15 | 2023-07-20 | | computos | 2023-07-20 | 2023-07-30 | | super mercado | 2023-08-10 | 2023-08-30 | | cumplea¤os D1 | 2023-09-01 | 2023-09-15 | | calculadora cuantica | 2023-09-15 | 2023-09-30 | +----------------------+---------------+-------------+ 10 rows in set (0.001 sec) MariaDB [dualdelovepment]> select * from cedula_total; +------------+---------+ | cedula | total | +------------+---------+ | 107778895 | 1800000 | | 356487985 | 4500000 | | 415895262 | 4500000 | | 1014785994 | 2500000 | | 1015785956 | 300000 | | 1025488963 | 3000000 | | 1047859512 | 950000 | | 1047859650 | 2000000 | | 1088956489 | 950000 | | 1414785951 | 2500000 | +------------+---------+ 10 rows in set (0.001 sec) MariaDB [dualdelovepment]> select * from descripcion; +-------------------+----------------------------------------------------+ | nombapk | descripcion | +-------------------+----------------------------------------------------+ | app prueba | informacion de apk no registrada | | bienvenida | software encargado de darle bienvenida a los nuevo | | costing | software encargado de costear el precio de otro so | | cumplea¤os | software encargado de felicitar a los trabajadores | | legumbreria | crea colas para compras y ventas en legumbreria | | medidor de campos | mide campos magneticos con la camara | | sistema activos | este software va a mostrar cuales son los que actu | | sistema antihack | software encargado de dar informacion al sistema d | | your apk | informacion de apk no registrada | +-------------------+----------------------------------------------------+ 9 rows in set (0.001 sec) MariaDB [dualdelovepment]> select * from empleados; +--------------+--------------------+-------------+-------------+---------------------------+--------------------+ | id_empleados | nombre | direccion | telefono | correo | apk_a_desarrollar | +--------------+--------------------+-------------+-------------+---------------------------+--------------------+ | 1025478566 | jhonnier palomeque | manrique | 3215488569 | jhonier@gmail.com | app prueba | | 1025489663 | mateo ortiz | la navarra | 3102556409 | mateoortiz@gmail.com | cumplea¤os | | 1047859512 | alejandro gimenez | san antonio | 3214782947 | gimenezgmail.com | your apk | | 1048956874 | alejandro duran | la playa | 3110254409 | alejadndroduran@gmail.com | legumbreria | | 1074554645 | andres blandon | girardot | 32458959519 | andres@gmail.com | sistema antihacks | | 1077896515 | luis quintero | poblado | 3145689569 | luisquintero@gmail.com | bienvenida | | 1078954489 | brianh lopez | bello | 31457814551 | lopez11@gmail.com | sistema activos | | 1155522222 | oscar cordoba | la navarra | 31457892209 | oscar@gmail.com | medidior de campos | +--------------+--------------------+-------------+-------------+---------------------------+--------------------+ 8 rows in set (0.001 sec) MariaDB [dualdelovepment]> exit