sqlite error near '''' syntax error data input -
i using sqlite3 , trying put data database.
create table club( cl_id int primary key not null, naam text not null, adres varchar(200) not null, dtm_opricht text not null ); create table stadion( sta_id int primary key not null, cl_id int references club(cl_id), naam text not null, adres varchar(200) not null, capaciteit int not null, dtm_bouw text not null ); create table technischdirecteur( td_id int primary key not null, cl_id int references club(cl_id), naam text not null, adres varchar(200) not null, salaris real not null, nationaliteit text not null, geslacht text not null, dtm_geboorte text not null );
everything going fine putting in data first 2 tables.
insert club values(101, 'ajax', 'amsterdamstraat 1', '05-01-1916'); insert stadion values(201, 101, 'arena', 'arenaweg 10', 50000, '05-03-1990');
however when tried put data 3rd table gave me syntax error near "301".
insert technischdirecteur(301, 101, 'michael kinsbergen', 'kalverstraat 18', 120000.13, 'nederlands', 'man', '03-09-1960');
what be?
you're missing keyword values
:
insert technischdirecteur values(301,...
Comments
Post a Comment