/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 vote312 views1 answer
Sql select most frequent value in group
SQL
0 vote346 views1 answer
Get last three characters in mysql column
SQL
7 votes330 views3 answers
How ot change name of column mysql
SQL
4 votes274 views1 answer
And or sql order of operations
SQL
0 vote339 views1 answer
Oracle tablespace autoextend
SQL
3 votes378 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
2 votes527 views5 answers
Unique in sql server
SQL
5 votes324 views1 answer
How to check nls format in oracle
SQL
6 votes319 views4 answers
Eloquent to sql with bindings
SQL
0 vote330 views1 answer
Get create sql of hibernqte entity
SQL

Share