方法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/article/details/124976921
https://blog.csdn.net/duoshehuan6005/article/details/128184450
统计指定数据库各个表大小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',CONCAT(ROUND(index_length/(1024*1024),4),'M') AS 'Index Size', CONCAT(ROUND((data_length+index_length)/(...
背景mysql数据库字段内容默认是不区分大小写的解决方法将数据库、数据表或表字段排序规则设置为bin结尾的类型即可示例：参考https://blog.csdn.net/weixin_42046751/article/details/107789377https://www.jianshu.com/p/977d78cfa0cc
背景Django使用DRF开发时，datetime时间格式返回给前端默认中间有个T字符，如2022-12-03T15:00:00解决方法在settings.py中增加如下配置：REST_FRAMEWORK = { 'DATETIME_FORMAT': "%Y-%m-%d %H:%M:%S", }参考http://wjhsh.net/gcgc-p-14024909.html
