I've read and re-read the manual and searched mailing list archive and still can't see what is wrong with this statement - I'm sure someone can put me out of my misery ! I'm simply trying to move the position of the Cat2 column.
mysql> alter table bollinks3 change Cat2 Cat2 smallint(5) unsigned not null after OutIP; ERROR 1064: You have an error in your SQL syntax near 'after OutIP' at line 1 I'm using mysql 3.22.32-log and have full privileges. The table is like this: mysql> describe bollinks3; +-------------+----------------------+------+-----+-------------------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------------------+------+-----+-------------------+----- -----------+ | ID | smallint(5) unsigned | | PRI | 0 | auto_increment | | Down | tinyint(3) unsigned | | | 0 | | | SiteName | varchar(100) | | | | | | SiteURL | varchar(100) | | UNI | | | | LastUpdate | timestamp(14) | YES | | NULL | | | Added | varchar(14) | YES | | NULL | | | Description | blob | | | NULL | | | Category | smallint(5) unsigned | | MUL | 0 | | | Cat2 | smallint(5) unsigned | | MUL | 0 | | | Cat3 | smallint(5) unsigned | | MUL | 0 | | | Country | varchar(100) | | | United_States.gif | | | UserName | varchar(16) | | | | | | Password | varchar(16) | | | | | | Hint | varchar(50) | | | | | | Email | varchar(50) | | | | | | HitsIn | smallint(5) unsigned | | | 0 | | | HitsOut | smallint(5) unsigned | | | 0 | | | InIP | varchar(15) | | | | | | OutIP | varchar(15) | | | | | +-------------+----------------------+------+-----+-------------------+----- -----------+ 19 rows in set (0.00 sec) Thanks, Gary Prosser --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
