[MYSQL] EXPORT QUERY TO CSV - fourslickz/notes GitHub Wiki

mysql -u root -p DATABASE_NAME -e "
SELECT 
    u.id AS user_id,
    u.name AS name,
    u.email AS email,
    u.firebase_uid AS firebase_uid,
    COALESCE(
        SUM(
            COALESCE(tgt.gems_collected,0) - COALESCE(tgt.gems_used,0)
        ),0
    ) AS total_coin
FROM users u
LEFT JOIN tt_gems_transactions tgt 
    ON tgt.user_id = u.id
    AND tgt.status IN ('SUCCESS','PROCESSED','SENT')
    AND tgt.status_type = 'COMPLETED'
    AND tgt.is_delete = 0
    AND tgt.is_active = 1
    AND tgt.created_at >= '2026-02-03 00:00:00'
GROUP BY u.id
" | sed 's/\t/,/g' > user_coin_report.csv