Date: Fri, 13 Feb 2015 21:49:53 +0100 From: Rolf Nielsen <rmg1970swe@gmail.com> To: User questions <freebsd-questions@freebsd.org> Subject: Batch editing an SQLite db Message-ID: <54DE6371.4070609@gmail.com>
next in thread | raw e-mail | index | archive | help
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 I recently changed from one ROM to another on my Android phone. The old one and the new one use different mount points for the external SD card, and because of this the music playlists I've painstakingly created are utterly useless. The player refuses to even open them, because the files in them are non-existent. These are SQLite database files, and I've been able to open them with the SQLiteEditor app for Android, but I've not found an option to replace all occurances of a string with something else. I have eight playlists with some 500 songs each, so editing them manually would be tedious. Is there something in the ports tree that can do this? SQL isn't a language I speak fluently, so I'd need some pointers as well. Basically I need to substitute "sdcard1" for "extSdcard". TIA, Rolf Nielsen -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBCAAGBQJU3mNgAAoJEPJMW41Co4JgIF8P/RZBX6Pk5pb2TXjwQREAYjBT yXmj3GWO9XSBvVlhpgNjpshkYar/H9ZMNVQvOijLf0gt/cQZ1/SeHhSKV9fHhDNl O54PHLbJH3zwJZyS0srxJnkw7YWg+KIxWjNTE3x2vjbmdTT86UryNSMd4kdcYQN6 gP2aJFXC/wjEDLO71Zh2WYD6fsbi1vyxxBz4hXZlfvfQV9J2cGfXXd/HnsC41lia MoAJ+T6MRGwmrt3fYXbVRKixQAZMowfyW7mNQcr5uVjwFHhZcjWXRXfkp+hctyK9 VgKqKfalszjkcyYTxLo45CnFzCF8qhIP2f8zpPhvtHvA15sO9DhpnA6BSkBgOwgB wR8EG3sg9CPLMH0IdAvUVnhQGSuR2fJ9wH/H2QXk3/3LrauUjnpskiEWhDQ5/qZj 9sMIaNPcsuj2EdqSUV3gZlfUHQPakSDO1OuPBoacK2BKQjRaugO/RQpqokm2cXMa KLpBiNGO8kbavCP4uoZmPs3xjhrUSD/8iO0kOt4Pbby9ffFnPVQtHjAWaX1BQLHl BMC0VXEtYrDJjndYpp2tMUuP5iwi3v8QSMviUAeUPMJtW03dlF+rSqBzDKVxbtlw YoNWRICvCbrNFFJJSnxs5GOLk0cVZtJ+jC97Xq6ais3l2ev/HWPnfICYyILlGFK+ onlq3WP7JtF8/luE5FI3 =QZ8L -----END PGP SIGNATURE-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?54DE6371.4070609>