MySQL Select Query

Tutorials

Mysql

Topic

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.

mysql> select * from student;
+--------+---------+-------+------------------+---------+
| studid | name    | marks | address          | phone   |
+--------+---------+-------+------------------+---------+
|      1 | steve   |   100 | 5th cross street | 2456987 |
|      2 | david   |    98 | welling street   |  547896 |
|      3 | michael |    75 | edinburgh        | 2598234 |
|      4 | jack    |    82 | victoria street  | 2436821 |
|      5 | anne    |   100 | downing street   | 2634821 |
|      6 | steve   |    75 | downing street   | 2874698 |
|      7 | anne    |    80 | edinburgh        | 2569843 |
|      8 | mille   |    98 | victoria street  | 1236547 |
+--------+---------+-------+------------------+---------+
8 rows in set (0.00 sec)

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

Mysql Select Query