/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 vote124 views1 answer
Remove mysql from centos 7
SQL
1 vote128 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
-1 vote141 views3 answers
PS5
SQL
1 vote139 views1 answer
Mysql order by desc null last
SQL
-1 vote167 views1 answer
Minus vs except in sql
SQL
0 vote127 views1 answer
Not equal to blank in mysql
SQL
1 vote196 views1 answer
Primary key reset in SQL database
SQL
0 vote123 views1 answer
Oracle exchange subpartition
SQL
1 vote150 views1 answer
Insert column after column mysql
SQL
2 votes139 views1 answer
Sql count having
SQL

Share