Load columnar text file into MySQL table
Kedar
Ever come accoss a situation where you have to load a flat text file into MySQL with data provided in single column! Say, your data to be loaded in table…
MySQL – Alter table-change datatype of column with foreign key
Schema alteration is a big headache especially when it has already reached to production and things get worse when the relations are involved.Below is a short example for altering tables…
Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY
MySQL Stored Routines (functions and procedures) are not only used for improving performance but also they’re handy when it comes to enhancing security and restricting user access. This post briefs…
JaxtrSMS-Send Free SMS Worldwide | Download for iPhone, Android, BlackBerry, Java
Introducing JaxtrSMS, The world’s first free and open texting app is a revolutionary product from co-founders Sabeer Bhatia & Yogesh Patel. Sending free text messages or free SMS is now…
What Music mean to you?
What music mean to you? Well, surealy this is one of those questions for which you know the answer but you just can’t describe satisfactorily. So, here is my try.…
MySQL Binary logs Generated Per Hour | Growth Estimate
The MySQL binary log is a set of log files that contain information about data modifications made to a MySQL server instance. At times we need to understand the disk…