mysql 查询库中所有表和表中所有字段

SELECT
	TABLE_NAME,
	column_name,
	column_comment,
	CHARACTER_MAXIMUM_LENGTH 
FROM
	information_schema.COLUMNS 
WHERE
	table_schema = 'wise_base_device' 
	AND column_name = 'store_code';


select
	CONCAT( 'CREATE DATABASE ', table_schema , ' DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ;' )
from
	(
	SELECT
		DISTINCT table_schema
	FROM
		information_schema.COLUMNS) t
where
	t.table_schema not in ('sys', 'information_schema', 'performance_schema', 'mysql')



查询表中所有字段
SELECT
	concat(
		'select ',
		(
		SELECT
			group_concat( u.NAME SEPARATOR ',' ) concat 
		FROM
			( SELECT DISTINCT column_name AS NAME FROM information_schema.`COLUMNS` WHERE table_schema = 'rootdb' AND table_name = 'user' ) AS u 
		),
		' from user' 
	) AS querySql