MariaDB [(none)]> shoe databases; 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 'shoe databases' at line 1 MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | bd_biblioteca | | information_schema | | libreria | | matricula | | matricula2 | | mysql | | performance_schema | | phpmyadmin | | reto2 | | sancardb | | sistema_escolar | | sistemaventa | | test | +--------------------+ 13 rows in set (0.073 sec) MariaDB [(none)]> use sancardb Database changed MariaDB [sancardb]> show tables; +--------------------+ | Tables_in_sancardb | +--------------------+ | clientes | | detalle | | direccion | | pedido | | productos | | proveedor | | usuarios | | ventas | +--------------------+ 8 rows in set (0.001 sec) MariaDB [sancardb]> describe productos; +-------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------+------+-----+---------+----------------+ | producto_id | int(11) | NO | PRI | NULL | auto_increment | | nombre | varchar(100) | NO | | NULL | | | descripcion | text | YES | | NULL | | | precio | decimal(10,2) | NO | | NULL | | | stock | int(11) | NO | | NULL | | +-------------+---------------+------+-----+---------+----------------+ 5 rows in set (0.021 sec) MariaDB [sancardb]> select * from productos; +-------------+--------------+----------------------+----------+-------+ | producto_id | nombre | descripcion | precio | stock | +-------------+--------------+----------------------+----------+-------+ | 1 | arroz | arroz de grano largo | 15000.00 | 100 | | 2 | az£car | az£car blanca | 5000.00 | 200 | | 3 | sal | sal de mesa | 2000.00 | 150 | | 4 | aceite | aceite vegetal | 12000.00 | 80 | | 5 | leche | leche entera | 8000.00 | 60 | | 6 | huevo | huevos de gallina | 10000.00 | 90 | | 7 | pollo | pollo fresco | 18000.00 | 110 | | 8 | carne de res | carne de res molida | 25000.00 | 120 | | 9 | pasta | fideos de pasta | 6000.00 | 140 | | 10 | frijoles | frijoles rojos | 7000.00 | 130 | +-------------+--------------+----------------------+----------+-------+ 10 rows in set (0.072 sec) MariaDB [sancardb]> Delimiter // MariaDB [sancardb]> create procedure insertar_productos(in _producto_id int, in _nombre varchar(100), in _descripcion text, in _precio decimal(10,2), in _stock int) -> Begin -> Insert into productos values(_producto_id,_nombre,_descripcion,_precio,_stock); -> end -> // Query OK, 0 rows affected (0.037 sec) MariaDB [sancardb]> delimiter ; MariaDB [sancardb]> MariaDB [sancardb]> show procedure estatus; 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 'estatus' at line 1 MariaDB [sancardb]> show procedure status; +-----------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-----------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | matricula | consultar_alumno | PROCEDURE | root@localhost | 2024-11-01 19:15:47 | 2024-11-01 19:15:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | eliminar_alumno | PROCEDURE | root@localhost | 2024-11-01 19:20:27 | 2024-11-01 19:20:27 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | insertar_alumno | PROCEDURE | root@localhost | 2024-11-01 18:50:15 | 2024-11-01 18:50:15 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | listar_alumno | PROCEDURE | root@localhost | 2024-11-01 19:09:33 | 2024-11-01 19:09:33 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | modificar_alumno | PROCEDURE | root@localhost | 2024-11-01 19:30:22 | 2024-11-01 19:30:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | sancardb | insertar_productos | PROCEDURE | root@localhost | 2024-11-05 14:26:56 | 2024-11-05 14:26:56 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | +-----------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 6 rows in set (0.016 sec) MariaDB [sancardb]> show create procedure insertar_producto; ERROR 1305 (42000): PROCEDURE insertar_producto does not exist MariaDB [sancardb]> show create procedure insertar_productos; +--------------------+-----------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +--------------------+-----------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | insertar_productos | NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`root`@`localhost` PROCEDURE `insertar_productos`(in _producto_id int, in _nombre varchar(100), in _descripcion text, in _precio decimal(10,2), in _stock int) Begin Insert into productos values(_producto_id,_nombre,_descripcion,_precio,_stock); end | cp850 | cp850_general_ci | utf8mb4_general_ci | +--------------------+-----------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.001 sec) MariaDB [sancardb]> describe productos; +-------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------+------+-----+---------+----------------+ | producto_id | int(11) | NO | PRI | NULL | auto_increment | | nombre | varchar(100) | NO | | NULL | | | descripcion | text | YES | | NULL | | | precio | decimal(10,2) | NO | | NULL | | | stock | int(11) | NO | | NULL | | +-------------+---------------+------+-----+---------+----------------+ 5 rows in set (0.020 sec) MariaDB [sancardb]> select * from productos;; +-------------+--------------+----------------------+----------+-------+ | producto_id | nombre | descripcion | precio | stock | +-------------+--------------+----------------------+----------+-------+ | 1 | arroz | arroz de grano largo | 15000.00 | 100 | | 2 | az£car | az£car blanca | 5000.00 | 200 | | 3 | sal | sal de mesa | 2000.00 | 150 | | 4 | aceite | aceite vegetal | 12000.00 | 80 | | 5 | leche | leche entera | 8000.00 | 60 | | 6 | huevo | huevos de gallina | 10000.00 | 90 | | 7 | pollo | pollo fresco | 18000.00 | 110 | | 8 | carne de res | carne de res molida | 25000.00 | 120 | | 9 | pasta | fideos de pasta | 6000.00 | 140 | | 10 | frijoles | frijoles rojos | 7000.00 | 130 | +-------------+--------------+----------------------+----------+-------+ 10 rows in set (0.001 sec) ERROR: No query specified MariaDB [sancardb]> call insertar_productos(11, 'Jab¢n', 'Barra de jab¢n de avena', 2500, 16); Query OK, 1 row affected (0.003 sec) MariaDB [sancardb]> select * from productos;; +-------------+--------------+-------------------------+----------+-------+ | producto_id | nombre | descripcion | precio | stock | +-------------+--------------+-------------------------+----------+-------+ | 1 | arroz | arroz de grano largo | 15000.00 | 100 | | 2 | az£car | az£car blanca | 5000.00 | 200 | | 3 | sal | sal de mesa | 2000.00 | 150 | | 4 | aceite | aceite vegetal | 12000.00 | 80 | | 5 | leche | leche entera | 8000.00 | 60 | | 6 | huevo | huevos de gallina | 10000.00 | 90 | | 7 | pollo | pollo fresco | 18000.00 | 110 | | 8 | carne de res | carne de res molida | 25000.00 | 120 | | 9 | pasta | fideos de pasta | 6000.00 | 140 | | 10 | frijoles | frijoles rojos | 7000.00 | 130 | | 11 | Jab¢n | Barra de jab¢n de avena | 2500.00 | 16 | +-------------+--------------+-------------------------+----------+-------+ 11 rows in set (0.000 sec) ERROR: No query specified MariaDB [sancardb]> call insertar_productos(12, 'Lentejas', 'Lentejas secas', 5000, 80); Query OK, 1 row affected (0.004 sec) MariaDB [sancardb]> select * from productos;; +-------------+--------------+-------------------------+----------+-------+ | producto_id | nombre | descripcion | precio | stock | +-------------+--------------+-------------------------+----------+-------+ | 1 | arroz | arroz de grano largo | 15000.00 | 100 | | 2 | az£car | az£car blanca | 5000.00 | 200 | | 3 | sal | sal de mesa | 2000.00 | 150 | | 4 | aceite | aceite vegetal | 12000.00 | 80 | | 5 | leche | leche entera | 8000.00 | 60 | | 6 | huevo | huevos de gallina | 10000.00 | 90 | | 7 | pollo | pollo fresco | 18000.00 | 110 | | 8 | carne de res | carne de res molida | 25000.00 | 120 | | 9 | pasta | fideos de pasta | 6000.00 | 140 | | 10 | frijoles | frijoles rojos | 7000.00 | 130 | | 11 | Jab¢n | Barra de jab¢n de avena | 2500.00 | 16 | | 12 | Lentejas | Lentejas secas | 5000.00 | 80 | +-------------+--------------+-------------------------+----------+-------+ 12 rows in set (0.000 sec) ERROR: No query specified MariaDB [sancardb]> call insertar_productos(13, 'Harina', 'Harina de trigo', 4000, 150); Query OK, 1 row affected (0.003 sec) MariaDB [sancardb]> select * from productos;; +-------------+--------------+-------------------------+----------+-------+ | producto_id | nombre | descripcion | precio | stock | +-------------+--------------+-------------------------+----------+-------+ | 1 | arroz | arroz de grano largo | 15000.00 | 100 | | 2 | az£car | az£car blanca | 5000.00 | 200 | | 3 | sal | sal de mesa | 2000.00 | 150 | | 4 | aceite | aceite vegetal | 12000.00 | 80 | | 5 | leche | leche entera | 8000.00 | 60 | | 6 | huevo | huevos de gallina | 10000.00 | 90 | | 7 | pollo | pollo fresco | 18000.00 | 110 | | 8 | carne de res | carne de res molida | 25000.00 | 120 | | 9 | pasta | fideos de pasta | 6000.00 | 140 | | 10 | frijoles | frijoles rojos | 7000.00 | 130 | | 11 | Jab¢n | Barra de jab¢n de avena | 2500.00 | 16 | | 12 | Lentejas | Lentejas secas | 5000.00 | 80 | | 13 | Harina | Harina de trigo | 4000.00 | 150 | +-------------+--------------+-------------------------+----------+-------+ 13 rows in set (0.000 sec) ERROR: No query specified MariaDB [sancardb]> call insertar_productos(14, 'Caf‚', 'Caf‚ molido', 12000, 50); Query OK, 1 row affected (0.003 sec) MariaDB [sancardb]> select * from productos;; +-------------+--------------+-------------------------+----------+-------+ | producto_id | nombre | descripcion | precio | stock | +-------------+--------------+-------------------------+----------+-------+ | 1 | arroz | arroz de grano largo | 15000.00 | 100 | | 2 | az£car | az£car blanca | 5000.00 | 200 | | 3 | sal | sal de mesa | 2000.00 | 150 | | 4 | aceite | aceite vegetal | 12000.00 | 80 | | 5 | leche | leche entera | 8000.00 | 60 | | 6 | huevo | huevos de gallina | 10000.00 | 90 | | 7 | pollo | pollo fresco | 18000.00 | 110 | | 8 | carne de res | carne de res molida | 25000.00 | 120 | | 9 | pasta | fideos de pasta | 6000.00 | 140 | | 10 | frijoles | frijoles rojos | 7000.00 | 130 | | 11 | Jab¢n | Barra de jab¢n de avena | 2500.00 | 16 | | 12 | Lentejas | Lentejas secas | 5000.00 | 80 | | 13 | Harina | Harina de trigo | 4000.00 | 150 | | 14 | Caf‚ | Caf‚ molido | 12000.00 | 50 | +-------------+--------------+-------------------------+----------+-------+ 14 rows in set (0.000 sec) ERROR: No query specified MariaDB [sancardb]> select * from productos; +-------------+--------------+-------------------------+----------+-------+ | producto_id | nombre | descripcion | precio | stock | +-------------+--------------+-------------------------+----------+-------+ | 1 | arroz | arroz de grano largo | 15000.00 | 100 | | 2 | az£car | az£car blanca | 5000.00 | 200 | | 3 | sal | sal de mesa | 2000.00 | 150 | | 4 | aceite | aceite vegetal | 12000.00 | 80 | | 5 | leche | leche entera | 8000.00 | 60 | | 6 | huevo | huevos de gallina | 10000.00 | 90 | | 7 | pollo | pollo fresco | 18000.00 | 110 | | 8 | carne de res | carne de res molida | 25000.00 | 120 | | 9 | pasta | fideos de pasta | 6000.00 | 140 | | 10 | frijoles | frijoles rojos | 7000.00 | 130 | | 11 | Jab¢n | Barra de jab¢n de avena | 2500.00 | 16 | | 12 | Lentejas | Lentejas secas | 5000.00 | 80 | | 13 | Harina | Harina de trigo | 4000.00 | 150 | | 14 | Caf‚ | Caf‚ molido | 12000.00 | 50 | +-------------+--------------+-------------------------+----------+-------+ 14 rows in set (0.000 sec) MariaDB [sancardb]> delimiter // MariaDB [sancardb]> create procedure eliminar_producto(in _producto_id int) -> begin -> delete from productos where producto_id=_producto_id; -> end -> // Query OK, 0 rows affected (0.007 sec) MariaDB [sancardb]> delimiter ; MariaDB [sancardb]> show procedure status; +-----------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-----------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | matricula | consultar_alumno | PROCEDURE | root@localhost | 2024-11-01 19:15:47 | 2024-11-01 19:15:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | eliminar_alumno | PROCEDURE | root@localhost | 2024-11-01 19:20:27 | 2024-11-01 19:20:27 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | insertar_alumno | PROCEDURE | root@localhost | 2024-11-01 18:50:15 | 2024-11-01 18:50:15 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | listar_alumno | PROCEDURE | root@localhost | 2024-11-01 19:09:33 | 2024-11-01 19:09:33 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | modificar_alumno | PROCEDURE | root@localhost | 2024-11-01 19:30:22 | 2024-11-01 19:30:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | sancardb | eliminar_producto | PROCEDURE | root@localhost | 2024-11-05 14:43:23 | 2024-11-05 14:43:23 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | sancardb | insertar_productos | PROCEDURE | root@localhost | 2024-11-05 14:26:56 | 2024-11-05 14:26:56 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | +-----------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 7 rows in set (0.019 sec) MariaDB [sancardb]> select * from productos; +-------------+--------------+-------------------------+----------+-------+ | producto_id | nombre | descripcion | precio | stock | +-------------+--------------+-------------------------+----------+-------+ | 1 | arroz | arroz de grano largo | 15000.00 | 100 | | 2 | az£car | az£car blanca | 5000.00 | 200 | | 3 | sal | sal de mesa | 2000.00 | 150 | | 4 | aceite | aceite vegetal | 12000.00 | 80 | | 5 | leche | leche entera | 8000.00 | 60 | | 6 | huevo | huevos de gallina | 10000.00 | 90 | | 7 | pollo | pollo fresco | 18000.00 | 110 | | 8 | carne de res | carne de res molida | 25000.00 | 120 | | 9 | pasta | fideos de pasta | 6000.00 | 140 | | 10 | frijoles | frijoles rojos | 7000.00 | 130 | | 11 | Jab¢n | Barra de jab¢n de avena | 2500.00 | 16 | | 12 | Lentejas | Lentejas secas | 5000.00 | 80 | | 13 | Harina | Harina de trigo | 4000.00 | 150 | | 14 | Caf‚ | Caf‚ molido | 12000.00 | 50 | +-------------+--------------+-------------------------+----------+-------+ 14 rows in set (0.000 sec) MariaDB [sancardb]> call eliminar_producto(14); Query OK, 1 row affected (0.005 sec) MariaDB [sancardb]> select * from productos; +-------------+--------------+-------------------------+----------+-------+ | producto_id | nombre | descripcion | precio | stock | +-------------+--------------+-------------------------+----------+-------+ | 1 | arroz | arroz de grano largo | 15000.00 | 100 | | 2 | az£car | az£car blanca | 5000.00 | 200 | | 3 | sal | sal de mesa | 2000.00 | 150 | | 4 | aceite | aceite vegetal | 12000.00 | 80 | | 5 | leche | leche entera | 8000.00 | 60 | | 6 | huevo | huevos de gallina | 10000.00 | 90 | | 7 | pollo | pollo fresco | 18000.00 | 110 | | 8 | carne de res | carne de res molida | 25000.00 | 120 | | 9 | pasta | fideos de pasta | 6000.00 | 140 | | 10 | frijoles | frijoles rojos | 7000.00 | 130 | | 11 | Jab¢n | Barra de jab¢n de avena | 2500.00 | 16 | | 12 | Lentejas | Lentejas secas | 5000.00 | 80 | | 13 | Harina | Harina de trigo | 4000.00 | 150 | +-------------+--------------+-------------------------+----------+-------+ 13 rows in set (0.000 sec) MariaDB [sancardb]> show tables; +--------------------+ | Tables_in_sancardb | +--------------------+ | clientes | | detalle | | direccion | | pedido | | productos | | proveedor | | usuarios | | ventas | +--------------------+ 8 rows in set (0.001 sec) MariaDB [sancardb]> select * from ventas; +----------+------------+-----------+------------+------------+-------------+----------+ | venta_id | fecha | total | cliente_id | usuario_id | id_producto | cantidad | +----------+------------+-----------+------------+------------+-------------+----------+ | 1 | 2024-10-01 | 10000.00 | 1 | 1 | 3 | 5 | | 2 | 2024-10-02 | 180000.00 | 2 | 2 | 7 | 10 | | 3 | 2024-10-03 | 45000.00 | 3 | 3 | 1 | 3 | | 4 | 2024-10-04 | 64000.00 | 4 | 4 | 5 | 8 | | 5 | 2024-10-05 | 84000.00 | 5 | 5 | 10 | 12 | | 6 | 2024-10-06 | 35000.00 | 6 | 6 | 2 | 7 | | 7 | 2024-10-07 | 100000.00 | 7 | 7 | 8 | 4 | | 8 | 2024-10-08 | 72000.00 | 8 | 8 | 4 | 6 | | 9 | 2024-10-09 | 90000.00 | 9 | 9 | 6 | 9 | | 10 | 2024-10-10 | 12000.00 | 10 | 10 | 9 | 2 | +----------+------------+-----------+------------+------------+-------------+----------+ 10 rows in set (0.004 sec) MariaDB [sancardb]> select * from productos; +-------------+--------------+-------------------------+----------+-------+ | producto_id | nombre | descripcion | precio | stock | +-------------+--------------+-------------------------+----------+-------+ | 1 | arroz | arroz de grano largo | 15000.00 | 100 | | 2 | az£car | az£car blanca | 5000.00 | 200 | | 3 | sal | sal de mesa | 2000.00 | 150 | | 4 | aceite | aceite vegetal | 12000.00 | 80 | | 5 | leche | leche entera | 8000.00 | 60 | | 6 | huevo | huevos de gallina | 10000.00 | 90 | | 7 | pollo | pollo fresco | 18000.00 | 110 | | 8 | carne de res | carne de res molida | 25000.00 | 120 | | 9 | pasta | fideos de pasta | 6000.00 | 140 | | 10 | frijoles | frijoles rojos | 7000.00 | 130 | | 11 | Jab¢n | Barra de jab¢n de avena | 2500.00 | 16 | | 12 | Lentejas | Lentejas secas | 5000.00 | 80 | | 13 | Harina | Harina de trigo | 4000.00 | 150 | +-------------+--------------+-------------------------+----------+-------+ 13 rows in set (0.000 sec) MariaDB [sancardb]> delimiter // MariaDB [sancardb]> create procedure registrar_venta (in _fecha date, in _total decimal(10,2), in _cliente_id int, in _usuario_id int, in _id_producto int, in _cantidad) -> begin -> insert into ventas (fecha, total, cliente_id, usuario_id, id_producto, cantidad) -> values (_fecha, _total; _cliente_id, _usuario_id, _id_producto, _cantidad); -> update productos -> set stock = stock - _cantidad -> where producto_id = _id_producto; -> end -> // 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 ') begin insert into ventas (fecha, total, cliente_id, usuario_id, id_producto...' at line 1 MariaDB [sancardb]> delimiter // MariaDB [sancardb]> create procedure registrar_venta (in _fecha date, in _total decimal(10,2), in _cliente_id int, in _usuario_id int, in _id_producto int, in _cantidad) -> ) -> begin -> insert into ventas (fecha, total, cliente_id, usuario_id, producto_id, cantidad) -> values (_fecha, _total; _cliente_id, _usuario_id, _id_producto, _cantidad); -> update productos -> set stock = stock - _cantidad -> where producto_id = _id_producto; -> end -> // 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 ') ) begin insert into ventas (fecha, total, cliente_id, usuario_id, producto_...' at line 1 MariaDB [sancardb]> select * from productos; -> end -> // +-------------+--------------+-------------------------+----------+-------+ | producto_id | nombre | descripcion | precio | stock | +-------------+--------------+-------------------------+----------+-------+ | 1 | arroz | arroz de grano largo | 15000.00 | 100 | | 2 | az£car | az£car blanca | 5000.00 | 200 | | 3 | sal | sal de mesa | 2000.00 | 150 | | 4 | aceite | aceite vegetal | 12000.00 | 80 | | 5 | leche | leche entera | 8000.00 | 60 | | 6 | huevo | huevos de gallina | 10000.00 | 90 | | 7 | pollo | pollo fresco | 18000.00 | 110 | | 8 | carne de res | carne de res molida | 25000.00 | 120 | | 9 | pasta | fideos de pasta | 6000.00 | 140 | | 10 | frijoles | frijoles rojos | 7000.00 | 130 | | 11 | Jab¢n | Barra de jab¢n de avena | 2500.00 | 16 | | 12 | Lentejas | Lentejas secas | 5000.00 | 80 | | 13 | Harina | Harina de trigo | 4000.00 | 150 | +-------------+--------------+-------------------------+----------+-------+ 13 rows 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 'end' at line 1 MariaDB [sancardb]> select * from productos; -> // +-------------+--------------+-------------------------+----------+-------+ | producto_id | nombre | descripcion | precio | stock | +-------------+--------------+-------------------------+----------+-------+ | 1 | arroz | arroz de grano largo | 15000.00 | 100 | | 2 | az£car | az£car blanca | 5000.00 | 200 | | 3 | sal | sal de mesa | 2000.00 | 150 | | 4 | aceite | aceite vegetal | 12000.00 | 80 | | 5 | leche | leche entera | 8000.00 | 60 | | 6 | huevo | huevos de gallina | 10000.00 | 90 | | 7 | pollo | pollo fresco | 18000.00 | 110 | | 8 | carne de res | carne de res molida | 25000.00 | 120 | | 9 | pasta | fideos de pasta | 6000.00 | 140 | | 10 | frijoles | frijoles rojos | 7000.00 | 130 | | 11 | Jab¢n | Barra de jab¢n de avena | 2500.00 | 16 | | 12 | Lentejas | Lentejas secas | 5000.00 | 80 | | 13 | Harina | Harina de trigo | 4000.00 | 150 | +-------------+--------------+-------------------------+----------+-------+ 13 rows in set (0.000 sec) MariaDB [sancardb]> exit