/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 vote307 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote284 views1 answer
Grant privileges of databse to user
SQL
0 vote268 views1 answer
Order by in codeigniter query builder
SQL
0 vote277 views1 answer
Count database access django
SQL
18 votes266 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
22 votes257 views3 answers
Sql cheat sheet
SQL
1 vote274 views1 answer
Rails run native ssql query
SQL
1 vote336 views2 answers
Copy table in sql
SQL
3 votes272 views4 answers
Psql list tables in schema
SQL
0 vote287 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL

Share