Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE DatosCoches;
- USE DatosCoches;
- CREATE TABLE PROPIETARIOS (DNI VARCHAR(10),
- Nombre VARCHAR(40),
- Edad INTEGER,
- UNIQUE KEY(DNI));
- CREATE TABLE COCHES (Matricula VARCHAR(10) ,
- Marca VARCHAR(20),
- Precio INTEGER,
- DNI VARCHAR (10),
- UNIQUE KEY(Matricula),
- FOREIGN KEY (DNI) References Propietarios(DNI));
- INSERT INTO Propietarios values('1A','Pepe',30);
- INSERT INTO Propietarios values('1B','Ana',40);
- INSERT INTO Propietarios values('1C','Maria',50);
- INSERT INTO Coches values('MA-1111','Opel',1000,'1A');
- INSERT INTO Coches values('MA-2222','Renault',2000,'1A');
- INSERT INTO Coches values('BA-3333', 'Seat', 3000,'1B');
- Describe Propietarios;
- Describe Coches;
- Select * from Propietarios;
- Select * from Coches;
- Select * from Propietarios, Coches
- where Propietarios.DNI=Coches.DNI;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement