Jump to content

Existing user? Sign In
Sign In

Remember me Not recommended on shared computers

Forgot your password?
Sign Up

Browse
- Forums
- Staff
- Leaderboard
- Guidelines
- Terms of Service
- More
Activity
- All Activity
- Search
- More
Join our Discord!
More
- More

MySQL Help

How do I make a MySQL column Auto_increment once I've already created the table

kpetsche20

By kpetsche20
June 30, 2008 in MySQL Help

Start new topic

Recommended Posts

kpetsche20

Regular Member

kpetsche20

Posted June 30, 2008

- Share

Posted June 30, 2008

How do I make a MySQL column Auto_increment once I've already created the table

Link to comment

https://forums.phpfreaks.com/topic/112633-how-do-i-make-a-mysql-column-auto_increment-once-ive-already-created-the-table/

Share on other sites

br0ken

Member

br0ken

Posted June 30, 2008

- Share

Posted June 30, 2008

ALTER TABLE tblTable MODIFY id INT AUTO_INCREMENT PRIMARY KEY

Link to comment

https://forums.phpfreaks.com/topic/112633-how-do-i-make-a-mysql-column-auto_increment-once-ive-already-created-the-table/#findComment-578500

Share on other sites

Advanced Member

fenway

Posted July 2, 2008

- Share

Posted July 2, 2008

Assuming it's NOT NULL already..... and it should be UNSIGNED, too.

Link to comment

https://forums.phpfreaks.com/topic/112633-how-do-i-make-a-mysql-column-auto_increment-once-ive-already-created-the-table/#findComment-579916

Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing

×

Browse
- Back
- Forums
- Staff
- Leaderboard
- Guidelines
- Terms of Service
Activity
- Back
- All Activity
- Search
Join our Discord!

×

Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.