Re: [Phpmyadmin-devel] MySQL queries

Hi Dne Thu, 31 Mar 2011 13:50:41 +0530 Samiran Raj Boro <srajbr@gmail.com> napsal(a):

I am not so sure whether to post it here or not. As I have decided to work on Stored procedure support for GSOC project, I need these answers.

1) What are the risk of using mysql database in MySQL? Why is it always suggested to use information_schema instead

Using information_schema is preferred way.

2) What is the difference between 'name' and 'specific_name' in mysql.proc? These two seems to be same than why do we need two.

Exactly same is in information_schema (SPECIFIC_NAME/ROUTINE_NAME), there is probably no difference in current MySQL versions. -- Michal Čihař | http://cihar.com | http://blog.cihar.com