-
Daily Popular
- Xtreme Movie Review: Agneepath Agneepath Agneepath (2012)
- JaxtrSMS-Send Free SMS Worldwide | Download for iPhone, Android, BlackBerry, Java
- Load Delimited Data (csv, excel) into MySQL Server
- Collection for insulting – one liners
- 10 Steps: MySQL Monitoring through Nagios: Install & Configure
- Unique birthday card wishes for My dear Brother
- Working with EditPlus Text Editor-Regular Expression How To
- MyDumpSplitter-Extract tables from Mysql dump-shell script
- Place to visit Mumbai: Alibaug 1-2 day tour weekend picnic
- 3 Idiots – Chatur Silencer Speech Chamatkar
-
MySQL Archive
-
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 /... -
5 useful MySQL Command Options-pager-prompt-rehash-tee-system
Posted on February 27, 2010 | No CommentsMore...There are set of commands that MySQL itself interprets. You may use “help” or “\h” at the mysql> prompt to list them. Below are the 5 most useful MySQL Command... -
MyDumpSplitter-Extract tables from Mysql dump-shell script
Posted on February 11, 2010 | 29 CommentsMore...A lot of articles have been written on splitting mysqldump and grab required tables. Long back when Shlomi had suggested a “sed” way, I actually shell scripted it, and now... -
Stored procedure to add-remove prefix by rename table mysql
Posted on February 8, 2010 | 3 CommentsMore...Here is one more procedure – (this time) for mass renaming of table. Adding and Removing table-name prefixes A friend of mine was renaming 100+ tables by using replace methods... -
Load Delimited Data (csv, excel) into MySQL Server
Posted on January 11, 2010 | 54 CommentsMore...Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost everytime LOAD DATA INFILE come into rescue. Here we will try... -
Petition – Help saving MySQL – II
Posted on December 29, 2009 | No CommentsMore...Recently Monty has posted again and I completely convinced with whatever Monty has conveyed now or earlier. The explainations he has provided under self-interview, I find sensible enough. I did participated the help-saving-mysql campaign... -
MySQL Memory Usage Limits on 32 bit Linux
Posted on December 18, 2009 | No CommentsMore...I’m having RHEL 5 (32-bit) and MySQL-5. I was trying to check how much is the Memory Utilization limits for MySQL 5 on 32bit OS. We can easily calculate the... -
MySQL Certification Free Retake: Get TWO chances to get MySQL Certified
Posted on December 15, 2009 | No CommentsMore...Recently MySQL has offered MySQL Certification Free Retake on both DBA or Developer Certifications for a limited time. For MySQL Certifications: 1. MySQL 5.0 Data Base Administrator Certification (SCMDBA) -... -
Monty: Help Saving MySQL – The Oracle & EC
Posted on December 14, 2009 | No CommentsMore...We all are aware about the acquisition happened to MySQL; Sun and now Oracle. A common understanding tells me that a business will always seek profit; so will Oracle. And... -
Stored procedure to Find database objects
Posted on December 5, 2009 | 1 CommentMore...This procedure lists available database objects under passed database name. It lists present Tables, Views, Stored Procedures, Functions and Triggers under particular database. It also lists storage engine of tables....