Collections:
Running "mysql" Commands from a Batch File in MySQL
How To Run "mysql" Commands from a Batch File in MySQL?
✍: FYIcenter.com
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, \temp\links.sql, contains following commands:
USE test; INSERT INTO links VALUES (10, 'dba.fyicenter.com'); SELECT * FROM links;
To run this batch file, you need to follow this tutorial:
>cd \mysql\bin >mysql -u root < \temp\links.sql id name 1 dba.fyicenter.com 10 dba.fyicenter.com
⇒ Returning Query Output in HTML Format in MySQL
⇐ Getting Help Information from the Server in MySQL
2018-02-08, 1982🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...