华南俳烁实业有限公司

以下實(shí)例我們將通過 SQL SELECT 命令來獲取 MySQL 數(shù)據(jù)表 tutorials_tbl 的數(shù)據(jù)：

實(shí)例

以下實(shí)例將返回數(shù)據(jù)表tutorials_tbl的所有記錄:

root@host# mysql -u root -p password;
Enter password:*******
mysql> use TUTORIALS;
Database changed
mysql> SELECT * from tutorials_tbl 
+-------------+----------------+-----------------+-----------------+
| tutorial_id | tutorial_title | tutorial_author | submission_date |
+-------------+----------------+-----------------+-----------------+
|           1 | Learn PHP      | John Poul       | 2007-05-21      |
|           2 | Learn MySQL    | Abdul S         | 2007-05-21      |
|           3 | JAVA Tutorial  | Sanjay          | 2007-05-21      |
+-------------+----------------+-----------------+-----------------+
3 rows in set (0.01 sec)

mysql>