useful-queries

UPDATE corporate_member_info SET 
course_access = NULL,
mng_group ="Zamil Group",
r_comp= NULL,
o_comp = NULL,
group_id = 442,
f_name = NULL,
l_name = NULL,
language_preference = "en",
Nname_f = NULL,
Nname_l = NULL,
password = "****",
email = NULL,
report_frequency = NULL, 
report_recipients = NULL,
total_time_spent = NULL,
current_login = NULL,
logins = NULL,
activate_date = NULL,
subscription_start_date = NULL,
subscription_end_date = NULL,
standby = 1,
completed = 0,
test_pass = 0, 
in_progress = 0,
active = 1
WHERE
test_user = NULL
AND portal_id = {{portal_id}}
LIMIT 50


//rest test user course progress
DELETE FROM member_course_table WHERE group_id = {{group_id}}

//set hard limit on subscription end date
UPDATE `corporate_member_info` SET duration = DATEDIFF({{end date}}, subscription_start_date), subscription_end_date = {{end_date}}