When trying to create this table in my database, I get an error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''order'. The query:
CREATE TABLE order
(
order_id char(11),
customername char(10),
productnumber char(3),
quantity char(2)
);