在PHPMYADMIN里批量查询要替换的内容

2024-07-31

在PHPMYADMIN里批量查询要替换的内容,适用于数量不是太多的数据直接查询表名+字段名:


SELECT

    CONCAT('SELECT "', TABLE_NAME, '" AS table_name, "', COLUMN_NAME, '" AS column_name, COUNT(*) AS occurrences FROM ', TABLE_NAME, ' WHERE ', COLUMN_NAME, ' LIKE ''%你要查询的内容或域名%'';')

FROM

    INFORMATION_SCHEMA.COLUMNS

WHERE

    TABLE_SCHEMA = '你的数据库名'

    AND DATA_TYPE IN ('char', 'varchar', 'text', 'mediumtext', 'longtext');


阅读4
分享
写评论...