MariaDB [(none)]> use hospital_db; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [hospital_db]> show tables; +-----------------------+ | Tables_in_hospital_db | +-----------------------+ | ingreso | | medico | | paciente | | planta | +-----------------------+ 4 rows in set (0,001 sec) MariaDB [hospital_db]> describe planta; +--------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+-------------+------+-----+---------+-------+ | nombre | varchar(20) | NO | PRI | NULL | | +--------+-------------+------+-----+---------+-------+ 1 row in set (0,002 sec) MariaDB [hospital_db]> insert into planta (nombre) values ('ortopedia'),('cirugia'),('pediatria'); Query OK, 3 rows affected (0,006 sec) Records: 3 Duplicates: 0 Warnings: 0 MariaDB [hospital_db]> show planta; 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 'planta' at line 1 MariaDB [hospital_db]> show create table planta; +--------+------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------+------------------------------------------------------------------------------------------------------------------------------------------------------+ | planta | CREATE TABLE `planta` ( `nombre` varchar(20) NOT NULL, PRIMARY KEY (`nombre`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci | +--------+------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0,001 sec) MariaDB [hospital_db]> select*from planta; +-----------+ | nombre | +-----------+ | cirugia | | ortopedia | | pediatria | +-----------+ 3 rows in set (0,001 sec) MariaDB [hospital_db]> describe medico; +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | id_medico | int(10) | NO | PRI | NULL | | | nombre_medico | varchar(100) | NO | | NULL | | | planta | varchar(20) | NO | MUL | NULL | | +---------------+--------------+------+-----+---------+-------+ 3 rows in set (0,002 sec) MariaDB [hospital_db]> insert into medico (id_medico, nombre_medico, planta) values (1, 'Dr. Juan Pérez', 'ortopedia'), (2, 'Dra. Ana Gómez', 'cirugia'),(3, 'Dr. Carlos López', 'pediatria'); Query OK, 3 rows affected (0,003 sec) Records: 3 Duplicates: 0 Warnings: 0 MariaDB [hospital_db]> select*from medico; +-----------+-------------------+-----------+ | id_medico | nombre_medico | planta | +-----------+-------------------+-----------+ | 1 | Dr. Juan Pérez | ortopedia | | 2 | Dra. Ana Gómez | cirugia | | 3 | Dr. Carlos López | pediatria | +-----------+-------------------+-----------+ 3 rows in set (0,001 sec) MariaDB [hospital_db]> truncate table medico; ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint (`hospital_db`.`ingreso`, CONSTRAINT `ingreso_ibfk_2` FOREIGN KEY (`id_medico`) REFERENCES `hospital_db`.`medico` (`id_medico`)) MariaDB [hospital_db]> select*from medico; +-----------+-------------------+-----------+ | id_medico | nombre_medico | planta | +-----------+-------------------+-----------+ | 1 | Dr. Juan Pérez | ortopedia | | 2 | Dra. Ana Gómez | cirugia | | 3 | Dr. Carlos López | pediatria | +-----------+-------------------+-----------+ 3 rows in set (0,001 sec) MariaDB [hospital_db]> TRUNCATE TABLE medico; ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint (`hospital_db`.`ingreso`, CONSTRAINT `ingreso_ibfk_2` FOREIGN KEY (`id_medico`) REFERENCES `hospital_db`.`medico` (`id_medico`)) MariaDB [hospital_db]> DELETE FROM medico; Query OK, 3 rows affected (0,003 sec) MariaDB [hospital_db]> select*from medico; Empty set (0,001 sec) MariaDB [hospital_db]> insert into medico (id_medico, nombre_medico, planta) values (1, 'Dr. Juan Pérez', 'ortopedia'), (2, 'Dra. Ana Gómez', 'cirugia'),(3, 'Dr. Carlos López', 'pediatria'); Query OK, 3 rows affected (0,004 sec) Records: 3 Duplicates: 0 Warnings: 0 MariaDB [hospital_db]> select*from medico; +-----------+-------------------+-----------+ | id_medico | nombre_medico | planta | +-----------+-------------------+-----------+ | 1 | Dr. Juan Pérez | ortopedia | | 2 | Dra. Ana Gómez | cirugia | | 3 | Dr. Carlos López | pediatria | +-----------+-------------------+-----------+ 3 rows in set (0,001 sec) MariaDB [hospital_db]> describe paciente; +-----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+-------+ | id_paciente | int(10) | NO | PRI | NULL | | | nombre_paciente | varchar(100) | NO | | NULL | | | estado | varchar(20) | NO | | NULL | | | medico_asignado | int(10) | NO | MUL | NULL | | +-----------------+--------------+------+-----+---------+-------+ 4 rows in set (0,002 sec) MariaDB [hospital_db]> insert into paciente (id_paciente, nombre_paciente, estado, medico_asignado) values (1, 'Pedro Martínez', 'estable', 1), (2, 'Lucía Fernández', 'grave', 1), (3, 'Andrés Rodríguez', 'recuperación', 2),(4, 'Camila Torres', 'estable', 2),(5, 'Santiago Gómez', 'crítico', 3), (6, 'Valentina Ramírez', 'estable', 3); Query OK, 6 rows affected (0,009 sec) Records: 6 Duplicates: 0 Warnings: 0 MariaDB [hospital_db]> select*from paciente; +-------------+--------------------+---------------+-----------------+ | id_paciente | nombre_paciente | estado | medico_asignado | +-------------+--------------------+---------------+-----------------+ | 1 | Pedro Martínez | estable | 1 | | 2 | Lucía Fernández | grave | 1 | | 3 | Andrés Rodríguez | recuperación | 2 | | 4 | Camila Torres | estable | 2 | | 5 | Santiago Gómez | crítico | 3 | | 6 | Valentina Ramírez | estable | 3 | +-------------+--------------------+---------------+-----------------+ 6 rows in set (0,001 sec) MariaDB [hospital_db]> describe ingreso; +---------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+----------------+ | id_ingreso | int(11) | NO | PRI | NULL | auto_increment | | fecha_ingreso | date | NO | | NULL | | | diagnostico | text | YES | | NULL | | | id_paciente | int(10) | NO | MUL | NULL | | | id_medico | int(10) | NO | MUL | NULL | | | planta | varchar(20) | NO | MUL | NULL | | +---------------+-------------+------+-----+---------+----------------+ 6 rows in set (0,002 sec) MariaDB [hospital_db]> insert into ingresos (fecha_ingreso, diagnostico, id_paciente, id_medico, planta) values ('2025-08-01', 'fractura de fémur, requiere inmovilización y fisioterapia', 1, 1, 'ortopedia'), ('2025-08-05', 'lesión de rodilla por accidente deportivo', 2, 1, 'ortopedia'), ('2025-08-02', 'apendicitis aguda, requiere cirugía inmediata', 3, 2, 'cirugia'), ('2025-08-06', 'hernia abdominal, programada para cirugía', 4, 2, 'cirugia'),('2025-08-03', 'neumonía infantil, tratamiento con antibióticos', 5, 3, 'pediatria'), ('2025-08-07', 'varicela, requiere aislamiento y control de fiebre', 6, 3, 'pediatria'); ERROR 1146 (42S02): Table 'hospital_db.ingresos' doesn't exist MariaDB [hospital_db]> MariaDB [hospital_db]> insert into ingreso (fecha_ingreso, diagnostico, id_paciente, id_medico, planta) values ('2025-08-01', 'fractura de fémur, requiere inmovilización y fisioterapia', 1, 1, 'ortopedia'), ('2025-08-05', 'lesión de rodilla por accidente deportivo', 2, 1, 'ortopedia'), ('2025-08-02', 'apendicitis aguda, requiere cirugía inmediata', 3, 2, 'cirugia'), ('2025-08-06', 'hernia abdominal, programada para cirugía', 4, 2, 'cirugia'),('2025-08-03', 'neumonía infantil, tratamiento con antibióticos', 5, 3, 'pediatria'), ('2025-08-07', 'varicela, requiere aislamiento y control de fiebre', 6, 3, 'pediatria'); Query OK, 6 rows affected (0,004 sec) Records: 6 Duplicates: 0 Warnings: 0 MariaDB [hospital_db]> select*from ingreso; +------------+---------------+-------------------------------------------------------------+-------------+-----------+-----------+ | id_ingreso | fecha_ingreso | diagnostico | id_paciente | id_medico | planta | +------------+---------------+-------------------------------------------------------------+-------------+-----------+-----------+ | 1 | 2025-08-01 | fractura de fémur, requiere inmovilización y fisioterapia | 1 | 1 | ortopedia | | 2 | 2025-08-05 | lesión de rodilla por accidente deportivo | 2 | 1 | ortopedia | | 3 | 2025-08-02 | apendicitis aguda, requiere cirugía inmediata | 3 | 2 | cirugia | | 4 | 2025-08-06 | hernia abdominal, programada para cirugía | 4 | 2 | cirugia | | 5 | 2025-08-03 | neumonía infantil, tratamiento con antibióticos | 5 | 3 | pediatria | | 6 | 2025-08-07 | varicela, requiere aislamiento y control de fiebre | 6 | 3 | pediatria | +------------+---------------+-------------------------------------------------------------+-------------+-----------+-----------+ 6 rows in set (0,001 sec) MariaDB [hospital_db]> insert into ingreso (fecha_ingreso, diagnostico, id_paciente, id_medico, planta) values ('2025-12-26', 'apendicitis aguda, requiere cirugia urgente', 1, 2, 'cirugia'); Query OK, 1 row affected (0,004 sec) MariaDB [hospital_db]> select*from ingreso; +------------+---------------+-------------------------------------------------------------+-------------+-----------+-----------+ | id_ingreso | fecha_ingreso | diagnostico | id_paciente | id_medico | planta | +------------+---------------+-------------------------------------------------------------+-------------+-----------+-----------+ | 1 | 2025-08-01 | fractura de fémur, requiere inmovilización y fisioterapia | 1 | 1 | ortopedia | | 2 | 2025-08-05 | lesión de rodilla por accidente deportivo | 2 | 1 | ortopedia | | 3 | 2025-08-02 | apendicitis aguda, requiere cirugía inmediata | 3 | 2 | cirugia | | 4 | 2025-08-06 | hernia abdominal, programada para cirugía | 4 | 2 | cirugia | | 5 | 2025-08-03 | neumonía infantil, tratamiento con antibióticos | 5 | 3 | pediatria | | 6 | 2025-08-07 | varicela, requiere aislamiento y control de fiebre | 6 | 3 | pediatria | | 7 | 2025-12-26 | apendicitis aguda, requiere cirugia urgente | 1 | 2 | cirugia | +------------+---------------+-------------------------------------------------------------+-------------+-----------+-----------+ 7 rows in set (0,001 sec) MariaDB [hospital_db]> select p.id_paciente, p.nombre_paciente, p.estado, m.nombre_medico from paciente p join medico m on p.medico_asignado = m.id_medico where m.id_medico=1; +-------------+-------------------+---------+-----------------+ | id_paciente | nombre_paciente | estado | nombre_medico | +-------------+-------------------+---------+-----------------+ | 1 | Pedro Martínez | estable | Dr. Juan Pérez | | 2 | Lucía Fernández | grave | Dr. Juan Pérez | +-------------+-------------------+---------+-----------------+ 2 rows in set (0,007 sec) MariaDB [hospital_db]> select p.id_paciente, p.nombre_paciente, p.estado, m.nombre_medico from paciente p join medico m on p.medico_asignado = m.id_medico where m.id_medico=2; +-------------+--------------------+---------------+-----------------+ | id_paciente | nombre_paciente | estado | nombre_medico | +-------------+--------------------+---------------+-----------------+ | 3 | Andrés Rodríguez | recuperación | Dra. Ana Gómez | | 4 | Camila Torres | estable | Dra. Ana Gómez | +-------------+--------------------+---------------+-----------------+ 2 rows in set (0,002 sec) MariaDB [hospital_db]> select p.id_paciente, p.nombre_paciente, p.estado, m.nombre_medico from paciente p join medico m on p.medico_asignado = m.id_medico where m.nombre_medico='Dr. Juan Pérez'; +-------------+-------------------+---------+-----------------+ | id_paciente | nombre_paciente | estado | nombre_medico | +-------------+-------------------+---------+-----------------+ | 1 | Pedro Martínez | estable | Dr. Juan Pérez | | 2 | Lucía Fernández | grave | Dr. Juan Pérez | +-------------+-------------------+---------+-----------------+ 2 rows in set (0,001 sec) MariaDB [hospital_db]> select pi.nombre_paciente, m.nombre_medico, i.fecha_ingreso from ingresos i join paciente pi on i.id_paciente=pi.id_paciente join medico m on i.id_medico = m.id_medico where pi.id_paciente=1; ERROR 1146 (42S02): Table 'hospital_db.ingresos' doesn't exist MariaDB [hospital_db]> select pi.nombre_paciente, m.nombre_medico, i.fecha_ingreso from ingreso i join paciente pi on i.id_paciente=pi.id_paciente join medico m on i.id_medico = m.id_medico where pi.id_paciente=1; +-----------------+-----------------+---------------+ | nombre_paciente | nombre_medico | fecha_ingreso | +-----------------+-----------------+---------------+ | Pedro Martínez | Dr. Juan Pérez | 2025-08-01 | | Pedro Martínez | Dra. Ana Gómez | 2025-12-26 | +-----------------+-----------------+---------------+ 2 rows in set (0,001 sec) MariaDB [hospital_db]> select pi.nombre_paciente, m.nombre_medico, i.fecha_ingreso from ingreso i join paciente pi on i.id_paciente=pi.id_paciente join medico m on i.id_medico = m.id_medico where pi.id_paciente=2; +-------------------+-----------------+---------------+ | nombre_paciente | nombre_medico | fecha_ingreso | +-------------------+-----------------+---------------+ | Lucía Fernández | Dr. Juan Pérez | 2025-08-05 | +-------------------+-----------------+---------------+ 1 row in set (0,001 sec) MariaDB [hospital_db]> select pi.nombre_paciente, m.nombre_medico, i.fecha_ingreso from ingreso i join paciente pi on i.id_paciente=pi.id_paciente join medico m on i.id_medico = m.id_medico where pi.id_paciente=3; +--------------------+-----------------+---------------+ | nombre_paciente | nombre_medico | fecha_ingreso | +--------------------+-----------------+---------------+ | Andrés Rodríguez | Dra. Ana Gómez | 2025-08-02 | +--------------------+-----------------+---------------+ 1 row in set (0,001 sec) MariaDB [hospital_db]> select planta, count(distinct id_paciente) as total_pacientes from ingreso group by planta; +-----------+-----------------+ | planta | total_pacientes | +-----------+-----------------+ | cirugia | 3 | | ortopedia | 2 | | pediatria | 2 | +-----------+-----------------+ 3 rows in set (0,001 sec) MariaDB [hospital_db]> update paciente set medico_asignado = 1 where id_paciente=2; Query OK, 0 rows affected (0,001 sec) Rows matched: 1 Changed: 0 Warnings: 0 MariaDB [hospital_db]> select*from paciente id_paciente=1; 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 '=1' at line 1 MariaDB [hospital_db]> select p.id_paciente, p.nombre_paciente, m.nombre_medico from paciente p join medico m on p.medico_asignado = m.id_medico where p.id_paciente=2; +-------------+-------------------+-----------------+ | id_paciente | nombre_paciente | nombre_medico | +-------------+-------------------+-----------------+ | 2 | Lucía Fernández | Dr. Juan Pérez | +-------------+-------------------+-----------------+ 1 row in set (0,001 sec) MariaDB [hospital_db]> select p.id_paciente, p.nombre_paciente, m.nombre_medico, m.id_medico from paciente p join medico m on p.medico_asignado = m.id_medico where p.id_paciente=2; +-------------+-------------------+-----------------+-----------+ | id_paciente | nombre_paciente | nombre_medico | id_medico | +-------------+-------------------+-----------------+-----------+ | 2 | Lucía Fernández | Dr. Juan Pérez | 1 | +-------------+-------------------+-----------------+-----------+ 1 row in set (0,001 sec) MariaDB [hospital_db]> select*from paciente; +-------------+--------------------+---------------+-----------------+ | id_paciente | nombre_paciente | estado | medico_asignado | +-------------+--------------------+---------------+-----------------+ | 1 | Pedro Martínez | estable | 1 | | 2 | Lucía Fernández | grave | 1 | | 3 | Andrés Rodríguez | recuperación | 2 | | 4 | Camila Torres | estable | 2 | | 5 | Santiago Gómez | crítico | 3 | | 6 | Valentina Ramírez | estable | 3 | +-------------+--------------------+---------------+-----------------+ 6 rows in set (0,001 sec) MariaDB [hospital_db]> update paciente set medico_asignado = 1 where id_paciente=2; Query OK, 0 rows affected (0,001 sec) Rows matched: 1 Changed: 0 Warnings: 0 MariaDB [hospital_db]> update paciente set medico_asignado = 1 where id_paciente=3; Query OK, 1 row affected (0,004 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [hospital_db]> select p.id_paciente, p.nombre_paciente, m.nombre_medico, m.id_medico from paciente p join medico m on p.medico_asignado = m.id_medico where p.id_paciente=3; +-------------+--------------------+-----------------+-----------+ | id_paciente | nombre_paciente | nombre_medico | id_medico | +-------------+--------------------+-----------------+-----------+ | 3 | Andrés Rodríguez | Dr. Juan Pérez | 1 | +-------------+--------------------+-----------------+-----------+ 1 row in set (0,001 sec) MariaDB [hospital_db]> select*from paciente; +-------------+--------------------+---------------+-----------------+ | id_paciente | nombre_paciente | estado | medico_asignado | +-------------+--------------------+---------------+-----------------+ | 1 | Pedro Martínez | estable | 1 | | 2 | Lucía Fernández | grave | 1 | | 3 | Andrés Rodríguez | recuperación | 1 | | 4 | Camila Torres | estable | 2 | | 5 | Santiago Gómez | crítico | 3 | | 6 | Valentina Ramírez | estable | 3 | +-------------+--------------------+---------------+-----------------+ 6 rows in set (0,001 sec) MariaDB [hospital_db]> exit