[Phpmyadmin-devel] MySQL queries

Michal Čihař 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...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20110331/90c44be9/attachment.sig>

More information about the Developers mailing list