On Aug 31, 2006, at 5:51 AM, Andrew Brown wrote:
Can BBEdit do anything useful with a MySQL database ? I'm looking for an effective editor of remote database records, with which one can search-and-replace on screen for example... copying from CocoaMySQL to BBEdit and back again can help, but is a rather heavy- handed approach. Apologies to those who have already seen a different form of this request elsewhere.
Export the records to a text format (tab delim, CSV, etc), modify the records, then use SQL's 'LOAD DATA INFILE' command. However, unless you're trying to do really complex regex work, you can typically do a lot of in-place editing on the database. I'd ask what you were trying to, but then we quickly get away from the list's topic. ----- Joe Hourcle -- ------------------------------------------------------------------ Have a feature request? Not sure the software's working correctly? If so, please send mail to <[EMAIL PROTECTED]>, not to the list. List FAQ: <http://www.barebones.com/support/lists/bbedit_talk.shtml> List archives: <http://www.listsearch.com/BBEditTalk.lasso> To unsubscribe, send mail to: <[EMAIL PROTECTED]>
