mysql表格添加内容

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

INSERT INTO table_name (column1, column2, column3, ...)
VALUES 
(value1_1, value1_2, value1_3, ...),
(value2_1, value2_2, value2_3, ...),
...
(valueN_1, valueN_2, valueN_3, ...);

INSERT INTO table2 (column1, column2, ...)
SELECT column1, column2, ...
FROM table1;

INSERT INTO table_name (id, column1, column2)
VALUES (1, 'value1', 'value2')
ON DUPLICATE KEY UPDATE column1='value1', column2='value2';

INSERT INTO table_name (column1, column2)
VALUES (CAST('123' AS INT), 'value2');

SET NAMES utf8mb4;
INSERT INTO table_name (column1, column2)
VALUES ('中文', 'value2');

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO users (username, email)
VALUES ('john_doe', 'john@example.com');

INSERT INTO users (username, email)
VALUES 
('jane_doe', 'jane@example.com'),
('alice_smith', 'alice@example.com');