Re^2: SQL solution or Perl solution?

You actually don't even need to do that...

select * from my_table order by rand();
[download]

will tell MySQL to randomize the record order. I assume most other database engines have a similar capability, although I wouldn't necessarily expect the syntax to be the same.

Comment on Re^2: SQL solution or Perl solution? Download Code

Replies are listed 'Best First'.
Re^3: SQL solution or Perl solution? by KurtSchwind (Chaplain) on Nov 06, 2007 at 21:18 UTC
I didn't recognize 'identity' so I didn't think this was MySQL. I think it's either SQL Server or Sybase because of the TSQL part. Inserting random strings via perl is easy. Use Perl's DBI package. Like the rest of you, I'm waiting for some more clarification. -- I used to drive a Heisenbergmobile, but every time I looked at the speedometer, I got lost.	[reply]
A reply falls below the community's threshold of quality. You may see it by logging in.