/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 vote189 views1 answer
Oracle DROP PROGRAM
SQL
-1 vote264 views1 answer
Mysql coalesce
SQL
0 vote202 views1 answer
Mysql date only no time
SQL
12 votes247 views6 answers
How to install sqlite3 in python
SQL
1 vote259 views2 answers
List tables sqlalchemy
SQL
-1 vote324 views5 answers
Left join sql
SQL
31 votes208 views3 answers
SQL Server change column data type
SQL
24 votes196 views6 answers
Rename a column in sql server
SQL
7 votes294 views2 answers
Oracle foreign key reference table
SQL
1 vote200 views1 answer
Postgresql reset serial counter after deleting content
SQL

Share