Batch execute mysql scripts from Windows NT shell

By teamprinceton | November 6, 2015 |

Ever had to execute hundreds of sql scripts for the initial setup of some schema? This nifty one-liner will sort things out for you if you’re working on Windows platform: FOR %%X IN (*.sql) DO mysql -u DB_USERNAME -pDB_PASS -h localhost SCHEMA_NAME< %%X What this will do is, it’ll look for all the filenames with … Continue reading “Batch execute mysql scripts from Windows NT shell”

Read More