/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

2 votes264 views2 answers
Sql percentage
SQL
7 votes258 views6 answers
Nth highest salary in sql
SQL
0 vote230 views1 answer
Metada in sql
SQL
0 vote296 views1 answer
Postgres list tables and row counts
SQL
0 vote254 views1 answer
Product of a column in mysql
SQL
1 vote252 views1 answer
Change table to innodb mysql
SQL
10 votes243 views1 answer
How to import database in mysql by cmd
SQL
0 vote245 views1 answer
Fetch second word from a string in ms sql
SQL
1 vote259 views2 answers
Mysql filter by date mount
SQL
0 vote261 views1 answer
How to find columns with null values in sql
SQL

Share