/SQL/Mysql show table fields

Mysql show table fields

Mysql show table structure

DESCRIBE table_name; # To show table structure...

4

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

-1 vote136 views1 answer
Sql add column bit
SQL
10 votes143 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote142 views1 answer
Mysql beautifier terminla
SQL
0 vote161 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote142 views2 answers
Select index table oracle
SQL
0 vote129 views1 answer
Postgresql newline character
SQL
0 vote135 views1 answer
Sql server convert date to weekday
SQL
21 votes136 views3 answers
Sql average
SQL
0 vote127 views1 answer
Opensuse stop MySQL
SQL
1 vote160 views1 answer
Sql order by timestamp
SQL

Share