faqts : Computers : Databases : MySQL : Shell Commands : mysql

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

87 of 114 people (76%) answered Yes
Recently 7 of 10 people (70%) answered Yes

Entry

How can I execute SQL statements in a text file inside MySQL?
Can I use a file as input to the mysql monitor program?
Using a Win 32-System is it necessary to set the Path-variable to mysql, if you want to use the batc

May 12th, 2008 20:33
i can do it, Nathan Wallace, Ralf Zimmer, Sinisa Milivojevic


Use the mysql monitor program, like this:
    mysql -u user -ppassword -h host database < your_text_file.txt
http://www.stupidarticles.com
http://www.halazona.com
http://www.shikapika.com
http://www.stakoza.com
http://www.uploadarticles.com
http://www.ganazat.com
http://www.damima.com
http://www.tarabiza.com
http://www.articlesxarticles.com
http://www.articlesfreedirectory.com