Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
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
✍: 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
2007-05-10, 6680👍, 0💬
Popular Posts:
Advantages of a macro over a function? Macro gets to see the Compilation environment, so it can expa...
Can you explain steps in function points? Below are the steps in function points: >First Count ILF, ...
How do we generate strong names ? or What is use the of SN.EXE ? or How do we apply strong names to ...
What is normalization? What are different types of normalization? It is set of rules that have been ...
How To Truncate an Array? - PHP Script Tips - PHP Built-in Functions for Arrays If you want to remov...