Created
February 6, 2013 19:40
-
-
Save intarstudents/4725159 to your computer and use it in GitHub Desktop.
Delete zero sized songs from iOS Music player
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| echo "DELETE FROM item WHERE item_pid IN (SELECT item_pid FROM item_extra WHERE file_size = 0); | |
| DELETE FROM item_search WHERE item_pid IN (SELECT item_pid FROM item_extra WHERE file_size = 0); | |
| DELETE FROM item_stats WHERE item_pid IN (SELECT item_pid FROM item_extra WHERE file_size = 0); | |
| DELETE FROM item_extra WHERE file_size = 0;" | sqlite3 /var/mobile/Media/iTunes_Control/iTunes/MediaLibrary.sqlitedb |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment