MariaDB [(none)]> create database matriculauni; Query OK, 1 row affected (0.001 sec) MariaDB [(none)]> use matriculauni; Database changed MariaDB [matriculauni]> create table estudiante -> (idestu varchar(4) not null primary key, -> nomestu varchar(80) not null, -> fechanaci date not null, -> programa varchar(60) not null, -> valmatricula int(10) not null); Query OK, 0 rows affected (0.254 sec) MariaDB [matriculauni]> describe estudiante; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | idestu | varchar(4) | NO | PRI | NULL | | | nomestu | varchar(80) | NO | | NULL | | | fechanaci | date | NO | | NULL | | | programa | varchar(60) | NO | | NULL | | | valmatricula | int(10) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 5 rows in set (0.024 sec) MariaDB [matriculauni]> create table materia -> (codmate varchar(4) not null primary key, -> nommate varchar(60) not null, -> cantcreditos int(10) not null, -> valcredito int(10) not null, -> valtotal int(10) not null); Query OK, 0 rows affected (0.227 sec) MariaDB [matriculauni]> describe materia; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | codmate | varchar(4) | NO | PRI | NULL | | | nommate | varchar(60) | NO | | NULL | | | cantcreditos | int(10) | NO | | NULL | | | valcredito | int(10) | NO | | NULL | | | valtotal | int(10) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 5 rows in set (0.026 sec) MariaDB [matriculauni]> create table matricula -> (idestu varchar(4) not null, -> codmate varchar(4) not null, -> foreign key (idestu) references estudiante(idestu) on delete cascade on update cascade, -> foreign key (codmate) references materia(codmate) on delete cascade on update cascade); Query OK, 0 rows affected (0.261 sec) MariaDB [matriculauni]> describe matricula; +---------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+------------+------+-----+---------+-------+ | idestu | varchar(4) | NO | MUL | NULL | | | codmate | varchar(4) | NO | MUL | NULL | | +---------+------------+------+-----+---------+-------+ 2 rows in set (0.023 sec) MariaDB [matriculauni]> insert into estudiante (idestu, nomestu, fechanaci, programa, valmatricula)values('001', 'Juan P‚rez', '2000-05-15', 'Ingenierˇa Inform tica', 0),('002', 'Marˇa Garcˇa', '2001-10-20', 'Administraci˘n de Empresas', 0),('003', 'Carlos Martˇnez', '1999-03-08', 'Psicologˇa', 0),('004', 'Ana L˘pez', '2002-08-25', 'Medicina', 0),('005', 'Pedro Ramˇrez', '2000-12-10', 'Derecho', 0); Query OK, 5 rows affected (0.217 sec) Records: 5 Duplicates: 0 Warnings: 0 MariaDB [matriculauni]> select * from estudiante; +--------+-----------------+------------+----------------------------+--------------+ | idestu | nomestu | fechanaci | programa | valmatricula | +--------+-----------------+------------+----------------------------+--------------+ | 001 | Juan P‚rez | 2000-05-15 | Ingenierˇa Inform tica | 0 | | 002 | Marˇa Garcˇa | 2001-10-20 | Administraci˘n de Empresas | 0 | | 003 | Carlos Martˇnez | 1999-03-08 | Psicologˇa | 0 | | 004 | Ana L˘pez | 2002-08-25 | Medicina | 0 | | 005 | Pedro Ramˇrez | 2000-12-10 | Derecho | 0 | +--------+-----------------+------------+----------------------------+--------------+ 5 rows in set (0.000 sec) MariaDB [matriculauni]> delimiter // MariaDB [matriculauni]> create trigger calvalmateria before insert on materia -> for each row -> begin -> set new.valtotal=new.valcredito*new.cantcreditos; -> end -> // Query OK, 0 rows affected (0.114 sec) MariaDB [matriculauni]> delimiter ; MariaDB [matriculauni]> show triggers; +---------------+--------+---------+-------------------------------------------------------------+--------+------------------------+-----------------------------------------------------+----------------+----------------------+----------------------+--------------------+ | Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation | +---------------+--------+---------+-------------------------------------------------------------+--------+------------------------+-----------------------------------------------------+----------------+----------------------+----------------------+--------------------+ | calvalmateria | INSERT | materia | begin set new.valtotal=new.valcredito*new.cantcreditos; end | BEFORE | 2024-03-03 16:24:40.17 | NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION | root@localhost | cp850 | cp850_general_ci | utf8mb4_general_ci | +---------------+--------+---------+-------------------------------------------------------------+--------+------------------------+-----------------------------------------------------+----------------+----------------------+----------------------+--------------------+ 1 row in set (0.028 sec) MariaDB [matriculauni]> insert into materia ('001', 'Introducci˘n a la Programaci˘n', 4, 150000, 0); 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 ''001', 'Introducci˘n a la Programaci˘n', 4, 150000, 0)' at line 1 MariaDB [matriculauni]> insert into materia values ('001', 'Introducci˘n a la Programaci˘n', 4, 150000, 0); Query OK, 1 row affected (0.117 sec) MariaDB [matriculauni]> select * from materia; +---------+--------------------------------+--------------+------------+----------+ | codmate | nommate | cantcreditos | valcredito | valtotal | +---------+--------------------------------+--------------+------------+----------+ | 001 | Introducci˘n a la Programaci˘n | 4 | 150000 | 600000 | +---------+--------------------------------+--------------+------------+----------+ 1 row in set (0.000 sec) MariaDB [matriculauni]> insert into materia (codmate, nommate, cantcreditos, valcredito, valtotal)values('002', 'Contabilidad B sica', 3, 120000, 0),('003', 'Psicologˇa General', 5, 140000, 0),('004', 'Anatomˇa Humana', 6, 180000, 0),('005', 'Derecho Civil', 4, 160000, 0); Query OK, 4 rows affected (0.107 sec) Records: 4 Duplicates: 0 Warnings: 0 MariaDB [matriculauni]> select * from materia; +---------+--------------------------------+--------------+------------+----------+ | codmate | nommate | cantcreditos | valcredito | valtotal | +---------+--------------------------------+--------------+------------+----------+ | 001 | Introducci˘n a la Programaci˘n | 4 | 150000 | 600000 | | 002 | Contabilidad B sica | 3 | 120000 | 360000 | | 003 | Psicologˇa General | 5 | 140000 | 700000 | | 004 | Anatomˇa Humana | 6 | 180000 | 1080000 | | 005 | Derecho Civil | 4 | 160000 | 640000 | +---------+--------------------------------+--------------+------------+----------+ 5 rows in set (0.000 sec) MariaDB [matriculauni]> update estudiante set valmatricula=(select sum(materia.valtotal) from matricula inner join materia on matricula.codmateria=materia.codmateria where materia.idestu=estudiante.idestu); ERROR 1054 (42S22): Unknown column 'materia.idestu' in 'where clause' MariaDB [matriculauni]> update estudiante set valmatricula=(select sum(materia.valtotal) from matricula inner join materia on matricula.codmateria=materia.codmateria where matricula.idestu=estudiante.idestu); ERROR 1054 (42S22): Unknown column 'matricula.codmateria' in 'on clause' MariaDB [matriculauni]> update estudiante set valmatricula=(select sum(materia.valtotal) from matricula inner join materia on matricula.codmate=materia.codmate where matricula.idestu=estudiante.idestu); Query OK, 0 rows affected, 5 warnings (0.043 sec) Rows matched: 5 Changed: 0 Warnings: 5 MariaDB [matriculauni]> update estudiante set valmatricula=(select sum(materia.valtotal) from matricula inner join materia on matricula.codmate=materia.codmate where matricula.idestu=estudiante.idestu) -> : -> ; 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 [matriculauni]> select * from materia; +---------+--------------------------------+--------------+------------+----------+ | codmate | nommate | cantcreditos | valcredito | valtotal | +---------+--------------------------------+--------------+------------+----------+ | 001 | Introducci˘n a la Programaci˘n | 4 | 150000 | 600000 | | 002 | Contabilidad B sica | 3 | 120000 | 360000 | | 003 | Psicologˇa General | 5 | 140000 | 700000 | | 004 | Anatomˇa Humana | 6 | 180000 | 1080000 | | 005 | Derecho Civil | 4 | 160000 | 640000 | +---------+--------------------------------+--------------+------------+----------+ 5 rows in set (0.000 sec) MariaDB [matriculauni]> select * from estudiante; +--------+-----------------+------------+----------------------------+--------------+ | idestu | nomestu | fechanaci | programa | valmatricula | +--------+-----------------+------------+----------------------------+--------------+ | 001 | Juan P‚rez | 2000-05-15 | Ingenierˇa Inform tica | 0 | | 002 | Marˇa Garcˇa | 2001-10-20 | Administraci˘n de Empresas | 0 | | 003 | Carlos Martˇnez | 1999-03-08 | Psicologˇa | 0 | | 004 | Ana L˘pez | 2002-08-25 | Medicina | 0 | | 005 | Pedro Ramˇrez | 2000-12-10 | Derecho | 0 | +--------+-----------------+------------+----------------------------+--------------+ 5 rows in set (0.000 sec) MariaDB [matriculauni]> select * from matricula; Empty set (0.000 sec) MariaDB [matriculauni]> insert into matricula values("001","001"); Query OK, 1 row affected (0.066 sec) MariaDB [matriculauni]> select * from matricula; +--------+---------+ | idestu | codmate | +--------+---------+ | 001 | 001 | +--------+---------+ 1 row in set (0.000 sec) MariaDB [matriculauni]> update estudiante set valmatricula=(select sum(materia.valtotal) from matricula inner join materia on matricula.codmate=materia.codmate where matricula.idestu=estudiante.idestu); Query OK, 1 row affected, 4 warnings (0.066 sec) Rows matched: 5 Changed: 1 Warnings: 4 MariaDB [matriculauni]> select * from estudiante; +--------+-----------------+------------+----------------------------+--------------+ | idestu | nomestu | fechanaci | programa | valmatricula | +--------+-----------------+------------+----------------------------+--------------+ | 001 | Juan P‚rez | 2000-05-15 | Ingenierˇa Inform tica | 600000 | | 002 | Marˇa Garcˇa | 2001-10-20 | Administraci˘n de Empresas | 0 | | 003 | Carlos Martˇnez | 1999-03-08 | Psicologˇa | 0 | | 004 | Ana L˘pez | 2002-08-25 | Medicina | 0 | | 005 | Pedro Ramˇrez | 2000-12-10 | Derecho | 0 | +--------+-----------------+------------+----------------------------+--------------+ 5 rows in set (0.000 sec) MariaDB [matriculauni]> insert into values("001","002"); 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 'values("001","002")' at line 1 MariaDB [matriculauni]> insert into matricula values("001","002"); Query OK, 1 row affected (0.075 sec) MariaDB [matriculauni]> select * from matricula; +--------+---------+ | idestu | codmate | +--------+---------+ | 001 | 001 | | 001 | 002 | +--------+---------+ 2 rows in set (0.000 sec) MariaDB [matriculauni]> select * from estudiante; +--------+-----------------+------------+----------------------------+--------------+ | idestu | nomestu | fechanaci | programa | valmatricula | +--------+-----------------+------------+----------------------------+--------------+ | 001 | Juan P‚rez | 2000-05-15 | Ingenierˇa Inform tica | 600000 | | 002 | Marˇa Garcˇa | 2001-10-20 | Administraci˘n de Empresas | 0 | | 003 | Carlos Martˇnez | 1999-03-08 | Psicologˇa | 0 | | 004 | Ana L˘pez | 2002-08-25 | Medicina | 0 | | 005 | Pedro Ramˇrez | 2000-12-10 | Derecho | 0 | +--------+-----------------+------------+----------------------------+--------------+ 5 rows in set (0.000 sec) MariaDB [matriculauni]> update estudiante set valmatricula=(select sum(materia.valtotal) from matricula inner join materia on matricula.codmate=materia.codmate where matricula.idestu=estudiante.idestu); Query OK, 1 row affected, 4 warnings (0.085 sec) Rows matched: 5 Changed: 1 Warnings: 4 MariaDB [matriculauni]> select * from estudiante; +--------+-----------------+------------+----------------------------+--------------+ | idestu | nomestu | fechanaci | programa | valmatricula | +--------+-----------------+------------+----------------------------+--------------+ | 001 | Juan P‚rez | 2000-05-15 | Ingenierˇa Inform tica | 960000 | | 002 | Marˇa Garcˇa | 2001-10-20 | Administraci˘n de Empresas | 0 | | 003 | Carlos Martˇnez | 1999-03-08 | Psicologˇa | 0 | | 004 | Ana L˘pez | 2002-08-25 | Medicina | 0 | | 005 | Pedro Ramˇrez | 2000-12-10 | Derecho | 0 | +--------+-----------------+------------+----------------------------+--------------+ 5 rows in set (0.000 sec) MariaDB [matriculauni]> drop table matricula; Query OK, 0 rows affected (0.194 sec) MariaDB [matriculauni]> select * from matricula; ERROR 1146 (42S02): Table 'matriculauni.matricula' doesn't exist MariaDB [matriculauni]> create table matricula -> -> (idestu varchar(4) not null, -> -> codmate varchar(4) not null, -> -> foreign key (idestu) references estudiante(idestu) on delete cascade on update cascade, -> -> foreign key (codmate) references materia(codmate) 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 '-> (idestu varchar(4) not null, -> codmate varchar(4) not null, -> fo...' at line 2 MariaDB [matriculauni]> create table matricula -> -> (idestu varchar(4) not null, -> -> codmate varchar(4) not null, -> -> foreign key (idestu) references estudiante(idestu) on delete cascade on update cascade, -> -> foreign key (codmate) references materia(codmate) 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 '-> (idestu varchar(4) not null, -> codmate varchar(4) not null, -> fo...' at line 2 MariaDB [matriculauni]> create table matricula(idestu varchar(4) not null,codmate varchar(4) not null,foreign key (idestu) references estudiante(idestu) on delete cascade on update cascade,foreign key (codmate) references materia(codmate) on delete cascade on update cascade); Query OK, 0 rows affected (0.260 sec) MariaDB [matriculauni]> delete table matricula; 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 'table matricula' at line 1 MariaDB [matriculauni]> delete matricula; 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 [matriculauni]> delete from matricula; Query OK, 0 rows affected (0.002 sec) MariaDB [matriculauni]> update estudiante set valmatricula=0 where idestu="001"; Query OK, 1 row affected (0.080 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [matriculauni]> select * from estudiante; +--------+-----------------+------------+----------------------------+--------------+ | idestu | nomestu | fechanaci | programa | valmatricula | +--------+-----------------+------------+----------------------------+--------------+ | 001 | Juan P‚rez | 2000-05-15 | Ingenierˇa Inform tica | 0 | | 002 | Marˇa Garcˇa | 2001-10-20 | Administraci˘n de Empresas | 0 | | 003 | Carlos Martˇnez | 1999-03-08 | Psicologˇa | 0 | | 004 | Ana L˘pez | 2002-08-25 | Medicina | 0 | | 005 | Pedro Ramˇrez | 2000-12-10 | Derecho | 0 | +--------+-----------------+------------+----------------------------+--------------+ 5 rows in set (0.000 sec) MariaDB [matriculauni]> delimiter // MariaDB [matriculauni]> creater trigger actulizar_valmatricula after insert on matricula -> for each row -> begin -> update estudiante set valmatricula=(select sum(materia.valtotal) from matricula inner join materia on matricula.codmate=materia.codmate where matricula.idestu=estudiante.idestu); -> end -> // 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 'creater trigger actulizar_valmatricula after insert on matricula for each row...' at line 1 MariaDB [matriculauni]> delimiter // MariaDB [matriculauni]> create trigger actulizar_valmatricula after insert on matricula -> for each row -> begin -> update estudiante set valmatricula=(select sum(materia.valtotal) from matricula inner join materia on matricula.codmate=materia.codmate where matricula.idestu=estudiante.idestu); -> end -> // Query OK, 0 rows affected (0.104 sec) MariaDB [matriculauni]> delimiter ; MariaDB [matriculauni]> show triggers; +------------------------+--------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------+----------------+----------------------+----------------------+--------------------+ | Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation | +------------------------+--------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------+----------------+----------------------+----------------------+--------------------+ | calvalmateria | INSERT | materia | begin set new.valtotal=new.valcredito*new.cantcreditos; end | BEFORE | 2024-03-03 16:24:40.17 | NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION | root@localhost | cp850 | cp850_general_ci | utf8mb4_general_ci | | actulizar_valmatricula | INSERT | matricula | begin update estudiante set valmatricula=(select sum(materia.valtotal) from matricula inner join materia on matricula.codmate=materia.codmate where matricula.idestu=estudiante.idestu); end | AFTER | 2024-03-03 17:13:34.22 | NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION | root@localhost | cp850 | cp850_general_ci | utf8mb4_general_ci | +------------------------+--------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------+----------------+----------------------+----------------------+--------------------+ 2 rows in set (0.026 sec) MariaDB [matriculauni]> insert into matricula values("001","001"); Query OK, 1 row affected (0.078 sec) MariaDB [matriculauni]> select * from estudiante; +--------+-----------------+------------+----------------------------+--------------+ | idestu | nomestu | fechanaci | programa | valmatricula | +--------+-----------------+------------+----------------------------+--------------+ | 001 | Juan P‚rez | 2000-05-15 | Ingenierˇa Inform tica | 600000 | | 002 | Marˇa Garcˇa | 2001-10-20 | Administraci˘n de Empresas | 0 | | 003 | Carlos Martˇnez | 1999-03-08 | Psicologˇa | 0 | | 004 | Ana L˘pez | 2002-08-25 | Medicina | 0 | | 005 | Pedro Ramˇrez | 2000-12-10 | Derecho | 0 | +--------+-----------------+------------+----------------------------+--------------+ 5 rows in set (0.000 sec) MariaDB [matriculauni]> insert into matricula values("001","002"); Query OK, 1 row affected (0.053 sec) MariaDB [matriculauni]> select * from estudiante; +--------+-----------------+------------+----------------------------+--------------+ | idestu | nomestu | fechanaci | programa | valmatricula | +--------+-----------------+------------+----------------------------+--------------+ | 001 | Juan P‚rez | 2000-05-15 | Ingenierˇa Inform tica | 960000 | | 002 | Marˇa Garcˇa | 2001-10-20 | Administraci˘n de Empresas | 0 | | 003 | Carlos Martˇnez | 1999-03-08 | Psicologˇa | 0 | | 004 | Ana L˘pez | 2002-08-25 | Medicina | 0 | | 005 | Pedro Ramˇrez | 2000-12-10 | Derecho | 0 | +--------+-----------------+------------+----------------------------+--------------+ 5 rows in set (0.001 sec) MariaDB [matriculauni]> select * from materia; +---------+--------------------------------+--------------+------------+----------+ | codmate | nommate | cantcreditos | valcredito | valtotal | +---------+--------------------------------+--------------+------------+----------+ | 001 | Introducci˘n a la Programaci˘n | 4 | 150000 | 600000 | | 002 | Contabilidad B sica | 3 | 120000 | 360000 | | 003 | Psicologˇa General | 5 | 140000 | 700000 | | 004 | Anatomˇa Humana | 6 | 180000 | 1080000 | | 005 | Derecho Civil | 4 | 160000 | 640000 | +---------+--------------------------------+--------------+------------+----------+ 5 rows in set (0.000 sec) MariaDB [matriculauni]> insert into matricula values("002","002"); Query OK, 1 row affected (0.082 sec) MariaDB [matriculauni]> select * from estudiante; +--------+-----------------+------------+----------------------------+--------------+ | idestu | nomestu | fechanaci | programa | valmatricula | +--------+-----------------+------------+----------------------------+--------------+ | 001 | Juan P‚rez | 2000-05-15 | Ingenierˇa Inform tica | 960000 | | 002 | Marˇa Garcˇa | 2001-10-20 | Administraci˘n de Empresas | 360000 | | 003 | Carlos Martˇnez | 1999-03-08 | Psicologˇa | 0 | | 004 | Ana L˘pez | 2002-08-25 | Medicina | 0 | | 005 | Pedro Ramˇrez | 2000-12-10 | Derecho | 0 | +--------+-----------------+------------+----------------------------+--------------+ 5 rows in set (0.000 sec) MariaDB [matriculauni]> insert into matricula values("003","002"); Query OK, 1 row affected (0.122 sec) MariaDB [matriculauni]> select * from estudiante; +--------+-----------------+------------+----------------------------+--------------+ | idestu | nomestu | fechanaci | programa | valmatricula | +--------+-----------------+------------+----------------------------+--------------+ | 001 | Juan P‚rez | 2000-05-15 | Ingenierˇa Inform tica | 960000 | | 002 | Marˇa Garcˇa | 2001-10-20 | Administraci˘n de Empresas | 360000 | | 003 | Carlos Martˇnez | 1999-03-08 | Psicologˇa | 360000 | | 004 | Ana L˘pez | 2002-08-25 | Medicina | 0 | | 005 | Pedro Ramˇrez | 2000-12-10 | Derecho | 0 | +--------+-----------------+------------+----------------------------+--------------+ 5 rows in set (0.000 sec) MariaDB [matriculauni]> insert into matricula values("003","003"); Query OK, 1 row affected (0.053 sec) MariaDB [matriculauni]> select * from estudiante; +--------+-----------------+------------+----------------------------+--------------+ | idestu | nomestu | fechanaci | programa | valmatricula | +--------+-----------------+------------+----------------------------+--------------+ | 001 | Juan P‚rez | 2000-05-15 | Ingenierˇa Inform tica | 960000 | | 002 | Marˇa Garcˇa | 2001-10-20 | Administraci˘n de Empresas | 360000 | | 003 | Carlos Martˇnez | 1999-03-08 | Psicologˇa | 1060000 | | 004 | Ana L˘pez | 2002-08-25 | Medicina | 0 | | 005 | Pedro Ramˇrez | 2000-12-10 | Derecho | 0 | +--------+-----------------+------------+----------------------------+--------------+ 5 rows in set (0.000 sec) MariaDB [matriculauni]> insert into matricula values("004","004"); Query OK, 1 row affected (0.161 sec) MariaDB [matriculauni]> insert into matricula values("005","005"); Query OK, 1 row affected (0.060 sec) MariaDB [matriculauni]> select * from estudiante; +--------+-----------------+------------+----------------------------+--------------+ | idestu | nomestu | fechanaci | programa | valmatricula | +--------+-----------------+------------+----------------------------+--------------+ | 001 | Juan P‚rez | 2000-05-15 | Ingenierˇa Inform tica | 960000 | | 002 | Marˇa Garcˇa | 2001-10-20 | Administraci˘n de Empresas | 360000 | | 003 | Carlos Martˇnez | 1999-03-08 | Psicologˇa | 1060000 | | 004 | Ana L˘pez | 2002-08-25 | Medicina | 1080000 | | 005 | Pedro Ramˇrez | 2000-12-10 | Derecho | 640000 | +--------+-----------------+------------+----------------------------+--------------+ 5 rows in set (0.000 sec) MariaDB [matriculauni]> exit