-
-
Notifications
You must be signed in to change notification settings - Fork 316
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
request data #22
Comments
izin bantu jawab mas @cahyadsn ,
Contoh Query Provinsi :SELECT * FROM wilayah_2020 WHERE CHAR_LENGTH(kode) = 2;
Contoh Query Kota berdasarkan Provinsi :SELECT * FROM wilayah_2020 WHERE CHAR_LENGTH(kode) = 5 AND LEFT(kode, 2) = '16';
Contoh Query Kecamatan berdasarkan Kota :SELECT * FROM wilayah_2020 WHERE CHAR_LENGTH(kode) = 8 AND LEFT(kode, 5) = '16.71';
Contoh Query Kelurahan / Desa berdasarkan Kecamatan :SELECT * FROM wilayah_2020 WHERE CHAR_LENGTH(kode) = 13 AND LEFT(kode, 8) = '16.71.07';
Selanjutnya silahkan dikembangkan lagi Query nya sesuai keperluan anda, dan jika sudah terjawab pertanyaan nya silahkan lakukan "Close Issue" karena ini lebih ke permasalahan end user dalam menggunakan data yang ada pada repo ini / cara pemanggilan data / query. Best Regard |
Referenced issue cahyadsn#22
halo mas @cahyadsn klo untuk request data sampe kecamatan bagaimana caranya ya ?
The text was updated successfully, but these errors were encountered: