mysql创建数据库并写入记录

mysql -u username -p

CREATE DATABASE mydatabase;

USE mydatabase;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO users (name, email) VALUES ('John Doe', 'john.doe@example.com');

# 连接到 MySQL 服务器
mysql -u username -p

# 创建数据库
CREATE DATABASE mydatabase;

# 使用数据库
USE mydatabase;

# 创建表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

# 插入记录
INSERT INTO users (name, email) VALUES ('John Doe', 'john.doe@example.com');

# 查询记录以验证
SELECT * FROM users;

SHOW DATABASES;  -- 查看所有数据库

DESCRIBE users;  -- 查看表结构

SET GLOBAL wait_timeout = 3600;  -- 设置超时时间为1小时