DEV Community

Cover image for Import banyak sql file
Eko Priyanto
Eko Priyanto

Posted on

Import banyak sql file

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" 
Enter fullscreen mode Exit fullscreen mode

Top comments (0)