编辑代码

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

INSERT INTO student (id, name, address, city) VALUES (1, '刘一', '郑十家隔壁', '河南');
INSERT INTO student (id, name, address, city) VALUES (2, '陈二',  '李四家隔壁', '安徽');
INSERT INTO student (id, name, address, city) VALUES (3, '张三',  '白娘子家隔壁', '杭州');
INSERT INTO student (id, name, address, city) VALUES (4, '李四',  '许仙家隔壁', '杭州');
INSERT INTO student (id, name, address, city) VALUES (5, '王五',  '李四家隔壁', '杭州');
SELECT * FROM student;
#选择查询
SELECT address FROM student WHERE city = '杭州';

#更新
START TRANSACTION;
UPDATE student SET address = '龙柏一村' WHERE city = '杭州';
COMMIT;
 
SELECT * FROM student;

#选择查询
SELECT name FROM student WHERE address = '龙柏一村';

#删除
START TRANSACTION;
DELETE FROM student WHERE address = '龙柏一村';  
COMMIT;
 
SELECT * FROM student;