GROUP_CONCAT in MySQL is quite a handy function and I have used it lots of times to solve problems in my professional life. And today I just used it to solve a memory issue I have in my PHP script which requires grouping of data. It all worked OK if …
After installing MAMP 2.0.5 and changed MySQL’s default root password, I kept getting the following error messages: The phpMyAdmin still works, because I have already updated the config.inc.php, but this popup every time I start MAMP server is just annoying. And I have found a way to fix this. To …
I use GROUP_CONCAT function in MySQL quite often, but today I encountered a situation where by I need to order the data returned from the GROUP_CONCAT function call. Simply having “ORDER BY” clause at the end of the query does not help as it orders the final output rows, not …
I have encountered this problem before and I had found the solution, but now I have completed forgotten how to do it again. Here is the question: I have a query like And I want the result to be sorted by the order specified in the IN clause. In order …
In order to insert unicode data into MySQL database, you will need to create tables using unicode support: Now use PHP to insert data into the new table: That’s it.
My new Snowflake Blog is now live. I will not be updating this blog anymore but will continue with new contents in the Snowflake world!