[长期贴]收集遇到的有趣sql

--  针对脱敏数据姓名,想要进行全文索引模糊查询的sql : 把 '许*志' 或者'葛*' 变成 '许一志' '葛一'
 

update 表名  SET 字段名 = REPLACE(字段名,'*', '一')

 -- 查询表名及字段名

SELECT
	TABLE_NAME AS 表名,
	TABLE_COMMENT AS 表注释 
FROM
	INFORMATION_SCHEMA.TABLES 
WHERE
	TABLE_SCHEMA = '数据库名'
	
	
	
	SELECT
	COLUMN_NAME AS 字段名,
	DATA_TYPE AS 数据类型,
	COLUMN_COMMENT AS 字段注释 
FROM
	INFORMATION_SCHEMA.COLUMNS 
WHERE
	TABLE_SCHEMA ='数据库名'
	AND TABLE_NAME = '表名'