Question

Please tell what is wrong with my SQL syntax

Answer 1

Answer:

Item Code should be changed as Item_Code

Item Name should be changed as Item_Name

ExpiryDate Date(NOT NULL) should be changed as ExpiryDate Date NOT NULL

Explanation:

As per your mysql version, you should not have spaces in between the words of your column name, you can either use any other character like '_' ,'-', .... etc.,

then,

the constraint 'Not Null' should not be enclosed in braces. It has to be declared as shown in the Answer.

Note: You can use the following link to examine whether your mysql syntax is correct or not

https://www.piliapp.com/mysql-syntax-check/