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