I would like to ask mysql how to create a stored procedure to query any table name information. I can’t write a stored procedure like this myself.
create procedure test(out testing varchar(10)) Start select * from testing; End $$
Mysql> call test(‘test1’) has its own table name of test1. It wants to query all the information of the table by storing the Process function, but there is an error here and the creation of the stored procedure is successful.
Your select * is to inquire about everything. There must be a mistake. Which table do you want to specify?