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
PROTECTED]
To: Uriel Wittenberg [EMAIL PROTECTED]; Gerald R. Jensen
[EMAIL PROTECTED]; [EMAIL PROTECTED]; Paul DuBois
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 10:28 PM
Subject: RE: Starting/stopping server on WinXP Home standalone -- what's
appropriate way?
I want
-
From: Paul DuBois [EMAIL PROTECTED]
To: Uriel Wittenberg [EMAIL PROTECTED]; Gerald R. Jensen
[EMAIL PROTECTED]; [EMAIL PROTECTED]; Ed Carp
[EMAIL PROTECTED]
Sent: Wednesday, September 11, 2002 11:04 AM
Subject: Re: Default Win install -- mySQL autostarts when booting?
At 10:43 +0800 9/11/02, Uriel
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 starting
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: Tuesday, September 10, 2002
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 [mysql]
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
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, upset! --Windows
standalone user
Then does a normal
-
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 autostarts when booting?
Which version of WinXP (Pro or Home)?
On WinXP Pro
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, for
[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 disable all LOAD DATA LOCAL commands in the MySQL server by starting
mysqld with --local-infile=0
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: Benjamin Pflugmann [EMAIL PROTECTED]
To: Uriel Wittenberg
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\binmysql --tee=\mysqluw\out.txt -T stud \mysqluw\mysql.txt
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
Well, I actually use copypaste. ;-)
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?
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 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 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 Send
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
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, which
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
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
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 why 3 prior
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 question was so clear. I have to
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 select
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
Exectutable: mysql.exe
Environment: Pentium processor, 64 MB RAM
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
27 matches
Mail list logo
