a trigger question

Hello,I am newcomer to the list.I have a question about mysql trigger.There is a
table named test and an insert trigger connected to the table.table temp is a copy
of table test,it records the columns inserted into test using the insert trigger.
I have read the manual,and created a trigger like this:

CREATE TRIGGER trigger_insert after INSERT ON test FOR EACH ROW BEGIN INSERT
INTO temp SET a1 = NEW.a1;

It seems like you have to specify the colunms in the SET substatement. Is there
something like "select * from inserted" in mssql ,so that I don't need to specify
the column name like "a1 = NEW.a1" staticly?

thanks in advance
marilynchai




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org