/SQL/Mysql get column names from table

Mysql get column names from table

Mysql get column names from table

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='yourdatabasename' 
    AND `TABLE_NAME`='yourtablename';

3

Source: stackoverflow.com

MySql get fields of table

SELECT COLUMN_NAME
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_SCHEMA = 'my_database' AND TABLE_NAME = 'my_table';

1

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 vote200 views1 answer
Add column to table with default value plsql
SQL
0 vote230 views1 answer
Influxdb list all tags for a measurement
SQL
4 votes269 views2 answers
DB::transaction
SQL
1 vote208 views1 answer
Create temporal table in sql
SQL
0 vote224 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
1 vote191 views1 answer
How to get mysql db size
SQL
0 vote216 views1 answer
Update top 100 order by sql server
SQL
6 votes209 views2 answers
Mysql convert timestamp to date
SQL
3 votes208 views1 answer
Convert sqlite table to pandas dataframe
SQL
0 vote209 views1 answer
SqlFunction does not exist
SQL

Share