Mysql
encircles
百度一下...
展开
-
Mysql,docker-compose主从配置
mysql主从 docker-compose.yml version: "3" services: mysql-master: image: mysql:5.7 container_name: mysql_master ports: - 3306:3306 volumes: - ./volume/mysql-master:/var/lib/mysql - ./volume/conf/mysql-ms/mysqld-master.cnf:原创 2020-05-12 11:05:57 · 276 阅读 · 0 评论 -
Mysql from 子查询问题? 随笔
表结构 select goods_id,goods_name from (SELECT * FROM `goods` WHERE 1 ORDER BY cat_id ASC,goods_id DESC) as tmp group by cat_id 上面的sql语句 5.6 和 5.1 结果不同 是mysql版本升级带来的改变吗?原创 2016-08-23 21:08:11 · 1119 阅读 · 0 评论 -
Mysql根据坐标字符串排序
SELECT id, desa, point FROM dyr_line WHERE point != '' ORDER BY GLength (LineStringFromWKB (LineString (GeomFromText(CONCAT('POINT(',(replace(point,',',' ')),')')) ,point (104.629239,28.770671))原创 2017-09-11 17:09:04 · 681 阅读 · 0 评论