Re: Randomize column order

2001-07-20 Thread Max Frazer
There are only 8,000 rows. Unfortunately, I was really hoping for some sort of function within MySQL to do this. I'm not using PHP, but rather Perl. I could pretty much do the same thing in Perl, I guess. Is there any elegant solution or alternative within MySQL? On Friday, July 20, 2001, a

Randomize column order

2001-07-20 Thread Max Frazer
I'm sure I'm just missing something basic, but here goes... I need to create a table, populated with data, from an existing table. Easy enough: "create table TEST select * from OLD_DATA" Most cool. Now, let's say OLD_DATA has three columns: A, B, & C. I want to create new table TEST, with a