编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE student (
	id int,
	name varchar(255),
	address varchar(255),
	city varchar(255)
);

INSERT INTO student VALUES (1, '刘一', '郑十家隔壁', '河南');
INSERT INTO student VALUES (2, '陈二',  '李四家隔壁', '安徽');
INSERT INTO student VALUES (3, '张三',  '白娘子家隔壁', '杭州');
INSERT INTO student VALUES (4, '李四',  '许仙家隔壁', '杭州');
INSERT INTO student VALUES (5, '王五',  '李四家隔壁', '杭州');
INSERT INTO student VALUES (6, '赵六',  '赵六家隔壁', '杭州');
INSERT INTO student VALUES (7, '孙七',  '张三家隔壁', '杭州');
INSERT INTO student VALUES (8, '周八',  '雷峰塔附近', '杭州');
INSERT INTO student VALUES (9, '吴九',  '孙七家隔壁', '杭州');
INSERT INTO student VALUES (10, '郑十',  '周八家隔壁', '杭州');
INSERT INTO student VALUES (11,'陆沉','南华城','青冥天下');
INSERT INTO student VALUES (12,'左右','中土神州','浩然天下');
INSERT INTO student VALUES (13,'齐静春','宝瓶洲','浩然天下');

UPDATE student SET name='陈平安' WHERE id=10;
ALTER TABLE student CHANGE name 姓名 varchar(255);
ALTER TABLE student CHANGE id 学号  int;
ALTER TABLE student CHANGE address  家庭住址 varchar(255);
ALTER TABLE student CHANGE city 城市 varchar(255);
SELECT * FROM student;
SELECT 姓名,城市,学号 FROM student;
SELECT 姓名,城市 ,学号 FROM student LIMIT 5;