zy108830/repeatFields.php

Created May 23, 2016 13:10

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/zy108830/bf45fc5c0fdf0eb1c3f99f1d114c50e7.js"></script>
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