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]