Error Creating Table: You Have an Error in Your SQL Syntax Near 'Order( Order_Id Int Unsigned Not Null Auto_Increment, User_Id ' At Line 1

Error creating table: You have an error in your SQL syntax near 'order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ' at line 1

You need to escape reserved words like order with backticks

CREATE TABLE `order` ( ...

or better use another name instead.

MySQL CREATE TABLE 'You have an error in your SQL syntax' error

order is an reserved word, you must enclose it name in back quotes

CREATE TABLE `order` (
    order_id INT,
    order_is_overnight BIT,
    order_quantity INT,
    order_amount DOUBLE,
    order_timestamp DATETIME
);

Error in CREATE table statement in MySQL

As the comments mentioned, ORDER among others are reserved in MySQL. The complete list is in the documentation here.

You have three options, either to change the table name (my personal recommendation), escape the name, or qualify the name with the database such as: CREATE TABLE mydb.ORDER ..... If you do choose to stick with a keyword named table (or column), you run the risk of confusion later if you forget to escape it in another query. If this is tied to customers, perhaps it could be the 'CustomerOrder' table.

CREATE TABLE `ORDER`(
    OrderNo Integer(5) Primary Key,
    CustNo Integer(7),
    ItemName Varchar(30),
    Qty Integer(5),
    Price Decimal(6,2) Not Null,
    Foreign Key (CustNo) references CUSTOMER(CustID)
);

Given that you have a primary key, you may also want it to auto increment so you don't have to create the keys manually.

CREATE TABLE `ORDER`(
    OrderNo Integer(5) Primary Key AUTO_INCREMENT,
    CustNo Integer(7),
    ItemName Varchar(30),
    Qty Integer(5),
    Price Decimal(6,2) Not Null,
    Foreign Key (CustNo) references CUSTOMER(CustID)
);

SQL syntax issues with creating table

You'll want to use backticks since ORDER is a reserved keyword:

CREATE TABLE `ORDER` (
    Order_id INT NOT NULL AUTO_INCREMENT,
    Order_Placed CHAR (10) NOT NULL,
    Delivered_on CHAR (10) NOT NULL,
    Total VARCHAR (8) NOT NULL,
    Ship_addr VARCHAR (50) NOT NULL,
    Order_status VARCHAR (35) NOT NULL,
    PRIMARY KEY (Order_id)
);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use'

The Error lies in your SQL Statement. LIKE is a keyword/reserved word and cannot be used as a name of an attribute.

Change your SQL Statement of the blogs table creation to the following one:

CREATE TABLE blogs (
    blog_id        integer        not null, 
    date_created   date, 
    discription    varchar(999), 
    dislike        bigint         not null, 
    liked          bigint         not null, 
    time_created   time, 
    primary key (blog_id)
) engine=InnoDB;

How to fix the error for creating table given below

I think these SQL useful to you. Just replace ' with `.

CREATE TABLE IF NOT EXISTS `users` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `username` VARCHAR(255) NOT NULL,
    `first_name` VARCHAR(255) NOT NULL,
    `last_name` VARCHAR(255) NOT NULL,
    `email` VARCHAR(255) NOT NULL,
    `password` VARCHAR(32) NOT NULL,
    `sign_up_date` DATE NOT NULL,
    `activated` ENUM('0','1') NOT NULL,
    PRIMARY KEY (id))
    ENGINE=INNODB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Thank you.

Getting error in SQL Statements

Yes its the keyword, it would better to not to use this if still you want then try in this way and in every operation you have to enclose table name in typos:

CREATE TABLE `Order` (
`Type` INT NULL AUTO_INCREMENT PRIMARY KEY,
 Order_Type INT NOT NULL,
 Order_Number VARCHAR(45) NOT NULL,
 Order_Date VARCHAR(45) NOT NULL
 );

MYSQL Error 1064: Can't seem to find the error exactly

order is a reserved word in SQL. You could either protect it by surrounding it with forward quotes:

CREATE TABLE `order` (
    id INT AUTO_INCREMENT,
    record_id INT,
    quantity INT unsigned,
    total DECIMAL(10, 2) unsigned,
    PRIMARY KEY (id),
    FOREIGN KEY (record_id)
            REFERENCES record (id)
);

or better yet, just find a name that ins't a reserved word, e.g., orders:

CREATE TABLE orders (
    id INT AUTO_INCREMENT,
    record_id INT,
    quantity INT unsigned,
    total DECIMAL(10, 2) unsigned,
    PRIMARY KEY (id),
    FOREIGN KEY (record_id)
            REFERENCES record (id)
);

Mysql error code creating table

order is a reserved word in MySQL. Use some other name.

See this related post: Syntax error due to using a reserved word as a table or column name in MySQL

I think you can use back-ticks to quote your table name, but I think that is not a great idea.

---

Related Topics