Do you have a question? Post it now! No Registration Necessary. Now with pictures!
October 7, 2005, 2:54 pm
rate this thread
records in sequence. However I am trying to modify this to work in
I cant seem to get the variable decleration right. I tried using
DECLARE CurVal int but that generates a mysql error. How can I modify
the code below to work under mysql?
DECLARE @CurVal int
DECLARE @FinalVal int
SELECT @CurVal = MAX(IdField) FROM MyTable
SET @FinalVal = @CurVal + 25
WHILE (@CurVal < @FinalVal)
SET @CurVal = @CurVal + 1
INSERT INTO `tbl_listings` ( `listnum`)
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum