/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 vote297 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote287 views1 answer
Sql query to return field name of a table
SQL
0 vote286 views1 answer
Sql menampilkan data tabel
SQL
0 vote280 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote296 views1 answer
Count columns psql(PostreSQL)
SQL
10 votes291 views6 answers
Sql between
SQL
10 votes278 views4 answers
Inner join in update query mysql
SQL
1 vote280 views2 answers
Drop function in sql
SQL
0 vote304 views1 answer
Insert using condition postgres
SQL
0 vote277 views1 answer
Oracle current session details
SQL

Share