Re: How can I build a sequence table, please help!

2001-06-21 Thread Gunnar von Boehn
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

How can I build a sequence table, please help!

2001-06-21 Thread Gunnar von Boehn
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