import data into mysql

import.cmd

@echo off

IF EXIST load.sql echo. > load.sql

for /f %%a IN ('dir /b *_iewpg.txt') do (
echo %%a
echo load data LOCAL infile '%%a' into table iewpg fields terminated by '\t' lines terminated by '\n'; >>load.sql
)


for /f %%a IN ('dir /b *_iewtr.txt') do (
echo %%a
echo load data LOCAL infile '%%a' into table iewtr fields terminated by '\t' lines terminated by '\n'; >>load.sql
)