Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200

    Unanswered: Mysql query in script

    Hi guys,

    I would like to run a shell script.I want to assign a values from a mysql query within a shell script.As

    t = ./mysql -D database -e "select count(*) from tablename;"

    so t can contain the number of records in the table and I can run futher in a loop.

    The part where I get stuck is when I run the script it says

    test_scrpt.sh: line 25: -D: command not found


    Please help me on this.

    Thnaks
    micky

  2. #2
    Join Date
    Apr 2004
    Location
    Europe->Sweden->Stockholm
    Posts
    71
    You want to start "mysql" with some parameters and input data from shell_script.sh? Have you tried using backticks?

    T = `mysql -e "..."`

  3. #3
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200
    Hi

    Thank you very much

    God bless you

    micky

Posting Permissions

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