随笔分类 -  mysql

mysql 存储过程 动态sql例子
摘要：proc:BEGIN DECLARE _count INT DEFAULt 0; DECLARE _eventID INT DEFAULT 0; DECLARE _status INT DEFAULT 0; DECLARE _startTime VARCHAR(19) DEF... 阅读全文
posted @ 2014-05-12 17:16 耐得住寂寞 阅读(675) 评论(0) 推荐(1)
mysql 存储过程 事务处理
摘要：BEGIN DECLARE t_error INTEGER DEFAULT 0; DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1; START TRANSACTION; #这边放sql语句,涉及到的表必须都为I... 阅读全文
posted @ 2014-04-23 14:25 耐得住寂寞 阅读(3976) 评论(1) 推荐(1)
mysql排行榜sql的实现
摘要：SELECT num_rowsFROM (SELECT @rownum := @rownum + 1 AS num_rows, openid FROM (SELECT @rownum := 0, openid, money FROM lt_cash_user ) t... 阅读全文
posted @ 2014-01-20 10:42 耐得住寂寞 阅读(290) 评论(0) 推荐(0)
MYSQL 简单的循环存储过程
摘要：BEGIN DECLARE i int DEFAULT 1; DECLARE j int DEFAULT 1; WHILE i<15 DO WHILE j<5 DO INSERT *** VALUES(NULL,'***',i,j,0); SET j=j+1; IF (i=14 AND j=3) THEN SET j=5; END IF; END WHILE; SET j=1; SET i=i+1... 阅读全文
posted @ 2014-01-15 16:10 耐得住寂寞 阅读(252) 评论(0) 推荐(0)