>Does anybody know if there is a function to retrieve the next unique ID
>number for a record to be made in the future?
I believe you can reliably allocate sequence numbers from a "sequence
table" (a table used only to dole out sequence numbers) like this:
create table sequence ( seq int not nul
W.,
Monday, July 01, 2002, 5:29:41 PM, you wrote:
WE> Does anybody know if there is a function to retrieve the next unique ID
WE> number for a record to be made in the future?
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by En
; Does anybody know if there is a function to retrieve the next unique ID
> number for a record to be made in the future?
>
>
> thx. Wilbert
>
> mysql query for next unique ID
>
> -
> Pas de Deux
> Van Mierisstraat 25
> 2526 NM Den Haag
> tel
Try this query:
SELECT
yourcolumn+1
FROM yourtable
ORDER BY id desc
LIMIT 1;
greetings,
richard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
Hi all,
Does anybody know if there is a function to retrieve the next unique ID
number for a record to be made in the future?
thx. Wilbert
mysql query for next unique ID
-
Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852
http
