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

mysql -u root -p produksi -e "
SELECT
    a.id, 
    a.nama,
    a.nta_primer,
    g.name,
    s.name as pangkalan,
    k.name as kecamatan,
    kb.name as kabupaten,
    p.name as propinsi
FROM tm_data_anggota a
JOIN tm_ref_gol_pramuka g
    ON a.gol_pramuka_id = g.id
JOIN tm_data_sekolah s 
    ON a.sekolah_id = s.id
JOIN tm_ref_kecamatan k 
    ON s.kecamatan_id = k.id
JOIN tm_ref_kabupaten kb 
    ON k.kabupaten_id = kb.id
JOIN tm_ref_propinsi p 
    ON kb.propinsi_id = p.id
WHERE p.id = 33 and s.pendidikan_id = 10 and a.gol_pramuka_id in (11,38)
" | sed 's/\t/;/g' > data_ketua_sekretaris_kwarcab_jateng.csv