MYSQL > Autoincrement-Problem
#8

Quote:
Originally Posted by Emmet_
Посмотреть сообщение
MySQL uses threaded queries so unfortunately you can't do that. You'll have to pass it through a callback and do it that way.

pawn Код:
mysql_query(sqlConnection, "SELECT MAX(gID) + 1 FROM `gangzones`", "onGetLastID");
pawn Код:
forward onGetLastID();
public onGetLastID() {
    lastZoneGIDDatabase = cache_get_row_int(0, 0);
}
Not quite accurate because if a row is deleted, it will return the last existed gID + 1 and an INSERT statement would give a different value than that.
Reply


Messages In This Thread
MYSQL > Autoincrement-Problem - by Meisternuke - 14.06.2015, 02:14
Re: MYSQL > Autoincrement-Problem - by [KHK]Khalid - 14.06.2015, 02:18
Re: MYSQL > Autoincrement-Problem - by Meisternuke - 14.06.2015, 02:19
Re: MYSQL > Autoincrement-Problem - by [KHK]Khalid - 14.06.2015, 02:21
Re: MYSQL > Autoincrement-Problem - by Emmet_ - 14.06.2015, 02:26
Re: MYSQL > Autoincrement-Problem - by Meisternuke - 14.06.2015, 02:41
Re: MYSQL > Autoincrement-Problem - by Emmet_ - 14.06.2015, 04:43
Re: MYSQL > Autoincrement-Problem - by Konstantinos - 14.06.2015, 10:30

Forum Jump:


Users browsing this thread: 2 Guest(s)