Mysql Select Query

How to use MySQL SELECT statement to select all columns in a table?

Explanation

MySQL Select Query :


After inserting datas into the table, we probably want to check the datas are stored correctly. To do so, we use the SELECT Statement.

The Select syntax is


SELECT what_to_select from tbl_name;
To view all the data from the table, we use the below select statement.

Example :


Mysql Select Query
It defines the mysql select query will list the complete details of the student table. Here * will select all the columns from the table.

Ask Questions

Ask Question