常用sql-Mysql

总结 mysqlsql  收藏
0 / 106

mysql常用几个sql总结

查询某个重复值的记录

SELECT * FROM account_user_work_order GROUP BY id_card_image_url having count(id_card_image_url) >= 2 ORDER BY create_time desc

field 自定义排序函数的格式

order by field(value,str1,str2,str3,str4,,,,,,strn)

####