MariaDB社区

标题: 请高手指点 [打印本页]
作者: z13682007    时间: 2011-11-9 08:24
标题: 请高手指点
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    时间: 2011-11-9 17:50
看你就想根据上下文修改数据，直接用存储过程好了，给你个例子，参考改写吧：
  1. DELIMITER $$

  3. CREATE DEFINER=`admin`@`%` PROCEDURE `USP_Abc`(v_OwnerId INT
  4.     )
  5. SWL_return:
  6.     BEGIN
  7.         DECLARE v_BuddyCount INT;

  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$$

  22. DELIMITER ;
复制代码
作者: kider    时间: 2011-11-9 17:51
动态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 ;
复制代码




欢迎光临 MariaDB社区 (http://123.56.88.72/) Powered by Discuz! X3.2