在数据库中建表的代码

网站编辑2023-05-11 14:11:21501

# 1. 创建数据库

CREATE DATABASE mydatabase;

# 2. 选择数据库

USE mydatabase;

# 3. 创建表

CREATE TABLE mytable (

id INT NOT NULL AUTO_INCREMENT,

name VARCHAR(50) NOT NULL,

age INT,

email VARCHAR(100),

PRIMARY KEY (id)

);

# 4. 插入数据

INSERT INTO mytable (name, age, email) VALUES ('John', 25, 'john@example.com');

INSERT INTO mytable (name, age, email) VALUES ('Jane', 30, 'jane@example.com');

INSERT INTO mytable (name, age, email) VALUES ('Bob', 40, 'bob@example.com');

# 5. 查询数据

SELECT * FROM mytable;

# 6. 更新数据

UPDATE mytable SET age = 35 WHERE name = 'Jane';

# 7. 删除数据

DELETE FROM mytable WHERE name = 'Bob';

# 8. 删除表

DROP TABLE mytable;

# 9. 删除数据库

DROP DATABASE mydatabase;