Trouble creating table in MySQL -


i trying create table using command in mysql:

create table tutorial_info(      tutorial_id int not_null auto_increment primary key,      tutorial_title varchar(100) not_null,      tutorial_author varchar(100) not_null,      submission_date timestamp    ); 

i cut , paste code terminal getting error:

you have error in sql syntax; check manual corresponds mysql server version right syntax use near 'not_null auto_increment primary key, tutorial_title varchar(100) not_null, ' @ line 1

not sure going on here. give me pointer might doing wrong here? thanks

change not_null not null as:

create table tutorial_info(      tutorial_id int not null auto_increment primary key,      tutorial_title varchar(100) not null,      tutorial_author varchar(100) not null,      submission_date timestamp    ); 

Comments

Popular posts from this blog

javascript - Using jquery append to add option values into a select element not working -

Android soft keyboard reverts to default keyboard on orientation change -

jquery - javascript onscroll fade same class but with different div -