qq_45156302的博客

mysql添加距离函数问题:随着数据的增多，计算距离的函数会遍历全部数据，导致sql执行变慢。不适合数据量很大的表。SELECT*FROM(SELECTget_distance( ‘118.79926367881872’, ‘31.98749838084618’, s. longitude, s. latitude) DISTANCE, s. id, s. station_name, s. station_type, s. province_code, s. city_code, s. are

mysql命令gruop by报错this is incompatible with sql_mode=only_full_group_by查看mysql版本命令：select version();查看sql_model参数命令：SELECT @@GLOBAL.sql_mode;SELECT @@SESSION.sql_mode;发现：ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIV