MySQL DQL 去重教程表代碼
2021-10-04 11:49:55

垃圾的撒嬌的風景色譜發(fā)票為菩薩的搭配覅色譜法配色【】we9rfpqsoedufoiewrun拍攝跑調(diào)覅就怕是東風破一堅實的皮膚的勝多負少的? 的食品發(fā)票速度發(fā)票首都非破損的賠付噴水電機 山東分批進隧道排是家拍攝地交水電費薩頂頂 上當受騙飛機票睡大覺佛奧圣誕節(jié)哦放假撒到附近收到了甲方收到后僵尸洞給按實際大佛給將三大排放量較為動設計福利卡三等獎佛給愛神的箭發(fā)票里煎熬手動? 【】JFLAJSDLFJSADLFJLKSADAJFOIASDJFHSADFJLSADAJHFLSADA,;FJKSADHFLJSDH　　　　薩拉丁會計分錄撒大家來看風景時代浪費空間收到了 破碎帶颶風破圣誕節(jié)安排了放假撒離得近服務商 圣誕節(jié)福利卡時間段浪費空間安山東覅今后【i愛神的箭恢復了卡薩丁撒大家哦放假撒多垃圾分離圣誕節(jié)福利卡薩京東覅靜安寺店鋪撒大路口附近拉三等獎

?

?

?

CREATE TABLE sutdy(
?? ?id? INT(50) NOT NULL AUTO_INCREMENT,
?? ?`name` VARCHAR(50) NOT NULL,
?? ?email VARCHAR(50),
?? ?PRIMARY KEY(id)
)ENGINE=INNODB DEFAULT CHARSET=utf8;


INSERT INTO `sutdy`(`id`,`name`,`email`)
VALUES(1,'楊開','yangkai@qq.com'),(2,'楊開','yangkai@qq.com'),(3,'楊開','yangkai@qq.com'),(4,'楊開','yangkai@qq.com'),(5,'玉如夢','yurumeng@qq.com'),(6,'玉如夢','yurumeng@qq.com'),(7,'玉如夢','yurumeng@qq.com'),(8,'玉如夢','yurumeng@qq.com'),(9,'蘇顏','suyan@qq.com'),(10,'蘇顏','suyan@qq.com'),(11,'蘇顏','suyan@qq.com'),(12,'蘇顏','suyan@qq.com'),(13,'蘇顏','suyan@qq.com'),(14,'蘇顏','suyan@qq.com'),(15,'蘇顏','suyan@qq.com'),(16,'蘇顏','suyan@qq.com'),(17,'夏凝裳','xianingshagn@qq.com'),(18,'夏凝裳','xianingshagn@qq.com'),(19,'夏凝裳','xianingshagn@qq.com'),(20,'夏凝裳','xianingshagn@qq.com'),(21,'夏凝裳','xianingshagn@qq.com'),(22,'夏凝裳','xianingshagn@qq.com'),(23,'扇輕羅','shanqingluo@qq.com'),(24,'扇輕羅','shanqingluo@qq.com'),(25,'扇輕羅','shanqingluo@qq.com'),(26,'扇輕羅','shanqingluo@qq.com'),(27,'扇輕羅','shanqingluo@qq.com'),(28,'扇輕羅','shanqingluo@qq.com'),(29,'雪月','xueyue@qq.com'),(30,'雪月','xueyue@qq.com'),(31,'雪月','xueyue@qq.com'),(32,'雪月','xueyue@qq.com'),(33,'雪月','xueyue@qq.com'),(34,'雪月','xueyue@qq.com'),(35,'雪月','xueyue@qq.com'),(36,'祝情','zhuqing@qq.com'),(37,'祝情','zhuqing@qq.com'),(38,'祝情','zhuqing@qq.com'),(39,'祝情','zhuqing@qq.com'),(40,'祝情','zhuqing@qq.com'),(41,'祝情','zhuqing@qq.com'),(42,'祝情','zhuqing@qq.com');



SELECT email FROM `sutdy` -- 普通查詢
SELECT DISTINCT `email` FROM `sutdy` -- 去掉重復查詢