Import banyak sql file

#mysql #sql

Buka CMD

mysql -u root --password=""



for %f in (G:\IDEA\wilayah_boundaries-main\wilayah_boundaries-main\db\prov\*.sql) do mysql -u root --password= lentera < "%f"



for %f in (G:\IDEA\wilayah_boundaries-main\wilayah_boundaries-main\db\kab\*.sql) do mysql -u root --password= lentera < "%f"



for %f in (G:\IDEA\wilayah_boundaries-main\wilayah_boundaries-main\db\kec\*.sql) do mysql -u root --password= lentera < "%f"

# untuk sub foldernya
for /r G:\IDEA\wilayah_boundaries-main\wilayah_boundaries-main\db\kel %f in (*.sql) do mysql -u root --password= lentera < "%f"