recentpopularlog in

therobyouknow : query   14

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
MYSQL Server has gone away query |
Disable Update Status Module advice here worked for me.
drupal  fix  mysql  query  sql  troubleshooting 
march 2010 by therobyouknow

Copy this bookmark:

to read