Re: MySQL -- Sequences -- Do they exist

2003-12-10 Thread Andrey Subbotin
Hello noel. Wednesday, December 10, 2003, 5:09:30 PM, you wrote: nkmdi> If not is there anyway to automatically generate primary keys for nkmdi> tables in MySQL. CREATE TABLE ttt ( id int not null auto_increment primary key, name varchar(100) not null ); Please note "auto_incremen

Re: MySQL -- Sequences -- Do they exist

2003-12-10 Thread Victoria Reznichenko
[EMAIL PROTECTED] 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

Re: MySQL -- Sequences -- Do they exist

2003-12-10 Thread Martijn Tonies
Hi Noel, > 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 working. > Do they exist for version 4.1 and if so could someone give me some sample > code. If not is there anyway to automatically generate

MySQL -- Sequences -- Do they exist

2003-12-10 Thread noel . king2
Hello 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 working. Do they exist for version 4.1 and if so could someone give me some sample code. If not is there anyway to automatically generate primary ke