xiaolin_2016的博客

SELECT store_name, ( st_distance ( point (lng, lat), point ( 114.24779, 22.71991 ) ) * 111195 / 10000 ) AS juli FROM ylk_store ORDER BY juli ASC

废话不多说直接贴SQL语句 SELECT moments.id AS id, COUNT(endorse.id) AS endorseCount, COUNT(reply.id) AS replyCount FROM jq_circle_moments moments LEFT JOIN jq_circle_endorse endorse ON moments.id = endorse...

这个错误搞了我两个小时，百度了好久终于发现一个能解决的  ALTER TABLE `seat` CONVERT TO CHARACTER SET utf8;   解决1366错误

1.安装mysql的yum源 a.下载配置mysql的yum源的rpm包       根据上面3张图片中的操作下载下来的rpm文件可以通过如下命令获取： wget https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm   b.安装用来配置mysql