Perintah sql milih user aktif moodle

 SELECT id, username, firstname, lastname
FROM mdl_user
WHERE deleted = 0
  AND suspended = 0
  AND confirmed = 1
  AND username <> 'guest';
785 rows in set (0.004 sec)



SELECT id, username, firstname, lastname
FROM mdl_user
WHERE deleted = 0
  AND suspended = 0
  AND confirmed = 1
  AND username <> 'guest'
INTO OUTFILE '/tmp/user_Active2025.csv'
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
LINES TERMINATED BY '\n';