MariaDB [inventarioalcaldia]> show tables; +------------------------------+ | Tables_in_inventarioalcaldia | +------------------------------+ | dafuninven | | funcionarios | | invenfunpro | | inventario | | objetosda¤ados | | proveedores | | secrefun | | secretarias | +------------------------------+ 8 rows in set (0.001 sec) MariaDB [inventarioalcaldia]> describe funcionarios; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | idfuncionario | varchar(10) | NO | PRI | NULL | | | nombre | varchar(40) | NO | | NULL | | | genero | varchar(10) | NO | | NULL | | | puesto | varchar(30) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 4 rows in set (0.035 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure insertar_funcionarios(in _idfuncionario varchar(10), in _nombre varchar(40), in _genero varchar(10), in puesto varchar(30)) -> Begin -> Insert into funcionarios values(_idfuncionario,_nombre,_genero,_puesto); -> End -> // Query OK, 0 rows affected (0.026 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> Show procedure status; +--------------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +--------------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | inventarioalcaldia | insertar_funcionarios | PROCEDURE | root@localhost | 2022-05-31 10:24:34 | 2022-05-31 10:24:34 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | +--------------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 1 row in set (0.023 sec) MariaDB [inventarioalcaldia]> Call insertar_funcionarios('87947670','Manuela Alvarez','Femenino','Auxiliar'); ERROR 1054 (42S22): Unknown column '_puesto' in 'field list' MariaDB [inventarioalcaldia]> drop procedure insertar_funcionarios; Query OK, 0 rows affected (0.004 sec) MariaDB [inventarioalcaldia]> Show procedure status; Empty set (0.013 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure insertar_funcionarios(in _idfuncionario varchar(10), in _nombre varchar(40), in _genero varchar(10), in _puesto varchar(30)) -> Begin -> Insert into funcionarios values(_idfuncionario,_nombre,_genero,_puesto); -> End -> // Query OK, 0 rows affected (0.004 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> Call insertar_funcionarios('87947670','Manuela Alvarez','Femenino','Auxiliar'); Query OK, 1 row affected (0.002 sec) MariaDB [inventarioalcaldia]> select * from funcionarios; +---------------+-----------------------+-----------+-----------+ | idfuncionario | nombre | genero | puesto | +---------------+-----------------------+-----------+-----------+ | 1000653947 | Carlos Perez | Masculino | Analista | | 10009033 | Santiago Echavarria | Masculino | Abogado | | 1001555983 | Sandra Jaramillo | Femenino | Contadora | | 23929494 | Daniela Torres | Femenino | Abogada | | 32218997 | Samuel Mu¤oz | Masculino | Abogado | | 46793423 | Maicol Hern ndez | Masculino | Abogado | | 48984934 | Maria Camila Gonzalez | Femenino | Auxiliar | | 65987905 | Catherine Lopez | Femenino | Analista | | 87947670 | Manuela Alvarez | Femenino | Auxiliar | | 96734744 | Luisa Maldonado | Femenino | Auxiliar | | 98838838 | Efrain Henao | Masculino | Analista | +---------------+-----------------------+-----------+-----------+ 11 rows in set (0.000 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure listar_funcionarios() -> Begin -> Select * from funcionarios; -> End -> // Query OK, 0 rows affected (0.004 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> Show procedure status; +--------------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +--------------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | inventarioalcaldia | insertar_funcionarios | PROCEDURE | root@localhost | 2022-05-31 10:28:46 | 2022-05-31 10:28:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | inventarioalcaldia | listar_funcionarios | PROCEDURE | root@localhost | 2022-05-31 10:30:58 | 2022-05-31 10:30:58 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | +--------------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 2 rows in set (0.013 sec) MariaDB [inventarioalcaldia]> Call listar_funcionarios; +---------------+-----------------------+-----------+-----------+ | idfuncionario | nombre | genero | puesto | +---------------+-----------------------+-----------+-----------+ | 1000653947 | Carlos Perez | Masculino | Analista | | 10009033 | Santiago Echavarria | Masculino | Abogado | | 1001555983 | Sandra Jaramillo | Femenino | Contadora | | 23929494 | Daniela Torres | Femenino | Abogada | | 32218997 | Samuel Mu¤oz | Masculino | Abogado | | 46793423 | Maicol Hern ndez | Masculino | Abogado | | 48984934 | Maria Camila Gonzalez | Femenino | Auxiliar | | 65987905 | Catherine Lopez | Femenino | Analista | | 87947670 | Manuela Alvarez | Femenino | Auxiliar | | 96734744 | Luisa Maldonado | Femenino | Auxiliar | | 98838838 | Efrain Henao | Masculino | Analista | +---------------+-----------------------+-----------+-----------+ 11 rows in set (0.001 sec) Query OK, 0 rows affected (0.051 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure consultar_funcionarios(in _idfuncionario varchar(10)) -> Begin -> Select * from funcionarios where idfuncionario=_idfuncionario; -> End -> // Query OK, 0 rows affected (0.004 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> Show procedure status; +--------------------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +--------------------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | inventarioalcaldia | consultar_funcionarios | PROCEDURE | root@localhost | 2022-05-31 10:32:54 | 2022-05-31 10:32:54 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | inventarioalcaldia | insertar_funcionarios | PROCEDURE | root@localhost | 2022-05-31 10:28:46 | 2022-05-31 10:28:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | inventarioalcaldia | listar_funcionarios | PROCEDURE | root@localhost | 2022-05-31 10:30:58 | 2022-05-31 10:30:58 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | +--------------------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 3 rows in set (0.013 sec) MariaDB [inventarioalcaldia]> call consultar_funcionarios ('10009033'); +---------------+---------------------+-----------+---------+ | idfuncionario | nombre | genero | puesto | +---------------+---------------------+-----------+---------+ | 10009033 | Santiago Echavarria | Masculino | Abogado | +---------------+---------------------+-----------+---------+ 1 row in set (0.001 sec) Query OK, 0 rows affected (0.010 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure eliminar_funcionario(in _idfuncionario varchar(10)) -> Begin -> Delete from funcionarios where idfuncionario=_idfuncionario; -> End -> // Query OK, 0 rows affected (0.005 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> Show procedure status; +--------------------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +--------------------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | inventarioalcaldia | consultar_funcionarios | PROCEDURE | root@localhost | 2022-05-31 10:32:54 | 2022-05-31 10:32:54 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | inventarioalcaldia | eliminar_funcionario | PROCEDURE | root@localhost | 2022-05-31 10:35:22 | 2022-05-31 10:35:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | inventarioalcaldia | insertar_funcionarios | PROCEDURE | root@localhost | 2022-05-31 10:28:46 | 2022-05-31 10:28:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | inventarioalcaldia | listar_funcionarios | PROCEDURE | root@localhost | 2022-05-31 10:30:58 | 2022-05-31 10:30:58 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | +--------------------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 4 rows in set (0.014 sec) MariaDB [inventarioalcaldia]> call eliminar_funcionarios ('87947670'); ERROR 1305 (42000): PROCEDURE inventarioalcaldia.eliminar_funcionarios does not exist MariaDB [inventarioalcaldia]> call eliminar_funcionario('87947670'); Query OK, 1 row affected (0.003 sec) MariaDB [inventarioalcaldia]> Call listar_funcionarios; +---------------+-----------------------+-----------+-----------+ | idfuncionario | nombre | genero | puesto | +---------------+-----------------------+-----------+-----------+ | 1000653947 | Carlos Perez | Masculino | Analista | | 10009033 | Santiago Echavarria | Masculino | Abogado | | 1001555983 | Sandra Jaramillo | Femenino | Contadora | | 23929494 | Daniela Torres | Femenino | Abogada | | 32218997 | Samuel Mu¤oz | Masculino | Abogado | | 46793423 | Maicol Hern ndez | Masculino | Abogado | | 48984934 | Maria Camila Gonzalez | Femenino | Auxiliar | | 65987905 | Catherine Lopez | Femenino | Analista | | 96734744 | Luisa Maldonado | Femenino | Auxiliar | | 98838838 | Efrain Henao | Masculino | Analista | +---------------+-----------------------+-----------+-----------+ 10 rows in set (0.001 sec) Query OK, 0 rows affected (0.047 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure modificar_funcioario(in _idfuncionario varchar(10), in _nombre varchar(40), in _genero varchar(10), in _puesto varchar(30)) -> Begin -> Update funcionarios set nombre=_nombre, genero=_genero, puesto=_puesto where idfuncionario=_idfuncionario; -> End -> // Query OK, 0 rows affected (0.004 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> Show procedure status; +--------------------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +--------------------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | inventarioalcaldia | consultar_funcionarios | PROCEDURE | root@localhost | 2022-05-31 10:32:54 | 2022-05-31 10:32:54 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | inventarioalcaldia | eliminar_funcionario | PROCEDURE | root@localhost | 2022-05-31 10:35:22 | 2022-05-31 10:35:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | inventarioalcaldia | insertar_funcionarios | PROCEDURE | root@localhost | 2022-05-31 10:28:46 | 2022-05-31 10:28:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | inventarioalcaldia | listar_funcionarios | PROCEDURE | root@localhost | 2022-05-31 10:30:58 | 2022-05-31 10:30:58 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | inventarioalcaldia | modificar_funcioario | PROCEDURE | root@localhost | 2022-05-31 10:39:15 | 2022-05-31 10:39:15 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | +--------------------+------------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 5 rows in set (0.013 sec) MariaDB [inventarioalcaldia]> call modificar_funcioario ('96734744','Luisa Maldonado','Femenino','Analista'); Query OK, 1 row affected (0.003 sec) MariaDB [inventarioalcaldia]> Call listar_funcionarios; +---------------+-----------------------+-----------+-----------+ | idfuncionario | nombre | genero | puesto | +---------------+-----------------------+-----------+-----------+ | 1000653947 | Carlos Perez | Masculino | Analista | | 10009033 | Santiago Echavarria | Masculino | Abogado | | 1001555983 | Sandra Jaramillo | Femenino | Contadora | | 23929494 | Daniela Torres | Femenino | Abogada | | 32218997 | Samuel Mu¤oz | Masculino | Abogado | | 46793423 | Maicol Hern ndez | Masculino | Abogado | | 48984934 | Maria Camila Gonzalez | Femenino | Auxiliar | | 65987905 | Catherine Lopez | Femenino | Analista | | 96734744 | Luisa Maldonado | Femenino | Analista | | 98838838 | Efrain Henao | Masculino | Analista | +---------------+-----------------------+-----------+-----------+ 10 rows in set (0.001 sec) Query OK, 0 rows affected (0.052 sec) MariaDB [inventarioalcaldia]> Describe inventario; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | idobjeto | varchar(6) | NO | PRI | NULL | | | tipo | varchar(20) | NO | | NULL | | | marca | varchar(20) | NO | | NULL | | | estado | varchar(20) | NO | | NULL | | +----------+-------------+------+-----+---------+-------+ 4 rows in set (0.014 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure insertar_objetos(in _idobjeto varchar(6), in _tipo varchar(20), in _marca varchar(20), in _estado varchar(20)) -> Begin -> Insert into inventario values(_idobjeto,_tipo,_marca,_estado); -> End -> // Query OK, 0 rows affected (0.006 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> Call insertar_objetos('D00002','Diadema','Poly','Bueno'); Query OK, 1 row affected (0.002 sec) MariaDB [inventarioalcaldia]> select * from inventario; +----------+----------+-----------+-----------+ | idobjeto | tipo | marca | estado | +----------+----------+-----------+-----------+ | D00001 | Diadema | Poly | Excelente | | D00002 | Diadema | Poly | Bueno | | P00001 | Portatil | Lenovo | Bueno | | P00002 | Portatil | Asus | Regular | | P00003 | Portatil | Hp | Excelente | | S00001 | Silla | boxbit | Bueno | | S00002 | Silla | boxbit | Excelente | | S00003 | Silla | boxbit | Bueno | | T00001 | Telefono | Panasonic | Excelente | | T00002 | Telefono | Orange | Excelente | | T00003 | Telefono | Alcatel | Bueno | +----------+----------+-----------+-----------+ 11 rows in set (0.000 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure listar_objetos() -> Begin -> Select * from inventario; -> End -> // Query OK, 0 rows affected (0.003 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> Call listar_objetos; +----------+----------+-----------+-----------+ | idobjeto | tipo | marca | estado | +----------+----------+-----------+-----------+ | D00001 | Diadema | Poly | Excelente | | D00002 | Diadema | Poly | Bueno | | P00001 | Portatil | Lenovo | Bueno | | P00002 | Portatil | Asus | Regular | | P00003 | Portatil | Hp | Excelente | | S00001 | Silla | boxbit | Bueno | | S00002 | Silla | boxbit | Excelente | | S00003 | Silla | boxbit | Bueno | | T00001 | Telefono | Panasonic | Excelente | | T00002 | Telefono | Orange | Excelente | | T00003 | Telefono | Alcatel | Bueno | +----------+----------+-----------+-----------+ 11 rows in set (0.001 sec) Query OK, 0 rows affected (0.043 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure consultar_objetos(in _idobjeto varchar(6)) -> Begin -> Select * from inventario where idobjeto=_idobjeto; -> End -> // Query OK, 0 rows affected (0.004 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> MariaDB [inventarioalcaldia]> call consultar_objetos ('D00001'); +----------+---------+-------+-----------+ | idobjeto | tipo | marca | estado | +----------+---------+-------+-----------+ | D00001 | Diadema | Poly | Excelente | +----------+---------+-------+-----------+ 1 row in set (0.001 sec) Query OK, 0 rows affected (0.012 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure eliminar_objeto(in _idobjeto varchar(6)) -> Begin -> Delete from inventario where idobjeto =_idobjeto; -> End -> // Query OK, 0 rows affected (0.004 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> call eliminar_objeto('S00001'); Query OK, 1 row affected (0.002 sec) MariaDB [inventarioalcaldia]> call consultar_objetos ('S00001'); Empty set (0.001 sec) Query OK, 0 rows affected (0.002 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure modificar_objeto(in _idobjeto varchar(6), in _tipo varchar(20), in _marca varchar(20), in _estado varchar(20)) -> Begin -> Update inventario set tipo=_tipo, marca=_marca, estado=_estado where idobjeto=_idobjeto; -> End -> // Query OK, 0 rows affected (0.003 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> call modificar_objeto ('D00002','Diadema','Poly','Excelente'); Query OK, 1 row affected (0.002 sec) MariaDB [inventarioalcaldia]> Call listar_objetos; +----------+----------+-----------+-----------+ | idobjeto | tipo | marca | estado | +----------+----------+-----------+-----------+ | D00001 | Diadema | Poly | Excelente | | D00002 | Diadema | Poly | Excelente | | P00001 | Portatil | Lenovo | Bueno | | P00002 | Portatil | Asus | Regular | | P00003 | Portatil | Hp | Excelente | | S00002 | Silla | boxbit | Excelente | | S00003 | Silla | boxbit | Bueno | | T00001 | Telefono | Panasonic | Excelente | | T00002 | Telefono | Orange | Excelente | | T00003 | Telefono | Alcatel | Bueno | +----------+----------+-----------+-----------+ 10 rows in set (0.001 sec) Query OK, 0 rows affected (0.036 sec) MariaDB [inventarioalcaldia]> describe proveedor; ERROR 1146 (42S02): Table 'inventarioalcaldia.proveedor' doesn't exist MariaDB [inventarioalcaldia]> describe proveedores; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | idproveedor | varchar(9) | NO | PRI | NULL | | | nombre | varchar(40) | NO | | NULL | | | descripcion | varchar(40) | NO | | NULL | | | estado | varchar(8) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 4 rows in set (0.014 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure insertar_proveedor(in _idproveedor varchar(9), in _nombre varchar(40), in _descripcion varchar(40), in _estado varchar(8)) -> Begin -> Insert into proveedores values(_idproveedor,_nombre,_descripcion,_estado); -> End -> // Query OK, 0 rows affected (0.004 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> Call insertar_proveedor('900980111','Sillas Baldar','Sillas con 100% de durabilidad ','Inactivo'); Query OK, 1 row affected (0.002 sec) MariaDB [inventarioalcaldia]> select * proveedores; 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 'proveedores' at line 1 MariaDB [inventarioalcaldia]> select * from proveedores; +-------------+------------------------------------+------------------------------------------+----------+ | idproveedor | nombre | descripcion | estado | +-------------+------------------------------------+------------------------------------------+----------+ | 900100200 | Electronics Masters | Venta de computadores y accesorios | Activo | | 900300200 | Telefonos Alpha SAS | Venta de telefonos de oficina garantizad | Inactivo | | 900400500 | Accesorios de comunicacion Bet SAS | Audifonos, diademas,microfonos | Activo | | 900800700 | Distribuidor de Sillas Magic | Venta de sillas de oficinas economicas y | Activo | | 900980111 | Sillas Baldar | Sillas con 100% de durabilidad | Inactivo | +-------------+------------------------------------+------------------------------------------+----------+ 5 rows in set (0.000 sec) MariaDB [inventarioalcaldia]> MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure listar_proveedores() -> Begin -> Select * from proveedores; -> End -> // Query OK, 0 rows affected (0.004 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> Call listar_proveedores; +-------------+------------------------------------+------------------------------------------+----------+ | idproveedor | nombre | descripcion | estado | +-------------+------------------------------------+------------------------------------------+----------+ | 900100200 | Electronics Masters | Venta de computadores y accesorios | Activo | | 900300200 | Telefonos Alpha SAS | Venta de telefonos de oficina garantizad | Inactivo | | 900400500 | Accesorios de comunicacion Bet SAS | Audifonos, diademas,microfonos | Activo | | 900800700 | Distribuidor de Sillas Magic | Venta de sillas de oficinas economicas y | Activo | | 900980111 | Sillas Baldar | Sillas con 100% de durabilidad | Inactivo | +-------------+------------------------------------+------------------------------------------+----------+ 5 rows in set (0.001 sec) Query OK, 0 rows affected (0.040 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure consultar_proveedor(in _idproveedor varchar(9)) -> Begin -> Select * from proveedores where idproveedor=_idproveedor; -> End -> // Query OK, 0 rows affected (0.015 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> call consultar_proveedor ('900980111'); +-------------+---------------+---------------------------------+----------+ | idproveedor | nombre | descripcion | estado | +-------------+---------------+---------------------------------+----------+ | 900980111 | Sillas Baldar | Sillas con 100% de durabilidad | Inactivo | +-------------+---------------+---------------------------------+----------+ 1 row in set (0.001 sec) Query OK, 0 rows affected (0.011 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure eliminar_proveedor(in _idproveedor varchar(9)) -> Begin -> Delete from proveedores where idproveedor=_idproveedor; -> End -> // Query OK, 0 rows affected (0.005 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> call eliminar_proveedor('900980111'); Query OK, 1 row affected (0.002 sec) MariaDB [inventarioalcaldia]> Call listar_proveedores; +-------------+------------------------------------+------------------------------------------+----------+ | idproveedor | nombre | descripcion | estado | +-------------+------------------------------------+------------------------------------------+----------+ | 900100200 | Electronics Masters | Venta de computadores y accesorios | Activo | | 900300200 | Telefonos Alpha SAS | Venta de telefonos de oficina garantizad | Inactivo | | 900400500 | Accesorios de comunicacion Bet SAS | Audifonos, diademas,microfonos | Activo | | 900800700 | Distribuidor de Sillas Magic | Venta de sillas de oficinas economicas y | Activo | +-------------+------------------------------------+------------------------------------------+----------+ 4 rows in set (0.001 sec) Query OK, 0 rows affected (0.033 sec) MariaDB [inventarioalcaldia]> Delimiter // MariaDB [inventarioalcaldia]> Create procedure modificar_proveedor(in _idproveedor varchar(9), in _nombre varchar(40), in _descripcion varchar(40), in _estado varchar(8)) -> Begin -> Update proveedores set nombre=_nombre, descripcion=_descripcion, estado=_estado where idproveedor=_idproveedor; -> End -> // Query OK, 0 rows affected (0.004 sec) MariaDB [inventarioalcaldia]> Delimiter ; MariaDB [inventarioalcaldia]> Call listar_proveedores; +-------------+------------------------------------+------------------------------------------+----------+ | idproveedor | nombre | descripcion | estado | +-------------+------------------------------------+------------------------------------------+----------+ | 900100200 | Electronics Masters | Venta de computadores y accesorios | Activo | | 900300200 | Telefonos Alpha SAS | Venta de telefonos de oficina garantizad | Inactivo | | 900400500 | Accesorios de comunicacion Bet SAS | Audifonos, diademas,microfonos | Activo | | 900800700 | Distribuidor de Sillas Magic | Venta de sillas de oficinas economicas y | Activo | +-------------+------------------------------------+------------------------------------------+----------+ 4 rows in set (0.000 sec) Query OK, 0 rows affected (0.029 sec) MariaDB [inventarioalcaldia]> call modificar_proveedor ('900100200','Electronics Masters PROS','Venta de computadores y accesorios','Activo'); Query OK, 1 row affected (0.002 sec) MariaDB [inventarioalcaldia]> Call listar_proveedores; +-------------+------------------------------------+------------------------------------------+----------+ | idproveedor | nombre | descripcion | estado | +-------------+------------------------------------+------------------------------------------+----------+ | 900100200 | Electronics Masters PROS | Venta de computadores y accesorios | Activo | | 900300200 | Telefonos Alpha SAS | Venta de telefonos de oficina garantizad | Inactivo | | 900400500 | Accesorios de comunicacion Bet SAS | Audifonos, diademas,microfonos | Activo | | 900800700 | Distribuidor de Sillas Magic | Venta de sillas de oficinas economicas y | Activo | +-------------+------------------------------------+------------------------------------------+----------+ 4 rows in set (0.000 sec) Query OK, 0 rows affected (0.033 sec) MariaDB [inventarioalcaldia]> exit