LOAD DATA INFILE / Stored Procedures

[Niti]

Hi,

I would like to know if MySQL supports stored procedures.. and if it does then what is the format for writing one..

I am trying to load some Update statements that would run every time I load in a file using LOAD DATA INFILE command.. I was told that I should be able to load the UPDATE statements at the same time when I load a file.. but I don't quite know how to do that either..

Please let me know how can i do it with Load Data Infile and/or using Stored Procedures if possible !!!

Thank you
Niti -