Archive for March, 2010
-
MySQL related file types and basic information
Posted on March 29, 2010 | 5 CommentsMore...This post covers the basic information of files that MySQL Server uses / creates for various tasks. my.cnf : It is the main configuration file for MySQL. You may find... -
Earth Hour March 27 2010-India-Switch off lights for future
Posted on March 27, 2010 | No CommentsMore...Earth Hour is a global event organized by WWF (World Wide Fund for Nature). Earth Hour held on the last Saturday of March annually, asking households and businesses to turn... -
Working with EditPlus Text Editor-Regular Expression How To
Posted on March 20, 2010 | 8 CommentsMore...Editplus is a lot better than the regular text editor, Notepad. From all it’s features I like RegExp Support the most, and than comes the block select feature. Here are... -
batch script to add remove prefix zero pad bulk file rename
Posted on March 18, 2010 | 3 CommentsMore...This post has two batch scripts: 1. Batch script to rename files with zero padded number series-prefix 2. Batch script to remove prefix of perticular length 1. Batch script to... -
SQL syntax with /*! c-style comments in MySQLdump
Posted on March 11, 2010 | 1 CommentMore...In mysql we have — , /* and /*! comments. This post is mainly about very basic c-style comments. /*! : C-Style comments in MySQL We normally see comments in... -
Top Secret of 2010-Got Revealed-Watch video free
Posted on March 6, 2010 | No CommentsMore...Yes the video will reveal the top most secret of 2010!! The video will give you the Hero… How can you, I, our friends really trust our selves that what... -
Ideas for select all columns but one mysql stored procedure
Posted on March 5, 2010 | No CommentsMore...Assume we’ve a table with 100 rows and we need to select all columns but one. The problem is headache of actually typing out all 99 required columns!! Solutions /... -
No More Spool Space Teradata Query Solution
Posted on March 2, 2010 | 4 CommentsMore...Have you ever come across a situation called NO MORE SPOOL SPACE? My friend does and hence I studied a bit about Teradata. The query: SELECT DISTINCT fieldname FROM tablename; The error:...