Auto numbering in MySQL?

[3GN Media]

Hey guys, I read a tutorial a long time ago on how to automatically have mysql number the rows but I forgot. Anyway, take a look at this for me:

$query = "INSERT INTO `games` VALUES (94, $cat, '$flash.swf', '$title', 0, 1, '$img.jpg', '400', '300', '$description', 24, '')";

Instead of putting 94 and changing it to 95, 96, etc. How can I make it so that it does automatically instead of having to manually change the number in the tables?

 

[nick-8318]

"auto_increment" in phpmyadmin

 

[3GN Media]

So do I just leave it blank in the query?

 

[iNod]

In PHPMyAdmin select auto_increments for Extras and change the mysql query to

$query = "INSERT INTO `games` VALUES ($cat, '$flash.swf', '$title', 0, 1, '$img.jpg', '400', '300', '$description', 24, '')";

Remove the 94 it will auto generate it.

iNod.

 

[3GN Media]

Thanks for the help guys

 

[brianmn]

So will this work if I have in a table records 1, 2, 3, 4 and then i delete 2 will the next record added continue onto 5 then or will it be 4 giving me two 4's and causing a possible conflict

 

[cytech]

Hey,

It will give you 5

MySQL keeps tracks off the records.

 

[Rudy]

Another good and helpful tool is MySQL Control Center, that you can download.

 

[tansks]

Is that possible to get the auto increment value after insert the record?

 

[Palyriot]

I was gonna say just count the total rows, then make the total rows the file id. Or, simple order by ID, then add 1 to the last row. Perfect way of doing it, but I guess that is easier.

 

[moondog]

Is that possible to get the auto increment value after insert the record?

If you are coding in PHP, you can use the mysql_insert_id() function.

-Bob

 

[Peter]

In PHPMyAdmin select auto_increments for Extras and change the mysql query to

$query = "INSERT INTO `games` VALUES ($cat, '$flash.swf', '$title', 0, 1, '$img.jpg', '400', '300', '$description', 24, '')";

Remove the 94 it will auto generate it.

iNod.

That wont work as sql will think that $cat is the first field. You can either have it so you explicitly name the table fields such as

$query = "INSERT INTO `games` ('field1', 'field2', 'field3', 'field4', 'field5', 'field6', 'field7', 'field8', 'field9', 'field10')VALUES ($cat, '$flash.swf', '$title', 0, 1, '$img.jpg', '400', '300', '$description', 24, '')";

obviously changing the field names to their proper names or you can make it

$query = "INSERT INTO `games` VALUES ('', $cat, '$flash.swf', '$title', 0, 1, '$img.jpg', '400', '300', '$description', 24, '')";