> after inserting some data in Table 1, I get the generated ID > by "SELECT = > MAX(ID) FROM TABLE1" > > how to avoid the ID conflict? I am using begin transaction > and commit = > transaction. Is it sufficient?
Assuming from an earlier post that ID is of type SERIAL, you can access the last value generated in the current transaction through the expression TABLE1.CURRVAL. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
