mannuScript

Hacking mysql concat function

In this article I will be sharing my experience of using MySQL concat function for multiple purposes like creating insert queries and curl requests from existing data in MySql tables. But before dwelling into the queries I wrote, let's understand the use of concat function: concat function is used to ... Read more »

Enlisting servers connected to mysql machine

Few days back our DBA updated the DNS entry of one of the slave to point it to newly created machine, with better configuration and disk space. Now we were required to switch all mysql connections (built by our app servers) from old machine to new one. show processlist gave ... Read more »

First id of the partition

In mysql we many times need to know the first id of current or last partition to feed it in select queries. For instance, if you want to scan last 2-3 partitions for given conditions. This is what my requirement was when I wrote this query to fetch the starting ... Read more »