I'm trying to speed up Load Data Infile and after some experimenting have
noticed this "qwirk".
BTW, all of the tables used below are empty and have identical table
structures. The value being loaded into the primary key column is 'NULL'.
Test1:
246 seconds to run Load Data Infile into a tabl
Well that is embarasing, thank you, It always ends up being the simple
things that get you.
On Sat, Oct 17, 2009 at 1:25 PM, Michael Dykman wrote:
> It appears to be a simple enough error message. Here is your trigger
> you are reffering quite explicitly to credits.enabled:
>
> > select SUM(cr
It appears to be a simple enough error message. Here is your trigger
you are reffering quite explicitly to credits.enabled:
> select SUM(credits.amount) into total_credits from credits where
> credits.enabled=1 and account=new.account;
and this table has no such column defined. debits does, bu
This is the first time I have attempted to expand beyond basic sql for
storing data in a table like structure. So my level of knowledge is
"familiar with basic SQL, but lacking in expanded knowledge". I expect my
error is a newbie mistake.
I have attempted to create a trigger to update another tab
