Skip to content

Instantly share code, notes, and snippets.

@zy108830

zy108830/repeatFields.php

Created May 23, 2016 13:10
Show Gist options
  • Save zy108830/bf45fc5c0fdf0eb1c3f99f1d114c50e7 to your computer and use it in GitHub Desktop.
Save zy108830/bf45fc5c0fdf0eb1c3f99f1d114c50e7 to your computer and use it in GitHub Desktop.
Download ZIP
根据字段,去除mysql中的重复纪录
Raw
repeatFields.php
SELECT * FROM stress_planlist WHERE id IN (SELECT max(id) FROM stress_planlist GROUP BY uid)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment