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
mysql 查询库中所有表和表中所有字段
于 2020-12-29 17:33:23 首次发布