/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

0 vote215 views4 answers
Open mysql port bitnami tomact
SQL
1 vote198 views1 answer
Influxdb export to csv
SQL
9 votes355 views2 answers
Current date in postgresql minus 1 day
SQL
8 votes235 views1 answer
Oracle tablespace datafile max size
SQL
17 votes211 views2 answers
T_sql contains
SQL
3 votes193 views4 answers
Ubuntu stop mysql
SQL
0 vote208 views1 answer
Every Derived yable must have its own alias
SQL
1 vote198 views2 answers
String to date postgres
SQL
11 votes257 views2 answers
Mysql disable safe mode
SQL
0 vote232 views1 answer
Testing sql queries
SQL

Share