if [ $? -ne 0 ] ;then
echo "insert data faild" >>$log
else
echo "insert data sucess" >>$log
fi
}
function mysql_create(){
echo | ${mysql_login} #判断数据库是否连接成功
if [ $? -ne 0 ]; then
echo "login mysql ${HOST}:${PORT} failed.." >>$log
exit 1
else
echo "login mysql ${HOST}:${PORT} success!" >> $log
fi
echo "create database $DBNAME ..." >> $log #创建数据库
mysql_create_db="create database if not exists $DBNAME"
echo ${mysql_create_db} | ${mysql_login}
if [ $? -ne 0 ]; then
echo "create db ${DBNAME} failed.." >> $log
else
echo "create db ${DBNAME} success!" >> $log
fi
echo "create table $TABLENAME ..." >> $log #创建表
mysql_create_table="CREATE TABLE $TABLENAME (
ur_id int(11) NOT NULL AUTO_INCREMENT,
visit_user_id int(11) NOT NULL DEFAULT '0',
visit_user_kind char(1) NOT NULL DEFAULT '1',
res_user_id int(11) NOT NULL DEFAULT '0',
res_id int(11) NOT NULL DEFAULT '0',
ur_createtime char(14) NOT NULL DEFAULT '00000000000000',
ur_ip varchar(15) NOT NULL DEFAULT '',
PRIMARY KEY (ur_id),
KEY idx_visituserid_resid (visit_user_id,res_id),
KEY idx_resuserid_createtime (res_user_id,ur_createtime)
) ENGINE=MyISAM AUTO_INCREMENT=1168783 DEFAULT CHARSET=gbk"
echo ${mysql_create_table} | ${mysql_login} ${DBNAME}
if [ $? -ne 0 ]; then
echo "create table ${TABLENAME} fail..." >> $log
else
echo "create table ${TABLENAME} success!" >> $log
fi
}