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 all
How many rows do you have? I'd do it in php along those lines:
read the rows from the old table in 3 arrays. randomize one or
all of them (built in function in version 4, else do it
yourself), then populate new table from those arrays.
Sie schrieben am Freitag, 20. Juli 2001, 23:56:38:
I'm
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,