Re: Multiple batch files

by AT&T > > -Original Message- > From: David Scott > > Date: Thu, 19 Mar 2009 11:16:03 > To: > Cc: > Subject: Re: Multiple batch files > > > Thanks for responding Gary > I get: > > --- > Volume in drive D has

Re: Multiple batch files

> Dir *.sql > my.bat > > Edit batch file for each line to append "| mysql" > > Call batch file > > > Sent via BlackBerry by AT&T > > -Original Message- > From: David Scott > > Date: Thu, 19 Mar 2009 11:08:28 > To: > Subject: Mu

Multiple batch files

dows box. Thanks for any suggestions you may have. -- David Scott

Re: Locking database when 'creating sort index'

Oh and we increased the key_buffer_size=1200M (30% of ram) no change. 2009/1/7 David Scott > 1) InnoDb2) 5.0.51 on Linux > 3) No, a Select with a bunch of Joins, a Where, group and order > 4) 37 seconds > 5) Yes > 6) Show Processlist does not show anything, just the user, what ar

Re: Locking database when 'creating sort index'

ther queries start to back up when the large >> one >> gets to the 'creating sort index' phase, this lock seems to affect the >> whole >> server, all databases... does anyone know what may be causing this? >> Thanks in advance >> -- >> David Scott &g

Locking database when 'creating sort index'

When we run a large query other queries start to back up when the large one gets to the 'creating sort index' phase, this lock seems to affect the whole server, all databases... does anyone know what may be causing this? Thanks in advance -- David Scott

Re: SELECT locking tables.... in other databases

t; 0 is invalid since already the value that you verify is > between unix_timestamp('2008-11-26') and unix_timestamp('2008-11-26') > > > gSL.starttime > unix_timestamp('2008-11-26') > AND gSL.startTime > 0 AND gSL.endTime > 0 > AND gSL.sta

Re: SELECT locking tables.... in other databases

serted 17853779, updated 10095603, deleted 18, read 948444635 13.99 inserts/s, 65.93 updates/s, 0.00 deletes/s, 98.90 reads/s END OF INNODB MONITOR OUTPUT ======== ' I hope that helps-- Dave 2008/11/27 Ananda Kumar <[EMAIL PROTECTED]> >

SELECT locking tables.... in other databases

Hi list.We have 2 tables, both have a few inserts, many updates and the occasional select. When running a select joining the 2 tables (which can take upto 20 seconds to complete, they are large tables) all updates are blocked and the maxconnections is quickly reached. We tried copying the data to

Re: A use for REGEXP, I think.

On 10/12/2007, Rob Wultsch <[EMAIL PROTECTED]> wrote: > > On Dec 9, 2007 9:17 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > > > > On Dec 9, 2007 10:53 AM, David Scott <[EMAIL PROTECTED]> > wrote: > > > I have a field in a DB that contains something like

A use for REGEXP, I think.

oint me in the right direction? -- Thanks David Scott

Translation of sql into mysql

right syntax to use near 'from extract a inner join CreditCodes b on a.ConsumerNO = b.Cons Can anyone translate it into correct mysql syntax for me? Thanks David Scott _____ David Scott Department of Statistics, Tam

Add column from another table

CallNumber which I want to add to the phone call table. I have looked at documentation and in the book I have available without success. Can anyone suggest appropriate syntax for this? David Scot _ David Scott Department of

Obtaining the first or second instance of an event

particular month. I am quite inexperienced with MySQL and SQL in general and would appreciate any help which you can offer. Thanks David Scott _ David Scott Department of Statistics, Tamaki Campus The University

Data types and reading in data

the appropriate location in the documentation. David Scott _________ David Scott Department of Statistics, Tamaki Campus The University of Auckland, PB 92019 Auckland 1142,NEW ZEALAND Phone: +64 9 373

Re: Auto Generation Of Passwords

think this will work, have not tried it: char(int) returns a character rand() returns a random number between 0 and 1 (with loads of decimal places) round(int) rounds a number to a whole number. so a random password generator could be SELECT char(round(rand()*100), round(rand()*100), round(rand()

Re: can you help me optimizing this query?

What about having a column for each genre, so tracks would look like: id, title, artist, gItalian, gInternational, g80, g70 the genres are of type "int" so 1 for yes 0 for no. then just do SELECT * FROM tracks WHERE g80 = 1 AND gItalian = 1 Not the most dynamic of solutions, but as your genre l

Re: Server Startup

I'm assuming your a first time user of mySQL, so I'm going to give you the basics, if I have miss read your post and all of the following you have done I apologise: There is no icon... So you have already installed mySQL? You need to install it as a service, follow this guide: http://www.kitebird

Fw: Slow user authentication cross server...

is period. Any help appreciated. -- Dave - Original Message - From: "David Scott" <[EMAIL PROTECTED]> To: "MYSQL list" <[EMAIL PROTECTED]> Sent: Wednesday, April 14, 2004 12:13 PM Subject: Slow user authentication cross server... Hi peeps, The setup I have

Slow user authentication cross server...

command: Sleep Time: 5 Info: [NULL] I even created the user "masterServer" and set its host to the IP of that machine but no joy. My question is, how do I reduce this user authentication time when connecting from a remote server? Driving me nuts -- David Scott

JOINING...

Hiya peeps. I have a table which looks something like this: TABLE1 id, something, page1, page2, page3 1, "wibble", 1, 3, 5 TABLE2 id, name 1, "hello" 2, "world" 3, "why can't" 4, "i get" 5, "this to work" I want to SELECT everything from TABLE1 replacing the numbers in page1, 2, 3 with the words

Fw: Reversing the group...

Putting it simply, I want the last record from the group, not the default first. Cheers -- Dave - Original Message - From: "David Scott" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 08, 2004 11:52 PM Subject: Reversing the group... OK, here is a

Reversing the group...

OK, here is a problem that has been bugging me for some time. If I have a table like this, showing 3 visitors to a website and the pages they view idvisitorIDpageID 113 214 312 423 524

INSERT returning ID

Hi list peeps In many of my projects I have the need to insert a new record into a table and then later on in the script update this record, Right now I am doing this by doing the insert, then immediately doing a Select to return the latest id (unique id) which I store later for my update.

Re: SUM() the results of a COUNT()

That is SPOT on, takes 2seconds to process but thats still better than 5 :) -- Dave - Original Message - From: "Michael Stassen" <[EMAIL PROTECTED]> To: "David Scott" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, February 20, 2004 5:30

SUM() the results of a COUNT()

Hiya peeps... If i have a table like this: +++ | id | uid| +++ | 1 | 26 | | 2 | 26 | | 3 | 267| | 4 | 267| | 5 | 269| | 6 | 269| | 7 | 271| | 8 | 271| | 9 | 271| | 10 | 424| +++ I could do this to get the cou

Re: File Permission

Thank you Gerald. That was the problem. I thought I read that FILE permission could not be set to a specific table so I was using somedatabase.*. David Scott On Monday, August 4, 2003, at 11:42 AM, gerald_clark wrote: Since you don't show your grant statement, it is difficult

File Permission

Greetings all I am not able to GRANT file permission to users. All permissions end up being issued with FILE being left out. What could I be missing? I running 3.23.53 on Mac OS 10.2. Thank you. - David Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com