/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

7 votes278 views2 answers
Mysql get year from date
SQL
1 vote282 views1 answer
How to delete data from sql database in android
SQL
0 vote269 views1 answer
Sql count total by foreign key
SQL
0 vote260 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote276 views1 answer
Sql find all different values in column
SQL
0 vote272 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote254 views1 answer
Create domain sql
SQL
14 votes289 views2 answers
Install mysqldump
SQL
2 votes275 views1 answer
Compare date in sql
SQL
0 vote233 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL

Share