The mysql.proc table is gone

from the Artful MySQL Tips List


If you have pre-8.0 MySQL code that uses mysql.proc to capture info on MySQL stored routines (procedures, functions, triggers), you have work to do---8.0 has moved that functionality from mysql.proc to information_schema tables.

What you lose in inter-version portability, you gain in inter-RDBMS portability ... as of 8.0, MySQL stored routine metadata is SQL standard.

For a thorough account of the changes see here.

Last updated 8 Apr 2020


Return to the Artful MySQL Tips page