Answers for "mysql column names from other table"

mysql get column names from table

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='yourdatabasename' 
    AND `TABLE_NAME`='yourtablename';

Posted by: Guest on December-18-2020

mysql select table names

SELECT *
FROM information_schema.tables
WHERE table_type='BASE TABLE'
AND table_schema='<insert_your_database_name_here>'

Posted by: Guest on December-29-2021

Code answers related to "mysql column names from other table"