Sorry about that. You are correct using AFTER or FIRST with ALTER TABLE ... MODIFY is not supported until version 4.
--- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -----Original Message----- Hi, RE: > I believe this is what you are looking for: > ALTER TABLE Images MODIFY Imcreatedat datetime NOT NULL default > '0000-00-00 00:00:00' AFTER Imccdtemp; Thanks, Tom for the clue. Yes, this is what I tried, but it did not work. Seems like modify does not accept the "AFTER" part. I tried it again, and the same failure: ERROR 1064: You have an error in your SQL syntax Maybe this is due to mysql-3.23.52 (i.e. not mysql-4)? Gaspar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
