Page 1 of 1

How do you make an ID in mysql?

Posted: Sat Jun 15, 2002 4:35 pm
by Gladiator
How do you insert an ID to a table for multiple users? Please tell me =]

Posted: Sat Jun 15, 2002 5:03 pm
by twigletmac
What do you mean exactly? Are you trying to insert an ID column into a table of user information?

Mac

Posted: Sat Jun 15, 2002 5:22 pm
by Gladiator
Its on one of the tutorials on the site but it doesn't say how to do it.

Posted: Sat Jun 15, 2002 5:23 pm
by Gladiator

Posted: Sat Jun 15, 2002 5:27 pm
by twigletmac
Are you trying to add an ID column to a table that already exists or a new one?

Mac

Posted: Sat Jun 15, 2002 5:44 pm
by Gladiator
new one

Posted: Sat Jun 15, 2002 6:07 pm
by twigletmac
Basically all you have to do is when you are creating your new table is call one of the columns something like 'ID', make it the primary key and make it an auto-incrementing field.

If you're not sure how to create a table there's this that'll be helpful:
http://newbienetwork.net/content.php?id=10

Mac

Posted: Sat Jun 15, 2002 10:17 pm
by Gladiator
alright thxs man