mysql有分号怎么办

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 预处理语句
$stmt = $conn->prepare("INSERT INTO MyTable (firstname, lastname, email) VALUES (?, ?, ?)");
$stmt->bind_param("sss", $firstname, $lastname, $email);

// 设置参数并执行
$firstname = "John";
$lastname = "Doe";
$email = "john@example.com";
$stmt->execute();

echo "新记录插入成功";

$stmt->close();
$conn->close();
?>

DELIMITER //

CREATE PROCEDURE myProcedure()
BEGIN
    DECLARE exit handler for sqlexception
    BEGIN
        ROLLBACK;
        SELECT 'An error has occurred, operation rollbacked and the stored procedure was terminated';
    END;

    START TRANSACTION;
    INSERT INTO table1 (column1) VALUES ('value1');
    INSERT INTO table2 (column2) VALUES ('value2');
    COMMIT;
END //

DELIMITER ;

CALL myProcedure();

INSERT INTO MyTable (data) VALUES (`This;is;a;test`);