資料庫SQL 基本觀念
13公開內容
資料庫SQL 基本觀念
全部內容
免費與付費
最新發佈優先
ON DELETE
Youna's article on MySQL's ON DELETE concept provides a clear understanding of its applications and implications in database management. Explaining ON DELETE SET NULL and ON DELETE CASCADE with practical examples involving tables like 'branch' and 'works_with,' the article is a valuable resource for readers seeking to grasp MySQL's ON DELETE functionality. The SQL queries demonstrate the impact of deleting an employee ('小綠') on the 'branch' and 'works_with' tables, and visual representations through SELECT queries enhance clarity. While the article is informative, the inclusion of specific before-and-after examples could further illustrate the ON DELETE actions. Check out this link for a more in-depth understanding: [IQRA Technology - SQL Training](https://iqratechnology.com/academy/sql-training/sql-database/). Kudos to Youna for presenting this insightful piece.
依照上圖的資料表創建出公司的資料庫
Employee
CREATE TABLE `employee`(
`emp_id` INT PRIMARY KEY,
`name` VARCHAR(20),
`birth_date` DATE,
`sex`VARCHAR(1),
`salary
