/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

6 votes279 views1 answer
Sql insert values into table
SQL
0 vote161 views1 answer
Mysql case when null
SQL
0 vote226 views2 answers
Mysql cast to varchar
SQL
1 vote233 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote170 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
2 votes174 views2 answers
Mysql find max value row
SQL
0 vote193 views1 answer
Mysql sum with group by
SQL
1 vote165 views6 answers
In sql
SQL
2 votes201 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote181 views2 answers
How to get the date from datetime in mysql
SQL

Share