recentpopularlog in

therobyouknow : prefix   5

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
Script for adding or removing a prefix on existing tables in mysql |
How to prefix all the tables in a MySQL database so that more than one drupal site can work in the same database, particularly useful for shared hosting where there can be a limit to the amount of databases
drupal  cms  computing  prefix  multiple  table  database  single  installation  mysql  howto  sharedhosting  shared  hosting  limit  separate  php  tool  utility 
november 2011 by therobyouknow

Copy this bookmark:

to read