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, 6918👍, 0💬
Popular Posts:
What are urlencode() and urldecode() functions in PHP? string urlencode(str) - Returns the URL encod...
Jack developed a program by using a Map container to hold key/value pairs. He wanted to make a chang...
Can include files be nested? The answer is yes. Include files can be nested any number of times. As ...
What Information Is Needed to Connect SQL*Plus an Oracle Server? - Oracle DBA FAQ - Introduction to ...
Write an equivalent expression for x%8? x&7