2012年12月13日
摘要: SELECT * FROM information_schema.PROCESSLISTWHERE info IS NOT NULLORDER BY TIME desc,state,INFO;SELECT CONCAT('kill ',id,';') AS KillSQL FROM information_schema.PROCESSLIST WHERE info LIKE '%from /... 阅读全文
posted @ 2012-12-13 14:33 思静 阅读(2430) 评论(0) 推荐(0) 编辑
摘要: 1. SET @Template_Title_L=(SELECT Title FROM AA WHERE ID=1); 2. DECLARE Article_Title_L VARCHAR(1000); DECLARE Article_URL_L VARCHAR(1000); SELECT IFNULL(Article_Title,''),IFNULL(Article_... 阅读全文
posted @ 2012-12-13 14:31 思静 阅读(1617) 评论(0) 推荐(0) 编辑