/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 vote219 views1 answer
MySQL - How to find word with the most similar beginning
SQL
4 votes170 views1 answer
Oracle error line
SQL
0 vote237 views1 answer
Mysql readable output
SQL
0 vote132 views1 answer
Mysql insert with foreign key
SQL
0 vote167 views1 answer
Will graphql replace sql
SQL
0 vote245 views1 answer
Sql trigger to call stored procedure with parameters
SQL
2 votes177 views1 answer
Add new column not null sql server
SQL
1 vote169 views2 answers
DROP TABLes regardless of constraints
SQL
1 vote186 views2 answers
Full join
SQL
7 votes171 views1 answer
Mysql remote connection command line
SQL

Share