MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 5 rows in set (0.001 sec) MariaDB [(none)]> create database Hospital; Query OK, 1 row affected (0.002 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | hospital | | information_schema | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 6 rows in set (0.001 sec) MariaDB [(none)]> use hispital; ERROR 1049 (42000): Unknown database 'hispital' MariaDB [(none)]> use hospital; Database changed MariaDB [hospital]> CREATE TABLE Pacientes ( -> id_paciente INT PRIMARY KEY AUTO_INCREMENT, -> nombre VARCHAR(100) NOT NULL, -> fecha_nacimiento DATE NOT NULL, -> genero CHAR(1) NOT NULL, -> telefono VARCHAR(15), -> direccion VARCHAR(200) -> ); Query OK, 0 rows affected (0.013 sec) MariaDB [hospital]> DROP TABLE Pacientes; Query OK, 0 rows affected (0.050 sec) MariaDB [hospital]> CREATE TABLE Pacientes ( -> id_paciente Varchar(45) not null PRIMARY KEY, -> nombre VARCHAR(45) NOT NULL, -> genero VARCHAR(45) NOT NULL, -> telefono VARCHAR(45) NOT NULL, -> Email VARCHAR(45) NOT NULL); Query OK, 0 rows affected (0.025 sec) MariaDB [hospital]> describe pacientes; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | id_paciente | varchar(45) | NO | PRI | NULL | | | nombre | varchar(45) | NO | | NULL | | | genero | varchar(45) | NO | | NULL | | | telefono | varchar(45) | NO | | NULL | | | Email | varchar(45) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 5 rows in set (0.019 sec) MariaDB [hospital]> CREATE TABLE Medicos ( -> id_medico Varchar(45) not null PRIMARY KEY, -> nombre VARCHAR(45) NOT NULL, -> especialidad VARCHAR(45) NOT NULL, -> telefono VARCHAR(45) NOT NULL, -> Email VARCHAR(45) NOT NULL); Query OK, 0 rows affected (0.014 sec) MariaDB [hospital]> describe MEDICOS; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | id_medico | varchar(45) | NO | PRI | NULL | | | nombre | varchar(45) | NO | | NULL | | | especialidad | varchar(45) | NO | | NULL | | | telefono | varchar(45) | NO | | NULL | | | Email | varchar(45) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 5 rows in set (0.009 sec) MariaDB [hospital]> CREATE TABLE Plantas ( -> id_planta Varchar(45) not null PRIMARY KEY, -> nombre_planta VARCHAR(45) NOT NULL); Query OK, 0 rows affected (0.015 sec) MariaDB [hospital]> describe plantas; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | id_planta | varchar(45) | NO | PRI | NULL | | | nombre_planta | varchar(45) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 2 rows in set (0.011 sec) MariaDB [hospital]> CREATE TABLE Ingresos ( -> id_ingreso Varchar(45) not null PRIMARY KEY, -> fecha_ingreso VARCHAR(45) NOT NULL, -> fecha_alta VARCHAR(45) NOT NULL, -> FK_paciente varchar(45) not null, -> FK_planta varchar(45) not null, -> foreign key(FK_paciente) references pacientes(id_paciente) on delete cascade on update cascade, -> foreign key(FK_planta) references plantasCtrl-C -- exit!n delete casc Bye on update cascade, C:\xampp\mysql\bin>mysql -uroot -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.4.32-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> Use hospital; Database changed MariaDB [hospital]> decribe plantas; 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 'decribe plantas' at line 1 MariaDB [hospital]> describe plantas; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | id_planta | varchar(45) | NO | PRI | NULL | | | nombre_planta | varchar(45) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 2 rows in set (0.014 sec) MariaDB [hospital]> CREATE TABLE Ingresos ( -> -> id_ingreso Varchar(45) not null PRIMARY KEY, -> -> fecha_ingreso VARCHAR(45) NOT NULL, -> -> fecha_alta VARCHAR(45) NOT NULL, -> -> FK_paciente varchar(45) not null, -> -> FK_planta varchar(45) not null, -> -> foreign key(FK_paciente) references pacientes(id_paciente) on delete -> cascade on update cascade,, -> ; 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_ingreso Varchar(45) not null PRIMARY KEY, -> fecha_ingreso VARCHAR...' at line 2 MariaDB [hospital]> CREATE TABLE Ingresos ( -> id_ingreso Varchar(45) not null PRIMARY KEY, -> fecha_ingreso VARCHAR(45) NOT NULL, -> fecha_alta VARCHAR(45) NOT NULL, -> FK_paciente varchar(45) not null, -> FK_planta varchar(45) not null, -> foreign key(FK_paciente) references pacientes(id_paciente) on delete cascade on update cascade, -> foreign key(FK_planta) references plantas(id_planta) on delete cascad e on update cascade); Query OK, 0 rows affected (0.031 sec) MariaDB [hospital]> describe ingresos; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | id_ingreso | varchar(45) | NO | PRI | NULL | | | fecha_ingreso | varchar(45) | NO | | NULL | | | fecha_alta | varchar(45) | NO | | NULL | | | FK_paciente | varchar(45) | NO | MUL | NULL | | | FK_planta | varchar(45) | NO | MUL | NULL | | +---------------+-------------+------+-----+---------+-------+ 5 rows in set (0.011 sec) MariaDB [hospital]> CREATE TABLE Asignaciones_Medicos ( -> id_asignacion Varchar(45) not null PRIMARY KEY, -> fecha_asignacion VARCHAR(45) NOT NULL, -> FK_ingreso varchar(45) not null, -> FK_medico varchar(45) not null, -> foreign key(FK_ingreso) references ingresos(id_ingreso) on delete cas cade on update cascade, -> foreign key(FK_medico) references medicos(id_medico) on delete cascad e on update cascade); Query OK, 0 rows affected (0.031 sec) MariaDB [hospital]> describe Asignaciones_Medicos; +------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+---------+-------+ | id_asignacion | varchar(45) | NO | PRI | NULL | | | fecha_asignacion | varchar(45) | NO | | NULL | | | FK_ingreso | varchar(45) | NO | MUL | NULL | | | FK_medico | varchar(45) | NO | MUL | NULL | | +------------------+-------------+------+-----+---------+-------+ 4 rows in set (0.013 sec) MariaDB [hospital]> INSERT INTO Pacientes (id_paciente, nombre, genero, telefono, Email) VALUES -> ('P001', 'Juan Perez', 'M', '1234567890', 'juan.perez@example.com'), -> ('P002', 'Maria Lopez', 'F', '0987654321', 'maria.lopez@example.com'), -> ('P003', 'Carlos Sanchez', 'M', '1122334455', 'carlos.sanchez@example.com'), -> ('P004', 'Ana Martinez', 'F', '5566778899', 'ana.martinez@example.com'), -> ('P005', 'Luis Garcia', 'M', '9988776655', 'luis.garcia@example.com'), -> ('P006', 'Sofia Fernandez', 'F', '4433221100', 'sofia.fernandez@example.com'), -> ('P007', 'Pedro Ramirez', 'M', '6677889900', 'pedro.ramirez@example.com'), -> ('P008', 'Laura Diaz', 'F', '3344556677', 'laura.diaz@example.com'), -> ('P009', 'Jorge Ruiz', 'M', '7788990011', 'jorge.ruiz@example.com'), -> ('P010', 'Carmen Torres', 'F', '9900112233', 'carmen.torres@example.com'); Query OK, 10 rows affected (0.005 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [hospital]> Select * from Pacientes; +-------------+-----------------+--------+------------+-----------------------------+ | id_paciente | nombre | genero | telefono | Email | +-------------+-----------------+--------+------------+-----------------------------+ | P001 | Juan Perez | M | 1234567890 | juan.perez@example.com | | P002 | Maria Lopez | F | 0987654321 | maria.lopez@example.com | | P003 | Carlos Sanchez | M | 1122334455 | carlos.sanchez@example.com | | P004 | Ana Martinez | F | 5566778899 | ana.martinez@example.com | | P005 | Luis Garcia | M | 9988776655 | luis.garcia@example.com | | P006 | Sofia Fernandez | F | 4433221100 | sofia.fernandez@example.com | | P007 | Pedro Ramirez | M | 6677889900 | pedro.ramirez@example.com | | P008 | Laura Diaz | F | 3344556677 | laura.diaz@example.com | | P009 | Jorge Ruiz | M | 7788990011 | jorge.ruiz@example.com | | P010 | Carmen Torres | F | 9900112233 | carmen.torres@example.com | +-------------+-----------------+--------+------------+-----------------------------+ 10 rows in set (0.001 sec) MariaDB [hospital]> INSERT INTO Medicos (id_medico, nombre, especialidad, telefono, Email) VALUES -> ('M001', 'Dr. Alejandro Gomez', 'Cardiologia', '1234567890', 'alejandro.gomez@example.com'), -> ('M002', 'Dra. Sofia Hernandez', 'Pediatria', '0987654321', 'sofia.hernandez@example.com'), -> ('M003', 'Dr. Luis Martinez', 'Cirugia', '1122334455', 'luis.martinez@example.com'), -> ('M004', 'Dra. Ana Lopez', 'Dermatologia', '5566778899', 'ana.lopez@example.com'), -> ('M005', 'Dr. Carlos Diaz', 'Ortopedia', '9988776655', 'carlos.diaz@example.com'), -> ('M006', 'Dra. Maria Ruiz', 'Ginecologia', '4433221100', 'maria.ruiz@example.com'), -> ('M007', 'Dr. Pedro Sanchez', 'Neurologia', '6677889900', 'pedro.sanchez@example.com'), -> ('M008', 'Dra. Laura Fernandez', 'Oncologia', '3344556677', 'laura.fernandez@example.com'), -> ('M009', 'Dr. Jorge Torres', 'Psiquiatria', '7788990011', 'jorge.torres@example.com'), -> ('M010', 'Dra. Carmen Garcia', 'Endocrinologia', '9900112233', 'carmen.garcia@example.com'); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [hospital]> Select * from medicos; +-----------+----------------------+----------------+------------+-----------------------------+ | id_medico | nombre | especialidad | telefono | Email | +-----------+----------------------+----------------+------------+-----------------------------+ | M001 | Dr. Alejandro Gomez | Cardiologia | 1234567890 | alejandro.gomez@example.com | | M002 | Dra. Sofia Hernandez | Pediatria | 0987654321 | sofia.hernandez@example.com | | M003 | Dr. Luis Martinez | Cirugia | 1122334455 | luis.martinez@example.com | | M004 | Dra. Ana Lopez | Dermatologia | 5566778899 | ana.lopez@example.com | | M005 | Dr. Carlos Diaz | Ortopedia | 9988776655 | carlos.diaz@example.com | | M006 | Dra. Maria Ruiz | Ginecologia | 4433221100 | maria.ruiz@example.com | | M007 | Dr. Pedro Sanchez | Neurologia | 6677889900 | pedro.sanchez@example.com | | M008 | Dra. Laura Fernandez | Oncologia | 3344556677 | laura.fernandez@example.com | | M009 | Dr. Jorge Torres | Psiquiatria | 7788990011 | jorge.torres@example.com | | M010 | Dra. Carmen Garcia | Endocrinologia | 9900112233 | carmen.garcia@example.com | +-----------+----------------------+----------------+------------+-----------------------------+ 10 rows in set (0.000 sec) MariaDB [hospital]> INSERT INTO Plantas (id_planta, nombre_planta) VALUES -> ('PL001', 'Planta 1 - Cardiologia'), -> ('PL002', 'Planta 2 - Pediatria'), -> ('PL003', 'Planta 3 - Cirugia'), -> ('PL004', 'Planta 4 - Dermatologia'), -> ('PL005', 'Planta 5 - Ortopedia'), -> ('PL006', 'Planta 6 - Ginecologia'), -> ('PL007', 'Planta 7 - Neurologia'), -> ('PL008', 'Planta 8 - Oncologia'), -> ('PL009', 'Planta 9 - Psiquiatria'), -> ('PL010', 'Planta 10 - Endocrinologia'); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [hospital]> select * from plantas; +-----------+----------------------------+ | id_planta | nombre_planta | +-----------+----------------------------+ | PL001 | Planta 1 - Cardiologia | | PL002 | Planta 2 - Pediatria | | PL003 | Planta 3 - Cirugia | | PL004 | Planta 4 - Dermatologia | | PL005 | Planta 5 - Ortopedia | | PL006 | Planta 6 - Ginecologia | | PL007 | Planta 7 - Neurologia | | PL008 | Planta 8 - Oncologia | | PL009 | Planta 9 - Psiquiatria | | PL010 | Planta 10 - Endocrinologia | +-----------+----------------------------+ 10 rows in set (0.000 sec) MariaDB [hospital]> INSERT INTO Ingresos (id_ingreso, fecha_ingreso, fecha_alta, FK_paciente, FK_planta) VALUES -> ('I001', '2023-01-01', '2023-01-10', 'P001', 'PL001'), -> ('I002', '2023-02-01', '2023-02-10', 'P002', 'PL002'), -> ('I003', '2023-03-01', '2023-03-10', 'P003', 'PL003'), -> ('I004', '2023-04-01', '2023-04-10', 'P004', 'PL004'), -> ('I005', '2023-05-01', '2023-05-10', 'P005', 'PL005'), -> ('I006', '2023-06-01', '2023-06-10', 'P006', 'PL006'), -> ('I007', '2023-07-01', '2023-07-10', 'P007', 'PL007'), -> ('I008', '2023-08-01', '2023-08-10', 'P008', 'PL008'), -> ('I009', '2023-09-01', '2023-09-10', 'P009', 'PL009'), -> ('I010', '2023-10-01', '2023-10-10', 'P010', 'PL010'); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [hospital]> select * from ingresos; +------------+---------------+------------+-------------+-----------+ | id_ingreso | fecha_ingreso | fecha_alta | FK_paciente | FK_planta | +------------+---------------+------------+-------------+-----------+ | I001 | 2023-01-01 | 2023-01-10 | P001 | PL001 | | I002 | 2023-02-01 | 2023-02-10 | P002 | PL002 | | I003 | 2023-03-01 | 2023-03-10 | P003 | PL003 | | I004 | 2023-04-01 | 2023-04-10 | P004 | PL004 | | I005 | 2023-05-01 | 2023-05-10 | P005 | PL005 | | I006 | 2023-06-01 | 2023-06-10 | P006 | PL006 | | I007 | 2023-07-01 | 2023-07-10 | P007 | PL007 | | I008 | 2023-08-01 | 2023-08-10 | P008 | PL008 | | I009 | 2023-09-01 | 2023-09-10 | P009 | PL009 | | I010 | 2023-10-01 | 2023-10-10 | P010 | PL010 | +------------+---------------+------------+-------------+-----------+ 10 rows in set (0.000 sec) MariaDB [hospital]> INSERT INTO Asignaciones_Medicos (id_asignacion, fecha_asignacion, FK_ingreso, FK_medico) VALUES -> ('A001', '2023-01-01', 'I001', 'M001'), -> ('A002', '2023-02-01', 'I002', 'M002'), -> ('A003', '2023-03-01', 'I003', 'M003'), -> ('A004', '2023-04-01', 'I004', 'M004'), -> ('A005', '2023-05-01', 'I005', 'M005'), -> ('A006', '2023-06-01', 'I006', 'M006'), -> ('A007', '2023-07-01', 'I007', 'M007'), -> ('A008', '2023-08-01', 'I008', 'M008'), -> ('A009', '2023-09-01', 'I009', 'M009'), -> ('A010', '2023-10-01', 'I010', 'M010'); Query OK, 10 rows affected (0.005 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [hospital]> select * from Asignaciones_Medicos; +---------------+------------------+------------+-----------+ | id_asignacion | fecha_asignacion | FK_ingreso | FK_medico | +---------------+------------------+------------+-----------+ | A001 | 2023-01-01 | I001 | M001 | | A002 | 2023-02-01 | I002 | M002 | | A003 | 2023-03-01 | I003 | M003 | | A004 | 2023-04-01 | I004 | M004 | | A005 | 2023-05-01 | I005 | M005 | | A006 | 2023-06-01 | I006 | M006 | | A007 | 2023-07-01 | I007 | M007 | | A008 | 2023-08-01 | I008 | M008 | | A009 | 2023-09-01 | I009 | M009 | | A010 | 2023-10-01 | I010 | M010 | +---------------+------------------+------------+-----------+ 10 rows in set (0.000 sec) MariaDB [hospital]> Delimiter // MariaDB [hospital]> Create procedure listar_paciente() -> Begin -> select * from Pacientes; -> end -> // Query OK, 0 rows affected (0.020 sec) MariaDB [hospital]> Delimiter; -> ; -> 9; -> use -> Ctrl-C -- exit! Bye C:\xampp\mysql\bin>use hospital; "use" no se reconoce como un comando interno o externo, programa o archivo por lotes ejecutable. C:\xampp\mysql\bin>mysql -uroot -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 10 Server version: 10.4.32-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use hospital; Database changed MariaDB [hospital]> DELIMITER // MariaDB [hospital]> MariaDB [hospital]> CREATE PROCEDURE ListarPacientes() -> BEGIN -> SELECT * FROM Pacientes; -> END // Query OK, 0 rows affected (0.005 sec) MariaDB [hospital]> MariaDB [hospital]> DELIMITER ; MariaDB [hospital]> show procedure status; +----------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +----------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | hospital | ListarPacientes | PROCEDURE | root@localhost | 2025-02-20 15:21:25 | 2025-02-20 15:21:25 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | | hospital | listar_paciente | PROCEDURE | root@localhost | 2025-02-20 15:15:59 | 2025-02-20 15:15:59 | DEFINER | | cp850 | cp850_general_ci | utf8mb4_general_ci | +----------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 2 rows in set (0.012 sec) MariaDB [hospital]> call ListarPacientes; +-------------+-----------------+--------+------------+-----------------------------+ | id_paciente | nombre | genero | telefono | Email | +-------------+-----------------+--------+------------+-----------------------------+ | P001 | Juan Perez | M | 1234567890 | juan.perez@example.com | | P002 | Maria Lopez | F | 0987654321 | maria.lopez@example.com | | P003 | Carlos Sanchez | M | 1122334455 | carlos.sanchez@example.com | | P004 | Ana Martinez | F | 5566778899 | ana.martinez@example.com | | P005 | Luis Garcia | M | 9988776655 | luis.garcia@example.com | | P006 | Sofia Fernandez | F | 4433221100 | sofia.fernandez@example.com | | P007 | Pedro Ramirez | M | 6677889900 | pedro.ramirez@example.com | | P008 | Laura Diaz | F | 3344556677 | laura.diaz@example.com | | P009 | Jorge Ruiz | M | 7788990011 | jorge.ruiz@example.com | | P010 | Carmen Torres | F | 9900112233 | carmen.torres@example.com | +-------------+-----------------+--------+------------+-----------------------------+ 10 rows in set (0.001 sec) Query OK, 0 rows affected (0.016 sec) MariaDB [hospital]> show create procedure ListarPacientes; +-----------------+-----------------------------------------------------+--------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +-----------------+-----------------------------------------------------+--------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | ListarPacientes | NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`root`@`localhost` PROCEDURE `ListarPacientes`() BEGIN SELECT * FROM Pacientes; END | cp850 | cp850_general_ci | utf8mb4_general_ci | +-----------------+-----------------------------------------------------+--------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.000 sec) MariaDB [hospital]> DELIMITER // MariaDB [hospital]> MariaDB [hospital]> CREATE PROCEDURE InsertarPaciente( -> IN p_id_paciente VARCHAR(45), -> IN p_nombre VARCHAR(45), -> IN p_genero VARCHAR(45), -> IN p_telefono VARCHAR(45), -> IN p_Email VARCHAR(45) -> ) -> BEGIN -> INSERT INTO Pacientes (id_paciente, nombre, genero, telefono, Email) -> VALUES (p_id_paciente, p_nombre, p_genero, p_telefono, p_Email); -> END // Query OK, 0 rows affected (0.005 sec) MariaDB [hospital]> MariaDB [hospital]> DELIMITER ; MariaDB [hospital]> DELIMITER // MariaDB [hospital]> MariaDB [hospital]> CREATE PROCEDURE ConsultarPaciente( -> IN p_id_paciente VARCHAR(45) -> ) -> BEGIN -> SELECT * FROM Pacientes WHERE id_paciente = p_id_paciente; -> END // Query OK, 0 rows affected (0.005 sec) MariaDB [hospital]> MariaDB [hospital]> DELIMITER ; MariaDB [hospital]> DELIMITER // MariaDB [hospital]> MariaDB [hospital]> CREATE PROCEDURE EliminarPaciente( -> IN p_id_paciente VARCHAR(45) -> ) -> BEGIN -> DELETE FROM Pacientes WHERE id_paciente = p_id_paciente; -> END // Query OK, 0 rows affected (0.007 sec) MariaDB [hospital]> MariaDB [hospital]> DELIMITER ; MariaDB [hospital]> DELIMITER // MariaDB [hospital]> MariaDB [hospital]> CREATE PROCEDURE ModificarPaciente( -> IN p_id_paciente VARCHAR(45), -> IN p_nombre VARCHAR(45), -> IN p_genero VARCHAR(45), -> IN p_telefono VARCHAR(45), -> IN p_Email VARCHAR(45) -> ) -> BEGIN -> UPDATE Pacientes -> SET nombre = p_nombre, genero = p_genero, telefono = p_telefono, Email = p_Email -> WHERE id_paciente = p_id_paciente; -> END // Query OK, 0 rows affected (0.006 sec) MariaDB [hospital]> MariaDB [hospital]> DELIMITER ; MariaDB [hospital]> exit Bye C:\xampp\mysql\bin>mysqldump -B -uroot -p inventario>c:/xampp/hospital.sql Enter password: