jidhin tr

jidhin tr

  • NA
  • 16
  • 7k

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

Aug 9 2013 6:19 AM
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 key,job_id int CONSTRAINT not_l NOT NULL)' at line 1 " as error

create table employee(employee_id int CONSTRAINT pri_ky primary key,job_id int CONSTRAINT not_l NOT NULL)
 


Answers (2)