SELECT table_name,column_name, column_comment, column_default, data_type FROM information_schema.COLUMNS WHERE data_type = 'bit' and table_schema = '数据库名称';
SELECT table_name,column_name, column_comment, column_default, data_type FROM information_schema.COLUMNS WHERE data_type = 'bit' and table_schema = '数据库名称';
本文标题:mysql 查询数据库中所有指定类型的字段
本文链接:https://www.haomeiwen.com/subject/dnlewctx.html
网友评论