Get All Columns in MySQL

Get all Column of a specific Tables in MySQL. SELECT table_name as ‘Table Name’, column_name as ‘Column Name’ FROM information_schema.COLUMNS WHERE table_schema = ‘$DATABASE_NAME’; AND table_name = ‘$TABLE_NAME’; Get all Column of some Tables in MySQL. SELECT table_name as ‘Table Name’, column_name as ‘Column Name’ FROM information_schema.COLUMNS WHERE table_schema = ‘$DATABASE_NAME’; AND table_name in (‘$TABLE_NAME1’, … Read more