SQL SELECT簡單使用
本次環境使用的是MySQL5.7版 1. 搜尋這個table中所有欄位、資料。 SELECT * FROM tableName mysql> SELECT * FROM Persons; +----------+----------+-----------+---------+------+ | PersonID | LastName | FirstName | Address | City | +----------+----------+-----------+---------+------+ | 11 | Lester | Mark | No | No | | 12 | Stenson | Jared | No | No | | 13 | Walker | Aidan | No | No | +----------+----------+-----------+---------+------+ 3 rows in set (0.00 sec) 2. 根據填入的欄位(cloumn1,cloumn2...)搜尋資料。 SELECT cloumn1,cloumn2... FROM tableName mysql> SELECT PersonID,LastName,FirstName FROM Persons; +----------+----------+-----------+ | PersonID | LastName | FirstName | +----------+----------+-----------+ | 11 | Lester | Mark | | 12 | Stenson | Jared | | 13 | Walker | Aidan | +----------+----------+-----------+ 3 rows in set (0.00 sec)