Re: [Firebird-devel] Simplify MySQL migration: LAST_INSERT_ID()

[emelhu <em...@em...>]

Maybe the simplest way ;)

CREATE SEQUENCE someTableSeq; 

CREATE TABLE someTable
( 
   ID INTEGER NOT NULL DEFAULT NEXT VALUE FOR someTableSeq, 
   .... 
) 

insert into someTable (firstname, lastname, address, phone, email)
  values ('Henry', 'Higgins', '27A Wimpole Street', '3231212', null)
  returning lastname, fullname, id

--
View this message in context: http://firebird.1100200.n4.nabble.com/Simplify-MySQL-migration-LAST-INSERT-ID-tp3163991p4335952.html
Sent from the firebird-devel mailing list archive at Nabble.com.