mySQL import file/script

[bobrivers2003]

Hi,

I have a fairly average skill in mysql. I just wanted to know what the command is to import a file of queries to, for example create a table. I wish to write the instructions in a text file then bring in the file instead of a line by line basis on the command line.

Thanks

 

[TonyGroves]

From the command shell:
[tt]mysql [options] <filepath[/tt]

 

[bobrivers2003]

Worked a treat thank you for your help