userが含まれるテーブルを検索
SELECT TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE '%user%';
すべてのデータベースからテーブルを検索するSQL【phpMyAdmin】横断検索
Last updated at Posted at 2025-01-24
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme