List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:December 10 2003 10:19am
Subject:Re: MySQL -- Sequences -- Do they exist
View as plain text  
noel.king2@stripped wrote:
> 
> I am looking to create a sequence to use as a primary key for a table, I
> have read about them on the mysql website but can?t seem to get them work=
> ing.
> Do they exist for version 4.1 and if so could someone give me some sampl=
> e
> code.  If not is there anyway to automatically generate primary keys for
> tables in MySQL.

You can specify column as AUTO_INCREMENT:
	http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




Thread
MySQL -- Sequences -- Do they existnoel.king210 Dec
  • Re: MySQL -- Sequences -- Do they existMartijn Tonies10 Dec
  • Re: MySQL -- Sequences -- Do they existVictoria Reznichenko10 Dec
  • Re: MySQL -- Sequences -- Do they existAndrey Subbotin10 Dec