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
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
