webfacer/deleteFromWithSubQueryAndSameTable.sql

Created September 25, 2019 14:50

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

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/webfacer/d5c081237e17f5f96efc736a0311f78a.js"></script>
Save webfacer/d5c081237e17f5f96efc736a0311f78a to your computer and use it in GitHub Desktop.

Download ZIP

Delete From with subquery and SameTable

Raw

deleteFromWithSubQueryAndSameTable.sql

    delete from myTable where id in(SELECT id FROM (SELECT id, from_unixtime(crdate, '%Y') from myTable WHERE pid = 2203 and from_unixtime(crdate, '%Y') = 2018) mail)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment