/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

1 vote183 views1 answer
Multiple count in sql
SQL
0 vote192 views1 answer
How to find database collation in postgres
SQL
0 vote285 views1 answer
Add user mysql wordpress
SQL
0 vote195 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote176 views1 answer
Run mssql server terminal
SQL
0 vote169 views1 answer
Alter table fulltext
SQL
1 vote178 views1 answer
Access the postgres psql
SQL
17 votes176 views4 answers
Show tables sql server
SQL
2 votes183 views1 answer
Compare date in sql
SQL
0 vote174 views1 answer
Create table if not exist with exceptions
SQL

Share