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

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

?

?

?

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,'玉如夢(mèng)','yurumeng@qq.com'),(6,'玉如夢(mèng)','yurumeng@qq.com'),(7,'玉如夢(mèng)','yurumeng@qq.com'),(8,'玉如夢(mèng)','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` -- 去掉重復(fù)查詢