Requirements: every time a list of new judge, when its meet the suffix name, and then to calculate write new tables,
Problem: the trigger condition can't write, how to judge he is to meet the new table I conditions,
Use the SELECT TABLE_NAME FROM INFORMATION_SCHEMA. TABLES WHERE TABLE_NAME like '% JG can determine what table
In a dead end, to everyone a great god,
Write statement myself to learn, thank you for your comment, thank you for,
CodePudding user response:
Use INFORMATION_SCHEMA judgment