0

Hi.....

There is a problem with the following mysql query

create table emp2 (Leave decimal(12,2) default NULL)

Error message
Error Code: 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 decimal(12,2) default NULL)' at line 1


If I type the query as..
create table emp2(Leav decimal(12,2) default NULL)

Then it will executed successfully..What is the problem with the field 'Leave'?Is it a key word?

2
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by hielo
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.