LiveCode Forums.

Posted: **Sun Nov 30, 2014 6:50 pm**

i ant to find the next auto increment number
currently with livecode im using SELECT MAX(id) FROM database then adding 1 to it to get the next id that will be used.
however what if i have 6 items, the next to be used will be 7. but if i delete item 6 from the database using my method will give me 6 as the next available one however MySQL will set the next entry as 7

Posted: **Sun Nov 30, 2014 10:34 pm**

Select max(id) after you do the insert? Or perhaps LAST_INSERT_ID()

Posted: **Mon Dec 01, 2014 7:55 pm**

that works at that point in time. but what if i go do other stuff. Log off the come back then need to find it. I would have to insert something to get the AI number

Posted: **Mon Dec 01, 2014 8:29 pm**

What about :

Code: Select all

SHOW TABLE STATUS WHERE Name = 'yourtable'

It will gives you infos on the table... with "auto increment" = the next value

Posted: **Tue Dec 02, 2014 3:34 am**

thanks. This works

Code: Select all

   put "SHOW TABLE STATUS WHERE Name = 'users' " into xSQL
   put revDataFromQuery(comma, cr, gConnectionID, xSQL) into maxData
   set itemDelimiter to comma
   answer item 11 of maxData

LiveCode Forums.

auto increment MySQL

auto increment MySQL

Re: auto increment MySQL

Re: auto increment MySQL

Re: auto increment MySQL

Re: auto increment MySQL