Want to list all the tables.columns in your mysql DB

this post have been formatted by AI

SELECT CONCAT(TABLE_NAME,’.’,COLUMN_NAME)
FROM information_schema.COLUMNS
where TABLE_SCHEMA=’foo’
and TABLE_NAME like ‘USER%’

Comments