Bash scripting, mysql, and creating tables.
I am trying to write a script that creates a table, and I am not getting very far with it. This is what I have:
DBCON="/usr/bin/mysql -h$DBHOST -u$DBUSERNAME -p$DBUSERPASS"
TABLEADD="CREATE TABLE $DBTABLE x VARCHAR(25), y VARCHAR(25), z VARCHAR(25), planet name VARCHAR(25), ruler name VARCHAR$
$DBCON && $TABLEADD
So when I execute it, it just goes into mysql and doesnt pass along the table creation part. What am I doing wrong?