mysql code need help asap [closed]

Question

1064 - 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 ( orderID VARCHAR(6) NOT NULL DEFAULT 0, orderDate DATE NOT NULL DEFAULT' at line 1

DROP DATABASE IF EXISTS tupperware;
CREATE DATABASE tupperware;
USE tupperware;

CREATE TABLE login (
user_name VARCHAR(10) NOT NULL DEFAULT '',
password VARCHAR(10) NOT NULL DEFAULT '',
email VARCHAR(30) NOT NULL DEFAULT '',
account_type VARCHAR(10) NOT NULL DEFAULT '',
ic INT(10) NOT NULL DEFAULT 0,
telephone_no INT(20) NOT NULL DEFAULT 0,
pin INT(20) NOT NULL DEFAULT 0,
gender VARCHAR(10) NOT NULL DEFAULT '',
shipping_address VARCHAR(100) NOT NULL DEFAULT '',
city VARCHAR(10)  NOT NULL DEFAULT '',
state VARCHAR(10) NOT NULL DEFAULT '', 
country VARCHAR(10) NOT NULL DEFAULT '',
zip_code INT(10) NOT NULL DEFAULT 0,
credit_type VARCHAR(10) NOT NULL DEFAULT '',
credit_number INT(20) NOT NULL DEFAULT 0,
cvv2 INT(3) NOT NULL DEFAULT 0
); 

CREATE TABLE products(
productID VARCHAR(6) NOT NULL DEFAULT 0,
productName VARCHAR(255) NOT NULL DEFAULT "",
warranty_date INT(3) NOT NULL DEFAULT 1,
productDiscount INT(3) NOT NULL DEFAULT 0,
listPrice DECIMAL(10,2) NOT NULL DEFAULT 0,
category VARCHAR(10) NOT NULL DEFAULT ""
);

CREATE TABLE order VALUES(
orderID VARCHAR(6) NOT NULL DEFAULT 0,
orderDate DATE NOT NULL DEFAULT '',
claimCondition VARCHAR(30) NOT NULL DEFAULT ''
);

CREATE TABLE feedback(
message VARCHAR(1000) NOT NULL DEFAULT '',
messageDate DATE NOT NULL DEFAULT '',
feedbackID INT(3) NOT NULL DEFAULT 0
);

Answer 1

order is a reserved keyword in MySQL. You should either change it or use ticks (`) around it:

CREATE TABLE `order` VALUES(