From: Peter Brawley
Date: January 13 2005 5:38pm
Subject: Re: create sequence
List-Archive: http://lists.mysql.com/mysql/178441
Message-Id: <41E6B1F8.6070603@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

You want AUTO_INCREMENT, 
http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html.

PB

-----

Scott Purcell wrote:

>Hello,
> 
>I would like to create a sequence object in mysql that I could use in multiple tables through a application I am developing.
> 
>Could someone please send my the syntax of how to create a simple sequence that starts at 1 increments by 1. 
>
>thanks,
>
> 
>
>  
>