I have a problem in creation of table with CONSTRAINT in sql

Question

Following is my query can any one help me to over come this . I am getting  #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONSTRAINT pri_ky primary keyjob_id int CONSTRAINT not_l NOT NULL)' at line 1  as error create table employee(employee_id int CONSTRAINT pri_ky primary keyjob_id int CONSTRAINT not_l NOT NULL)

Iftikar Hussain · Answer

Hi You should not use CONSTRAINT while creating a new table. Please refer the below link for more details http://www.w3schools.com/sql/sql_primarykey.asp Regards Iftikar

Sunny Sharma · Answer

hi jidhin tr CONSTRAINT keyword is not required while creating a table use the syntax below: CREATE TABLE EMPLOYEE(employee_id INT PRIMARY KEYjob_id INT NOT NULL); Happy Coding :) Cheers!