/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 vote228 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
22 votes222 views3 answers
Sql cheat sheet
SQL
0 vote303 views1 answer
Current month transactions in mysql
SQL
2 votes264 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
11 votes613 views4 answers
Reset identity column values in sql server
SQL
0 vote257 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote242 views1 answer
Store case result sql
SQL
0 vote226 views1 answer
Enable Rabbitmq management plugin
SQL
1 vote237 views1 answer
Partition by sql server
SQL
3 votes223 views1 answer
Force using index oracle
SQL

Share