MySQL Admin - How To Run "mysql" Commands from a Batch File
Interview Question Database For Software Developers
|
|
| How To Run "mysql" Commands from a Batch File | | How To Run "mysql" Commands from a Batch File? - MySQL FAQs - Command-Line End User Interface mysql | | By: 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
| | ID: 926 | Rank: 1068 | Votes: 0 | Views: 38 | Submitted: 20070510 |
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view