Auto numbering in MySQL?

3GN Media · 12-29-2005, 06:44 PM

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:
????: NamePros.com http://www.namepros.com/programming/152408-auto-numbering-in-mysql.html

Code:

$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 · 12-29-2005, 06:53 PM

"auto_increment" in phpmyadmin

3GN Media · 12-29-2005, 06:56 PM

So do I just leave it blank in the query?

iNod · 12-29-2005, 07:05 PM

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

PHP Code:

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

????: NamePros.com http://www.namepros.com/showthread.php?t=152408

Remove the 94 it will auto generate it.

iNod.

3GN Media · 12-29-2005, 07:06 PM

Thanks for the help guys

brianmn · 01-03-2006, 02:18 PM

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 · 01-03-2006, 05:53 PM

Hey,

It will give you 5

MySQL keeps tracks off the records.

Rudy · 01-03-2006, 05:54 PM

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

tansks · 01-04-2006, 06:16 AM

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

Palyriot · 01-04-2006, 06:33 AM

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 · 01-04-2006, 07:03 AM

Originally Posted by tansks

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 · 01-04-2006, 09:32 AM

Originally Posted by iNod

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

PHP Code:

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

????: NamePros.com http://www.namepros.com/showthread.php?t=152408

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

PHP Code:

  $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

PHP Code:

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

????: NamePros.com http://www.namepros.com/showthread.php?t=152408

12-29-2005, 06:44 PM	THREAD STARTER #1 (permalink)
3GN Media NamePros Regular Join Date: Jan 2005 Posts: 439	Auto numbering in MySQL? 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: ????: NamePros.com http://www.namepros.com/programming/152408-auto-numbering-in-mysql.html Code: $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?

12-29-2005, 06:53 PM	#2 (permalink)
nick NamePros Regular Join Date: Jun 2004 Location: Iowa City Posts: 703	"auto_increment" in phpmyadmin __________________ formally ninedogger ------ Want to talk to a stranger? -->\| Click Here \| TalkToAStranger.com \| <-- Meet New Friends

12-29-2005, 07:05 PM	#4 (permalink)
iNod Eating Pie Join Date: Nov 2004 Location: Canada Posts: 2,267	In PHPMyAdmin select auto_increments for Extras and change the mysql query to PHP Code: $query = "INSERT INTO `games` VALUES ($cat, '$flash.swf', '$title', 0, 1, '$img.jpg', '400', '300', '$description', 24, '')"; ????: NamePros.com http://www.namepros.com/showthread.php?t=152408 Remove the 94 it will auto generate it. iNod. __________________ I feel old.

01-03-2006, 05:53 PM	#7 (permalink)
cytech NamePros Member Join Date: Nov 2005 Posts: 123	Hey, It will give you 5 MySQL keeps tracks off the records. __________________ CYTechnologies - Professional Website Development and Design GetCustomerRated.com - Get Customer Rated allows a business to capture genuine word of mouth advertising and place it in a virtual player on their website.

01-03-2006, 05:54 PM	#8 (permalink)
Rudy NamePros Regular Join Date: Jul 2005 Location: United States Posts: 586	Another good and helpful tool is MySQL Control Center, that you can download. __________________ Smooth Stone Services Affordable Web Hosting Solutions Starting at only $4.95/month, IT Consulting and Technical Support Hunt Sources - Hunting Resources Online

12-29-2005, 06:56 PM	THREAD STARTER #3 (permalink)
3GN Media NamePros Regular Join Date: Jan 2005 Posts: 439	So do I just leave it blank in the query?

12-29-2005, 07:06 PM	THREAD STARTER #5 (permalink)
3GN Media NamePros Regular Join Date: Jan 2005 Posts: 439	Thanks for the help guys

01-03-2006, 02:18 PM	#6 (permalink)
brianmn NamePros Member Join Date: Oct 2005 Posts: 173	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

01-04-2006, 06:16 AM	#9 (permalink)
tansks NamePros Regular Join Date: Dec 2004 Location: Penang, Malaysia Posts: 886	Is that possible to get the auto increment value after insert the record? __________________ █ Hostegic - Premium cPanel Hosting [Softaculous \| RvSitebuilder \| R1Soft daily backups \| LiteSpeed] █ [UK] [Linux - cPanel \| Windows - WebsitePanel/Plesk] [Shared Hosting \| Reseller Hosting \| VPS]

01-04-2006, 06:33 AM	#10 (permalink)
Palyriot NamePros Regular Join Date: Jul 2004 Location: Seattle, Wa Posts: 596	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.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Great Scripts for Sale With Resale Rights!	Zeeble	Scripts For Sale	20	01-04-2006 01:39 AM
Auto Body Shops Database - 114,270 Records	odditysoftware	Content For Sale	0	11-30-2005 10:54 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
HOW TO: Use shell to control MySQL.	abdulmueid	Webmaster Tutorials	16	08-27-2005 08:17 AM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM