show creat table user
时间: 2024-01-19 20:04:26 浏览: 108
Sure, here is an example of a SQL statement to create a table named "user":
```sql
CREATE TABLE user (
id INT PRIMARY KEY,
username VARCHAR(50) NOT NULL,
email VARCHAR(100) NOT NULL,
password VARCHAR(100) NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);
```
In this example, the "user" table has five columns: "id", "username", "email", "password", and "created_at". The "id" column is the primary key, which uniquely identifies each record in the table. The other columns store the user's username, email, password, and the timestamp of when the record was created.
阅读全文