generating a unique ID in mysql table

[suckablesausage]

hello gurus =)

i was wondering how to generate a unique ID so it can be put in mysql.
am i making sense?

[txmedic03]

[code]mysql_query("CREATE TABLE IF NOT EXISTS `tablename` (`id` int(11) not null auto_increment, `field1` text(80) not null, `field2` text(80) not null, primary key (id))") or die(mysql_error());[/code]

The id field will be incremented automatically so it will be unique. If you use phpMyAdmin or something of that nature you can set all of these things while creating the table through the user interface.

[Plazman65]

[!--quoteo(post=360191:date=Mar 30 2006, 03:07 PM:name=jireh)--][div class=\'quotetop\']QUOTE(jireh @ Mar 30 2006, 03:07 PM) [snapback]360191[/snapback][/div][div class=\'quotemain\'][!--quotec--]
hello gurus =)

i was wondering how to generate a unique ID so it can be put in mysql.
am i making sense?
[/quote]
oh oh I think I can answer this one for ya! (Im new myself). If you mean you want a unique number for lets say a user name I use the Auto-Increment.

Michelle

[suckablesausage]

ah yes i got it to work! man youre so smart =P i have another quick question. the id is 2 ,3 ,4 but is there a way to make it 00002, 00003, 00004? =)

[Barand]

Define the id as

[code]id int(5) zerofill not null auto_increment[/code]

[suckablesausage]

wow!! thank you!! gosh i love this forum :)