| 1234567891011121314 |
- CREATE DATABASE IF NOT EXISTS test;
- USE test;
- CREATE TABLE IF NOT EXISTS users (
- id INT AUTO_INCREMENT PRIMARY KEY,
- name VARCHAR(100) NOT NULL,
- email VARCHAR(100) NOT NULL,
- created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- );
- -- 插入一些测试数据
- INSERT INTO users (name, email) VALUES
- ('测试用户1', 'test1@example.com'),
- ('测试用户2', 'test2@example.com');
|
