Re: auto_increment

You are missing a semicolon after the first alter statement. Kapu On 7. 9. 2010 18:05, Ron Piggott wrote:

I am receiving the following error Adriano: SQL query: ALTER TABLE stats DROP visits CREATE TABLE stats2 LIKE stats ; MySQL said: Documentation #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 'CREATE TABLE stats2 LIKE stats' at line 2 The complete commands were: ALTER TABLE stats DROP visits CREATE TABLE stats2 LIKE stats; ALTER TABLE stats2 ADD COLUMN visits INT( 25 ) NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY(visits) FIRST; INSERT INTO stats2 SELECT *, 0 FROM stats ORDER BY initial_access; I don't understand the error, your way of creating a table is new to me. Did something small get missed? Ron