/SQL/MySql get fields of table

MySql get fields of table

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 vote280 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote257 views1 answer
How to drop columns with constraint from a table in sql script
SQL
2 votes269 views2 answers
How to view created temporary tables in mysql
SQL
0 vote277 views1 answer
Arithmetic expression in sql
SQL
0 vote287 views1 answer
How to create a table based on another table in mysql
SQL
0 vote231 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
4 votes270 views2 answers
Bulk kill mysql processlist
SQL
6 votes226 views2 answers
Generate c# class from sql server table
SQL
0 vote242 views1 answer
Mysql sleep connections
SQL
1 vote271 views1 answer
Sql Split string function
SQL

Share