Hi all.
I had both 3.23 and 4.0 separately listed in my WinXP/Home "Add or Remove
Programs" list. I was able to remove 4.0 but not 3.23. (It says it's
stopping because it can't locate file uninst.isu.)
Also, I still have MYSQL listed in ctl panel / admin tools / services and
don't see how to r
start the server
(as per Paul), or can I do
C:>NET START
- Original Message -
From: "Ed Carp" <[EMAIL PROTECTED]>
To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; "Gerald R. Jensen"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "Paul
ET START mysql
NET STOP mysql
but only when mysqld is installed as a service.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; "Gerald R. Jensen"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTE
ssage -
From: "Gerald R. Jensen" <[EMAIL PROTECTED]>
To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "Paul
DuBois" <[EMAIL PROTECTED]>
Sent: Wednesday, September 11, 2002 7:47 AM
Subject: Re: Default Win install --> mySQL autost
runs
when explicitly invoked?
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 11:59 PM
Subject: Re: Confused, discombobulated, weirded out, upse
>If mysql works fine, then you've already started the server.
Then does a normal Windows installation set it up so the server autostarts
whenever you boot up? I did not manually start the server.
>You have to restart the server before it will notice the [mysqld] option
group change.
After I add
THANKS VERY MUCH! That worked!
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 9:15 PM
Subject: re: Re: LOAD DATA LOCAL INFILE "not allowed this version"?
[.]
Put local-infile=1 in the [mysqld] and [my
Sorry! I made a mistake here. I still have the questions below but my
problem with LOAD DATA is SOLVED! I made an editing mistake when updating
the my.cnf(my.ini) files.
- Original Message -
From: "Uriel Wittenberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent:
I seem to have a version problem. I'm using v. 3.23.51 on a Windows
standalone system -- there is no network here. *ALL I want* is to run MySQL
standalone on this machine. So do I need to "start the server"? MySQL seems
to mostly work fine if I just go and do:
C:\mysql\bin> mysql
without "starti
rom: "Sqlcoders.com Programming Dept" <[EMAIL PROTECTED]>
To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; "Mysql" <[EMAIL PROTECTED]>
Sent: Monday, September 09, 2002 8:31 AM
Subject: RE: LOAD DATA LOCAL INFILE "not allowed this version"?
One can
The command
LOAD DATA LOCAL INFILE "C:\\MO10.txt"
INTO TABLE stud1
fields terminated by "/"
lines terminated by '\r\n';
produces:
ERROR 1148 at line 1: The used command is not allowed with this MySQL vers
Could someone explain why??
I'm running version "MYSQL Ver 11.18 Distrib 3.23.51,
>Well, I actually use copy&paste. ;-)
But I find I can't paste into a mySQL session (in Windows Me). I'm
referring to the DOS window's paste function. Is there another way to
paste from the Windows clipboard into a mySQL session?
---
> > Is there really a SOURCE command?
>
> An explanation why you did not simply try it, would be nice. Maybe
> that would have helped to get an early answer.
>
> > Where is it in the official manual?
>
> This is part of the command line client, the belonging manual section
> is http://www.mysql.co
How do you get output like below without retyping the command ("SELECT
count(*) FROM config a INNER JOIN config b USING (gid) WHERE
a.gid=10856")?
I'm using Windows Me.
The following type of command does not work:
C:\mysql\bin>mysql --tee=\mysqluw\out.txt -T stud < \mysqluw\mysql.txt
-
create temporary table TT
select distinct class1, dt
from scores;
select p.class1, p.dt
from TT p inner join TT q using(class1)
group by p.class1, p.dt;
Remove the "temporary" and it works.
- Original Message -
From: "Benja
I tried:
select ... from T1 a inner join T1 b using(...);
and it doesn't work. I get a message about "Can't reopen table: 'a' ".
Is this not something that belongs in section "1.4.4 Functionality
Missing from MySQL" of the manual?
-
The bitbybit.dk MySQL FAQ says:
How do I use a batch file with MySQL?
>From within the MySQL client (v. 3.23.9 and above):
mysql> SOURCE filename
Is there really a SOURCE command? Where is it in the official manual?
Also, if you have
---
The current Reference Manual does not explain certain types of JOIN.
Specifically:
table_reference [CROSS] JOIN table_reference
is nowhere explained.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Under "Description of MySQL regular expression syntax", the manual says:
This is a simplistic reference that skips the details. To get more exact
information, see Henry Spencer's regex(7) manual page that is included
in the source distribution.
Since the
> section 6.4.1.1:
> ...
> INNER JOIN and , (comma) are semantically equivalent. Both do a
> full join between the tables used. Normally, you specify how
> the tables should be linked in the WHERE condition.
> ...
> Carsten H. Pedersen
??
Since this does not appear in the manual for v. 3.23.42,
The manual's description of Join Syntax lists the various kinds of
syntax but doesn't define some of them, e.g.:
table_reference, table_reference
and
table_reference INNER JOIN table_reference join_condition
I'm guessing these two are equivalent, except that you can't use a
join_condition with
>The FAQ clearly states
There's a FAQ?
I don't see one mentioned at
http://www.mysql.com/documentation/index.html , except for the "dynamic
FAQ". I just tried this dynamic FAQ with Topic "Language Reference",
keyword "join". That produces 0 results.
The welcome message for this list says "
> If you look at the documentation for UPDATE, you'll
> find no mention of multi-table updates, and so they don't
> exist. If you search the docs you'll find that they are to
> be added in 4.1.
> The FAQ clearly states that multi-table updates and deletes
> do not exist at this point in time. And
I am trying to do an UPDATE that is slightly less trivial than
UPDATE persondata SET age=age+1;
What I want is something like
UPDATE persondata SET age = select age from othertable where
persondata.id = othertable.id;
But the manual gives no clue as to whether this is possible. And if
there is
> > > "batch mode" doesn't necessarily mean "raw mode". You want to ask
for
> > > "raw mode", but ask for "batch mode".
> >
> > Luckily this led me to look up the letter "r" in command line
options
> > and I happened to find the "-r" option. Which is exactly what I
need.
>
> Fine.
>
> > My questio
> "batch mode" doesn't necessarily mean "raw mode". You want to ask for
> "raw mode", but ask for "batch mode".
Luckily this led me to look up the letter "r" in command line options
and I happened to find the "-r" option. Which is exactly what I need.
My question was so clear. I have to wonder w
> It may not intuitive at first, but it is really what one
> wants for default. For example, how would you else know, whether
>
> test
> asdf
>
> was originally one row ("test\nasdf") or two rows ("test"+"asdf")?
I would know because I'm the one who thought up and wrote -- for good
reasons -- the
> because a newline will indicate a new record, new lines
> have to be escaped. Else, you couldn't reasonably distinguish what's
> content and what's record seperator.
Thanks for the reply. Seems to me mySQL should give me the \n I'm asking
for rather than assuming that's not what I mean and esca
ally, instead of a newline character. In other
words, it's the output I'd expect from
select "test \\n test";
Originator: Uriel Wittenberg
Organization: Tsinghua U.
MySQL support: none
Severity: non-critical
Priority: medium
Category: mysql
Class: sw-bug
Release: mysql-3.23.42
29 matches
Mail list logo
