/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 vote334 views1 answer
Sql eliminare un record
SQL
0 vote336 views2 answers
How to combine diff colmun value using group by postgres
SQL
23 votes356 views4 answers
How to show all users in mysql
SQL
8 votes326 views5 answers
Alter table add column with default value
SQL
0 vote382 views1 answer
Postgres rename database
SQL
0 vote343 views1 answer
Mysql date time string format for marshmellow field schema
SQL
2 votes334 views2 answers
Change varchar length mysql
SQL
1 vote357 views1 answer
Psql import backup file for windows
SQL
1 vote351 views1 answer
Mysql check table exists
SQL
0 vote330 views1 answer
Pl sql search in all packages
SQL

Share