How can I view the content of a table in a MySQL database?

There are several methods to view the contents of tables in a MySQL database.

1. Retrieve the content of a table using the SELECT statement.

SELECT * FROM table_name;

This SQL statement can be used to view all data in a specific table.

1. View table structure using DESC statement.

DESC table_name;

This SQL statement can be used to view the structure of a table, including information such as field names, data types, and key types.

1. View all tables in the database using the SHOW TABLES statement.

SHOW TABLES;

This SQL statement can list all table names in the current database.

1. Use the SHOW COLUMNS statement to view information about the fields in a table.

SHOW COLUMNS FROM table_name;

This SQL statement can be used to view the information of specified table fields, including field names, data types, key types, and etc.

By using the methods described above, it is easy to view the content and structure of tables in a MySQL database.