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

this question has answer here:

• error creating table: have error in sql syntax near 'order( order_id int unsigned not null auto_increment, user_id ' @ line 1 [duplicate] 2 answers

i pulling hair out on this. have connected mysql server , trying create table on it:

create table order (     order_id int,     order_is_overnight bit,     order_quantity int,     order_amount double,     order_timestamp datetime ); 

when run get:

error: have error in sql syntax; check manual corresponds mysql server version right syntax use near 'order (         order_id int,         order_is_overnight bit,         order_quantity int,         order_amou' @ line 1 sqlstate:  42000 errorcode: 1064 

this world's vaguest error message, akin java exception says "whoops, went wrong somewhere in code!"

any ideas i'm going awry?! have checked, , rechecked, , rechecked , seems valid/legal create table statement (don't worry performance, indexes, keys, etc.; dummy/test table).

order reserved word, must enclose name in quotes

create table `order` (     order_id int,     order_is_overnight bit,     order_quantity int,     order_amount double,     order_timestamp datetime );