SQL problems....Error 28
Posted: Sun Apr 02, 2006 10:46 pm
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....SELECT *
FROM `000_data_01`
WHERE `data_used` =0
ORDER BY RAND( )
LIMIT 10
MySQL said:
#1030 - Got error 28 from table handler