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, 6711👍, 0💬
Popular Posts:
What is Concern in AOP? gA concern is a particular goal, concept, or area of interesth There are m...
Can you explain project life cycle ? Figure :- 12.2 Life cycle of a project There are five stages of...
Can a variable be both const and volatile? Yes. The const modifier means that this code cannot chang...
What are some uses of Intranets & Extranets? An "intranet" is the generic term for a collect...
How To Compile a JUnit Test Class? Compiling a JUnit test class is like compiling any other Java cla...