MySQL是一個開源的關系型數據庫管理系統，被廣泛應用于Web應用程序的開發中。雖然在初學時可能會感到有些難度，但是實際上MySQL的操作非常簡單。

//連接到MySQL數據庫
$conn = mysqli_connect("localhost", "username", "password", "dbname");
//查詢數據
$result = mysqli_query($conn, "SELECT * FROM users");
//遍歷數據，輸出結果
while($row = mysqli_fetch_assoc($result)) {
echo "Name: " . $row["name"] . " - Age: " . $row["age"] . "
";
}
//插入數據
$sql = "INSERT INTO users (name, age, email) VALUES ('John Doe', 30, 'johndoe@example.com')";
if(mysqli_query($conn, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
//更新數據
$sql = "UPDATE users SET age=32 WHERE name='John Doe'";
if(mysqli_query($conn, $sql)) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . mysqli_error($conn);
}
//刪除數據
$sql = "DELETE FROM users WHERE name='John Doe'";
if(mysqli_query($conn, $sql)) {
echo "Record deleted successfully";
} else {
echo "Error deleting record: " . mysqli_error($conn);
}
//關閉數據庫連接
mysqli_close($conn);

通過以上代碼范例，我們可以看到MySQL操作的語法非常直觀且易于理解。只需掌握一些基本的SQL語句，就能輕松應對日常的數據庫管理任務。