How about using the INSERT statement with a SELECT subclause? http://dev.mysql.com/doc/refman/5.6/en/insert.html
++hobbitt On Tue, Jan 28, 2014 at 7:42 AM, Rob Landry <[email protected]> wrote: > > I write a lot of Perl scripts that interact with MySQL databases. When > inserting anything into a non-numeric field, I always pre-process the data > with: > > $data =~ s/'/\\'/g; > > The single quote is used by MySQL as a field delimiter, so it needs to be > escaped. I've never had trouble with any other characters. > > > Rob > > > > On Tue, 28 Jan 2014, Cowboy wrote: > > >> A conversion project. ( hopefully, just a task ) >> Not specifically Rivendell, but maybe one or two of you have >> run into a similar "problem" ? >> >> I need a way to extract a value, a single table entry, from >> one table, and copy/move/insert/update/replace ( whichever is >> appropriate. My lack of understanding ) into another table, into >> another column, preferably by bash script. >> >> There are "more than a few" table entries to deal with. ;) >> These table entries may be a number, may be text. >> I fear the text entries may create a delimiter problem. >> So far, with everything I've tried, the text entries ( of >> random length and content ) have created delimiter issues. >> Some them contain single quotes, some contain double quotes. >> Some contain colons, and some semi-colons. Some contain >> backslashes, etc. So far, none contain certain characters that >> may be delimiter candidates, such as a vertical bar. >> Assume I can find a suitable delimiter. >> >> Unfortunately, with what I've tried, things like catenate the last >> column, ignoring delimiters, works for text in the last column, >> but some tables have another column after the text, so that doesn't >> always work so pretty good. >> With thousands of table entries to move/copy something like >> PHPAdmin or SIDU is impractical. >> Tried several things. >> Exporting a table as a spreadsheet, working on that, followed >> by importing the spreadsheet. Works sometimes. >> Columns containing zeros seem to cause various issues, like >> being ignored, so the following column ends up in the wrong place, >> or creating a null entry where a zero should be. >> >> Preferably, a "simple" loop, that can do something like >> for column A "has any entry at all" in table B do; >> copy column C to table D column E. >> done >> >> In some cases >> where column A LIKE "something" AND column B LIKE "something else" >> copy column D into table Y column E >> >> Just seeking a relatively simple, generic loop, and I'll hack the details. >> Prefer BASH script. Can work with a PHP loop if absolutely necessary. >> >> Suggestions ? >> Since this isn't Rivendell ( but you go where you can find the best >> expertise ) off list is fine. >> >> Thanks... >> >> -- >> Cowboy >> >> http://cowboy.cwf1.com >> >> So, what's with this guy Gideon, anyway? And why can't he ever >> remember his Bible? >> >> _______________________________________________ >> Rivendell-dev mailing list >> [email protected] >> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >> >> _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > -- druidlabs.wordpress.com flickr.com/photos/druidlabs/sets
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
