luogan129的博客

mysql循环插入数据库中数据。DELIMITER ;; CREATE PROCEDURE test_insert () BEGIN DECLARE i INT DEFAULT 1;WHILE i<100 DO insert into goods(good_name,good_price,de) values ('gui',i,'hao'); SET i=i+1; END WHILE

http://www.cnblogs.com/yxhblogs/p/6666988.html 完整的PHP MYSQL数据库类MySQL数据库操作类(PHP实现，支持连贯操作) http://blog.youkuaiyun.com/helencoder/article/details/51172389

mysql 数据表中查找重复记录SELECT open_id, ip, Count(*)FROM dingding_user_countWHERE type = 'readypro'GROUP BY ipHAVING Count(*) > 1ORDER BY Count(*) DESC;

SELECT * FROM `www.ipplus360.com`.`aiwen_free_district_v2.0.1` WHEREINET_ATON('222.85.85.85') BETWEEN minip AND maxip LIMIT 1;查询速度比较快： SELECT * FROM `www.ipplus360.com`.`aiwen_free_district_v2.0.1` W