MySQL Programming Question:

How To Run "mysql" Commands from a Batch File?

Tweet Share WhatsApp

Answer:

If you have group of "mysql" commands that need to be executed repeatedly, you can put them into a file, and run them from the file in "mysql" batch mode. Here is a batch file, emplinks.sql, contains following commands:

USE test;
INSERT INTO links VALUES (10, 'www.GlobalGuideLine.com');
SELECT * FROM links;

To run this batch file, you need to follow this tutorial:

>cd mysqlin
>mysql -u root < emplinks.sql
id name
1 www.GlobalGuideLine.com
10 www.GlobalGuideLine.com


Download MySQL Programming PDF Read All 110 MySQL Programming Questions
Previous QuestionNext Question
How To Get Help Information from the Server?How To Return Query Output in HTML Format?