MariaDB [papeleria]> update producto set Precio_venta = Precio_costo + (Precio_costo * 0.22); Query OK, 10 rows affected (0.074 sec) Rows matched: 10 Changed: 10 Warnings: 0 MariaDB [papeleria]> select * from producto; +-------------+-------------+--------------+--------------+------------+ | id_producto | Nombre | Precio_costo | Precio_venta | Disponible | +-------------+-------------+--------------+--------------+------------+ | P001 | Cuaderno | 1200 | 1464 | 100 | | P002 | L piz | 300 | 366 | 500 | | P003 | Bol¡grafo | 500 | 610 | 300 | | P004 | Marcador | 700 | 854 | 150 | | P005 | Tijeras | 2500 | 3050 | 80 | | P006 | Pegamento | 1800 | 2196 | 90 | | P007 | Borrador | 200 | 244 | 400 | | P008 | Regla | 1000 | 1220 | 120 | | P009 | Carpeta | 3500 | 4270 | 50 | | P010 | Calculadora | 25000 | 30500 | 30 | +-------------+-------------+--------------+--------------+------------+ 10 rows in set (0.002 sec) MariaDB [papeleria]> select max(Precio_venta) "Valor producto m s caro" from producto; +-------------------------+ | Valor producto m s caro | +-------------------------+ | 30500 | +-------------------------+ 1 row in set (0.000 sec) MariaDB [papeleria]> select * from distribuidor; +-----------------+--------------------------+------------+--------------+ | id_distribuidor | Nombre | Telefono | Ciudad | +-----------------+--------------------------+------------+--------------+ | D001 | Distribuidora Central | 3112345678 | Bogot  | | D002 | Papeles del Norte | 3156789123 | Medell¡n | | D003 | Suminsitros Andes | 3109876543 | Cali | | D004 | Office Supplies | 3167890123 | Barranquilla | | D005 | Distribuciones Siglo XXI | 3123456789 | Cartagena | | D006 | Surtitodo | 3119876543 | Pereira | | D007 | Distribuidora del Sur | 3104567891 | Bucaramanga | | D008 | Insumos y Papeles | 3145678912 | Manizales | | D009 | Papeler¡a Todo | 3198765432 | C£cuta | | D010 | Suministros Express | 3176543210 | Ibagu‚ | +-----------------+--------------------------+------------+--------------+ 10 rows in set (0.008 sec) MariaDB [papeleria]> update distribuidor set nombre="Papeles del sur" where id_distribuidor="D002"; Query OK, 1 row affected (0.026 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [papeleria]> select * from distribuidor; +-----------------+--------------------------+------------+--------------+ | id_distribuidor | Nombre | Telefono | Ciudad | +-----------------+--------------------------+------------+--------------+ | D001 | Distribuidora Central | 3112345678 | Bogot  | | D002 | Papeles del sur | 3156789123 | Medell¡n | | D003 | Suminsitros Andes | 3109876543 | Cali | | D004 | Office Supplies | 3167890123 | Barranquilla | | D005 | Distribuciones Siglo XXI | 3123456789 | Cartagena | | D006 | Surtitodo | 3119876543 | Pereira | | D007 | Distribuidora del Sur | 3104567891 | Bucaramanga | | D008 | Insumos y Papeles | 3145678912 | Manizales | | D009 | Papeler¡a Todo | 3198765432 | C£cuta | | D010 | Suministros Express | 3176543210 | Ibagu‚ | +-----------------+--------------------------+------------+--------------+ 10 rows in set (0.001 sec) MariaDB [papeleria]> UPDATE producto SET Precio_costo = 1500, Disponible = 120 WHERE id_producto = 'P001'; Query OK, 1 row affected (0.014 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [papeleria]> select * from producto; +-------------+-------------+--------------+--------------+------------+ | id_producto | Nombre | Precio_costo | Precio_venta | Disponible | +-------------+-------------+--------------+--------------+------------+ | P001 | Cuaderno | 1500 | 1464 | 120 | | P002 | L piz | 300 | 366 | 500 | | P003 | Bol¡grafo | 500 | 610 | 300 | | P004 | Marcador | 700 | 854 | 150 | | P005 | Tijeras | 2500 | 3050 | 80 | | P006 | Pegamento | 1800 | 2196 | 90 | | P007 | Borrador | 200 | 244 | 400 | | P008 | Regla | 1000 | 1220 | 120 | | P009 | Carpeta | 3500 | 4270 | 50 | | P010 | Calculadora | 25000 | 30500 | 30 | +-------------+-------------+--------------+--------------+------------+ 10 rows in set (0.000 sec) MariaDB [papeleria]> SELECT id_producto, Nombre, Disponible FROM producto WHERE Disponible > 0; +-------------+-------------+------------+ | id_producto | Nombre | Disponible | +-------------+-------------+------------+ | P001 | Cuaderno | 120 | | P002 | L piz | 500 | | P003 | Bol¡grafo | 300 | | P004 | Marcador | 150 | | P005 | Tijeras | 80 | | P006 | Pegamento | 90 | | P007 | Borrador | 400 | | P008 | Regla | 120 | | P009 | Carpeta | 50 | | P010 | Calculadora | 30 | +-------------+-------------+------------+ 10 rows in set (0.006 sec) MariaDB [papeleria]> SELECT id_producto, Nombre, Disponible FROM producto WHERE Disponible > 100; +-------------+-----------+------------+ | id_producto | Nombre | Disponible | +-------------+-----------+------------+ | P001 | Cuaderno | 120 | | P002 | L piz | 500 | | P003 | Bol¡grafo | 300 | | P004 | Marcador | 150 | | P007 | Borrador | 400 | | P008 | Regla | 120 | +-------------+-----------+------------+ 6 rows in set (0.001 sec) MariaDB [papeleria]> SELECT v.id_venta, v.Fecha, dv.Cantidad_vendida, p.Nombre FROM venta v JOIN detalles_venta dv ON v.id_venta = dv.FK_venta JOIN producto p ON dv.FK_producto = p.id_producto WHERE v.FK_consumidor = 'C001'; +----------+------------+------------------+----------+ | id_venta | Fecha | Cantidad_vendida | Nombre | +----------+------------+------------------+----------+ | V001 | 2024-10-01 | 2 | Cuaderno | +----------+------------+------------------+----------+ 1 row in set (0.031 sec) MariaDB [papeleria]> SELECT v.id_venta, v.Fecha, dv.Cantidad_vendida, p.Nombre FROM venta v JOIN detalles_venta dv ON v.id_venta = dv.FK_venta JOIN producto p ON dv.FK_producto = p.id_producto WHERE v.FK_consumidor = 'C002'; +----------+------------+------------------+--------+ | id_venta | Fecha | Cantidad_vendida | Nombre | +----------+------------+------------------+--------+ | V002 | 2024-10-02 | 5 | L piz | +----------+------------+------------------+--------+ 1 row in set (0.001 sec) MariaDB [papeleria]> select * from producto; +-------------+-------------+--------------+--------------+------------+ | id_producto | Nombre | Precio_costo | Precio_venta | Disponible | +-------------+-------------+--------------+--------------+------------+ | P001 | Cuaderno | 1500 | 1464 | 120 | | P002 | L piz | 300 | 366 | 500 | | P003 | Bol¡grafo | 500 | 610 | 300 | | P004 | Marcador | 700 | 854 | 150 | | P005 | Tijeras | 2500 | 3050 | 80 | | P006 | Pegamento | 1800 | 2196 | 90 | | P007 | Borrador | 200 | 244 | 400 | | P008 | Regla | 1000 | 1220 | 120 | | P009 | Carpeta | 3500 | 4270 | 50 | | P010 | Calculadora | 25000 | 30500 | 30 | +-------------+-------------+--------------+--------------+------------+ 10 rows in set (0.001 sec) MariaDB [papeleria]> DELETE FROM producto WHERE id_producto = 'P010'; Query OK, 1 row affected (0.013 sec) MariaDB [papeleria]> select * from producto; +-------------+-----------+--------------+--------------+------------+ | id_producto | Nombre | Precio_costo | Precio_venta | Disponible | +-------------+-----------+--------------+--------------+------------+ | P001 | Cuaderno | 1500 | 1464 | 120 | | P002 | L piz | 300 | 366 | 500 | | P003 | Bol¡grafo | 500 | 610 | 300 | | P004 | Marcador | 700 | 854 | 150 | | P005 | Tijeras | 2500 | 3050 | 80 | | P006 | Pegamento | 1800 | 2196 | 90 | | P007 | Borrador | 200 | 244 | 400 | | P008 | Regla | 1000 | 1220 | 120 | | P009 | Carpeta | 3500 | 4270 | 50 | +-------------+-----------+--------------+--------------+------------+ 9 rows in set (0.001 sec) MariaDB [papeleria]> INSERT INTO producto (id_producto, Nombre, Precio_costo, Precio_venta, Disponible) VALUES ('P010', 'Bloc de notas', 800, 0, 200); Query OK, 1 row affected (0.007 sec) MariaDB [papeleria]> select * from producto; +-------------+---------------+--------------+--------------+------------+ | id_producto | Nombre | Precio_costo | Precio_venta | Disponible | +-------------+---------------+--------------+--------------+------------+ | P001 | Cuaderno | 1500 | 1464 | 120 | | P002 | L piz | 300 | 366 | 500 | | P003 | Bol¡grafo | 500 | 610 | 300 | | P004 | Marcador | 700 | 854 | 150 | | P005 | Tijeras | 2500 | 3050 | 80 | | P006 | Pegamento | 1800 | 2196 | 90 | | P007 | Borrador | 200 | 244 | 400 | | P008 | Regla | 1000 | 1220 | 120 | | P009 | Carpeta | 3500 | 4270 | 50 | | P010 | Bloc de notas | 800 | 0 | 200 | +-------------+---------------+--------------+--------------+------------+ 10 rows in set (0.001 sec) MariaDB [papeleria]> SELECT AVG(Precio_venta) AS Promedio_Precio_Venta FROM producto; +-----------------------+ | Promedio_Precio_Venta | +-----------------------+ | 1427.4000 | +-----------------------+ 1 row in set (0.004 sec) MariaDB [papeleria]> select * from producto; +-------------+---------------+--------------+--------------+------------+ | id_producto | Nombre | Precio_costo | Precio_venta | Disponible | +-------------+---------------+--------------+--------------+------------+ | P001 | Cuaderno | 1500 | 1464 | 120 | | P002 | L piz | 300 | 366 | 500 | | P003 | Bol¡grafo | 500 | 610 | 300 | | P004 | Marcador | 700 | 854 | 150 | | P005 | Tijeras | 2500 | 3050 | 80 | | P006 | Pegamento | 1800 | 2196 | 90 | | P007 | Borrador | 200 | 244 | 400 | | P008 | Regla | 1000 | 1220 | 120 | | P009 | Carpeta | 3500 | 4270 | 50 | | P010 | Bloc de notas | 800 | 0 | 200 | +-------------+---------------+--------------+--------------+------------+ 10 rows in set (0.002 sec) MariaDB [papeleria]> CREATE TABLE producto_copia AS SELECT * FROM producto; Query OK, 10 rows affected (0.039 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [papeleria]> select * from copia; ERROR 1146 (42S02): Table 'papeleria.copia' doesn't exist MariaDB [papeleria]> select * from producto_copia; +-------------+---------------+--------------+--------------+------------+ | id_producto | Nombre | Precio_costo | Precio_venta | Disponible | +-------------+---------------+--------------+--------------+------------+ | P001 | Cuaderno | 1500 | 1464 | 120 | | P002 | L piz | 300 | 366 | 500 | | P003 | Bol¡grafo | 500 | 610 | 300 | | P004 | Marcador | 700 | 854 | 150 | | P005 | Tijeras | 2500 | 3050 | 80 | | P006 | Pegamento | 1800 | 2196 | 90 | | P007 | Borrador | 200 | 244 | 400 | | P008 | Regla | 1000 | 1220 | 120 | | P009 | Carpeta | 3500 | 4270 | 50 | | P010 | Bloc de notas | 800 | 0 | 200 | +-------------+---------------+--------------+--------------+------------+ 10 rows in set (0.001 sec) MariaDB [papeleria]> select * from producto; +-------------+---------------+--------------+--------------+------------+ | id_producto | Nombre | Precio_costo | Precio_venta | Disponible | +-------------+---------------+--------------+--------------+------------+ | P001 | Cuaderno | 1500 | 1464 | 120 | | P002 | L piz | 300 | 366 | 500 | | P003 | Bol¡grafo | 500 | 610 | 300 | | P004 | Marcador | 700 | 854 | 150 | | P005 | Tijeras | 2500 | 3050 | 80 | | P006 | Pegamento | 1800 | 2196 | 90 | | P007 | Borrador | 200 | 244 | 400 | | P008 | Regla | 1000 | 1220 | 120 | | P009 | Carpeta | 3500 | 4270 | 50 | | P010 | Bloc de notas | 800 | 0 | 200 | +-------------+---------------+--------------+--------------+------------+ 10 rows in set (0.001 sec) MariaDB [papeleria]> ALTER TABLE distribuidor MODIFY COLUMN Telefono int; Query OK, 10 rows affected, 10 warnings (0.084 sec) Records: 10 Duplicates: 0 Warnings: 10 MariaDB [papeleria]> describe producto; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | id_producto | varchar(20) | NO | PRI | NULL | | | Nombre | varchar(45) | NO | | NULL | | | Precio_costo | int(45) | NO | | NULL | | | Precio_venta | int(45) | NO | | NULL | | | Disponible | int(45) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 5 rows in set (0.009 sec) MariaDB [papeleria]> describe distribuidor; +-----------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+---------+-------+ | id_distribuidor | varchar(20) | NO | PRI | NULL | | | Nombre | varchar(45) | NO | | NULL | | | Telefono | int(11) | YES | | NULL | | | Ciudad | varchar(45) | NO | | NULL | | +-----------------+-------------+------+-----+---------+-------+ 4 rows in set (0.015 sec) MariaDB [papeleria]> delimiter // MariaDB [papeleria]> create procedure listar_producto() -> begin -> select * from producto; -> end -> // Query OK, 0 rows affected (0.032 sec) MariaDB [papeleria]> delimiter ; MariaDB [papeleria]> call listar_producto; +-------------+---------------+--------------+--------------+------------+ | id_producto | Nombre | Precio_costo | Precio_venta | Disponible | +-------------+---------------+--------------+--------------+------------+ | P001 | Cuaderno | 1500 | 1464 | 120 | | P002 | Lapiz | 300 | 366 | 500 | | P003 | Boligrafo | 500 | 610 | 300 | | P004 | Marcador | 700 | 854 | 150 | | P005 | Tijeras | 2500 | 3050 | 80 | | P006 | Pegamento | 1800 | 2196 | 90 | | P007 | Borrador | 200 | 244 | 400 | | P008 | Regla | 1000 | 1220 | 120 | | P009 | Carpeta | 3500 | 4270 | 50 | | P010 | Bloc de notas | 800 | 0 | 200 | +-------------+---------------+--------------+--------------+------------+ 10 rows in set (0.015 sec) Query OK, 0 rows affected (0.090 sec) MariaDB [papeleria]> show procedure status; +-----------+------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-----------+------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+---------- | matricula | listar_alumno | PROCEDURE | root@localhost | 2024-11-02 13:29:15 | 2024-11-02 13:25:13 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | +-----------+------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+---------- 6 rows in set (0.016 sec) MariaDB [papeleria]> show create procedure listar_producto; +-----------------+-----------------------------------------------------+---------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +-----------------+-----------------------------------------------------+---------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | listar_producto | NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`root`@`localhost` PROCEDURE `listar_producto`() begin select * from producto; end | cp850 | cp850_general_ci | utf8mb4_general_ci | +-----------------+-----------------------------------------------------+---------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.001 sec) 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 'demiliter' at line 1 MariaDB [papeleria]> delimiter ; MariaDB [papeleria]> select venta.id_venta, venta.Fecha, consumidor.nombre AS nombre_consumidor, producto.Nombre AS Nombre_producto, Detalles_Venta.Cantidad_vendida from venta inner join consumidor on venta.FK_consumidor = consumidor.id_consumidor inner join Detalle -> s_Venta on venta.id_venta = Detalles_Venta.FK_venta inner join producto on Detalles_Venta.FK_producto = producto.id_producto; ERROR 1146 (42S02): Table 'papeleria.detalle' doesn't exist MariaDB [papeleria]> select venta.id_venta, venta.Fecha, consumidor.nombre AS nombre_consumidor, producto.Nombre AS Nombre_producto, Detalles_Venta.Cantidad_vendida from venta inner join consumidor on venta.FK_consumidor = consumidor.id_consumidor inner join Detalle s_Venta on venta.id_venta = Detalles_Venta.FK_venta inner join producto on Detalles_Venta.FK_producto = producto.id_producto; +----------+------------+-------------------+-----------------+------------------+ | id_venta | Fecha | nombre_consumidor | Nombre_producto | Cantidad_vendida | +----------+------------+-------------------+-----------------+------------------+ | V001 | 2024-10-01 | Luis Gómez | Cuaderno | 2 | | V002 | 2024-10-02 | Marta Rojas | Lápiz | 5 | | V003 | 2024-10-03 | Carlos Díaz | Bolígrafo | 3 | | V004 | 2024-10-04 | Ana Ramírez | Marcador | 1 | | V005 | 2024-10-05 | Pedro Pérez | Tijeras | 4 | +----------+------------+-------------------+-----------------+------------------+ 5 rows in set (0.001 sec) MariaDB [papeleria]> create view consumidorz as select * from consumidor where nombre like '%z'; Query OK, 0 rows affected (0.008 sec) MariaDB [papeleria]> select * from consumidorz; +---------------+-------------+------------+--------------+ | id_consumidor | Nombre | Telefono | Ciudad | +---------------+-------------+------------+--------------+ | C001 | Luis Gómez | 3214567890 | Bogotá | | C003 | Carlos Díaz | 3234567891 | Cali | | C004 | Ana Ramírez | 3245678901 | Barranquilla | | C005 | Pedro Pérez | 3256789012 | Cartagena | +---------------+-------------+------------+--------------+ 4 rows in set (0.017 sec) MariaDB [papeleria]> exit Bye