Select*fromEmployee;+------+--------+|Id |Name |+------+- -------+|100 |Ram ||200 |Gaurav||300 |Mohan&nb"/> Select*fromEmployee;+------+--------+|Id |Name |+------+- -------+|100 |Ram ||200 |Gaurav||300 |Mohan&nb">

Home  >  Article  >  Database  >  How can we get all records from a specific MySQL table?

How can we get all records from a specific MySQL table?

王林
王林forward
2023-08-29 17:45:111148browse

我们如何从特定的 MySQL 表中获取所有记录?

We can use SELECT * from table_name;query to get all records from the MySQL table. The example is as follows, get all records from "Employee" table -

mysql> Select * from Employee;
+------+--------+
| Id   | Name   |
+------+--------+
| 100  | Ram    |
| 200  | Gaurav |
| 300  | Mohan  |
+------+--------+
3 rows in set (0.00 sec)

The above is the detailed content of How can we get all records from a specific MySQL table?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete