/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 vote166 views1 answer
AddEntityFrameworkSqlite
SQL
1 vote171 views1 answer
Oracle add proxy
SQL
1 vote178 views1 answer
Delete specific row in sql
SQL
0 vote180 views1 answer
Alter database name script
SQL
0 vote163 views1 answer
Sql select rows between 1000 and 2000
SQL
8 votes176 views1 answer
My sql version
SQL
1 vote172 views4 answers
Postgres extract date from timestamp
SQL
0 vote224 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
1 vote225 views4 answers
How to check table in postgresql from terminal
SQL
0 vote178 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL

Share