mysql 插入默认值

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL,
    status VARCHAR(20) DEFAULT '活跃'
);

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

SELECT * FROM users;

+----+------------+------------------+--------+
| id | username   | email            | status |
+----+------------+------------------+--------+
|  1 | john_doe   | john@example.com | 活跃   |
+----+------------+------------------+--------+

DESCRIBE users;

+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id       | int(11)     | NO   | PRI | NULL    | auto_increment |
| username | varchar(50) | NO   |     | NULL    |                |
| email    | varchar(100)| NO   |     | NULL    |                |
| status   | varchar(20) | YES  |     | 活跃    |                |
+----------+-------------+------+-----+---------+----------------+

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