mysql and bash

rharris72 · 12-23-2005, 04:54 PM

is there away of getting some info from a database and then getting a bash script to asign it to a string so i can use it to sed into an existing file

thanks in advance

Hko · 12-24-2005, 06:01 AM

Sure.
Example:

Code:

#!/bin/bash

USER=root
PASSWD=secret

printcolumns()
{
    TABLE=$1
    echo "describe $TABLE" \
      | mysql -s -B -u $USER --password=$PASSWD mysql \
      | while read COL; do
        COLNAME=$(echo $COL | cut -f1)
        echo -e "\t$COLNAME"
    done
}

echo "show tables" \
  | mysql -s -B -u $USER --password=$PASSWD mysql \
  | while read TABLE; do
    echo 'Table: "'${TABLE}'" :'
    printcolumns $TABLE
    echo
done