Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    5

    Unanswered: execute sql query from command line

    hello,
    I need to execute sql query from command line

    I have to schedule a batch file which execute a query onto a mysql DB (so specifying username, pwd, sql file, server etc...) and get the results into a xls (or csv or other) file....

    may you help me?

    thanks

  2. #2
    Join Date
    Nov 2003
    Posts
    2,932
    Provided Answers: 12
    Use the MySQL commandline program and pass the script to be executed:

    MySQL :: MySQL 5.1 Reference Manual :: 4.5.1 mysql ? The MySQL Command-Line Tool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •