/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

0 vote114 views1 answer
Create new schema mysql
SQL
-1 vote124 views8 answers
Sql to c# linq converter online
SQL
0 vote196 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
1 vote119 views1 answer
Right outer vs left outer join
SQL
0 vote119 views1 answer
Longtext sql
SQL
2 votes111 views1 answer
Oracle sql drop column if exists
SQL
2 votes163 views2 answers
How to DROP a table in mysql
SQL
1 vote119 views1 answer
Altrer name column postgres
SQL
18 votes110 views3 answers
Mysql number format
SQL
4 votes114 views2 answers
How to delete row in sql
SQL

Share