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, 6843👍, 0💬
Popular Posts:
Can you explain project life cycle ? Figure :- 12.2 Life cycle of a project There are five stages of...
.NET INTERVIEW QUESTIONS - What are Daemon threads and how can a thread be created as Daemon? Daemon...
How To Get the Uploaded File Information in the Receiving PHP Script? Once the Web server received t...
How To Use SELECT Statement to Count the Number of Rows? - Oracle DBA FAQ - Understanding SQL SELECT...
Would I use print "$a dollars" or "{$a} dollars" to print out the amount of dollars in this example?...