The following, once copied and pasted into phpMyAdmin, gives me the following familiar error message:
#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 ‘{ id INT NOT NULL AUTO_INCREMENT PRIMARY KEY UNSIGNED, name VARCHAR(50) NOT NU’ at line 1
I don’t know what to change to fix it.
CREATE TABLE Addresses {
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
, name VARCHAR(50) NOT NULL
, address1 VARCHAR(100) NOT NULL
, address2 VARCHAR(100) NOT NULL
, city VARCHAR(30) NOT NULL
, state CHAR(2) NOT NULL
, zip VARCHAR(10) NOT NULL
, url VARCHAR(255) NULL
, email VARCHAR(255) NULL
, phone VARCHAR(20) NULL
, details TEXT NULL
, display CHAR(1) NULL
, added DATE NOT NULL
} DEFAULT CHARACTER SET utf8 ENGINE=InnoDB