-
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
-
stored procedure 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 Stored procedure to Generate-Extract Insert Statement
Posted on May 5, 2010 | 6 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... -
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 /... -
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... -
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 | 17 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... -
Calculate Mysql Memory Usage – Quick Stored Proc
Posted on November 16, 2009 | No CommentsMore...While going through mysql doc and MySQL Server Memory Usage, I noted following quick points regarding how mysql uses memory. We have global buffers which are allocated irrespective of connections... -
Search-find through all databases, tables, columns in mysql
Posted on October 29, 2009 | 3 CommentsMore...What will you do if one day some one ask you to find single string in all databases, all tables and in all columns? I just read such question and tried to find...