/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

4 votes186 views1 answer
Mysql biginteger size
SQL
0 vote189 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote180 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
1 vote200 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote220 views1 answer
Min varias colunas spark sql
SQL
0 vote186 views1 answer
We are intrested to work with your organization
SQL
18 votes266 views3 answers
Get the list of all tables in sql server
SQL
0 vote187 views1 answer
Postgres 11 add primary key
SQL
19 votes225 views5 answers
Display table in sql
SQL
1 vote190 views2 answers
Update with inner join sql server
SQL

Share