Hi I am new to mysql getting an error but i didn't understood where i do mistake,this 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 BhattPosted Aug 14, 2015, 6:59 AM
Raja TPosted Aug 14, 2015, 6:56 AM
Rajeesh MenothPosted Aug 14, 2015, 6:54 AM
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
)