mysql insert

[jenniferG]

we are  investigating a piece of php4 code  datagrid generator and the code

supplier  gave us a database file callet test.sql  the  file contains

a table create  statrement followed by a number of insert statements.  From

the mysql prompt,  what is the syntax for  loading that file into the database?

 

Thanks,

Annabel 

[sushant_d84]

source    (\.) Execute an SQL script file. Takes a file name as an argument.

 

mysql> \. c:\ssd.txt

 

 

Try this out........

 

 

 

Regards

Sushant