I don't think you can alter that field but you can create a new field in the
appropriate place, copy the data from the old field to the new, and then
drop the old field.
Cheers
Rolf
PS. altering tables is explained in chapter 7 of the manual.
----- Original Message -----
From: "Zeus" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 17:37
Subject: Altering Table Fields Place on the table
Hi there,
I'm rather new to mySQL and I have some questions to ask :
How can I alter my table field to move before another table field ?
Chua Zhi Hon aka. Zeus
-------------------------------------
Founder, Frozened.com
"Your site for technology news, SUMMARISED!"
http://www.frozened.com
Editorial, paGn.net
http://www.pagn.net
---------------------------------------------------------------------
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
