随笔分类 -  mysql

摘要：SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = '字段名' -- AND TABLE_SCHEMA='数据库名' -- AND TABLE_NAME NOT LIKE '表明%'; 阅读全文

摘要：/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50527 Source Host : localhost:3306 Source Database : mydb Target Serv 阅读全文

摘要：/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50527 Source Host : localhost:3306 Source Database : mydb Target Serv 阅读全文

摘要：SELECT * FROM (SELECT id, name, age, count(*) sum FROM person GROUP BY id, name, age) WHERE sum > 1; 阅读全文

摘要：-- 查询orderdetail表在哪个数据库mysql> SELECT table_schema FROM information_schema.TABLES WHERE table_name = 'orderdetail';+ +| table_schema |+ +| mybatis |+ + 阅读全文