/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 vote144 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
2 votes172 views1 answer
Show max_allowed_packet mysql
SQL
0 vote132 views1 answer
Sql delete where x or y or z
SQL
-1 vote147 views1 answer
Spring boot mysql connection properties
SQL
0 vote130 views1 answer
Mysql date minus 1 day
SQL
3 votes153 views1 answer
Oracle list invalid password logon denied
SQL
1 vote136 views1 answer
Mysql show data from table
SQL
0 vote159 views1 answer
Show all sequences postgres
SQL
2 votes99 views4 answers
Mysql change database character set to utf8mb4
SQL
10 votes180 views1 answer
Oracle all_dependencies
SQL

Share