Microsoft Windows [Versión 10.0.22631.4890] (c) Microsoft Corporation. Todos los derechos reservados. C:\Users\mfurn>cd/xampp/mysql/bin C:\xampp\mysql\bin>mysql -uroot -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 18 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)]> CREATE DATABASE IF NOT EXISTS Tienda; Query OK, 1 row affected (0.002 sec) MariaDB [(none)]> USE Tienda; Database changed MariaDB [Tienda]> CREATE TABLE Clientes ( -> id_cliente INT AUTO_INCREMENT PRIMARY KEY, -> nombre VARCHAR(100) NOT NULL, -> correo VARCHAR(100) NOT NULL -> ); Query OK, 0 rows affected (0.014 sec) MariaDB [Tienda]> CREATE TABLE Bitacora ( -> id_bitacora INT AUTO_INCREMENT PRIMARY KEY, -> accion VARCHAR(255) NOT NULL, -> fecha TIMESTAMP DEFAULT CURRENT_TIMESTAMP -> ); Query OK, 0 rows affected (0.015 sec) MariaDB [Tienda]> DELIMITER // MariaDB [Tienda]> MariaDB [Tienda]> CREATE TRIGGER after_insert_cliente -> AFTER INSERT ON Clientes -> FOR EACH ROW -> BEGIN -> INSERT INTO Bitacora (accion) -> VALUES (CONCAT('Se ha insertado un nuevo cliente con ID: ', NEW.id_cliente, ', Nombre: ', NEW.nombre)); -> END// Query OK, 0 rows affected (0.015 sec) MariaDB [Tienda]> MariaDB [Tienda]> DELIMITER ; MariaDB [Tienda]> INSERT INTO Clientes (nombre, correo) -> VALUES ('Juan Pérez', 'juanperez@gmail.com'); Query OK, 1 row affected (0.006 sec) MariaDB [Tienda]> SELECT * FROM Bitacora; +-------------+----------------------------------------------------------------+---------------------+ | id_bitacora | accion | fecha | +-------------+----------------------------------------------------------------+---------------------+ | 1 | Se ha insertado un nuevo cliente con ID: 1, Nombre: Juan Pérez | 2025-03-15 19:42:39 | +-------------+----------------------------------------------------------------+---------------------+ 1 row in set (0.001 sec) MariaDB [Tienda]> exit Bye C:\xampp\mysql\bin>mysqldump -b -uroot -p --routines Tienda>c:/xampp/Tienda2.sql mysqldump: unknown option '-b'