lo realizado el dia 151011

8/3/2019 Lo Realizado El Dia 151011

1/4

Enter password: *****Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;+--------------------+ Database +--------------------+ information_schema libros mysql phpmyadmin test +--------------------+5 rows in set (0.34 sec)

mysql> use libros;Database changedmysql> create view cosulta1 as select nombre from editorial where codigo='5';Query OK, 0 rows affected (0.11 sec)

mysql> select * from cosulta1;+--------------+ nombre +--------------+ Mc Graw Hill +--------------+1 row in set (0.03 sec)

mysql> drop view cosulta1;Query OK, 0 rows affected (0.00 sec)

mysql> create database matricula;Query OK, 1 row affected (0.02 sec)

mysql> use matricula;Database changedmysql> create table estudiante

-> (carnet char(12) not null primary key,-> nombre char(30) not null)engine=innobd-> C;

ERROR 1286 (42000): Unknown table engine 'innobd'mysql> create table estudiante-> (carnet char(12) not null primary key,-> nombre char(30) not null)engine=innobd;

ERROR 1286 (42000): Unknown table engine 'innobd'mysql> create table estudiante

-> (carnet char(12) not null primary key,-> nombre char(30) not null)engine=innodb;

Query OK, 0 rows affected (0.19 sec)

mysql> create table materia-> cod char(5) not null primary key,-> descripcion char(30) not null)engine=innodb;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatcorresponds to your MySQL server version for the right syntax to use near 'cod char(5) not null primary key,


2/4

descripcion char(30) not null)engine=innodb' at line 2mysql> create table materia

-> (cod char(5) not null primary key,-> descripcion char(30) not null)engine=innodb;

Query OK, 0 rows affected (0.05 sec)

mysql> cretae table relacional

-> carnet char(12),-> C-> c;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatcorresponds to your MySQL server version for the right syntax to use near 'cretae table relacionalcarnet char(12),Cc' at line 1mysql> cretae table relacional

-> (carnet char(12),-> cod char(5),

-> foreign key(carnet) references estudiante(carnet) on delete cascade on update cascade, foreign key(cod) references materia(cod) on delete cascade on update cascade engine=innodb;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatcorresponds to your MySQL server version for the right syntax to use near 'cretae table relacional(carnet char(12),cod char(5),foreign key(carnet) refer' at line 1mysql> foreign key(carnet) references estudiante(carnet) on delete cascade on update cascade, foreign key(cod) references materia(cod) on delete cascade on update cascade engine=innodb;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near 'foreign key(carnet) references estudiante(carnet) on delete cascade on update ca' atline 1mysql> foreign key(carnet) references estudiante(carnet) on delete cascade on update cascade,

-> foreign key(cod)references materia(cod) on delete cascade on update cascade engine=innodb;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatcorresponds to your MySQL server version for the right syntax to use near 'foreign key(carnet) references estudiante(carnet) on delete cascade on update ca' atline 1mysql> foreign key(cod) references materia(cod) on delete cascade on update cascade engine=innodb;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatcorresponds to your MySQL server version for the right syntax to use near 'foreign key(cod) references materia(cod) on delete cascade on update cascade eng' atline 1mysql> foreign key(cod) references materia(cod) on delete cascade on update cascade) engine=innodb;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatcorresponds to your MySQL server version for the right syntax to use near 'foreign key(cod) references materia(cod) on delete cascade on update cascade) en' atline 1mysql> foreign key(carnet) references estudiante(carnet) on delete cascade on update cascade,

-> foreign key(cod) references materia(cod) on delete cascade on update cascade) engine=innodb;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that


3/4

corresponds to your MySQL server version for the right syntax to use near 'foreign key(carnet) references estudiante(carnet) on delete cascade on update ca' atline 1mysql> cretae table relacional

-> (carnet char(12),-> cod char(5),-> foreign key(carnet) references estudiante(carnet) on delete cascade on up

date cascade, foreign key(cod) references materia(cod) on delete cascade on update cascade) engine=innodb;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatcorresponds to your MySQL server version for the right syntax to use near 'cretae table relacional(carnet char(12),cod char(5),foreign key(carnet) refer' at line 1mysql> cretae table relacional

-> c;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatcorresponds to your MySQL server version for the right syntax to use near 'creta

e table relacionalc' at line 1mysql> create table relacional

-> (carnet char(12),-> cod char(5),-> foreign key(carnet) references estudiante(carnet) on delete cascade on up

date cascade, foreign key(cod) references materia(cod) on delete cascade on update cascade) engine=innodb;Query OK, 0 rows affected (0.11 sec)

mysql> inset into estudiante(carnet, nombre) values ('01','maria');ERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatcorresponds to your MySQL server version for the right syntax to use near 'inset

into estudiante(carnet, nombre) values ('01','maria')' at line 1mysql> insert into estudiante(carnet, nombre) values ('01','maria');Query OK, 1 row affected (0.05 sec)

mysql> insert into estudiante(carnet, nombre) values ('02','juan');Query OK, 1 row affected (0.02 sec)

mysql> insert into estudiante(carnet, nombre) values ('03','carlos');Query OK, 1 row affected (0.03 sec)

mysql> insert into materia(cod, descripcion) values ('1','matematicas');Query OK, 1 row affected (0.03 sec)

mysql> insert into materia(cod, descripcion) values ('2','lenguaje');Query OK, 1 row affected (0.01 sec)

mysql> insert into materia(cod, descripcion) values ('3','logaritmo');Query OK, 1 row affected (0.11 sec)

mysql> insert into relacional(carnet, cod) values ('01','2');Query OK, 1 row affected (0.06 sec)




4/4



mysql> insert into relacional(carnet, cod) values ('03','0');

ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`matricula/relacional`, CONSTRAINT `relacional_ibfk_2` FOREIGN KEY (`cod`)REFERENCES `materia` (`cod`) ON DELETE CASCADE ON UPDATE CASCADE)mysql> insert into relacional(carnet, cod) values ('03','01');ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`matricula/relacional`, CONSTRAINT `relacional_ibfk_2` FOREIGN KEY (`cod`)REFERENCES `materia` (`cod`) ON DELETE CASCADE ON UPDATE CASCADE)mysql> insert into relacional(carnet, cod) values ('03','1');Query OK, 1 row affected (0.03 sec)

mysql> delete from estudiante where carnet='02';Query OK, 1 row affected (0.05 sec)

mysql>

lo realizado el dia 151011

Documents