MySQL Stored procedure »
A lot of places I saw people asking for ways to generate Insert statements. We do have GUI Tools which can extract [...]
EPIC-First Indian Web »
Recently India got it's own Currency Symbol for Indian Rupee! But do we know, we also got our own "Made [...]
My Sony DSC HX1 Performance, »
After a lot of ifs, buts, confusions and questions I've bought Sony's DSC HX1 . Well I'm not that good [...]
My Digital confusion for »
In the huge task of selecting a digital camera, one more day has passed. I'm still not decided. Yes, [...]
Extreme Movie Review: I hate Luv »
I hate Luv Stories. No! it's not a spell mistake, they have intentionally made it "LUV" as they love LOVE stories. Since I heard the name, I started [Read More]
Prologue: Long back there were golden days of post graduation in the "great" DDIT (Now [...]
Assume we've a table with 100 rows and we need to select all columns but one. The [...]
Here is one more procedure - (this time) for mass renaming of table. Adding and Removing [...]
Top Secret of 2010-Got »
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 we see on TV and hear on radio is true? How do we know that our openions are really our [Read More]
More Just for fun Headlines
MySQL Stored procedure to Generate-Extract Insert Statement
A lot of places I saw people asking for ways to generate Insert statements. We do have GUI Tools which can extract insert statements for us readily. of the time I choose the MySQLDump way to generate insert statements. mysqldump -uroot -ppassword --complete-insert --no-create-info DATABASE TABLENAME > TABLENAME.sql But mind is very [...]
Steps to Move Copy Rename MySQL Database
Moving, copying or renaming database is a very basic activity. I have just noted a few commands for reference to quickly follow the required operation. 1. Rename database on Linux Machine: A. Use RENAME DATABASE Command . RENAME DATABASE db_name TO new_db_name; B. mysql -uroot -pPASSWORD -e "drop database if exists NEW-DB-NAME; create [...]
MySQL Load Data Infile Syntax Generator Tool Download
The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. The file name must be given as a literal string. I have already written the basic how to follow that considering additional cases. A lot of questions I have seen for loading separated data to MySQL, so here I've created a very beginner level excel [...]
MySQL related file types and basic information
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 it under base directory in windows or under /etc/. .sock : mysqld creates a socket for programs to connect to and notes in this file. It is named as mysql.sock. Pid file [...]
SQL syntax with /*! c-style comments in MySQLdump
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 MySQLdump as follows: /*!40000 ALTER TABLE `a` DISABLE KEYS */; Or /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ These are actually C-Style comments which has [...]
