Microsoft Windows [Versión 10.0.22631.2506]
(c) Microsoft Corporation. Todos los derechos reservados.

C:\Users\Harold Martinez>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 10
Server version: 10.4.24-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)]> source C:\xampp\zonadecargaBD.sql
Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Database changed
Query OK, 0 rows affected (0.007 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.015 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 10 rows affected (0.002 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.007 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.009 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.008 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 10 rows affected (0.002 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.007 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.013 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 10 rows affected (0.002 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.007 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.009 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.003 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 10 rows affected (0.002 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.006 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.016 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 10 rows affected (0.005 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.007 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.009 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.003 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 10 rows affected (0.002 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.007 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.009 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 10 rows affected (0.002 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.006 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.010 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 10 rows affected (0.002 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.006 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.009 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 10 rows affected (0.002 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

MariaDB [zonadecargaBD]> show tables;
+-------------------------+
| Tables_in_zonadecargabd |
+-------------------------+
| aeroage                 |
| aerolinea               |
| aeronave                |
| agemp                   |
| agencia                 |
| bodeaeroseg             |
| bodega                  |
| empleado                |
| empresa_seguridad       |
| vuelo                   |
+-------------------------+
10 rows in set (0.001 sec)

MariaDB [zonadecargaBD]> create table exportador(nit varchar(10) not null primary key,      
    -> razonsocial varchar(50) not null,         
    -> recordexpo int (5) not null);
ERROR 1813 (HY000): Tablespace for table '`zonadecargabd`.`exportador`' exists. Please DISCARD the tablespace before IMPORT
MariaDB [zonadecargaBD]> create table exportadores(nit varchar(10) not null primary key,      
    -> razonsocial varchar(50) not null,         
    -> recordexpo int (5) not null);
Query OK, 0 rows affected (0.011 sec)

MariaDB [zonadecargaBD]> create table tipomercancia(codtpmercancia varchar(4) not null primary key,      
    -> descripcion varchar(5) not null,     
    -> nit varchar(10) not null,
    -> foreign key(nit) references exportadores(nit) on delete cascade on update cascade);
Query OK, 0 rows affected (0.011 sec)

MariaDB [zonadecargaBD]> show tables;
+-------------------------+
| Tables_in_zonadecargabd |
+-------------------------+
| aeroage                 |
| aerolinea               |
| aeronave                |
| agemp                   |
| agencia                 |
| bodeaeroseg             |
| bodega                  |
| empleado                |
| empresa_seguridad       |
| exportadores            |
| tipomercancia           |
| vuelo                   |
+-------------------------+
12 rows in set (0.001 sec)

MariaDB [zonadecargaBD]> insert into exportadores(nit, razonsocial, recordexpo) values('1234567891','FAMILIA',103);
Query OK, 1 row affected (0.005 sec)

MariaDB [zonadecargaBD]> insert into exportadores(nit, razonsocial, recordexpo) values('8521478963','COLCAFE',450);
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into exportadores(nit, razonsocial, recordexpo) values('9632587412','GALLETAS NOEL',453);
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into exportadores(nit, razonsocial, recordexpo) values('2598745621','NUVANT',50);
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into exportadores(nit, razonsocial, recordexpo) values('1245856854','LEONISA',1221);
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aeronave(matricula, capacidad, codaerolinea) values('AK65B',4000,'A01','Boeing');
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [zonadecargaBD]> insert into aeronave(matricula, capacidad, codaerolinea) values('N57B',5000,'A02','Airbus');
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [zonadecargaBD]> insert into aeronave(matricula, capacidad, codaerolinea) values('HK569',3000,'A03','Safran');
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [zonadecargaBD]> insert into aeronave(matricula, capacidad, codaerolinea) values('T28T',4000,'A04','Boeing');
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [zonadecargaBD]> insert into aeronave(matricula, capacidad, codaerolinea) values('ASDFF',5000,'A02','Airbus');
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [zonadecargaBD]> insert into aeronave(matricula, capacidad, codaerolinea) values('AM709',3000,'A03','Safran');
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [zonadecargaBD]> insert into aeronave(matricula, capacidad, codaerolinea) values('N589',5000,'A07','Boeing');
ERROR 1136 (21S01): Column count doesn't match value count at row 1
MariaDB [zonadecargaBD]> insert into aeronave(matricula, capacidad, codaerolinea, marca) values('AK65B',4000,'A01','Boeing');
Query OK, 1 row affected (0.003 sec)

MariaDB [zonadecargaBD]> insert into aeronave(matricula, capacidad, codaerolinea, marca) values('N57B',5000,'A02','Airbus');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [zonadecargaBD]> insert into aeronave(matricula, capacidad, codaerolinea, marca) values('HK569',3000,'A03','Safran');
Query OK, 1 row affected, 1 warning (0.002 sec)

MariaDB [zonadecargaBD]> insert into aeronave(matricula, capacidad, codaerolinea, marca) values('T28T',4000,'A04','Boeing');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aeronave(matricula, capacidad, codaerolinea, marca) values('ASDFF',5000,'A02','Airbus');
Query OK, 1 row affected, 1 warning (0.001 sec)

MariaDB [zonadecargaBD]> insert into aeronave(matricula, capacidad, codaerolinea, marca) values('AM709',3000,'A03','Safran');
Query OK, 1 row affected, 1 warning (0.001 sec)

MariaDB [zonadecargaBD]> insert into aeronave(matricula, capacidad, codaerolinea, marca) values('N589',5000,'A07','Boeing');
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> Delimiter //
MariaDB [zonadecargaBD]> Create procedure listar_empleados()
    -> Begin
    -> Select * from empleado;
    -> End
    -> //
Query OK, 0 rows affected (0.008 sec)

MariaDB [zonadecargaBD]> Call listar_empleados;
    -> Delimiter //
+------------+-----------------+------------+----------------------+
| idempleado | nombre          | telefono   | email                |
+------------+-----------------+------------+----------------------+
| E01        | Juan Rodriguez  | 9632145875 | juan@correo.com      |
| E02        | Pepe Peralta    | 1265987501 | pepe@correo.com      |
| E03        | Karen Martinez  | 3366559902 | karen@correo.com     |
| E04        | Jose Hernandez  | 3214785203 | jose@correo.com      |
| E05        | Estefania Perez | 9517896321 | estefa@correo.com    |
| E06        | Alejandra Lopez | 1593578520 | alejandra@correo.com |
| E07        | Camila Sanpedro | 3520006980 | camila@correo.com    |
| E08        | Kevin Jaramillo | 3398713650 | kevin@correo.com     |
| E09        | Viky Rivera     | 9635874120 | viky@correo.com      |
| E10        | Sergio Ramos    | 9631578758 | sergio@correo.com    |
+------------+-----------------+------------+----------------------+
10 rows in set (0.004 sec)

Query OK, 0 rows affected (0.028 sec)

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 'Delimiter' at line 1
MariaDB [zonadecargaBD]> Call listar_empleados;
    -> //
+------------+-----------------+------------+----------------------+
| idempleado | nombre          | telefono   | email                |
+------------+-----------------+------------+----------------------+
| E01        | Juan Rodriguez  | 9632145875 | juan@correo.com      |
| E02        | Pepe Peralta    | 1265987501 | pepe@correo.com      |
| E03        | Karen Martinez  | 3366559902 | karen@correo.com     |
| E04        | Jose Hernandez  | 3214785203 | jose@correo.com      |
| E05        | Estefania Perez | 9517896321 | estefa@correo.com    |
| E06        | Alejandra Lopez | 1593578520 | alejandra@correo.com |
| E07        | Camila Sanpedro | 3520006980 | camila@correo.com    |
| E08        | Kevin Jaramillo | 3398713650 | kevin@correo.com     |
| E09        | Viky Rivera     | 9635874120 | viky@correo.com      |
| E10        | Sergio Ramos    | 9631578758 | sergio@correo.com    |
+------------+-----------------+------------+----------------------+
10 rows in set (0.001 sec)

Query OK, 0 rows affected (0.023 sec)

MariaDB [zonadecargaBD]> Delimiter //
MariaDB [zonadecargaBD]> ;
    -> Delimiter //
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 ';
Delimiter' at line 1
MariaDB [zonadecargaBD]> show procedure;
    ->
    -> //
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 '' at line 1
MariaDB [zonadecargaBD]> Call listar_empleados;
    -> //
+------------+-----------------+------------+----------------------+
| idempleado | nombre          | telefono   | email                |
+------------+-----------------+------------+----------------------+
| E01        | Juan Rodriguez  | 9632145875 | juan@correo.com      |
| E02        | Pepe Peralta    | 1265987501 | pepe@correo.com      |
| E03        | Karen Martinez  | 3366559902 | karen@correo.com     |
| E04        | Jose Hernandez  | 3214785203 | jose@correo.com      |
| E05        | Estefania Perez | 9517896321 | estefa@correo.com    |
| E06        | Alejandra Lopez | 1593578520 | alejandra@correo.com |
| E07        | Camila Sanpedro | 3520006980 | camila@correo.com    |
| E08        | Kevin Jaramillo | 3398713650 | kevin@correo.com     |
| E09        | Viky Rivera     | 9635874120 | viky@correo.com      |
| E10        | Sergio Ramos    | 9631578758 | sergio@correo.com    |
+------------+-----------------+------------+----------------------+
10 rows in set (0.001 sec)

Query OK, 0 rows affected (0.027 sec)

MariaDB [zonadecargaBD]> show procedures;
    -> //
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 'procedures' at line 1
MariaDB [zonadecargaBD]> show procedure;
    -> //
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 '' at line 1
MariaDB [zonadecargaBD]> Show procedure status;
    -> //
+---------------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db            | Name               | Type      | Definer        | Modified            | Created             | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+---------------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| dburgencias   | consultar_paciente | PROCEDURE | root@localhost | 2023-08-06 17:17:39 | 2023-08-06 17:17:39 | DEFINER       |         | cp850
   | cp850_general_ci     | utf8mb4_general_ci |
| dburgencias   | eliminar_paciente  | PROCEDURE | root@localhost | 2023-08-06 17:37:44 | 2023-08-06 17:37:44 | DEFINER       |         | cp850
   | cp850_general_ci     | utf8mb4_general_ci |
| dburgencias   | insertar_paciente  | PROCEDURE | root@localhost | 2023-08-06 17:08:09 | 2023-08-06 17:08:09 | DEFINER       |         | cp850
   | cp850_general_ci     | utf8mb4_general_ci |
| dburgencias   | listar_paciente    | PROCEDURE | root@localhost | 2023-08-06 17:15:12 | 2023-08-06 17:15:12 | DEFINER       |         | cp850
   | cp850_general_ci     | utf8mb4_general_ci |
| dburgencias   | modificar_paciente | PROCEDURE | root@localhost | 2023-08-06 17:35:56 | 2023-08-06 17:35:56 | DEFINER       |         | cp850
   | cp850_general_ci     | utf8mb4_general_ci |
| zonadecargabd | listar_empleados   | PROCEDURE | root@localhost | 2023-11-13 13:33:53 | 2023-11-13 13:33:53 | DEFINER       |         | cp850
   | cp850_general_ci     | utf8mb4_general_ci |
+---------------+--------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
6 rows in set (0.004 sec)

MariaDB [zonadecargaBD]> Delimiter //
MariaDB [zonadecargaBD]> Create procedure consultar_empleado(in _idempleado char(4))
    -> Begin
    -> Select *from empleado where idempleado=_idempleado;
    -> End
    -> //
Query OK, 0 rows affected (0.006 sec)

MariaDB [zonadecargaBD]> Call consultar_empleado('E03');
    -> //
+------------+----------------+------------+------------------+
| idempleado | nombre         | telefono   | email            |
+------------+----------------+------------+------------------+
| E03        | Karen Martinez | 3366559902 | karen@correo.com |
+------------+----------------+------------+------------------+
1 row in set (0.001 sec)

Query OK, 0 rows affected (0.004 sec)

MariaDB [zonadecargaBD]> select current_date();
    -> //
+----------------+
| current_date() |
+----------------+
| 2023-11-13     |
+----------------+
1 row in set (0.001 sec)

MariaDB [zonadecargaBD]> delimiter //
MariaDB [zonadecargaBD]> create trigger listaraeronaves before insert on aeronave
    -> for each row
    -> begin
    -> select * from aeronave;
    -> end
    -> //
ERROR 1415 (0A000): Not allowed to return a result set from a trigger
MariaDB [zonadecargaBD]> show triggers;
    -> //
Empty set (0.005 sec)

MariaDB [zonadecargaBD]> delimiter //
MariaDB [zonadecargaBD]> create trigger listaraeronaves after delete on aeronave
    -> for each row
    -> Begin
    -> select * from aeronave;
    -> end
    -> //
ERROR 1415 (0A000): Not allowed to return a result set from a trigger
MariaDB [zonadecargaBD]> delimiter //
MariaDB [zonadecargaBD]> create trigger listaraeronaves after insert on aeronave
    -> for each row
    -> begin
    -> select * from aerolinea;
    -> end
    -> //
ERROR 1415 (0A000): Not allowed to return a result set from a trigger
MariaDB [zonadecargaBD]> select nit,razonsocial from exportador where substr(nit, 1,2)in ('12’);
    -> //
ERROR 1146 (42S02): Table 'zonadecargabd.exportador' doesn't exist
MariaDB [zonadecargaBD]> select nit,razonsocial from exportadores where substr(nit, 1,2)in ('12’);
    -> //
+------------+-------------+
| nit        | razonsocial |
+------------+-------------+
| 1234567891 | FAMILIA     |
| 1245856854 | LEONISA     |
+------------+-------------+
2 rows in set (0.001 sec)

MariaDB [zonadecargaBD]> Select destino,if(cantidad>05, ‘Bastantes’,’Pocos’) Cantidad_de_vuelos from vuelo;
    -> //
ERROR 1054 (42S22): Unknown column 'cantidad' in 'field list'
MariaDB [zonadecargaBD]> Select destino,if(destino>05, ‘Bastantes’,’Pocos’) Cantidad_de_vuelos from vuelo;
    -> //
+----------+--------------------+
| destino  | Cantidad_de_vuelos |
+----------+--------------------+
| Miami    | Pocos              |
| Madrid   | Pocos              |
| San Jose | Pocos              |
| Lima     | Pocos              |
| Panama   | Pocos              |
| New York | Pocos              |
| San Juan | Pocos              |
| Cancun   | Pocos              |
| Mexico   | Pocos              |
| Montreal | Pocos              |
+----------+--------------------+
10 rows in set, 10 warnings (0.001 sec)

MariaDB [zonadecargaBD]> select destino, hora, case when((hora) in (BETWEEN 00:00 AND 11:59)) then 'Mañana' when ((hora) in (BETWEEN 12:00 AND 18:59))then 'Tarde' else 'Noche' end as 'Horario' from vuelo;
    -> //
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 'BETWEEN 00:00 AND 11:59)) then 'Mañana' when ((hora) in (BETWEEN 12:00 AND 1...' at line 1
MariaDB [zonadecargaBD]> select * from aeronave where marca like ‘%Boeing%’ and marca like ‘%Airbus%’;
    -> //
Empty set (0.001 sec)

MariaDB [zonadecargaBD]> select * from aeronave where marca like ‘%Boeing%’ or marca like ‘%Airbus%’;
    -> //
+-----------+-----------+--------+--------------+
| matricula | capacidad | marca  | codaerolinea |
+-----------+-----------+--------+--------------+
| AK65B     |      4000 | Boeing | A01          |
| N589      |      5000 | Boeing | A07          |
| T28T      |      4000 | Boeing | A04          |
+-----------+-----------+--------+--------------+
3 rows in set (0.001 sec)

MariaDB [zonadecargaBD]> select nivel as Nivel, count(*) as Cantidad from agencia group by nivel;
    -> //
+-------+----------+
| Nivel | Cantidad |
+-------+----------+
| 1     |        3 |
| 2     |        4 |
| 3     |        3 |
+-------+----------+
3 rows in set (0.003 sec)

MariaDB [zonadecargaBD]> Create table registrocursos
    -> select nivel as Nivel, count(*) as Cantidad from agencia group by nivel;
    -> //
Query OK, 3 rows affected (0.014 sec)
Records: 3  Duplicates: 0  Warnings: 0

MariaDB [zonadecargaBD]> select * from registrocursos;
    -> //
+-------+----------+
| Nivel | Cantidad |
+-------+----------+
| 1     |        3 |
| 2     |        4 |
| 3     |        3 |
+-------+----------+
3 rows in set (0.001 sec)

MariaDB [zonadecargaBD]> delimiter //
MariaDB [zonadecargaBD]> create trigger listaraeronaves after insert on aerolinea
    -> for each row
    -> begin
    -> update aeronave set capacidad = (select capacidad + 1000 from aerolinea where aerolinea.codaerolinea = aeronave.matricula);
    -> end
    -> //
Query OK, 0 rows affected (0.009 sec)

MariaDB [zonadecargaBD]> delimiter ;
MariaDB [zonadecargaBD]> show triggers;
+-----------------+--------+-----------+----------------------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------+----------------+----------------------+----------------------+--------------------+
| Trigger         | Event  | Table     | Statement                                                                                                                              | Timing | Created                | sql_mode                                            | Definer        | character_set_client | collation_connection | Database Collation |
+-----------------+--------+-----------+----------------------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------+----------------+----------------------+----------------------+--------------------+
| listaraeronaves | INSERT | aerolinea | begin
update aeronave set capacidad = (select capacidad + 1000 from aerolinea where aerolinea.codaerolinea = aeronave.matricula);
end | AFTER  | 2023-11-13 13:58:20.51 | NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION | root@localhost | cp850                | cp850_general_ci     | utf8mb4_general_ci |
+-----------------+--------+-----------+----------------------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------+----------------+----------------------+----------------------+--------------------+
1 row in set (0.006 sec)

MariaDB [zonadecargaBD]> insert into aerolinea(codaerolinea, nombre) values('A15','Airnew');
Query OK, 1 row affected (0.008 sec)

MariaDB [zonadecargaBD]> select * from aeronave;
+-----------+-----------+--------+--------------+
| matricula | capacidad | marca  | codaerolinea |
+-----------+-----------+--------+--------------+
| AK65B     |         0 | Boeing | A01          |
| AM709     |         0 |        | A03          |
| ASDFF     |         0 |        | A02          |
| HK569     |         0 |        | A03          |
| N57B      |         0 |        | A02          |
| N589      |         0 | Boeing | A07          |
| T28T      |         0 | Boeing | A04          |
+-----------+-----------+--------+--------------+
7 rows in set (0.001 sec)

MariaDB [zonadecargaBD]> exit
Bye

C:\xampp\mysql\bin>mysqldump -B -uroot -p zonadecargabd>c:/xampp/zonadecargabd.sql
Enter password: