[mksingh79]

i have to create a batch process to populate my mysql tables with data from a file

this is what i normally do
i open the mysql prompt(just like dos prompt exe)
and get

mysql>

now i type"use tms;"

mysql> use tms;

this selects the database
and i get "database changed"

then i do this

mysql> source /path/to/file/test.sql;

this read the file and puts the data into the table.
and then

mysql> exit

i dont know batch programming
but i did this

@echo off
call C:\mysql\bin\mysql.exe

so i get to the mysql prompt but then how do i do the rest??

thanks

[mksingh79]

i got it