[PHP-DB] Altering a column in an existing table

2003-06-27 Thread Rick Dahl 
I have a column (ID) that is currently not auto_incremental.  I need to change it so 
that it is auto_incremental.  There are already records in this column.  also, I need 
to change the field type from int(4) to int(8).

Rick

Re: [PHP-DB] Altering a column in an existing table

2003-06-27 Thread Leif K-Brooks 
Rick Dahl wrote:

I have a column (ID) that is currently not auto_incremental.  I need to change it so that it is auto_incremental.  There are already records in this column.  also, I need to change the field type from int(4) to int(8).

Rick

 

1) This has nothing to do with PHP.
2) This will most likely require an ALTER query.
3) Read your DB's manual.
--
The above message is encrypted with double rot13 encoding.  Any unauthorized attempt 
to decrypt it will be prosecuted to the full extent of the law.


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php