MySQL多表操作與批處理實戰（一）：建表、插數據、隱式內連接查詢

場景：員工基本信息表 + 文章發表記錄表

1. 查看現有表mytable

SELECT * FROM mytable;
+----------+------+------------+-----------+
| name     | sex  | birth      | birthaddr |
+----------+------+------------+-----------+
| abccs    | f    | 1977-07-07 | china     |
| mary     | f    | 1978-12-12 | usa       |
| tom      | m    | 1970-09-02 | usa       |
+----------+------+------------+-----------+

2. 創建文章表title

CREATE TABLE title (
    writer VARCHAR(20) NOT NULL,
    title  VARCHAR(40) NOT NULL,
    senddate DATE
);

插入數據後：

SELECT * FROM title;
+--------+-------+------------+
| writer | title | senddate   |
+--------+-------+------------+
| abccs  | a1    | 2000-01-23 |
| mary   | b1    | 1998-03-21 |
| abccs  | a2    | 2000-12-04 |
| tom    | c1    | 1992-05-16 |
| tom    | c2    | 1999-12-12 |
+--------+-------+------------+

3. 多表查詢：查abccs的姓名、性別、文章

SELECT name, sex, title 
FROM mytable, title 
WHERE name = writer AND name = 'abccs';
+-------+------+-------+
| name  | sex  | title |
+-------+------+-------+
| abccs | f    | a1    |
| abccs | f    | a2    |
+-------+------+-------+

核心知識點

• 逗號分隔表名 = 隱式內連接（等價INNER JOIN ... ON）
• WHERE同時承擔關聯條件與過濾條件
• 現代寫法推薦顯式JOIN：FROM mytable JOIN title ON mytable.name = title.writer，語義更清晰、易維護