shell脚本内与交互
 
一:
 
[plain] 
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等操作同理  
 
二:
 
[plain] 
loadsql="LOAD DATA LOW_PRIORITY LOCAL INFILE '${LOG_TEMP}' INTO TABLE ${MYSQL_DB_NAME}.${table_name} FIELDS TERMINATED BY '&' LINES TERMINATED BY '\n'(id,URL.....);"  
  
mysql -h ${MYSQL_HOST}  -P ${MYSQL_PORT}  -u ${MYSQL_USER} -p'${MYSQL_PASS}' -N -e "${loadsql}" 
insert等操作同理