Is it possible to apply trigger on any table in information_schema?
+1
A:
It is my understanding that the tables in information_schema are really views. This is mentioned here.
According to MySQL, you can't make triggers on temp tables or views. See this page for a discussion about that.
So, I'm going to say no based on that information. I'm sure someone will correct me if I'm wrong on this.
There is a discussion similar to what you are asking here.
What are you trying to accomplish?
itsmatt
2010-03-24 12:49:42
I am trying to do accomplish a task I have mentioned here http://forums.mysql.com/read.php?99,360049,360049#msg-360049Please Throw Some Light
OM The Eternity
2010-03-25 07:34:51
Saw your question there. If I understand your scenario correctly, you are trying to get the TRIGGER to dynamically adjust to the fact you've renamed a column that is specifically mentioned in the TRIGGER's definition. Of course, it doesn't do that automatically and the update fails because the TRIGGER is looking for the old column name and it has been renamed.My advice would be to just keep things simple and if you need to modify the table's column name, modify the trigger's definition. Someone smarter than me might have another approach. Good luck!
itsmatt
2010-03-25 11:16:12