#1064 - You have an error in your SQL syntax

[StevenHu]

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

[rcashell]

You need to use () and not {} for you create table statement.

[spikeZ]

change the { and } for ( and )

[StevenHu]

A little PHP leaked into my MySQL! Thanks!