test-training.sql

-- Create test training data (%80) from ML-100K

CREATE TABLE ratings2
as
select
  rand() as rnd, 
  userid, 
  movieid, 
  rating
from 
  ratings;

CREATE TABLE training
as
select * from ratings2
order by rnd DESC
limit 80000;

CREATE TABLE testing
as
select * from ratings2
order by rnd ASC
limit 80000, 100000;