MySQL临时表是共享资源吗?

I have a MySQL stored procedure that uses a temporary table. Assume that my table name is 'temp' and I use it to store some middle data. It will create at the beginning of procedure, and will drop at the end.I have a MySQL stored procedure that uses a tem