31 Mar
2011
31 Mar
'11
10:37 a.m.
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.
- 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.
- 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