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)

Posted in Tech Tips, Web Development | Tagged , , , , | Leave a comment

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

Posted in Software, Tech Tips | Tagged , , , , , | 1 Comment