recentpopularlog in

therobyouknow : combine   15

sql - How does one concatenate database values into a string? - Stack Overflow
Useful for marking which bugzilla bugs have migrated to JIRA.

UPDATE `bugs` SET short_desc = CONCAT('BUG', bug_id, ': ', short_desc ) WHERE product_id = 3 OR product_id = 9

UPDATE `bugs` SET short_desc = CONCAT( short_desc, ' [JIRA]' ) WHERE product_id = 3 OR product_id = 9
concatenate  database  string  within  variable  query  append  prepend  join  combine  link  value  prefix  suffix  field  update  insert  computing  mysql  howto  work 
december 2011 by therobyouknow
Concatenate files
Response 3 works with any file type: copy mar89.rpt + apr89.rpt + may89.rpt report
This command combines the files named MAR89.RPT, APR89.RPT, and MAY89.RPT

Assumes that files weren't split parts being recombined - for that use copy /b file.* which will combine files ending in 001 002 ... 00n
text  file  combine  dos  dosshell  shell  windows  concatenate  append  howto  computing  any  copy  command  console  cli  line 
february 2010 by therobyouknow

Copy this bookmark:





to read