摘要:
CREATE DEFINER=`root`@`%` FUNCTION `getDistance`(`lat1` decimal(10,7),`lon1` decimal(10,7),`lat2` decimal(10,7),`lon2` decimal(10,7)) RETURNS decimal( 阅读全文
摘要:
DELETE FROM table WHERE id NOT IN (//根据判断字段查出对应最小id的集合 SELECT dt.min_id FROM ( SELECT MIN(id) AS min_id FROM table GROUP BY c_id//判断唯一字段 ) AS dt ) 阅读全文