/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 votes162 views4 answers
Start postgres server
SQL
0 vote147 views2 answers
Postgres another version
SQL
16 votes178 views6 answers
Insert sql
SQL
0 vote150 views1 answer
Mysql foreach insert
SQL
1 vote116 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
0 vote165 views1 answer
Postgresql import data from csv
SQL
0 vote138 views1 answer
Show specific events on mysql
SQL
5 votes163 views1 answer
AND OR NOT operators sql
SQL
10 votes143 views1 answer
Query to find object dependencies in oracle
SQL
0 vote143 views1 answer
Mysql uuid
SQL

Share