Search
-
Recent Posts
Tags
adwords amazon analytics api apple aws blog chrome chromium cloud Design dropbox ec2 email error facebook firefox google google-apps homebrew ipad javascript jQuery linux lion mac microsoft mysql os x osx paypal php plugin quicksilver raspberry pi scam social spam twitter ubuntu unix video windows woo wordpress
Tag Archives: update
MySQL UPDATE JOIN
Here is a working example of how to do an UPDATE JOIN with MySQL: MySql UPDATE LEFT / CENTER / RIGHT JOIN Example This is the correct way to update a table when using a JOIN. They key is that the SET needs to come after the JOIN. UPDATE wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) SET wp_term_taxonomy.taxonomy = ‘category’ WHERE 1 AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (1) This WILL NOT WORK because the SET is in the wrong place: UPDATE wp_posts SET wp_term_taxonomy.taxonomy = ‘category’ LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1 AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (1)
Firefox: Disable Auto Update
There are two methods to Disable Auto Update in Firefox: Firefox: Disable Auto Update Method 1 Go to the “Tools” menu (in the menu bar) and choose Preferences / Options. On Mac OS X Go to the “Firefox” menu bar and choose preferences or press cmd+, Choose the “Advanced” tab and the “Update” sub tab, and then choose one of the options: Install updates automatically (recommended) Download update but let me choose whether to install them Check for updates but let me choose whether to download and install them Never check for updates (not recommended) Firefox: Disable Auto Update Method 2 In your browser bar type in about:config and press return. Type in app.update.auto to filter results, and look for the boolean entry. Set this to: true – firefox will auto update (default setting) false – firefox will not update automatically