Dnia 2014-01-08, śro o godzinie 03:02 +0100, Sylvain "Gugli" Guglielmi
pisze:
> I can have something like "UPDATE `roster-items` SET
> `object-sequence`=`object-sequence`+1" but his break uniqueness in the
> table.
I come from PostgreSQL, so explicitly handled sequences is natural to
me:
UPDATE "roster-items" SET "object-sequence" = nextval('object-sequence')
> I haven't found any easy ways to do something similar with
> LAST_INSERT_ID() or AUTO_INCREMENT in MySQL, hence my question.
StackOverflow [1] suggests a convoluted solution:
SELECT Auto_increment FROM information_schema.tables WHERE
table_name='the_table_you_want';
Not pretty.
I think you should be fine with manual increment or
MAX(`object-sequence`)+1
> Just to check : you're talking about the pools in "pool.h".
Yes.
> Maybe at one point it'll be better to use pools for roster items too (item,
> item->name,
> item->groups and its content). I've not yet profiled anything, but this
> may be a way to improve speed when loading user data for packet delivery
> (without having to code 2 load-user events).
I will gladly accept code submission if you decide to do it. :-)
[1]
http://stackoverflow.com/questions/12271235/mysql-query-next-sequence-number-for-mysql-auto-incremented-field
--
Tomasz Sterna @ http://abadcafe.pl/ @ http://www.xiaoka.com/
