/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

5 votes222 views1 answer
Oracle nls instance
SQL
0 vote147 views1 answer
Mysql convert column to uppercase
SQL
1 vote202 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote227 views1 answer
Insert output identity
SQL
2 votes207 views1 answer
Where clause for child record apex
SQL
0 vote183 views1 answer
Oracle select invalid views
SQL
0 vote233 views2 answers
Sql update multiple tables
SQL
13 votes371 views4 answers
Sql joining 3 tables
SQL
-1 vote204 views3 answers
Psql get last rows
SQL
0 vote208 views2 answers
Compound operator in sql
SQL

Share