Mysql
lib_seek
重走人生路?
展开
-
mysql 多表查询
SELECT a.id, a.user_name, a.user_mobile, b.area_name, d.is_all_true, d.countFROM ( SELECT c.is_all_true,c.count,c.user_id FROM ...原创 2019-12-05 13:40:21 · 113 阅读 · 0 评论 -
使用Navicat导出数据字典
SELECT t.TABLE_NAME AS 表名, t.COLUMN_NAME AS 字段名, t.COLUMN_TYPE AS 数据类型, CASE IFNULL(t.COLUMN_DEFAULT,'Null') WHEN '' THEN '空字符串' WHEN 'Null' THEN 'NULL' ELSE...原创 2019-10-16 13:42:44 · 370 阅读 · 0 评论