摘要：BEGINSET @baseStr= "SELECT * FROM tbName WHERE 1=1 ";SET @_where="";IF 1=1 THEN SET @_where= CONCAT(@_where," AND sourcedomain=\"www.baidu.com\" ");E... 阅读全文

摘要：自增Id重新计数 TRUNCATE TABLE 表名获取最后插入数据的ID SELECT LAST_INSERT_ID();使用"id1,id2,id3"当参数 FIND_IN_SET(id,"id1,id2,id3,")返回受影响行数 FOUND_ROWS() : select ROW_COUNT 阅读全文

摘要：1. 1 using System; 2 using System.Collections; 3 using MySql.Data.MySqlClient; 4 5 namespace Helper 6 { 7 /// 8 /// MySQL连接池 9 /// 10 ... 阅读全文