- or download this
update table set turns = turns+ x;
update table set turns = max where turns > max;
commit;
- or download this
update table set
last_login = sysdate(),
turns_left = ( $turns_per_day * datediff( sysdate(), last_login ))
where user_id = ?
- or download this
update table set
turns_left = ( $turns_per_day * datediff( sysdate(), last_login ))
+,
last_login = sysdate()
where user_id = ?