学习笔记（3):MySQL数据库从入门实战课-使用DISTINCT去除重复数据

立即学习:https://edu.csdn.net/course/play/27328/370700?utm_source=blogtoedu

DROP TABLE IF EXISTS footprint;
CREATE TABLE footprint(
id INT not NULL auto_increment PRIMARY KEY COMMENT 'ID',
username VARCHAR(30) COMMENT '用户名',
city VARCHAR(30) COMMENT '城市',
visit_date VARCHAR(10) COMMENT '到访日期'
);

INSERT INTO footprint (username,city,visit_date) VALUES('liufeng','贵阳','2019-12-06');
INSERT INTO footprint (username,city,visit_date) VALUES('liufeng','贵阳','2020-01-15');
INSERT INTO footprint (username,city,visit_date) VALUES('liufeng','北京','2018-10-10');
INSERT INTO footprint (username,city,visit_date) VALUES('zhangsan','上海','2020-01-01');
INSERT INTO footprint (username,city,visit_date) VALUES('zhangsan','上海','2020-02-02');
INSERT INTO footprint (username,city,visit_date) VALUES('lisi','拉萨','2016-12-20');