Quote:
Originally posted by amsch
I go this erro when I did my query?
Error
SQL-query:
ALTER TABLE smilie ADD showid SMALLINT not null
ALTER TABLE smilie ADD INDEX (showid)
UPDATE smilie SET showid=smilieid
MySQL said: You have an error in your SQL syntax near 'ALTER TABLE smilie ADD INDEX (showid) UPDATE smilie SET showid=smilieid' at line 2
|
They are each different queries.
Run
ALTER TABLE smilie ADD showid SMALLINT not null
Then run
ALTER TABLE smilie ADD INDEX (showid)
Then
UPDATE smilie SET showid=smilieid
All separately.