On 2015/04/08 11:42, Andrew Wallace wrote:
I think you'd have to do that with a trigger.
Yes, one can do that with a trigger, but it is a real pain. MySQL now allows
(new.a,new.b,new.c,new.d) <> (old.a,old.b,old.c,old.d)
but one needs to beware of NULL. Maybe it is better to split off t
A trigger is far simpler than remodelling your data and adding extra
queries. They are nothing to be afraid of.
On Thu, Apr 9, 2015 at 10:46 AM, wrote:
> On 2015/04/08 11:42, Andrew Wallace wrote:
>
>> I think you'd have to do that with a trigger.
>>
>
> Yes, one can do that with a trigger, but
On Tue, 7 Apr 2015, shawn l.green wrote:
Temporary tables are going to become your very good friends.
yes I do use temporary tables a lot
The advantage to using temporary tables is that they can have indexes on
them. You can create the indexes when you create the table or you can
ALTER the
