请高手指点

z13682007

mysql -uroot -pBjxh6yZ masinterfacedb -e "select simmsid from zsl" >1
a=$(awk -F % 'NR==2 {printf $1}' 1)
tele1=15802694097
tele2=15973111256
tele3=15116242898
tele4=15974158275
n=1
while [ $n -le 40 ]; do
mysql -uroot -pBjxh6yZ masinterfacedb -e "update zsl set SIMMSID=$((a+1)),DESTADDR=$tele1"
mysql -uroot -pBjxh6yZ masinterfacedb -e "insert into mms_outbox select * from zsl"

mysql -uroot -pBjxh6yZ masinterfacedb -e "update zsl set SIMMSID=$((a+2)),DESTADDR=$tele2"
mysql -uroot -pBjxh6yZ masinterfacedb -e "insert into mms_outbox select * from zsl"

mysql -uroot -pBjxh6yZ masinterfacedb -e "update zsl set SIMMSID=$((a+3)),DESTADDR=$tele3"
mysql -uroot -pBjxh6yZ masinterfacedb -e "insert into mms_outbox select * from zsl"

mysql -uroot -pBjxh6yZ masinterfacedb -e "update zsl set SIMMSID=$((a+4)),DESTADDR=$tele4"
mysql -uroot -pBjxh6yZ masinterfacedb -e "insert into mms_outbox select * from zsl"
   n=$(($n+4));
done

给出具体配置。我想优化！谢谢大家！

kider

看你就想根据上下文修改数据，直接用存储过程好了，给你个例子，参考改写吧：

1. DELIMITER $$
   
2. 
   
3. CREATE DEFINER=`admin`@`%` PROCEDURE `USP_Abc`(v_OwnerId INT
   
4.     )
   
5. SWL_return:
   
6.     BEGIN
   
7.         DECLARE v_BuddyCount INT;
   
8. 
   
9.         SELECT ....
   
10.         IF v_at>=v_att THEN
    
11.                 SELECT -520 AS 'Version';
    
12.                 LEAVE SWL_return;
    
13.         END IF;
    
14.         IF EXISTS(SELECT * FROM ttt WHERE ..) THEN
    
15.                 SELECT ...;
    
16.                 LEAVE SWL_return;
    
17.         END IF;
    
18.        
    
19.        
    
20.     END$$
    
21. 
    
22. DELIMITER ;
    

复制代码

kider

动态SQL的例子：

1. DROP PROCEDURE IF EXISTS `USP_LoadConfigTable`$$
   
2. CREATE DEFINER=`admin`@`%` PROCEDURE `USP_LoadConfigTable`(v_TableName        VARCHAR(64))
   
3. BEGIN
   
4.         DECLARE v_stat VARCHAR(200);
   
5.         SET @v_stat=CONCAT('select * from ',v_TableName);       
   
6.         PREPARE SelectConfigTable FROM @v_stat;
   
7.         EXECUTE SelectConfigTable;
   
8.     END$$
   
9. DELIMITER ;
   

复制代码