MariaDB [matricula]> describe estudienate; ERROR 1146 (42S02): Table 'matricula.estudienate' doesn't exist MariaDB [matricula]> describe alumno; +--------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+----------+------+-----+---------+-------+ | carnet | char(10) | NO | PRI | NULL | | | nombre | char(40) | NO | | NULL | | | estado | char(10) | NO | | NULL | | +--------+----------+------+-----+---------+-------+ 3 rows in set (0.025 sec) MariaDB [matricula]> Delimiter // MariaDB [matricula]> Create procedure insertar_alumno(in _carnet char(10), in _nombre char(40), in _estado char(10)) -> begin -> insert into alumno values(_carnet, _nombre, _estado); -> end -> // Query OK, 0 rows affected (0.036 sec) MariaDB [matricula]> delimiter ; MariaDB [matricula]> show procedure status; +-----------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-----------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | matricula | insertar_alumno | PROCEDURE | root@localhost | 2024-11-01 23:51:13 | 2024-11-01 23:51:13 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | +-----------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 1 row in set (0.018 sec) MariaDB [matricula]> show create procedure insertar_alumno; +-----------------+-----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +-----------------+-----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | insertar_alumno | NO_AUTO_VALUE_ON_ZERO | CREATE DEFINER=`root`@`localhost` PROCEDURE `insertar_alumno`(in _carnet char(10), in _nombre char(40), in _estado char(10)) begin insert into alumno values(_carnet, _nombre, _estado); end | utf8 | utf8_general_ci | latin1_swedish_ci | +-----------------+-----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.001 sec) MariaDB [matricula]> select * from alumno; +-----------+-----------------------+----------+ | carnet | nombre | estado | +-----------+-----------------------+----------+ | 1000 | gloria | activo | | 112121545 | kelly ruiz | inactivo | | 2000 | jose miguel jaramillo | activo | | 3000 | luna | activo | | dsfds | sdfsdf | Activo | +-----------+-----------------------+----------+ 5 rows in set (0.001 sec) MariaDB [matricula]> Call insertar_alumno("012", "sofia", "Activo"); Query OK, 1 row affected (0.003 sec) MariaDB [matricula]> select * from alumno; +-----------+-----------------------+----------+ | carnet | nombre | estado | +-----------+-----------------------+----------+ | 012 | sofia | Activo | | 1000 | gloria | activo | | 112121545 | kelly ruiz | inactivo | | 2000 | jose miguel jaramillo | activo | | 3000 | luna | activo | | dsfds | sdfsdf | Activo | +-----------+-----------------------+----------+ 6 rows in set (0.001 sec) MariaDB [matricula]> select * from materia; +--------+-------------+--------+ | codigo | nombre | estado | +--------+-------------+--------+ | 100 | matematicas | | | 200 | humanidades | | +--------+-------------+--------+ 2 rows in set (0.003 sec) MariaDB [matricula]> Delimiter // MariaDB [matricula]> Create procedure listar() -> Begin -> Select * from alumno; -> End -> // Query OK, 0 rows affected (0.004 sec) MariaDB [matricula]> Delimiter ; MariaDB [matricula]> show procedure status; +-----------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-----------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | matricula | insertar_alumno | PROCEDURE | root@localhost | 2024-11-01 23:51:13 | 2024-11-01 23:51:13 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | listar | PROCEDURE | root@localhost | 2024-11-02 00:09:46 | 2024-11-02 00:09:46 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | +-----------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 2 rows in set (0.015 sec) MariaDB [matricula]> show create procedure listar; +-----------+-----------------------+----------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +-----------+-----------------------+----------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | listar | NO_AUTO_VALUE_ON_ZERO | CREATE DEFINER=`root`@`localhost` PROCEDURE `listar`() Begin Select * from alumno; End | utf8 | utf8_general_ci | latin1_swedish_ci | +-----------+-----------------------+----------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.001 sec) MariaDB [matricula]> call listar(); +-----------+-----------------------+----------+ | carnet | nombre | estado | +-----------+-----------------------+----------+ | 012 | sofia | Activo | | 1000 | gloria | activo | | 112121545 | kelly ruiz | inactivo | | 2000 | jose miguel jaramillo | activo | | 3000 | luna | activo | | dsfds | sdfsdf | Activo | +-----------+-----------------------+----------+ 6 rows in set (0.001 sec) Query OK, 0 rows affected (0.018 sec) MariaDB [matricula]> Delimiter // MariaDB [matricula]> Create procedure cons_alumno(in _carnet char(10)) -> Begin -> Select *from alumno where carnet=_carnet; -> End -> // Query OK, 0 rows affected (0.005 sec) MariaDB [matricula]> Delimiter ; MariaDB [matricula]> show procedure status; +-----------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-----------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | matricula | cons_alumno | PROCEDURE | root@localhost | 2024-11-02 00:16:09 | 2024-11-02 00:16:09 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_alumno | PROCEDURE | root@localhost | 2024-11-01 23:51:13 | 2024-11-01 23:51:13 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | listar | PROCEDURE | root@localhost | 2024-11-02 00:09:46 | 2024-11-02 00:09:46 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | +-----------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 3 rows in set (0.021 sec) MariaDB [matricula]> call cons_alumno("012"); +--------+--------+--------+ | carnet | nombre | estado | +--------+--------+--------+ | 012 | sofia | Activo | +--------+--------+--------+ 1 row in set (0.001 sec) Query OK, 0 rows affected (0.005 sec) MariaDB [matricula]> Delimiter // MariaDB [matricula]> Create procedure eliminar_alumno(in _carnet char(10)) -> Begin -> Delete from alumno where carnet=_carnet; -> End -> // Query OK, 0 rows affected (0.005 sec) MariaDB [matricula]> Delimiter ; MariaDB [matricula]> call eliminar_alumno("012"); Query OK, 1 row affected (0.004 sec) MariaDB [matricula]> select * from alumno; +-----------+-----------------------+----------+ | carnet | nombre | estado | +-----------+-----------------------+----------+ | 1000 | gloria | activo | | 112121545 | kelly ruiz | inactivo | | 2000 | jose miguel jaramillo | activo | | 3000 | luna | activo | | dsfds | sdfsdf | Activo | +-----------+-----------------------+----------+ 5 rows in set (0.001 sec) MariaDB [matricula]> Delimiter // MariaDB [matricula]> Create procedure modificar_alumno(in _carnet char(10), in _nombre char(40)) -> Begin -> Update alumno set nombre=_nombre where carnet=_carnet; -> End -> // Query OK, 0 rows affected (0.005 sec) MariaDB [matricula]> Delimiter ; MariaDB [matricula]> show procedure status; +-----------+------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-----------+------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | matricula | cons_alumno | PROCEDURE | root@localhost | 2024-11-02 00:16:09 | 2024-11-02 00:16:09 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | eliminar_alumno | PROCEDURE | root@localhost | 2024-11-02 00:21:08 | 2024-11-02 00:21:08 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_alumno | PROCEDURE | root@localhost | 2024-11-01 23:51:13 | 2024-11-01 23:51:13 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | listar | PROCEDURE | root@localhost | 2024-11-02 00:09:46 | 2024-11-02 00:09:46 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | modificar_alumno | PROCEDURE | root@localhost | 2024-11-02 00:25:51 | 2024-11-02 00:25:51 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | +-----------+------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 5 rows in set (0.019 sec) MariaDB [matricula]> call modificar_alumno("1000", "pepe"); Query OK, 1 row affected (0.004 sec) MariaDB [matricula]> select * from alumno; +-----------+-----------------------+----------+ | carnet | nombre | estado | +-----------+-----------------------+----------+ | 1000 | pepe | activo | | 112121545 | kelly ruiz | inactivo | | 2000 | jose miguel jaramillo | activo | | 3000 | luna | activo | | dsfds | sdfsdf | Activo | +-----------+-----------------------+----------+ 5 rows in set (0.000 sec) MariaDB [matricula]> call modificar_alumno('0001','Juan Pablo rava'); Query OK, 0 rows affected (0.001 sec) MariaDB [matricula]> select * from alumno; +-----------+-----------------------+----------+ | carnet | nombre | estado | +-----------+-----------------------+----------+ | 1000 | pepe | activo | | 112121545 | kelly ruiz | inactivo | | 2000 | jose miguel jaramillo | activo | | 3000 | luna | activo | | dsfds | sdfsdf | Activo | +-----------+-----------------------+----------+ 5 rows in set (0.001 sec) MariaDB [matricula]> call modificar_alumno('1000','Juan Pablo rava'); Query OK, 1 row affected (0.003 sec) MariaDB [matricula]> select * from alumno; +-----------+-----------------------+----------+ | carnet | nombre | estado | +-----------+-----------------------+----------+ | 1000 | Juan Pablo rava | activo | | 112121545 | kelly ruiz | inactivo | | 2000 | jose miguel jaramillo | activo | | 3000 | luna | activo | | dsfds | sdfsdf | Activo | +-----------+-----------------------+----------+ 5 rows in set (0.001 sec)