error while runing table creation code

Is there anythng wrong wid the following code-
stmt.execute("create table order(ORDER_INDEX INTEGER not null GENERATED ALWAYS AS IDENTITY CONSTRAINT orderno_pk primary key,ONAME VARCHAR(30),DESC VARCHAR(30),CUSTOMER VARCHAR(30),PHONE INTEGER,ORDERDATE VARCHAR(30),DELIVERYDATE VARCHAR(30),ADVANCE DECIMAL(20,2),BAL DECIMAL(20,2))");
i am getting the attached error..pls help..
run.txt
daydreamer6565Asked:
Who is Participating?
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
'order' is a reserved word in MySQL and should not be used for table or column names.
0
 
daydreamer6565Author Commented:
The table is created..Thanks ..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.