02 2017 档案

附近的店铺 mysql查询
摘要：SELECT lat, lng, SQRT(POW(111.2 * ( lat - 31.8366060000), 2) + POW(111.2 * (118.5984990000 - lng) * COS(lat/ 57.3), 2)) AS distance FROM rep_info wher 阅读全文
posted @ 2017-02-17 14:11 he0xff 阅读(964) 评论(0) 推荐(0)
mysql 循环插入表
摘要：DELIMITER:CREATE PROCEDURE test_insert() BEGIN DECLARE i INT DEFAULT 1;WHILE i<100 DO insert into test(id, name) values (i, i); SET i=i+1; END WHILE ; 阅读全文
posted @ 2017-02-09 11:10 he0xff 阅读(458) 评论(0) 推荐(0)