Loading

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

jidhin tr

13y1.4k

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)

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
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 Sharma13y ago
hi jidhin tr,

CONSTRAINT keyword is not required while creating a table, use the syntax below:

CREATE TABLE EMPLOYEE(employee_id INT PRIMARY KEY,job_id INT NOT NULL);

Happy Coding :)
Cheers!