mysql命令行 desc

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

DESC users;

+-----------+------------------+------+-----+-------------------+----------------+
| Field     | Type             | Null | Key | Default           | Extra          |
+-----------+------------------+------+-----+-------------------+----------------+
| id        | int(11)           | NO   | PRI | NULL              | auto_increment |
| username  | varchar(50)       | NO   |     | NULL              |                |
| email     | varchar(100)      | NO   | UNI | NULL              |                |
| created_at| timestamp         | YES  |     | CURRENT_TIMESTAMP |                |
+-----------+------------------+------+-----+-------------------+----------------+