重复insert,故障。高手处理！
#!/bin/bash
mysql -uroot -pBjxh6yZ masinterfacedb -e "select simmsid from zsl" >1
a=$(awk -F % 'NR==2 {printf $1}' 1)
echo $a
for n in 1 2 3 4 5 ;
do
mysql -uroot -pBjxh6yZ masinterfacedb -e "update zsl set SIMMSID=$((a+$n)),DESTADDR=$(awk -F % 'NR==$n {printf $1}' tele)";
imysql -uroot -pBjxh6yZ masinterfacedb -e "insert into mms_outbox select * from zsl";
done
tele一列电话号码。可读。
执行上述脚本后，报错！
41
ERROR 2013 (HY000): Lost connection to MySQL server during query
22.sh: line 8: imysql: command not found
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
22.sh: line 8: imysql: command not found
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
22.sh: line 8: imysql: command not found
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
22.sh: line 8: imysql: command not found
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
22.sh: line 8: imysql: command not found
请调手批点
mysql -uroot -pBjxh6yZ masinterfacedb -e "select simmsid from zsl" >1
a=$(awk -F % 'NR==2 {printf $1}' 1)
echo $a
for n in 1 2 3 4 5 ;
do
mysql -uroot -pBjxh6yZ masinterfacedb -e "update zsl set SIMMSID=$((a+$n)),DESTADDR=$(awk -F % 'NR==$n {printf $1}' tele)";
imysql -uroot -pBjxh6yZ masinterfacedb -e "insert into mms_outbox select * from zsl";
done
tele一列电话号码。可读。
执行上述脚本后，报错！
41
ERROR 2013 (HY000): Lost connection to MySQL server during query
22.sh: line 8: imysql: command not found
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
22.sh: line 8: imysql: command not found
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
22.sh: line 8: imysql: command not found
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
22.sh: line 8: imysql: command not found
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
22.sh: line 8: imysql: command not found
请调手批点
8同行回答
不懂Mysql，建议你把“mysql -uroot -pBjxh6yZ masinterfacedb -e”全部改成echo执行，看生成的变量值是否正确，然后对照SQL语法检查。收起
浏览632
语法错误，我对mysql不熟悉，先看有没有imysql命令，如果有，找到mysql的profile文件，在脚本里面加入类似如下的脚本就能用命令了：
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi收起
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi收起
浏览660
呵呵，版主。有人来踢馆了收起
浏览633
>> imysql -uroot -pBjxh6yZ masinterfacedb -e "insert into mms_outbox select * from zsl";
那来的imysql:@收起
那来的imysql:@收起
浏览635
第8行的 imysql应该是输入错误，上面的明显语法有问题~错误信息解释的很明白，你的update 应该把
SIMMSID=$((a+$n)),DESTADDR=$(awk -F % 'NR==$n {printf $1}' tele先赋给变量,而不是直接写在语句里，以后这类问题请先自己尝试从错误信息中寻找问题，这样才有助于自己提高收起
SIMMSID=$((a+$n)),DESTADDR=$(awk -F % 'NR==$n {printf $1}' tele先赋给变量,而不是直接写在语句里，以后这类问题请先自己尝试从错误信息中寻找问题，这样才有助于自己提高收起
浏览614