Entry

Database: MySql: Command: Multiple: Execute: How to: How to run pipe commands in MySql?

Jul 6th, 2008 13:23
Knud van Eeden, dman,

----------------------------------------------------------------------
--- Knud van Eeden --- 22 May 2005 - 02:03 am ------------------------

Database: MySql: Command: Multiple: Execute: How to: How to run pipe 
commands in MySql?

---

Steps: Overview:

 1. -Create a file containing your SQL commands
     (you will not see the SQL query text while they are executed)

e.g.

--- cut here: begin --------------------------------------------------

CREATE DATABASE databaseTest;

USE databaseTest;

CREATE TABLE
 tableCustomer
(
 columnId INT NOT NULL PRIMARY KEY,
 columnName VARCHAR( 50 )
)
;

INSERT INTO
 tableCustomer
(
 columnName
)
VALUES
(
 "Knud"
)
;

--- cut here: end ----------------------------------------------------

 2. -Save this file

      e.g. save as

       yourfilename.txt

 3. -Start MySql

 4. -Run mysql.exe by typing

      mysql.exe < yourinputfilename.txt

 5. -That will pipe this text into mysql.exe, which
     will execute it

 6. -If you want to also output the result into a file,
     from the command line, use

      mysql.exe < yourinputfilename.txt  > youroutputfilename.txt

     ---

     Note:

     This gives a possibility to automate, e.g. by using
     this commands in an MSDOS batch file.

---
---

Internet: see also:

---

Database: MySql: Command: Multiple: Execute: How to execute multiple 
commands at once in MySql?
http://www.faqts.com/knowledge_base/view.phtml/aid/36416/fid/52

----------------------------------------------------------------------