Sql syntax error while creating `leave` table

I have a problem while creating table in my wamp server (version-2.2.22) and php (version 5.3.13).The error given below...

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 'leave( lid INT AUTO_INCREMENT, empname VARCHAR(255), username VARCHAR(255), ' at line 1

and here my code.pls help me..

create table leave(
lid INT AUTO_INCREMENT,
empname VARCHAR(255),
username VARCHAR(255),
nod INT,
sdate DATE,
edate DATE,
reason VARCHAR(255),
PRIMARY KEY(lid),
FOREIGN KEY(empID) REFERENCES users(empID)
);

Answers


LEAVE is a reserved word in MySQL. Surround it with backtics.

CREATE TABLE `leave` (

Need Your Help

Clone element with fineuploader applied to it

javascript jquery fine-uploader

I apply FineUploader to an element, then clone it. The new element will open the file upload dialog, but won't upload a file. How can this be accomplished?