Re: joining six tables by mutual column

2005-04-25 Thread Nick Pasich
able4.something AND table1.something LIKE table5.something AND table1.something LIKE table6.something ; ----( Nick Pasich ) On Mon, Apr 25, 2005 at 12:51:53AM +0200, Schalk Neethling wrote: > Greetings everyone. > > Hope someone can give me some

Problems Using SELECT INTO OUTFILE

2003-03-05 Thread Nick Pasich
',' ENCLOSED BY '"' From AnyTable; or: Select * From AnyTable; Subsequent Calls Work Fine. >How-To-Repeat: Execute the same command more than once. >Fix: Use SQL_NO_CACHE as temporary fix

Problems Using SELECT INTO OUTFILE

2003-03-05 Thread Nick Pasich
',' ENCLOSED BY '"' From AnyTable; or: Select * From AnyTable; Subsequent Calls Work Fine. >How-To-Repeat: Execute the same command more than once. >Fix: Use SQL_NO_CACHE as temporary fix

mysqldump doesn't write data on subsequent calls (MySql 4.0.1)

2002-04-10 Thread Nick Pasich
t;How-To-Repeat: Execute a mysqldump command more than once. >Fix: >Submitter-Id: >Originator:Nick Pasich >Organization: >MySQL support: email support >Synopsis: Problem with mysqldump when using query caching >Severity: serious >Priority:

Problem with mysqldump when using query caching

2002-04-10 Thread Nick Pasich
t;How-To-Repeat: Execute a mysqldump command more than once. >Fix: >Submitter-Id: >Originator:Nick Pasich >Organization: >MySQL support: email support >Synopsis: Problem with mysqldump when using query caching >Severity: serious >Priority:

Re: Problem with mysqldump when using query caching (4.01)

2002-04-10 Thread Nick Pasich
roduce this reliably maybe we could get a fix! Can you > do this everytime? > Ken > > - Original Message - > From: "Nick Pasich" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, April 10, 2002 12:27 PM > Subject: Problem with mysqldump when using

Re: "gunk" in mysqldump output

2002-04-15 Thread Nick Pasich
Use option "-K or --no-disable-keys" with myqldump. > Date: Mon, 15 Apr 2002 09:37:43 -0400 > To: [EMAIL PROTECTED] > From: Bill Marrs <[EMAIL PROTECTED]> > Subject: "gunk" in mysqldump output > > In some recent release of MySQL, lines like this: > > /*!4 ALTER TABLE States DISABLE KEYS

Re: mysqldump doesn't write data on subsequent calls (MySql 4.0.1)

2002-04-19 Thread Nick Pasich
On Fri, Apr 19, 2002 at 04:12:35AM -0700, Jeremy Zawodny wrote: > On Wed, Apr 10, 2002 at 08:48:01AM -0700, Nick Pasich wrote: > > [snip] > > > > > Any subsequent executions do not. This is because of query caching. > > I can run --> mysql -e "re

Re: ReisserFS

2001-02-22 Thread Nick Pasich
the the fast mounting that the Reiser file-system afords.. ( Nick Pasich ) On Thu, 22 Feb 2001, Simon Windsor wrote: > > Has anyone user MySql on a ReisserFS file system ? > > > > Where any problems encountered ? and do you

3.23.35 mysqlimport Doesn't Report Stats

2001-03-18 Thread Nick Pasich
: Disconnecting from localhost -( Nick Pasich )- -- _ __ _ __ __ _ ___(_) ___| |__ | '_ \| '_ \ / _` / __| |/ __| '_ \ http://www.users.cts.com/sd/n/npasich | | | | |_) | (_| \__ \ | (__| | | | |

3.23.35 mysqlimport Doesn't Report Stats (resent)

2001-03-20 Thread Nick Pasich
ffic/LOADDIR/blockedHistory.asc into blockedHistory traffic.blockedHistory: ^^ ^^ ^^^ Disconnecting from localhost -( Nick Pasich )- ---