[Phpmyadmin-devel] MySQL queries
michal at cihar.com
Thu Mar 31 10:37:03 CEST 2011
Dne Thu, 31 Mar 2011 13:50:41 +0530
Samiran Raj Boro <srajbr at 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
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 836 bytes
Desc: not available
More information about the Developers