Hi all. I come from an MS SQL background and a newbie in MY SQL. Im trying to run a simple query to populate a table:
Declare @I As Int Select @I = 1 While (@I < 100) Begin Insert into tbWhatEva Select @I Select @I = @I + 1 End
Why is it so hard to populate arbitrary data in a loop? Please tell me where Im going wrong.