mysql表不存在就创建

CREATE TABLE IF NOT EXISTS `table_name` (
    `column1` data_type,
    `column2` data_type,
    ...
);

DELIMITER //

CREATE PROCEDURE CreateTableIfNotExists()
BEGIN
    DECLARE table_exists INT DEFAULT 0;

    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
        SET @sql = CONCAT('CREATE TABLE your_table_name (',
                          'id INT AUTO_INCREMENT PRIMARY KEY,',
                          'name VARCHAR(255) NOT NULL',
                          ');');
        PREPARE stmt FROM @sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
    END IF;
END //

DELIMITER ;

CALL CreateTableIfNotExists();