MySQL是一種常見的關系型數據庫管理系統，被廣泛應用于Web應用程序的數據存儲中。它是開源的，可以在不同的操作系統平臺上運行。MySQL支持多種編程語言，包括C、C++、Java、PHP、Python等等。而且，MySQL擁有豐富的功能，如事務處理、外鍵約束、存儲過程、觸發器等等。

//連接數據庫
$conn = mysqli_connect($servername, $username, $password);
if (!$conn) {
die("連接失敗: " . mysqli_connect_error());
}
//創建數據庫
$sql = "CREATE DATABASE myDB";
if (mysqli_query($conn, $sql)) {
echo "數據庫創建成功";
} else {
echo "Error creating database: " . mysqli_error($conn);
}
//創建表格
$sql = "CREATE TABLE MyGuests (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)";
if (mysqli_query($conn, $sql)) {
echo "Table MyGuests created successfully";
} else {
echo "Error creating table: " . mysqli_error($conn);
}
//插入數據
$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";
if (mysqli_query($conn, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
//查詢數據
$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) >0) {
// 輸出數據
while($row = mysqli_fetch_assoc($result)) {
echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "
";
}
} else {
echo "0 結果";
}
mysqli_close($conn);

以上是MySQL常見的應用場景和示例，對于需要進行數據存儲和處理的項目來說，MySQL是一個非常不錯的選擇。