Re: Get Number and Increment

[Phillip Ward]

Quote

Do I need to surround it with a Transaction ?

I would recommend doing so, but it's not strictly necessary because you're updating the value before selecting it, which will implicitly take a lock on the record.

begin transaction ; 

   update tableName 
   set myField = myField + 1 ;

   select myField 
   from tableName ; 

commit ;

Please tell me there's only one record in this table ...

Also: last_insert_id() returns the last, auto-increment value generated by an insert statement.

Regards, Phill W.