如果为超过10行插入相同的列值，则中止插入- mysql-php

DELIMITER //
CREATE TRIGGER check_duplicate_values BEFORE INSERT ON your_table
FOR EACH ROW
BEGIN
    DECLARE duplicate_count INT;
    SELECT COUNT(*) INTO duplicate_count FROM your_table WHERE your_column = NEW.your_column;
    IF duplicate_count >= 10 THEN
        SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Insertion aborted: Too many duplicate values';
    END IF;
END //
DELIMITER ;

<?php
$servername = "your_servername";
$username = "your_username";
$password = "your_password";
$dbname = "your_dbname";

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $conn->beginTransaction();

    // 执行插入操作
    $stmt = $conn->prepare("INSERT INTO your_table (your_column) VALUES (:value)");
    $value = "your_value"; // 要插入的值
    $stmt->bindParam(':value', $value);

    for ($i = 0; $i < 10; $i++) {
        $stmt->execute();
    }

    $conn->commit();
    echo "Insertion successful";
} catch (PDOException $e) {
    $conn->rollBack();
    echo "Insertion aborted: " . $e->getMessage();
}

$conn = null;
?>