/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

3 votes179 views1 answer
RENAME table pl sql
SQL
2 votes146 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote110 views2 answers
Sql update from two different database
SQL
0 vote148 views1 answer
Postgresql if else endif
SQL
0 vote162 views2 answers
Create-toys-table-with-toy_name-column
SQL
5 votes145 views2 answers
Sql server port number
SQL
19 votes143 views6 answers
Laravel sql query
SQL
0 vote148 views1 answer
Rows, INSERT INTO, Returning
SQL
6 votes186 views3 answers
Rename column ORACLE
SQL
0 vote175 views2 answers
Clauses in mysql
SQL

Share