Hallo Jason,
my problem is that the mysql 'auto_increment' behaviour
will increase the 'sequence' always to the maxnumber +1.
We now have p.e. a table with customers.
Every new customer will of course get a customer_id.
We now have 2 different id_ranges.
Some customers should get their id ran
Hello,
We are using mysql 2.22.32 (yes antique, but ISPs)
I need an sequence table.
Every time a client reads, the value shall be incremented.
A single row, integer value would be an ideal sequencen I think.
CREATE TABLE sequence(
id int4;
);
now, is this the correct way to emulate a sequ