MariaDB [PatitasAlAire]> select * from mascota; +-----------+--------+----------+--------+-----------------+---------+-------+--------+-----------+------------+--------+ | idMascota | Nombre | Color | Sexo | FechaNacimiento | Tamano | Peso | idRaza | idCliente | idPaseador | Estado | +-----------+--------+----------+--------+-----------------+---------+-------+--------+-----------+------------+--------+ | 1 | Fido | Marr¢n | Macho | 2020-01-15 | Mediano | 20.50 | 1 | 1 | 1 | 1 | | 2 | Bella | Negro | Hembra | 2019-05-20 | Grande | 30.00 | 2 | 2 | 2 | 1 | | 3 | Rex | Dorado | Macho | 2018-03-10 | Grande | 35.00 | 1 | 3 | 3 | 1 | | 4 | Luna | Blanco | Hembra | 2021-06-25 | Peque¤o | 10.00 | 3 | 4 | 4 | 1 | | 5 | Miau | Gris | Hembra | 2017-11-05 | Peque¤o | 4.50 | 4 | 5 | 5 | 1 | | 6 | Bunny | Blanco | Macho | 2022-02-12 | Peque¤o | 2.00 | 8 | 6 | 6 | 1 | | 7 | Chico | Verde | Macho | 2023-07-18 | Mediano | 1.00 | 6 | 7 | 7 | 1 | | 8 | Dora | Amarillo | Hembra | 2020-09-01 | Peque¤o | 5.00 | 5 | 8 | 8 | 1 | | 9 | Tina | Marr¢n | Hembra | 2019-12-30 | Mediano | 15.00 | 2 | 9 | 9 | 1 | | 10 | Kiki | Rojo | Macho | 2021-08-15 | Peque¤o | 3.50 | 3 | 10 | 10 | 1 | +-----------+--------+----------+--------+-----------------+---------+-------+--------+-----------+------------+--------+ 10 rows in set (0.012 sec) MariaDB [PatitasAlAire]> select current_date(); +----------------+ | current_date() | +----------------+ | 2024-11-09 | +----------------+ 1 row in set (0.001 sec) MariaDB [PatitasAlAire]> select year (current_date()); +-----------------------+ | year (current_date()) | +-----------------------+ | 2024 | +-----------------------+ 1 row in set (0.000 sec) MariaDB [PatitasAlAire]> select month(current_date()); +-----------------------+ | month(current_date()) | +-----------------------+ | 11 | +-----------------------+ 1 row in set (0.001 sec) MariaDB [PatitasAlAire]> select day(current_date()); +---------------------+ | day(current_date()) | +---------------------+ | 9 | +---------------------+ 1 row in set (0.000 sec) MariaDB [PatitasAlAire]> SELECT idMascota, Nombre, FechaNacimiento, -> FLOOR(DATEDIFF(CURDATE(), FechaNacimiento) / 365) AS EdadEnAnios -> FROM MASCOTA -> WHERE FLOOR(DATEDIFF(CURDATE(), FechaNacimiento) / 365) > 2; +-----------+--------+-----------------+-------------+ | idMascota | Nombre | FechaNacimiento | EdadEnAnios | +-----------+--------+-----------------+-------------+ | 1 | Fido | 2020-01-15 | 4 | | 2 | Bella | 2019-05-20 | 5 | | 3 | Rex | 2018-03-10 | 6 | | 4 | Luna | 2021-06-25 | 3 | | 5 | Miau | 2017-11-05 | 7 | | 8 | Dora | 2020-09-01 | 4 | | 9 | Tina | 2019-12-30 | 4 | | 10 | Kiki | 2021-08-15 | 3 | +-----------+--------+-----------------+-------------+ 8 rows in set (0.003 sec) MariaDB [PatitasAlAire]> SELECT COUNT(*) AS TotalMachosMenoresDe2Anios -> FROM MASCOTA -> WHERE Sexo = 'Macho' -> AND FLOOR(DATEDIFF(CURDATE(), FechaNacimiento) / 365) < 2; +----------------------------+ | TotalMachosMenoresDe2Anios | +----------------------------+ | 1 | +----------------------------+ 1 row in set (0.012 sec) MariaDB [PatitasAlAire]> SELECT Nombre, FechaNacimiento, -> FLOOR(DATEDIFF(CURDATE(), FechaNacimiento) / 365) AS EdadEnAnios -> FROM MASCOTA -> WHERE Sexo = 'Macho' -> AND FLOOR(DATEDIFF(CURDATE(), FechaNacimiento) / 365) < 2; +--------+-----------------+-------------+ | Nombre | FechaNacimiento | EdadEnAnios | +--------+-----------------+-------------+ | Chico | 2023-07-18 | 1 | +--------+-----------------+-------------+ 1 row in set (0.001 sec) MariaDB [PatitasAlAire]> select * from Usuario; +-----------+----------------+------------------+--------+----------+ | idUsuario | NombreUsuario | Contrasena | Estado | idPerfil | +-----------+----------------+------------------+--------+----------+ | 1 | admin | admin123 | 1 | 1 | | 2 | cliente1 | cliente123 | 1 | 2 | | 3 | paseador1 | paseador123 | 1 | 3 | | 4 | recepcionista1 | recepcionista123 | 1 | 4 | | 5 | gerente1 | gerente123 | 1 | 5 | | 6 | contador1 | contador123 | 1 | 6 | | 7 | supervisor1 | supervisor123 | 1 | 7 | | 8 | soporte1 | soporte123 | 1 | 8 | | 9 | desarrollador1 | desarrollador123 | 1 | 9 | | 10 | marketing1 | marketing123 | 1 | 10 | +-----------+----------------+------------------+--------+----------+ 10 rows in set (0.005 sec) MariaDB [PatitasAlAire]> select * from Paseador; +------------+----------+-----------+-----------+----------------+-----------------+-------------------------------+----------+--------+ | idPaseador | Cedula | NombreUno | NombreDos | PrimerApellido | SegundoApellido | CorreoElectronico | Telefono | Estado | +------------+----------+-----------+-----------+----------------+-----------------+-------------------------------+----------+--------+ | 1 | 12398765 | Pedro | Luis | Ram¡rez | Gonz lez | pedro.ramirez@example.com | 5558765 | 1 | | 2 | 98712345 | Lucia | Sofia | Ortega | Fern ndez | lucia.ortega@example.com | 5554321 | 1 | | 3 | 15975348 | Jorge | Alejandro | Cruz | Vargas | jorge.cruz@example.com | 5551234 | 1 | | 4 | 25896314 | Ana | Luc¡a | P‚rez | Mart¡nez | ana.perez@example.com | 5555678 | 1 | | 5 | 35715964 | Miguel | Angel | Santos | Torres | miguel.santos@example.com | 5558765 | 1 | | 6 | 14725836 | Claudia | Natalia | Ordo¤ez | Quintero | claudia.ordonez@example.com | 5554321 | 1 | | 7 | 96385274 | Roberto | Carlos | D¡az | Hern ndez | roberto.diaz@example.com | 5556789 | 1 | | 8 | 75395142 | Carolina | Milagros | Cordero | Salazar | carolina.cordero@example.com | 5552345 | 1 | | 9 | 85274169 | Fernando | David | Ceballos | N£¤ez | fernando.ceballos@example.com | 5558765 | 1 | | 10 | 45612378 | Isabella | Fernanda | L¢pez | Mora | isabella.lopez@example.com | 5553456 | 1 | +------------+----------+-----------+-----------+----------------+-----------------+-------------------------------+----------+--------+ 10 rows in set (0.014 sec) MariaDB [PatitasAlAire]> MariaDB [PatitasAlAire]> select * from Paseador; +------------+----------+-----------+-----------+----------------+-----------------+-------------------------------+----------+--------+ | idPaseador | Cedula | NombreUno | NombreDos | PrimerApellido | SegundoApellido | CorreoElectronico | Telefono | Estado | +------------+----------+-----------+-----------+----------------+-----------------+-------------------------------+----------+--------+ | 1 | 12398765 | Pedro | Luis | Ram¡rez | Gonz lez | pedro.ramirez@example.com | 5558765 | 1 | | 2 | 98712345 | Lucia | Sofia | Ortega | Fern ndez | lucia.ortega@example.com | 5554321 | 1 | | 3 | 15975348 | Jorge | Alejandro | Cruz | Vargas | jorge.cruz@example.com | 5551234 | 1 | | 4 | 25896314 | Ana | Luc¡a | P‚rez | Mart¡nez | ana.perez@example.com | 5555678 | 1 | | 5 | 35715964 | Miguel | Angel | Santos | Torres | miguel.santos@example.com | 5558765 | 1 | | 6 | 14725836 | Claudia | Natalia | Ordo¤ez | Quintero | claudia.ordonez@example.com | 5554321 | 1 | | 7 | 96385274 | Roberto | Carlos | D¡az | Hern ndez | roberto.diaz@example.com | 5556789 | 1 | | 8 | 75395142 | Carolina | Milagros | Cordero | Salazar | carolina.cordero@example.com | 5552345 | 1 | | 9 | 85274169 | Fernando | David | Ceballos | N£¤ez | fernando.ceballos@example.com | 5558765 | 1 | | 10 | 45612378 | Isabella | Fernanda | L¢pez | Mora | isabella.lopez@example.com | 5553456 | 1 | +------------+----------+-----------+-----------+----------------+-----------------+-------------------------------+----------+--------+ 10 rows in set (0.004 sec) MariaDB [PatitasAlAire]> SELECT idPaseador, Nombre, DocumentoIdentidad -> FROM PASEADOR -> WHERE SUBSTRING(DocumentoIdentidad, 6, 1) = '3'; ERROR 1054 (42S22): Unknown column 'Nombre' in 'field list' MariaDB [PatitasAlAire]> SELECT idPaseador, NombreUno, NombreDos, PrimerApellido, SegundoApellido, Cedula -> FROM PASEADOR -> WHERE SUBSTRING(Cedula, 6, 1) = '3'; +------------+-----------+-----------+----------------+-----------------+----------+ | idPaseador | NombreUno | NombreDos | PrimerApellido | SegundoApellido | Cedula | +------------+-----------+-----------+----------------+-----------------+----------+ | 2 | Lucia | Sofia | Ortega | Fern ndez | 98712345 | | 3 | Jorge | Alejandro | Cruz | Vargas | 15975348 | | 4 | Ana | Luc¡a | P‚rez | Mart¡nez | 25896314 | | 10 | Isabella | Fernanda | L¢pez | Mora | 45612378 | +------------+-----------+-----------+----------------+-----------------+----------+ 4 rows in set (0.000 sec) MariaDB [PatitasAlAire]> SELECT CONCAT(NombreUno, ' ', NombreDos, ' ', PrimerApellido, ' ', SegundoApellido) AS Nombre -> FROM PASEADOR -> WHERE RIGHT(Telefono, 1) = '5'; +-----------------------------------+ | Nombre | +-----------------------------------+ | Pedro Luis Ram¡rez Gonz lez | | Miguel Angel Santos Torres | | Carolina Milagros Cordero Salazar | | Fernando David Ceballos N£¤ez | +-----------------------------------+ 4 rows in set (0.001 sec) MariaDB [PatitasAlAire]> SELECT CONCAT(NombreUno, ' ', NombreDos, ' ', PrimerApellido, ' ', SegundoApellido) AS Nombre, -> Telefono -> FROM PASEADOR -> WHERE RIGHT(Telefono, 1) = '5'; +-----------------------------------+----------+ | Nombre | Telefono | +-----------------------------------+----------+ | Pedro Luis Ram¡rez Gonz lez | 5558765 | | Miguel Angel Santos Torres | 5558765 | | Carolina Milagros Cordero Salazar | 5552345 | | Fernando David Ceballos N£¤ez | 5558765 | +-----------------------------------+----------+ 4 rows in set (0.000 sec) MariaDB [PatitasAlAire]> select * from factura; +-----------+------------+----------+-------------+--------+ | idFactura | Fecha | Hora | idContratos | Estado | +-----------+------------+----------+-------------+--------+ | 1 | 2024-01-01 | 10:00:00 | 1 | 1 | | 2 | 2024-02-01 | 12:00:00 | 2 | 1 | | 3 | 2024-03-01 | 14:00:00 | 3 | 1 | | 4 | 2024-04-01 | 16:00:00 | 4 | 1 | | 5 | 2024-05-01 | 18:00:00 | 5 | 1 | | 6 | 2024-06-01 | 09:00:00 | 6 | 1 | | 7 | 2024-07-01 | 11:00:00 | 7 | 1 | | 8 | 2024-08-01 | 13:00:00 | 8 | 1 | | 9 | 2024-09-01 | 15:00:00 | 9 | 1 | | 10 | 2024-10-01 | 17:00:00 | 10 | 1 | +-----------+------------+----------+-------------+--------+ 10 rows in set (0.016 sec) MariaDB [PatitasAlAire]> select * from contratos; +-------------+-------------+------------+------------+------------------+-----------+------------+--------------+-----------------+-----------+--------+ | idContratos | FechaInicio | FechaFin | Clausulas | CantidadMascotas | TotalPago | idPaseador | idSitioPaseo | idRegistroPaseo | idMascota | Estado | +-------------+-------------+------------+------------+------------------+-----------+------------+--------------+-----------------+-----------+--------+ | 1 | 2024-01-01 | 2024-06-01 | Cl usula A | 3 | 150.00 | 1 | 1 | 1 | 1 | 1 | | 2 | 2024-02-01 | 2024-07-01 | Cl usula B | 2 | 200.00 | 2 | 2 | 2 | 2 | 1 | | 3 | 2024-03-01 | 2024-08-01 | Cl usula C | 1 | 250.00 | 3 | 3 | 3 | 3 | 1 | | 4 | 2024-04-01 | 2024-09-01 | Cl usula D | 5 | 300.00 | 4 | 4 | 4 | 4 | 1 | | 5 | 2024-05-01 | 2024-10-01 | Cl usula E | 4 | 350.00 | 5 | 5 | 5 | 5 | 1 | | 6 | 2024-06-01 | 2024-11-01 | Cl usula F | 3 | 400.00 | 6 | 6 | 6 | 6 | 1 | | 7 | 2024-07-01 | 2024-12-01 | Cl usula G | 2 | 450.00 | 7 | 7 | 7 | 7 | 1 | | 8 | 2024-08-01 | 2025-01-01 | Cl usula H | 4 | 500.00 | 8 | 8 | 8 | 8 | 1 | | 9 | 2024-09-01 | 2025-02-01 | Cl usula I | 3 | 550.00 | 9 | 9 | 9 | 9 | 1 | | 10 | 2024-10-01 | 2025-03-01 | Cl usula J | 1 | 600.00 | 10 | 10 | 10 | 10 | 1 | +-------------+-------------+------------+------------+------------------+-----------+------------+--------------+-----------------+-----------+--------+ 10 rows in set (0.002 sec) MariaDB [PatitasAlAire]> SELECT idContrato, TipoPago, Precio -> FROM CONTRATOS -> WHERE TipoPago = (SELECT TipoPago -> FROM CONTRATOS -> WHERE Precio = (SELECT MAX(Precio) FROM CONTRATOS)); ERROR 1054 (42S22): Unknown column 'idContrato' in 'field list' MariaDB [PatitasAlAire]> SELECT idContrato, TipoPago, Precio -> FROM CONTRATOS -> WHERE TipoPago = (SELECT TipoPago -> FROM CONTRATOS -> WHERE Precio = (SELECT MAX(Precio) FROM CONTRATOS) -> LIMIT 1); ERROR 1054 (42S22): Unknown column 'idContrato' in 'field list' MariaDB [PatitasAlAire]> SELECT idContratos, TipoPago, TotalPago -> FROM CONTRATOS -> WHERE TipoPago = (SELECT TipoPago -> FROM CONTRATOS -> WHERE TotalPago = (SELECT MAX(TotalPago) FROM CONTRATOS) -> LIMIT 1); ERROR 1054 (42S22): Unknown column 'TipoPago' in 'field list' MariaDB [PatitasAlAire]> SELECT idContratos, Estado, TotalPago -> FROM CONTRATOS -> WHERE Estado = (SELECT Estado -> FROM CONTRATOS -> WHERE TotalPago = (SELECT MAX(TotalPago) FROM CONTRATOS) -> LIMIT 1); +-------------+--------+-----------+ | idContratos | Estado | TotalPago | +-------------+--------+-----------+ | 1 | 1 | 150.00 | | 2 | 1 | 200.00 | | 3 | 1 | 250.00 | | 4 | 1 | 300.00 | | 5 | 1 | 350.00 | | 6 | 1 | 400.00 | | 7 | 1 | 450.00 | | 8 | 1 | 500.00 | | 9 | 1 | 550.00 | | 10 | 1 | 600.00 | +-------------+--------+-----------+ 10 rows in set (0.000 sec) MariaDB [PatitasAlAire]> SELECT idContratos, FechaInicio, FechaFin, TotalPago -> FROM CONTRATOS -> WHERE TotalPago = (SELECT MAX(TotalPago) FROM CONTRATOS); +-------------+-------------+------------+-----------+ | idContratos | FechaInicio | FechaFin | TotalPago | +-------------+-------------+------------+-----------+ | 10 | 2024-10-01 | 2025-03-01 | 600.00 | +-------------+-------------+------------+-----------+ 1 row in set (0.001 sec) MariaDB [PatitasAlAire]> SELECT idContratos, FechaInicio, FechaFin, CantidadMascotas -> FROM CONTRATOS -> WHERE CantidadMascotas > (SELECT AVG(CantidadMascotas) FROM CONTRATOS); +-------------+-------------+------------+------------------+ | idContratos | FechaInicio | FechaFin | CantidadMascotas | +-------------+-------------+------------+------------------+ | 1 | 2024-01-01 | 2024-06-01 | 3 | | 4 | 2024-04-01 | 2024-09-01 | 5 | | 5 | 2024-05-01 | 2024-10-01 | 4 | | 6 | 2024-06-01 | 2024-11-01 | 3 | | 8 | 2024-08-01 | 2025-01-01 | 4 | | 9 | 2024-09-01 | 2025-02-01 | 3 | +-------------+-------------+------------+------------------+ 6 rows in set (0.001 sec) MariaDB [PatitasAlAire]> SELECT idContratos, TotalPago, -> IF(TotalPago <= 400.00, -> CONCAT('Porcentaje de Aumento el 25%, Incremento: ', TotalPago * 0.25), -> CONCAT('Porcentaje de aumento del 40%, Incremento: ', TotalPago * 0.40)) AS Incremento -> FROM CONTRATOS; +-------------+-----------+-----------------------------------------------------+ | idContratos | TotalPago | Incremento | +-------------+-----------+-----------------------------------------------------+ | 1 | 150.00 | Porcentaje de Aumento el 25%, Incremento: 37.5000 | | 2 | 200.00 | Porcentaje de Aumento el 25%, Incremento: 50.0000 | | 3 | 250.00 | Porcentaje de Aumento el 25%, Incremento: 62.5000 | | 4 | 300.00 | Porcentaje de Aumento el 25%, Incremento: 75.0000 | | 5 | 350.00 | Porcentaje de Aumento el 25%, Incremento: 87.5000 | | 6 | 400.00 | Porcentaje de Aumento el 25%, Incremento: 100.0000 | | 7 | 450.00 | Porcentaje de aumento del 40%, Incremento: 180.0000 | | 8 | 500.00 | Porcentaje de aumento del 40%, Incremento: 200.0000 | | 9 | 550.00 | Porcentaje de aumento del 40%, Incremento: 220.0000 | | 10 | 600.00 | Porcentaje de aumento del 40%, Incremento: 240.0000 | +-------------+-----------+-----------------------------------------------------+ 10 rows in set (0.001 sec) MariaDB [PatitasAlAire]> SELECT idContratos, FechaFin, -> CASE -> WHEN FechaFin > CURDATE() THEN 'Activo' -> ELSE 'Vencido' -> END AS EstadoContrato -> FROM CONTRATOS; +-------------+------------+----------------+ | idContratos | FechaFin | EstadoContrato | +-------------+------------+----------------+ | 1 | 2024-06-01 | Vencido | | 2 | 2024-07-01 | Vencido | | 3 | 2024-08-01 | Vencido | | 4 | 2024-09-01 | Vencido | | 5 | 2024-10-01 | Vencido | | 6 | 2024-11-01 | Vencido | | 7 | 2024-12-01 | Activo | | 8 | 2025-01-01 | Activo | | 9 | 2025-02-01 | Activo | | 10 | 2025-03-01 | Activo | +-------------+------------+----------------+ 10 rows in set (0.001 sec) MariaDB [PatitasAlAire]> CREATE TABLE AUDITORIA_PASEOS ( -> idAuditoria INT AUTO_INCREMENT PRIMARY KEY, -> idSitioPaseo INT, -> Nombre VARCHAR(100), -> Ubicacion VARCHAR(100), -> Estado BOOLEAN, -> FechaInsercion DATETIME -> ); Query OK, 0 rows affected (0.031 sec) MariaDB [PatitasAlAire]> DELIMITER // MariaDB [PatitasAlAire]> MariaDB [PatitasAlAire]> CREATE TRIGGER after_insert_sitio_paseo -> AFTER INSERT ON SITIO_PASEO -> FOR EACH ROW -> BEGIN -> INSERT INTO AUDITORIA_PASEOS (idSitioPaseo, Nombre, Ubicacion, Estado, FechaInsercion) -> VALUES (NEW.idSitioPaseo, NEW.Nombre, NEW.Ubicacion, NEW.Estado, NOW()); -> END // Query OK, 0 rows affected (0.026 sec) MariaDB [PatitasAlAire]> MariaDB [PatitasAlAire]> DELIMITER ; MariaDB [PatitasAlAire]> INSERT INTO SITIO_PASEO (Nombre, Ubicacion, Estado) -> VALUES ('Parque Natural', 'Zona Sur', TRUE); Query OK, 1 row affected, 1 warning (0.032 sec) MariaDB [PatitasAlAire]> SELECT * FROM AUDITORIA_PASEOS; +-------------+--------------+----------------+-----------+--------+---------------------+ | idAuditoria | idSitioPaseo | Nombre | Ubicacion | Estado | FechaInsercion | +-------------+--------------+----------------+-----------+--------+---------------------+ | 1 | 0 | Parque Natural | Zona Sur | 1 | 2024-11-09 12:24:51 | +-------------+--------------+----------------+-----------+--------+---------------------+ 1 row in set (0.000 sec) MariaDB [PatitasAlAire]> Select * from SITIO_PASEO; +--------------+------------------+----------------+--------+ | idSitioPaseo | Nombre | Ubicacion | Estado | +--------------+------------------+----------------+--------+ | 0 | Parque Natural | Zona Sur | 1 | | 1 | Parque Central | Zona Norte | 1 | | 2 | Bosque Nacional | Zona Oeste | 1 | | 3 | Playa Dorada | Zona Sur | 1 | | 4 | Centro Hist¢rico | Zona Este | 1 | | 5 | Monta¤a Verde | Zona Noreste | 1 | | 6 | R¡o Azul | Zona Suroeste | 1 | | 7 | Lago Sereno | Zona Sureste | 1 | | 8 | Ciudad Moderna | Zona Centro | 1 | | 9 | Campo Abierto | Zona Rural | 1 | | 10 | Valle Florido | Zona Monta¤osa | 1 | +--------------+------------------+----------------+--------+ 11 rows in set (0.001 sec) MariaDB [PatitasAlAire]> CREATE TABLE RAZA_DUPLICADA AS -> SELECT idRaza, Nombre, Descripcion, idTipoMascota, Estado -> FROM RAZA; Query OK, 10 rows affected (0.053 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [PatitasAlAire]> select * from Raza_duplicada; +--------+---------------+-------------------------+---------------+--------+ | idRaza | Nombre | Descripcion | idTipoMascota | Estado | +--------+---------------+-------------------------+---------------+--------+ | 1 | Labrador | Raza grande | 1 | 1 | | 2 | Pastor Alem n | Raza de trabajo | 1 | 1 | | 3 | Bulldog | Raza robusta | 1 | 1 | | 4 | Persa | Raza de gato | 2 | 1 | | 5 | Siam‚s | Raza de gato | 2 | 1 | | 6 | Cacat£a | Ave colorida | 3 | 1 | | 7 | Terrapin | Tortuga de agua | 4 | 1 | | 8 | Angora | Conejo de orejas largas | 5 | 1 | | 9 | Dwarf | Hamster enano | 6 | 1 | | 10 | Guppy | Pez de agua dulce | 7 | 1 | +--------+---------------+-------------------------+---------------+--------+ 10 rows in set (0.001 sec) MariaDB [PatitasAlAire]> select * from Raza; +--------+---------------+-------------------------+---------------+--------+ | idRaza | Nombre | Descripcion | idTipoMascota | Estado | +--------+---------------+-------------------------+---------------+--------+ | 1 | Labrador | Raza grande | 1 | 1 | | 2 | Pastor Alem n | Raza de trabajo | 1 | 1 | | 3 | Bulldog | Raza robusta | 1 | 1 | | 4 | Persa | Raza de gato | 2 | 1 | | 5 | Siam‚s | Raza de gato | 2 | 1 | | 6 | Cacat£a | Ave colorida | 3 | 1 | | 7 | Terrapin | Tortuga de agua | 4 | 1 | | 8 | Angora | Conejo de orejas largas | 5 | 1 | | 9 | Dwarf | Hamster enano | 6 | 1 | | 10 | Guppy | Pez de agua dulce | 7 | 1 | +--------+---------------+-------------------------+---------------+--------+ 10 rows in set (0.000 sec) MariaDB [PatitasAlAire]> show tables in PatitasAlAire; +-------------------------+ | Tables_in_patitasalaire | +-------------------------+ | auditoria_paseos | | cliente | | comportamiento | | contratos | | factura | | horarios | | mascota | | mascota_registro_paseo | | pago | | paseador | | perfil | | raza | | raza_comportamiento | | raza_duplicada | | registro_paseo | | sitio_paseo | | tipo_mascota | | tipo_pago | | usuario | +-------------------------+ 19 rows in set (0.003 sec) MariaDB [PatitasAlAire]> select * from Usuario; +-----------+----------------+------------------+--------+----------+ | idUsuario | NombreUsuario | Contrasena | Estado | idPerfil | +-----------+----------------+------------------+--------+----------+ | 1 | admin | admin123 | 1 | 1 | | 2 | cliente1 | cliente123 | 1 | 2 | | 3 | paseador1 | paseador123 | 1 | 3 | | 4 | recepcionista1 | recepcionista123 | 1 | 4 | | 5 | gerente1 | gerente123 | 1 | 5 | | 6 | contador1 | contador123 | 1 | 6 | | 7 | supervisor1 | supervisor123 | 1 | 7 | | 8 | soporte1 | soporte123 | 1 | 8 | | 9 | desarrollador1 | desarrollador123 | 1 | 9 | | 10 | marketing1 | marketing123 | 1 | 10 | +-----------+----------------+------------------+--------+----------+ 10 rows in set (0.005 sec) MariaDB [PatitasAlAire]> select * from Perfil; +----------+-----------------+--------+ | idPerfil | NombrePerfil | Estado | +----------+-----------------+--------+ | 1 | Administrador | 1 | | 2 | Cliente | 1 | | 3 | Paseador | 1 | | 4 | Recepcionista | 1 | | 5 | Gerente | 1 | | 6 | Contador | 1 | | 7 | Supervisor | 1 | | 8 | Soporte T‚cnico | 1 | | 9 | Desarrollador | 1 | | 10 | Marketing | 1 | +----------+-----------------+--------+ 10 rows in set (0.003 sec) MariaDB [PatitasAlAire]> INSERT INTO USUARIO (idUsuario, NombreUsuario, Contrase¤a, Estado, idPerfil) -> SELECT -> ROW_NUMBER() OVER (ORDER BY idPerfil) + (SELECT COUNT(*) FROM USUARIO) AS idUsuario, -> CONCAT('usuario', ROW_NUMBER() OVER (ORDER BY idPerfil)) AS NombreUsuario, -> CONCAT('contrase¤a', ROW_NUMBER() OVER (ORDER BY idPerfil)) AS Contrase¤a, -> TRUE AS Estado, -> p.idPerfil -> FROM PERFIL p -> WHERE p.Estado = TRUE; ERROR 1054 (42S22): Unknown column 'Contrase¤a' in 'field list' MariaDB [PatitasAlAire]> INSERT INTO USUARIO (idUsuario, NombreUsuario, contrasena, Estado, idPerfil) -> SELECT -> (SELECT COALESCE(MAX(idUsuario), 0) + ROW_NUMBER() OVER (ORDER BY p.idPerfil) FROM USUARIO) AS idUsuario, -> CONCAT('usuario', ROW_NUMBER() OVER (ORDER BY p.idPerfil)) AS NombreUsuario, -> CONCAT('contrasena', ROW_NUMBER() OVER (ORDER BY p.idPerfil)) AS contrasena, -> TRUE AS Estado, -> p.idPerfil -> FROM PERFIL p -> WHERE p.Estado = TRUE; ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY' MariaDB [PatitasAlAire]> INSERT INTO USUARIO (idUsuario, NombreUsuario, Contrase¤a, Estado, idPerfil) -> SELECT -> 1 AS idUsuario, -> 'admin' AS NombreUsuario, -> 'admin123' AS Contrase¤a, -> TRUE AS Estado, -> p.idPerfil -> FROM PERFIL p -> WHERE p.NombrePerfil = 'Administrador'; ERROR 1054 (42S22): Unknown column 'Contrase¤a' in 'field list' MariaDB [PatitasAlAire]> MariaDB [PatitasAlAire]> INSERT INTO USUARIO (idUsuario, NombreUsuario, Contrase¤a, Estado, idPerfil) -> SELECT -> 2 AS idUsuario, -> 'cliente1' AS NombreUsuario, -> 'cliente123' AS Contrase¤a, -> TRUE AS Estado, -> p.idPerfil -> FROM PERFIL p -> WHERE p.NombrePerfil = 'Cliente'; ERROR 1054 (42S22): Unknown column 'Contrase¤a' in 'field list' MariaDB [PatitasAlAire]> MariaDB [PatitasAlAire]> INSERT INTO USUARIO (idUsuario, NombreUsuario, Contrase¤a, Estado, idPerfil) -> SELECT -> 3 AS idUsuario, -> 'paseador1' AS NombreUsuario, -> 'paseador123' AS Contrase¤a, -> TRUE AS Estado, -> p.idPerfil -> FROM PERFIL p -> WHERE p.NombrePerfil = 'Paseador'; ERROR 1054 (42S22): Unknown column 'Contrase¤a' in 'field list' MariaDB [PatitasAlAire]> MariaDB [PatitasAlAire]> INSERT INTO USUARIO (idUsuario, NombreUsuario, Contrasena, Estado, idPerfil) -> SELECT -> 1 AS idUsuario, -> 'admin' AS NombreUsuario, -> 'admin123' AS Contrasena, -> TRUE AS Estado, -> p.idPerfil -> FROM PERFIL p -> WHERE p.NombrePerfil = 'Administrador'; ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY' MariaDB [PatitasAlAire]> MariaDB [PatitasAlAire]> INSERT INTO USUARIO (idUsuario, NombreUsuario, Contrasena, Estado, idPerfil) -> SELECT -> 2 AS idUsuario, -> 'cliente1' AS NombreUsuario, -> 'cliente123' AS Contrasena, -> TRUE AS Estado, -> p.idPerfil -> FROM PERFIL p -> WHERE p.NombrePerfil = 'Cliente'; ERROR 1062 (23000): Duplicate entry '2' for key 'PRIMARY' MariaDB [PatitasAlAire]> MariaDB [PatitasAlAire]> INSERT INTO USUARIO (idUsuario, NombreUsuario, Contrasena, Estado, idPerfil) -> SELECT -> 3 AS idUsuario, -> 'paseador1' AS NombreUsuario, -> 'paseador123' AS Contrasena, -> TRUE AS Estado, -> p.idPerfil -> FROM PERFIL p -> WHERE p.NombrePerfil = 'Paseador'; ERROR 1062 (23000): Duplicate entry '3' for key 'PRIMARY' MariaDB [PatitasAlAire]> MariaDB [PatitasAlAire]> INSERT INTO USUARIO (idUsuario, NombreUsuario, Contrasena, Estado, idPerfil) -> SELECT -> 1 AS idUsuario, -> 'admin' AS NombreUsuario, -> 'admin123' AS Contrasena, -> TRUE AS Estado, -> p.idPerfil -> FROM PERFIL p -> WHERE p.NombrePerfil = 'Administrador'; ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY' MariaDB [PatitasAlAire]> exit