Category: MySql

How to delete chat history of a particular user/contact in Skype [Solved]

Skype, one of the most used VOIP client software for communication inside organizations. One problem with this software is that: by default you can’t remove chat history for a specific contact. To delete chat history of a particular user/contact in your Skype, you have to use a DB browser software( sqlitebrowser ) to read the…

June 27, 2013
Refreshing new look of php.net

PHP.NET website has got a new refreshing look. Yes, with the recent launch of PHP 5.5.0 they have changed to the new layout for php.net It looks awesome !! For the time-being, a new banner has been added to the top of the php.net website introducing everyone to the new theme. Go and have a…

June 25, 2013
SQL query to get post and its meta_values as one row of record (single data grid)

How to query EAV attributes into separate columns ? Here is the SQL query to get post and its meta_values as one row of record (single data grid). 🙂 🙂 WordPress stores the post data mainly in two tables (i.e. wp_posts and wp_postmeta). The first table stores the data which are common and apply to…

April 14, 2013
[Solved] latin1_swedish_ci collation by default in PhpMyadmin to “utf8_general_ci”

After upgrading to PhpMyAdmin version: 3.4.5 (which comes in XAMPP 1.7.7-VC9), I noticed that the default collation of MySql is set to “latin1_swedish_ci”.Due to this, whenever a new database is created using phpMyAdmin, it sets the collation as latin1_swedish_ci by default(there will be no problem due this though). We can change this to “utf8_general_ci” /…

June 6, 2012