Category: MySql

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

    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…

  • Refreshing new look of php.net

    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…

  • SQL query to get post and its meta_values as one row of record (single data grid)

    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…

  • [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” /…