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

Popular posts from this blog

c++ - How to add Crypto++ library to Qt project -

jQuery Mobile app not scrolling in Firefox -

How to use vim as editor in Matlab GUI -