mysql插入时判断表是否存在

SELECT COUNT(*)
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'your_database_name'
AND TABLE_NAME = 'your_table_name';

CREATE TABLE IF NOT EXISTS your_table_name (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);

INSERT INTO your_table_name (name) VALUES ('John Doe');

DELIMITER //

CREATE PROCEDURE insert_if_not_exists()
BEGIN
    DECLARE table_exists INT;

    SELECT COUNT(*)
    INTO table_exists
    FROM information_schema.TABLES
    WHERE TABLE_SCHEMA = 'your_database_name'
    AND TABLE_NAME = 'your_table_name';

    IF table_exists = 0 THEN
        CREATE TABLE your_table_name (
            id INT AUTO_INCREMENT PRIMARY KEY,
            name VARCHAR(255) NOT NULL
        );
    END IF;

    INSERT INTO your_table_name (name) VALUES ('John Doe');
END //

DELIMITER ;

CALL insert_if_not_exists();