mysql与shell关系_shell脚本内与mysql交互

一：

mysqlCMD="mysql -h${MYSQL_HOST}  -P${MYSQL_PORT}  -u${MYSQL_USER} -p${MYSQL_PASS}"

create_table_sql="CREATE TABLE IF NOT EXISTS ${MYSQL_DB_NAME}.${access_table_name} (

id INT(10) NOT NULL AUTO_INCREMENT,

accId INT(10) NOT NULL,

URL INT(10) NOT NULL,

....

PRIMARY KEY (id),

INDEX URL (URL)

)

COLLATE='utf8_general_ci'

ENGINE=MyISAM

ROW_FORMAT=DEFAULT

AUTO_INCREMENT=1"

empty_table_sql="TRUNCATE ${MYSQL_DB_NAME}.${table_name} "

echo $create_table_sql | ${mysqlCMD}

echo $empty_table_sql | ${mysqlCMD}

insert等操作同理

二：

loadsql="LOAD DATA LOW_PRIORITY LOCAL INFILE '${LOG_TEMP}' INTO TABLE ${MYSQL_DB_NAME}.${table_name} FIELDS TERMINATED BY '&' LINES TERMINATED BY '

'(id,URL.....);"

mysql -h ${MYSQL_HOST} -P ${MYSQL_PORT} -u ${MYSQL_USER} -p'${MYSQL_PASS}' -N -e "${loadsql}"

insert等操作同理