Page 1 of 1

SQL problems....Error 28

Posted: Sun Apr 02, 2006 10:46 pm
by Deseree
SELECT *
FROM `000_data_01`
WHERE `data_used` =0
ORDER BY RAND( )
LIMIT 10


MySQL said:

#1030 - Got error 28 from table handler
How do i fix this??? I have 2 million rows of data in table 000_data_01, and I want it to randomly return 10 rows.... and then mark those ten as used so they don't get used again....

Posted: Sun Apr 02, 2006 10:51 pm
by John Cartwright
You already tried threadjacking, and now multiple, identical threads?

Topic Locked.