/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

10 votes341 views2 answers
Reset mysql root password mac
SQL
1 vote368 views1 answer
OstgreSQL version
SQL
-1 vote372 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
0 vote340 views1 answer
Oracle synonym procedure dblink
SQL
0 vote349 views2 answers
Wordpress change url in database
SQL
1 vote363 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote380 views1 answer
Declare or use variable in snowflake
SQL
8 votes345 views1 answer
Oracle tablespace datafile max size
SQL
0 vote340 views1 answer
Soql user profile
SQL
2 votes345 views1 answer
Oracle current date without time
SQL

Share