/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 vote115 views2 answers
How to add CHECK constraint to a column in postgres
SQL
1 vote113 views1 answer
Mysql pretty date format
SQL
3 votes104 views1 answer
Two selects in one query
SQL
0 vote105 views2 answers
Drop check constraint in ms sql
SQL
10 votes113 views2 answers
Mysql alter add foreign key
SQL
0 vote68 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote117 views1 answer
How get data from database if id not found then search another column
SQL
16 votes107 views2 answers
Gremove folder from git
SQL
0 vote122 views1 answer
Mysql conf.d exampel
SQL
0 vote121 views2 answers
Advantages of stored procedures sql
SQL

Share