MySQL 数据库字段简易比对工具

SELECT CONCAT(t1.TABLE_NAME,'|',t1.COLUMN_NAME,'|',IFNULL(t1.COLUMN_DEFAULT,''),'|',t1.IS_NULLABLE,'|',t1.DATA_TYPE,'|',IFNULL(t1.CHARACTER_MAXIMUM_LENGTH,''),'|',IFNULL(t1.CHARACTER_OCTET_LENGTH,''),
'|',IFNULL(t1.NUMERIC_PRECISION,''),'|',IFNULL(t1.NUMERIC_SCALE,''),'|',IFNULL(t1.DATETIME_PRECISION,''),'|',t1.COLUMN_TYPE,'|',IFNULL(t1.EXTRA,'')
) AS 'mix_column' FROM `information_schema`.`COLUMNS` t1
INNER JOIN `information_schema`.`TABLES` t2 ON t1.TABLE_NAME = t2.TABLE_NAME
WHERE t1.TABLE_SCHEMA = 'poadb_crm' AND t2.TABLE_SCHEMA = 'poadb_crm' 
ORDER BY t1.TABLE_NAME,t1.COLUMN_NAME LIMIT 100000