18 lines
584 B
SQL
18 lines
584 B
SQL
create database concesionario;
|
|
use concesionario;
|
|
|
|
|
|
create table T_COCHE(
|
|
identificador int primary key,
|
|
marca varchar(50) not null,
|
|
modelo varchar(50) not null,
|
|
cilindrada decimal(4,2) not null
|
|
);
|
|
|
|
insert into T_COCHE values (1,'Renault', 'Megane', 1.5);
|
|
insert into T_COCHE values (2,'Seat', 'León', 1.6);
|
|
insert into T_COCHE values (3,'Suzuki', 'Vitara', 1.9);
|
|
insert into T_COCHE values (4,'Seat', 'Clio', 1.4);
|
|
insert into T_COCHE values (5,'Seat', 'Ibiza', 1.4);
|
|
insert into T_COCHE values (6,'Peugeot', '308', 2.0);
|
|
insert into T_COCHE values (7,'Renault', 'Megane', 1.5); |