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

Share

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

Quote

Link to comment

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

Quote

Link to comment

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.

Quote

Link to comment

Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest

Reply to this topic...

× Pasted as rich text. Restore formatting

Only 75 emoji are allowed.

× Your link has been automatically embedded. Display as a link instead

× Your previous content has been restored. Clear editor

× You cannot paste images directly. Upload or insert images from URL.

Insert image from URL

×

Share

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.