mySQL table error!!

[fr0stx]

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 25
STR: ->
SQL: CREATE TABLE siteHits (
-> ID INT UNIQUE PRIMARY KEY AUTO_INCREMENT,
-> sourceIP VARCHAR(17) UNIQUE)
SQL-query :

CREATE TABLE siteHits ( -> ID INT UNIQUE PRIMARY KEY AUTO_INCREMENT, -> sourceIP VARCHAR(17) UNIQUE)

MySQL said:

#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 UNIQUE PRIMARY KEY AUTO_INCREMENT,
-> sourceIP VARCHA

I don't understand that?

// This is sql

CREATE TABLE siteHits ( -> ID INT UNIQUE PRIMARY KEY AUTO_INCREMENT, -> sourceIP VARCHAR(17) UNIQUE)

[sidney]

syntax more like this

CREATE TABLE siteHits (ID INT not null AUTO_INCREMENT, sourceIP VARCHAR (17) not null , PRIMARY KEY (ID), UNIQUE (ID, sourceIP))