/SQL/MySql get fields of table

MySql get fields of table

Get the mysql table columns data type mysql

SHOW COLUMNS FROM mydb.mytable;

2

Mysql show table fields

DESCRIBE my_table;

2

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

Similar codes

0 vote141 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
6 votes145 views3 answers
Commit in sql
SQL
0 vote169 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
1 vote147 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote171 views1 answer
Find wordpress version in database
SQL
1 vote163 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote161 views1 answer
Update database collation in postgresql
SQL
0 vote148 views1 answer
Oracle procedure teamplate
SQL
1 vote133 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote222 views1 answer
Mssql unique key accept nulls
SQL

Share