$result = mysql_query("SELECT cust_id, surname, firstname FROM customer");
while ($row = mysql_fetch_array($result)) {
echo "ID: {$row['cust_id']}\n";
echo "Surname: {$row['surname']}\n";
echo "First name: {$row['firstname']}\n\n";
}
// 避免使用數字索引 $row[0]、$row[1] —— 易隨 SELECT 順序變更而破壞
SELECT winery.name AS wname, region.name AS rname
FROM winery, region
WHERE winery.region_id = region.region_id;
// PHP 端:$row['wname']、$row['rname'] 清晰無歧義
SELECT winery.region_id FROM winery;
// $row['region_id'] 而非 $row['winery.region_id']
SELECT COUNT(*) AS cnt FROM customer;
// $row['cnt'] 遠優於 $row['COUNT(*)']
LONG VARCHAR/MEDIUMTEXT 別名,定義時請用具體類型。YYYY-MM-DD,PHP 產生:date('Y-m-d')。日期相減直接得天數差:$age = $current_date - $birthdate;(MySQL 隱式轉換)。mysql_num_rows()(結果集大小未知)。| 符號 | 用途 | 搭配 |
|---|---|---|
| * | 選擇所有欄位 | SELECT * |
| % | 匹配任意長度字串 | LIKE 'abc%' |
| _ | 匹配單一字元 | LIKE 'ab_' |
注意:% **必須**與 LIKE 搭配,* 僅用於選欄位。
NULL ≠ 空字串 '' ≠ 零 0。%通配符匹配空字串,不匹配 NULL。IS NULL/IS NOT NULL 特殊判斷邏輯。