/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

0 vote177 views1 answer
Store query result in variable sql
SQL
0 vote189 views1 answer
Mysql date + 1 day
SQL
1 vote206 views1 answer
Using SQL in rails migration
SQL
0 vote226 views1 answer
Sqlcl format
SQL
0 vote213 views1 answer
Mysqldump ignore table
SQL
9 votes231 views3 answers
Mysql show table column full description
SQL
0 vote227 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
2 votes223 views1 answer
Query to check cpu utilization in oracle database
SQL
1 vote219 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote204 views1 answer
Sql select min row
SQL

Share