You have an error in sql syntax

Question

Hi I am new to mysql getting an error but i didn't understood where i do mistakethis code is implementing in mysql command prompt.This is my syntax. CREATE TABLE tutorials_tbl ( -> tutorial_id INT NOT NULL AUTO_INCREMENT  -> tutorial_title VARCHAR ( 100 ) NOT NULL  -> tutorial_author VARCHAR ( 40 ) NOT NULL  -> submission_date DATE  -> PRIMARY KEY ( tutorial_id ) -> ); will you please help me .... Thanks prathyusha

Vicky Bhatt · Answer

Hi Try below Script. CREATE TABLE tutorials_tbl ( tutorial_id int IDENTITY(11) PRIMARY KEY tutorial_title varchar(100) NOT NULL tutorial_author varchar(40) NOT NULL submission_date Date ) Hope you can get your answer.

Raja T · Answer

Hi Please share here what error you got it? After we will assist you.

Rajeesh Menoth · Answer

Hi Remove This one -> your query... //pattern for creating table in mysql.. CREATE TABLE MyGuests ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY firstname VARCHAR(30) NOT NULL lastname VARCHAR(30) NOT NULL email VARCHAR(50) reg_date TIMESTAMP )