/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 vote202 views1 answer
Oracle date winter time
SQL
0 vote175 views1 answer
Inser into example
SQL
0 vote146 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote182 views1 answer
Oracle free up space in tablespace
SQL
1 vote197 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
2 votes155 views1 answer
Latest record in sql
SQL
1 vote208 views1 answer
Mysql select for update ejemplo
SQL
0 vote199 views1 answer
Difference between 2 query results sql server
SQL
4 votes287 views1 answer
Select first and last row sql
SQL
1 vote266 views1 answer
Cannot drop database because it is currently in use
SQL

Share