October, 2011
How to run SQL Yog in Ubuntu
SQLYog is the best MySQL GUI client for Windows ( to me ). Since I started work on Ubuntu, I was badly missing the tool. Thanks to Andrew Ault for his nice blog. Andrew Ault has written a blog which actually guide you through the process of running SQL Yog in Ubuntu. Have a look.
Tags: mysql ubuntu sql yog web yog gui client
Posted in: blog | No Comments »
Understanding JSON Data
JSON (JavaScript Object Notation) is the modern way of data exchange. You can find more on JSON here. It is easy to manually create the JSON data. JSON data based on key/value pairs. These pairs can be in the form of object and array too. JSON data enclosed within curly brackets “{ }” and array [...]
Posted in: blog | No Comments »
A little tutorial on MySQL UNION and GROUP BY
Recently I have experienced a situation while working on a PHP project with MySQL, where I had to combine 2 SQL result set while grouping with common key for the entire combines result. I found a thread on mysql forums ( http://lists.mysql.com/mysql/182163 ) that solved this problem. Let’s make a messaging example: Table: Messages ============== MsgID [...]
Tags: database, dba, example, group by, mysql, programming, query, sql, tech, union
Posted in: blog | No Comments »