/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

1 vote246 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote232 views1 answer
Check if database exists sql
SQL
0 vote209 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
28 votes231 views4 answers
Show tables mysql
SQL
0 vote228 views1 answer
How to combine rows in sql server procedure
SQL
11 votes244 views1 answer
Creating tables in sql with python
SQL
0 vote218 views1 answer
Sql query to delete row by id
SQL
1 vote246 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote257 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote219 views1 answer
Cara menampilkan user di mysql terminal
SQL

Share