往mysql数据库中加添加数据

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO users (name, email) VALUES ('John Doe', 'john.doe@example.com');

INSERT INTO users (name, email) VALUES 
('Jane Smith', 'jane.smith@example.com'),
('Alice Johnson', 'alice.johnson@example.com');

INSERT INTO users (name, email)
SELECT name, email FROM temp_users;

INSERT INTO users (id, name, email) VALUES (1, 'John Doe', 'john.doe@example.com')
ON DUPLICATE KEY UPDATE name='John Doe', email='john.doe@example.com';

INSERT INTO users (name, email) VALUES ('John Doe', CAST('john.doe@example.com' AS CHAR(100)));

START TRANSACTION;
INSERT INTO users (name, email) VALUES 
('Jane Smith', 'jane.smith@example.com'),
('Alice Johnson', 'alice.johnson@example.com');
COMMIT;