Using following steps we can intall Apache , MySQL and PHP on Ubuntu 16.10 system. 1. First install Apache server Open Terminal and write following command Advertisements
SELECT * FROM `tablename` group by field_title having count(`id`) > 1
//set parameter in mysql query $query = “SELECT * FROM category WHERE published=1 and id not in (’11’,’22’,’33’)”; //execute the query $result = mysql_query($query);
You can disable all WordPress plugin at once from a single MySQL query. This will be faster to disable all plugins through command line. You need to disable plugins if you want upgrade the WordPress site. Following MySQL command will helpful for you. UPDATE wp_options SET option_value = ” WHERE option_name = ‘active_plugins’; Above command … More How to disable WordPress plugin from database?
Sometime you want to change WordPress theme without login in site backend. For example If you upgrade wordpress site and after complete upgradation of site you found that site is stop working. You may see just a blank page instead of newly updated site. This situation may happen if your old theme not support the … More How to change WordPress theme directly from database?