/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 vote252 views1 answer
Lister les index d'une table oracle
SQL
0 vote297 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote219 views1 answer
Import sql file in mysql linux
SQL
1 vote275 views1 answer
Sql padd let with zeros
SQL
-1 vote257 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote267 views2 answers
Mysql password error create datbase
SQL
1 vote219 views1 answer
Oracle compile schema
SQL
6 votes313 views2 answers
Mysql convert timestamp to date
SQL
0 vote600 views1 answer
Create pl/sql stored procedure
SQL
0 vote284 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL

Share