-
Daily Popular
- 10 Steps: MySQL Monitoring through Nagios: Install & Configure
- Collection for insulting – one liners
- Calculate Mysql Memory Usage – Quick Stored Proc
- MyDumpSplitter-Extract tables from Mysql dump-shell script
- How to echo colored text in linux shell script
- Audit-Checking login history-to know WHO DID THAT on Redhat Linux
- MySQL Stored procedure – Split Delimited string into Rows
- MySQL Function to Convert Date To Words
- MySQL Memory Usage Limits on 32 bit Linux
- Load Delimited Data (csv, excel) into MySQL Server
-
code Archive
-
![More... Okay! So here we will use Load Data syntax to load file into MySQL Server in a Stored procedure. Yep! It’s a workaround. Download MySQL UDF: [root@localhost kedar]# wget...](http://kedar.nitty-witty.com/blog/wp-content/themes/arras/images/thumbnail.png "Using LOAD DATA INFILE with Stored Procedure Workaround-MySQL")
Using LOAD DATA INFILE with Stored Procedure Workaround-MySQL
Posted on November 30, 2010 | 16 CommentsMore...Okay! So here we will use Load Data syntax to load file into MySQL Server in a Stored procedure. Yep! It’s a workaround. Download MySQL UDF: [root@localhost kedar]# wget http://www.mysqludf.org/lib_mysqludf_sys/lib_mysqludf_sys_0.0.3.tar.gz... -
MySQL Function to Convert Date To Words
Posted on September 16, 2010 | 3 CommentsMore...Recently I saw a MySQL Stored Function requirement on Experts-Exchange for converting date into some specific words format. You may find MySQL function for date to words conversion online; even... -
My worst mathematical program in perl
Posted on August 4, 2010 | 3 CommentsMore...I have a Mathe-crap-matical friend. Who keeps digging into graves of dead formulas and equations and all possible Math related stuffs. Since I started understanding Mathematics (that it’s not my... -
Java termwork connect Access Database and operations
Posted on May 24, 2010 | 1 CommentMore...Prologue: Long back there were golden days of post graduation in the “great” DDIT (Now Dharamsinh Desai University), Nadiad. Assignments, termwork and journals or everything similar was in demand –... -
MySQL Stored procedure to Generate-Extract Insert Statement
Posted on May 5, 2010 | 8 CommentsMore...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... -
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.... -
MySQL Stored procedure – Split Delimited string into Rows
Posted on December 5, 2009 | 18 CommentsMore...This procedure will split a “;” separated column in to new fields preserving ids. This is very specific problem, lets check it with example. Consider a sample table test: And... -
MySQL Stored procedure – Execute query if table or Column exists
Posted on December 5, 2009 | 2 CommentsMore...Well procedures mainly carried out working with information schema and it’s usage in stored procedure. Procedures are fairly simple and easy to understand. 1. Edit_table – following procedure executes queries to... -
How to echo colored text in linux shell script
Posted on December 4, 2009 | 2 CommentsMore...Try following command on you bash: bash $] tput setaf 1 You will see your text color will turn red. To reset it you can type following command to make... -
MySQL master master replication monitor with php code
Posted on December 4, 2009 | 2 CommentsMore...For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it Well this is fairly simple php code for monitoring...