/SQL/MySQL query to get column names

MySQL query to get column names

MySQL query to get column names

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

3

Source: stackoverflow.com

Mysql to get column name in database

SELECT table_name, column_name from information_schema.columns WHERE column_name LIKE '%column_name_to_search%';

0

Source: ka.lpe.sh

Similar codes

1 vote223 views1 answer
Mysql count words
SQL
0 vote250 views1 answer
Mysql delete entire row on condition
SQL
1 vote192 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote239 views1 answer
How to use select union and loop
SQL
1 vote240 views1 answer
Mysql strict_trans_tables
SQL
0 vote246 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
5 votes201 views1 answer
Postgres upsert
SQL
3 votes227 views1 answer
Oracle get trigger ddl
SQL
0 vote236 views3 answers
Average salary in sql
SQL
1 vote233 views1 answer
Mysql count multiple columns in one query
SQL

Share