Tagged: MySQL

Alternate to FIND_IN_SET for non-MySQL databases

If you are MySQL user initially at the beginning of your career and later on as the career progresses got in touch with other RDBMS then you might miss MySQL’s FIND_IN_SET function badly.
What MySQL’s FIND_IN_SET does is it returns position of the matched element in the SET. That SET of items must be comma-separated. Now if you’re long time MySQL user you will miss some of the functions and one of them could be FIND_IN_SET, read on to find out how easily we can use LIKE in alternate to FIND_IN_SET.

MySQL 5.5 available for production

Back in December when I updated my twitter status to announce MySQL 5.5 general availability, I was very happy at that moment. It was the first major and much awaited release of MySQL after Oracle – the database giant acquired Sun (and so MySQL). Though MySQL 6.0 is not an active project right now and there are many strategic changes after Oracle’s acquisition of Sun for MySQL’s development road-map, but as a AMP developer it was news to be happy about.

Using Views to avoid cross database connection – MySQL

Table Views can be used as an unconventional way to avoid cross/multiple database connections sometimes..! Yes, it can be. I came across such case and found that it can be handy in some simple cases when we just want to avoid connection to another database on the same MySQL server and we can’t afford to create that table in the same database due to some reasons.

HeidiSQL 5.1 – good has got better

have been using HeidiSQL since more than three and half years now and I am really happy with it. I must say that we work with heavy database consisting of more than 400 tables and database size exceeding few GBs but HeidiSQL has never let us down. I have tried loading my development database with phpMyAdmin and SQL Buddy both but they just failed to load such a large database with few hundreds of tables..! But with HeidiSQL I never had any problem except I got some crashing sometime in newer 5.x version but I am sure all such things will be fixed in coming builds. I am not telling that there are no other good tools are available in the market but HeidiSQL is in premium open-source tool at free of cost. I remember I had written a post on HeidiSQL 4.x more than a year ago and today we are up with HeidiSQL 5.1.