方法SELECT *, round( st_distance_sphere ( point ( 116.393823, 39.905024 ), point ( `longitude`, `latitude` ) ), 2 ) dis FROM teacher ORDER BY dis参考https://blog.csdn.net/worilb/artic...
统计指定数据库各个表大小SELECT CONCAT(table_schema,'.',table_name) AS 'Table Name', CONCAT(ROUND(table_rows/1000000,4),'M') AS 'Number of Rows', CONCAT(ROUND(data_length/(1024*1024),4),'M') AS 'Data Size',CONC...
背景mysql数据库字段内容默认是不区分大小写的解决方法将数据库、数据表或表字段排序规则设置为bin结尾的类型即可示例:参考https://blog.csdn.net/weixin_42046751/article/details/107789377https://www.jianshu.com/p/977d78cfa0cc