Re: LOAD DATA INFILE

2004-12-20 Thread Goutham S Mohan
cify the column and record delimiters as required. -> Escape characters need to be defined when you do a mysqlimport so that the data is not mistaken as a delimiter by mysql. -> Also make sure that there are no foreign key violations in your target database. Regards, Goutham S Mohan --

Re: Help me optimize this query

2004-12-16 Thread Goutham S Mohan
e a temporary result by breaking the query. insert into "temporary_table" select t2.ZZZ from t2 where t2.AAA like '%bla%'; Then use this temporary to join with t1 in an update. Again, before trying this, make sure you have all indexes, foreign keys defined. Defining this i

Re: repair table priv

2004-12-15 Thread Goutham S Mohan
ables: so a superset of these privileges should be available. -Goutham S Mohan --- Bgs <[EMAIL PROTECTED]> wrote: > > up > > Bgs wrote: > > > > Does this silence mean that nobody knows?!? :) > > > >> I've been trying to find what privilege i

Re: Re: Help me optimize this query

2004-12-13 Thread Goutham S Mohan
e a temporary result by breaking the query. insert into "temporary_table" select t2.ZZZ from t2 where t2.AAA like '%bla%'; Then use this temporary to join with t1 in an update. Again, before trying this, make sure you have all indexes, foreign keys defined. Defining this i

Using IA64 build on Itanium running HPUX B.11.22

2004-02-25 Thread Goutham S Mohan
this. Thanks and regards, Goutham S Mohan - Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want.