I am not able to create any table because of this error could anyone help I have attached the code thanks in advance

Question

0.00/5 (No votes)

See more:

ERROR 1064 (42000): 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 'order(
id INT PRIMARY KEY,
amount INT NOT NULL,
discount INT NOT NULL,
date_orde' at line 1

What I have tried:

mysql> CREATE TABLE order(
-> id INT PRIMARY KEY,
-> amount INT NOT NULL,
-> discount INT NOT NULL,
-> date_order DATE,
-> order_status VARCHAR(20) NOT NULL);

Posted 20-Feb-22 19:41pm

Mohit Lakhwani 2022

Updated 20-Feb-22 21:50pm

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2022-02-20T20:20:00

Solution 1

You can't call the table "order" - that's a keyword (as in SELECT ... ORDER BY ...)
Change the table name to "Orders" and it should work.

Posted 20-Feb-22 20:20pm

OriginalGriff

M Imran Ansari · Answer 2 · 2022-02-20T20:33:00

What is your database name? Normally the following error produce when we used hyphen (−) in the database name, which isn’t acceptable.
You can use the way to create the table in your database:

create table orders(
   id INT NOT NULL,
   amount INT NOT NULL,
   discount INT NOT NULL,
   date_order DATE,
   order_status VARCHAR(20) NOT NULL,
   PRIMARY KEY (id)
);

Graeme_Grant · Answer 3 · 2022-02-20T21:50:00

The best way to learn how to write this type of SQL is to use a Database Management tool. Create the table in the tool, then select the table and there will be a menu option (usually done by right-clicking on the table name) and it will generate the SQL for you.

For MySql, the management tool is: MySQL Workbench. There are other apps that can do this too...

I am not able to create any table because of this error could anyone help I have attached the code thanks in advance

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0