Re: John Holmes->Re: [PHP] Challenging problem for you programing gurus...
| From: | Chris Shiflett | Date: | Sun, 29 Sep 2002 02:41:40 +0000 |
| Subject: | Re: John Holmes->Re: [PHP] Challenging problem for you programing gurus... | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-118033@lists.php.net to get a copy of this message | ||
It is because of the syntax for that command. In your case, old_column_name and new_column name would be identical. You would want to basically redefine it exactly as before (you're not changing from int to auto_increment, for example), except that you would add the auto_increment characteristic. You basically give the column you want to change and completely redefine it.
Happy hacking.
Chris
Ryan A wrote:
Am a bit confused, 2 guys already gave me the advise you are giving me but you also say "CHANGE COLUMN old_column_name new_column_name" why to change the column name? dont I only have to change it from being an "int" to an "Auto_Increment"?