可以执行建库和表,但是没法插入数据,一执行脚本就提示没有命令;
insert_sql="insert into ${TABLENAME} values (1,'cai','male','131623456','t416',4),(2,'shijun','male','131123456','t416',4),(3,'shi','male','131323456','t416',4),(4,'huang','male','131423456','t416',4),(5,'zhangtao','male','131223456','t416',4),(6,'dai','male','131234561','t416',4),(7,'xiao','male','131564123','t416',4),(8,'zhangzhen','male','131123654','t416',4),(8,'hou','male','131123465','t416',4),(10,'wang','male','131123456','t416',4)"
msyql -h ${HOSTNAME} -P ${PORT} -u ${USERNAME} -p${PASSWORD} ${DBNAME} -e " ${insert_sql} "
./mysql$$shell.sh: line 17: msyql: command not found