Re: Mysql 8 stored procedure

[Zoltan Szmutku]

Hi,

I think the problem can be found about the

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'teszt061122' AND TABLE_NAME = concat('bizonylat_torzs_2021');

command... Altough the table is there, but the field list answer sometimes void or defective.

So, the question for simple:

How can I force MySql 8 to refresh INFORMATION_SCHEMA informations?