Loading

Sunday, April 17, 2005

How to alter mysql table column to AUTO_INCREMENT

mysql> set insert_id=7;
Query OK, 0 rows affected (0.00 sec)

mysql> alter table fixtures modify column id int auto_increment;
Query OK, 7 rows affected (0.01 sec)
Records: 7 Duplicates: 0 Warnings

SHARE TWEET

Thank you for reading this article How to alter mysql table column to AUTO_INCREMENT With URL http://x-tutorials.blogspot.com/2005/04/how-to-alter-mysql-table-column-to.html. Also a time to read the other articles.

0 comments:

Write your comment for this article How to alter mysql table column to AUTO_INCREMENT above!