Home  >  Article  >  Database  >  sql语句使用记录_MySQL

sql语句使用记录_MySQL

WBOY
WBOYOriginal
2016-05-31 08:49:471063browse


查询存在重复的字段(mysql)

select nickname from user where school_id="swiftv" group by nickname having count(*)>1;

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn