1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
|
create table test
(
id smallint unsigned auto_increment not null,
name char(255) not null,
start smallint unsigned not null,
end smallint unsigned not null,
fkid smallint unsigned not null,
primary key (id)
);
insert into test values(null,'toto',10,20,1);
insert into test values(null,'titi',20,25,2);
insert into test values(null,'tutu',25,35,2);
insert into test values(null,'tata',35,40,2);
insert into test values(null,'tedc',40,41,2);
insert into test values(null,'hfgh',10,14,3);
insert into test values(null,'asze',15,30,3);
insert into test values(null,'vbnh',30,40,3);
insert into test values(null,'oplm',40,50,3);
insert into test values(null,'wxcs',50,55,3);
insert into test values(null,'uiop',10,30,5);
insert into test values(null,'cvcg',30,32,5);
insert into test values(null,'ezds',32,35,5);
insert into test values(null,'ecds',35,46,5);
insert into test values(null,'oplm',14,35,6); |
Partager