/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 vote299 views1 answer
Default
SQL
2 votes266 views1 answer
Sql column values comma separated
SQL
0 vote287 views3 answers
How to increase size of column in sql
SQL
1 vote272 views1 answer
Generate random data postgresql
SQL
0 vote313 views1 answer
How to use sqlcommand
SQL
0 vote272 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
2 votes247 views1 answer
Get first 3 letters name in sql
SQL
0 vote272 views1 answer
Normalization in database 2nd normal form
SQL
9 votes284 views5 answers
Sql delete duplicate rows but keep one
SQL
-1 vote272 views3 answers
Compute age mysql
SQL

Share