Digital Media, Web Design, and Web Development by Ethan Kent | ethanmultimedia.com

ethan -at- ethanmultimedia -dot- com
six one nine - two four six - four one two zero

How To Select An Incrementing Column With MySQL

– 2008-05-02 09:50

Introduction

This comes in handy when performing a mass insert from a table without a primary key to a table with an AUTO_INCREMENT value. A common tecnique simply inserts blank values to the AUTO_INCREMENT column. Doing so generates a warning for each row. Generating a bunch of warnings makes it difficult to identify and address the other warnings that may occur. Using my tecnique to generate incremental values addresses this problem.

Initialize the variable and set the starting value.

SET @INC = 15;

Put the variable into the select statement with a := operator.

SELECT
   @INC:=@INC+1 AS 'Record Number', 
   `column1`, 
   `column2`, 
   `etc`
FROM 
   `table1`;

---

Filed Under: code sample, mysql

---

Comment

Name		Remember
E-mail
Website
Message
	Textile Help

« REGEX Notes « Previous Article

Next Article » Non-Stick Suckerfish »