As we all know that mysql is available with store procedures. But i dont know how to use the store procedures for my website. as i heard that we cannot use the store procedures for live site. we can only use store procedures for desktop application. plz explain
No, that is not true that you can not use stored procedures for live site. From MySQL side it has absolutely no difference whether desktop application connects to it or website - MySQL server just does not have that "knowledge".
You probably should start by reading what MySQL manual has to say about them: http://dev.mysql.com/doc/refman/6.0/...ams-views.html