insert into drupal_test.users(
uid, name,
pass, mail,
mode,sort,
threshold, timestamp,
status,timezone,
rating,language,
init)
select 
uid,  nickname,
MD5(uid),
realemail,
0,0,
0, UNIX_TIMESTAMP(),
1,0,
0.00,'en',
realemail
from scoop_test.users
where uid>1