| Attributes | Values |
|---|
| rdfs:label
| - Guía Práctica MySQL 5.1/Capítulo 12: Desencadenadores
|
| rdfs:comment
| - Creacion: DROP DATABASE IF EXISTS videoteca; CREATE DATABASE videoteca; Tablas: USE videoteca; CREATE TABLE actor ( id INT NOT NULL AUTO_INCREMENT, nombre VARCHAR(64) NOT NULL, apellidos VARCHAR(64) NOT NULL, PRIMARY KEY(id) ) ENGINE = InnoDB; CREATE TABLE actor_ext ( idactor INT NOT NULL, imdb VARCHAR(32) NOT NULL, carpeta VARCHAR(255) NOT NULL, PRIMARY KEY(idactor), INDEX ae_FK(idactor), FOREIGN KEY(idactor) REFERENCES actor(id) ) ENGINE = InnoDB; Inserciones: USE videoteca; INSERT INTO actor(nombre, apellidos) VALUES('Harrison', 'Ford'); INSERT INTO actor(nombre, apellidos) VALUES('Russell', 'Crowe'); INSERT INTO actor_ext(idactor, imdb, carpeta) VALUES(1, 'nm0000148', 'harrison_ford'); INSERT INTO actor_ext(idactor, imdb, carpeta) VALUES(2, 'nm0000128', 'russell_crowe');
|
| dcterms:subject
| |
| abstract
| - Creacion: DROP DATABASE IF EXISTS videoteca; CREATE DATABASE videoteca; Tablas: USE videoteca; CREATE TABLE actor ( id INT NOT NULL AUTO_INCREMENT, nombre VARCHAR(64) NOT NULL, apellidos VARCHAR(64) NOT NULL, PRIMARY KEY(id) ) ENGINE = InnoDB; CREATE TABLE actor_ext ( idactor INT NOT NULL, imdb VARCHAR(32) NOT NULL, carpeta VARCHAR(255) NOT NULL, PRIMARY KEY(idactor), INDEX ae_FK(idactor), FOREIGN KEY(idactor) REFERENCES actor(id) ) ENGINE = InnoDB; Inserciones: USE videoteca; INSERT INTO actor(nombre, apellidos) VALUES('Harrison', 'Ford'); INSERT INTO actor(nombre, apellidos) VALUES('Russell', 'Crowe'); INSERT INTO actor_ext(idactor, imdb, carpeta) VALUES(1, 'nm0000148', 'harrison_ford'); INSERT INTO actor_ext(idactor, imdb, carpeta) VALUES(2, 'nm0000128', 'russell_crowe');
|
![[RDF Data]](/fct/images/sw-rdf-blue.png)