On Wed, Sep 05, 2001 at 07:59:15AM +0800, Steve Doig wrote:
> Hi Folks,
>
> I'm running a batch command in win2K: cmd> mysql < batch-file > output.txt
> In the batch file, can I specify that values are separated by commas instead
> of tabs?
>
> Cheers,
> Steve
>
not using that syntax but with
On Wed, Sep 05, 2001 at 08:30:53PM +0100, Chris Thorpe wrote:
> Is it possible to modify the following query:
>
> SELECT COUNT(*) AS pass WHERE test=x AND value BETWEEN low AND high;
>
> to also count the total number of records where 'test=x'
> and hence return the percentage pass mark all with
On Tue, Aug 21, 2001 at 04:08:42PM -0400, Sekaran, Chandra wrote:
> Hi We have a licensed MySQL software.
> I have one question. During Database Maintenance, i don't want users to be
> connected with the database.
> I want to start my database in restricted mode, thereby other than DBA, no
> one c
On Mon, Aug 20, 2001 at 02:00:29PM +0200, Kloppenburg Ernst (FV/FLI) * wrote:
> On Mon, Aug 20, 2001 at 06:06:22 -0600, Benjamin David Hildred wrote:
> > On Mon, Aug 20, 2001 at 11:08:47AM +0200, Ernst Kloppenburg wrote:
> > > >Description:
> > > with DECIMAL t
On Mon, Aug 20, 2001 at 11:08:47AM +0200, Ernst Kloppenburg wrote:
> >Description:
> with DECIMAL the number of digits before and after the decimal
> point is fixed. Thus it should be described in the documentation as a
> fixed point number
> >How-To-Repeat:
the manual is correct. the number
On Thu, Aug 16, 2001 at 02:04:25PM +0100, Ken Guest wrote:
>
> hi,
> I'm new to this list, but not so new to using MySQL and have a question
> about locking. (This is my first foray into datalocking with MySQL.)
>
> I'd like to lock a table (a row in that table would be better) for read
> and
On Thu, Aug 16, 2001 at 03:01:20AM -0700, Jose de Leon wrote:
> This is what I did:
>
> load data local infile '/var/lib/mysql/mysql/user.MYD' into table data;
^
>
> At first I did it without the 'local' keyword. But with 'local' keyword it works.
>
When you ad the loc
