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
SQL problems....Error 28
Moderator: General Moderators
SQL problems....Error 28
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact: