You might try:
INSERT INTO table_track select OLD.*;
-Original Message-
From: Olaf Stein [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 09, 2007 2:59 PM
To: MySql
Subject: Trigger OLD question
Hi All,
I have a table with 205 columns. When an update statement updates a row
in
this tab
At 4:59 PM -0400 5/9/07, Olaf Stein wrote:
Hi All,
I have a table with 205 columns. When an update statement updates a row in
this table I want a trigger that creates a record of the old row in a
separate table.
The following works fine when not too many columns need to be written into
the other
