How else to make a serial SQL definition

From: "Brian Johnson" <bjohnson(at)jecinc(dot)on(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: How else to make a serial SQL definition
Date: 2002-08-19 19:41:46
Message-ID: 20020819.LbK.41601400@192.168.0.1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I couldn't figure out what mailing list would be the right place for this question

I need to know if there is a SQL table creation method that would work for both
PostgreSQL and MySQL to create a incremental field like 'id serial'

My program needs to access the sequence value after a record is added to create a
link to it from another table

I have it working in Perl for PostgreSQL but would like for it also to work under MySQL

Browse pgsql-novice by date

  From Date Subject
Next Message Donnahoo, George 2002-08-19 22:15:58 Stored Procedures
Previous Message Darrin Domoney 2002-08-19 19:29:03 Re: [ADMIN] [SQL] Urgent - SQL Unique constraint error (long)