mysql 展示表的结构

DESCRIBE table_name;

SHOW COLUMNS FROM table_name;

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
);

DESCRIBE users;

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