>select f2 from tt where f1=1 having f2=max(f2);
>Empty set (0.00 sec)
>
The correct way to get the desired results in MySQL is two step:
*SELECT @a:=max(f2) from tt where f1=1;
*SELECT f2 from tt where f1=1 and [EMAIL PROTECTED]
regds,
-Original Message-
From: Bruce Feist [mailto:[EMAIL
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Ben Balbo wrote:
Seems MySQL doesn't much like having nested joins in joins...
Oops! Sorry about that. (Curse me for a MySQL novice! )
However, your principles led me to my result. As the search page will
pass the class ids in anyway, I don't need to read these from the
table. I.E. I pass the
Hu Qinan wrote:
>Dear all,
>
>I intend to write a query to select rows based on the results from another query:
>
>SELECT * FROM tbl1 WHERE coln1 IN (SELECT DISTINCT coln2 FROM tbl2);
>
>But this one does not work in MySQL. Anyone could help me to figure out this problem?
>
>
MySQL doesn't supp
At 21:41 -0600 3/9/03, Charles Lewis wrote:
I was reading somewhere that MySQL 4.1 UPDATE syntax will allow
update to table with values from another table in the following
manner:
update client, zip
set client.st = zip.st, client.city = zip.city
where client.zip = zip.zip;
Is there a creative wa
I was reading somewhere that MySQL 4.1 UPDATE syntax will allow update to
table with values from another table in the following manner:
update client, zip
set client.st = zip.st, client.city = zip.city
where client.zip = zip.zip;
Is there a creative way to do this in 4.0.11?
chas
Hi Bruce,
Thanks for your reply. I just got the time to take a look at it, and
it makes sense. However, for the first test:
SELECT distinct t.name
FROM Teacher t
INNER JOIN (TeacherClass tc2 INNER JOIN Class c2 ON tc2.classid =
c2.id AND c2.name = 'English') ON t.teacherid = tc2.teac
Dear all,
I intend to write a query to select rows based on the results from another query:
SELECT * FROM tbl1 WHERE coln1 IN (SELECT DISTINCT coln2 FROM tbl2);
But this one does not work in MySQL. Anyone could help me to figure out this problem?
Thanks a lot.
Dear all,
Please help !
Thanks a lot !
Kevin
> Kevin Chan Write:
> Sent: Friday, March 07, 2003 12:36 PM
> Dear Smith, Dave, Clark and Victoria:
>
> Thanks for all of your reply as quick !
>
> Because I am a neewbie on MYSQL, would you mind to teach me how to create
a
> user and data directory
>From you're info below, mysql *shouldn't* be turning on the binary log. An
easy way to test is just to run the 'ps' command and see if '--log-bin' is
being added to the command line. If you have a long command line for the
mysql process, you may need to use 'ps awx' or 'ps awwx' -- these work on
L
At 17:21 -0600 3/9/03, cosmicsoft wrote:
But shouldn't it realize that there is a wildcard entry? How could it
deny access then, since it realizes there is a wildcard but doesn't
know the username?
Adam sql
If in fact there is such an entry, yes. But it depends on how your ISP
made the change to %
But shouldn't it realize that there is a wildcard entry? How could it
deny access then, since it realizes there is a wildcard but doesn't
know the username?
Adam sql
On Sunday, March 9, 2003, at 05:15 PM, Paul DuBois wrote:
It *is* consulting the user table. This particular error message
means
At 17:01 -0600 3/9/03, cosmicsoft wrote:
I am trying to access a MySQL database remotely from the mysql
command. I get an error 1130:
ERROR 1130: Host '209-103-193-182.dial-in1.apl.athenet.net' is not
allowed to connect to this MySQL server
I asked the tech support to update the grant tables to
I am trying to access a MySQL database remotely from the mysql command.
I get an error 1130:
ERROR 1130: Host '209-103-193-182.dial-in1.apl.athenet.net' is not
allowed to connect to this MySQL server
I asked the tech support to update the grant tables to change the host
for my user to %, but t
Hi,
On Sun, Mar 09, 2003 at 02:48:31PM -0800, [EMAIL PROTECTED] wrote:
>
> mysql> update user set password=PASSWORD('silksmitha') where
>Host='bajji.myorg.com';
> ...OK...
>
> When I connect to the server from bajji.myorg.com, the call
>
> DriverManager.getConnection(
>"jdb
I am running 3.22.32 server on Sol 2.7. After successfully installing
the server on (server dbserver), I created my database 'foo' and granted
all privileges to '[EMAIL PROTECTED]':
mysql> use mysql;
...
mysql> grant all on *.* to [EMAIL PROTECTED];
...OK...
mysql> update user set password
Can't start ./safte_mysql. Error message:
touch: /usr/local/mysql/var/gemini.err cannot create
chown: /usr/local/mysql/var/gemini.err: No such file or directory
Starting mysqld daemon with databases from /usr/local/mysql/var
./safe_mysqld: /usr/local/mysql/var/gemini.err: cannot create
So I created
Just in case you haven't already received an answer:
mysqldump does what you want.
The documentation is at:
4.8.5 mysqldump, Dumping Table Structure and Data
http://www.mysql.com/doc/en/mysqldump.html
jeff
At 11:31 -0500 3/9/03, Jeff Brewer wrote:
does mysql provide a command to export table str
I download a pre-compiled mysql from sunfreeware.com.
When I run ./safe_mysqld &, I was told the there is not mysql id.
When I run mysql -help. I got the error message: ld.so.1: mysql: fatal:
libncurses.so.5: open failed: No such file or directory
Any advice?
Ed
Philip,
For starters, you are not wasting my time. I know the difficulties, as
it took me a while to get it installed and running.
I would suggest you take a look over your book a little more carefully.
I could be wrong, but it should have mentioned that mysql_install_db is
a shell script for Li
At 23:52 +0800 3/9/03, Hu Qinan wrote:
Dear all,
A table "book" looks like this:
"page" "content"
--
1 abc
1 de
2 fgh
3 ijk
3 lmn
3 opq
...
210 z
I need a query to randomly select 90% of all pages and their
corresponding contents.
I have writte
At 21:06 +1100 3/9/03, Philip McCarthy wrote:
Loren
Firstly thanks heaps for your reply. I will try and be as specific as
possible to not waste your time.
If indeed the connection is defaulting to the user ODBC and it is set in
one of the my.* files, where can I see this? Fix this?
You could try
Hi,
MySQL server is single process, multi-threaded, and creates one thread
per client connection (more details in the manual:
http://www.mysql.com/doc/en/MySQL_threads.html)
What you see happens only if you run a single client at a time.
Is it your case ?
Regards,
Joseph Bueno
Julien Metayer wrote
Hi.
On Sun 2003-03-09 at 11:34:33 -0500, [EMAIL PROTECTED] wrote:
> From what I understand, "transactions" are a kind of protection that
> prevents certain commands from executing if certain other conditions
> haven't been met.
Not completely. They can do much more.
Another way to look at tran
Hi,
I very need sync password for same mysql users with LDAP (or *nix passwd file).
Any idea?
--
Miroslav Ris
System Administrator
iNet System
iNet WebMail System
-
Before posting, please ch
Hi,
> No, not with mine :)
Well , you have the wrong data. Let me post the whole thing to let
people what I'm talking about.
mysql> select * from tt;
+--+--+
| f1 | f2 |
+--+--+
|1 |1 |
|1 |2 |
|2 |3 |
|1 |4 |
+--+-
From what I understand, "transactions" are a kind of protection that
prevents certain commands from executing if certain other conditions
haven't been met. And this is particularly important for ecommerce,
among other things. Do I more or less have that right?
My main question, tho', is: Does t
does mysql provide a command to export table structure and data? i can't
seem to find anything like this in the manual. i'm trying to export tables
and data created on my desktop to my isp...help!
Jeff
-
Before posting, please
Hi everybody
I have a Redhat 8 with mysql 3.23 max (binary). My problem is simple, I have
a bi-xeon processor on the server, and mysql only launches one linux
process. With high charge, the process uses 100% on one processor only
instead of lauching new process on the other processors. I have not
Dear all,
A table "book" looks like this:
"page" "content"
--
1 abc
1 de
2 fgh
3 ijk
3 lmn
3 opq
...
210 z
I need a query to randomly select 90% of all pages and their
corresponding contents.
I have written the following querys. But I have pr
Hi!
On Mar 09, Shawn wrote:
> In http://www.databasejournal.com/features/mysql/ they give an example
> of a BOOLEAN MODE search using "here" which they also pointed out was a
> stop word in regular full text searches.
>
> mysql> SELECT copy, MATCH(copy)
> AGAINST ('+here past' IN BOOLEAN MODE)
In http://www.databasejournal.com/features/mysql/ they give an example
of a BOOLEAN MODE search using "here" which they also pointed out was a
stop word in regular full text searches.
mysql> SELECT copy, MATCH(copy)
AGAINST ('+here past' IN BOOLEAN MODE)
AS m FROM fulltext_sample WHERE MATCH(cop
hello, mysql.
i have installed mysql-server 3.23.55 from ports under FreeBSD 4.7-STABLE.
databases place is /var/db/mysql. and in this dir creates binary log of updated
databases in /var/db/mysql/bingo-bin.001, 002, etc. i do not turn on this in
configs and startup files, but it don't care appear
Hi!
I've been using mysql embedded server in my online game
project. The game server receive client requests,
and create a new thread for every request.
I made some tests with a single thread,
and found some strange things.
The following code works under Windows XP, but doesn't
work under Debian
Hi!
On Mar 08, Gabriel TATARANU wrote:
> >
> > Then, when you use group functions without explicit GROUP BY it's the
> > same as GROUP BY const - that is, group functions are applied to the
> > whole table (or, rather, sub-table after the WHERE).
>
> Ok, so we're deducting here that WHERE
Loren
Firstly thanks heaps for your reply. I will try and be as specific as
possible to not waste your time.
If indeed the connection is defaulting to the user ODBC and it is set in
one of the my.* files, where can I see this? Fix this?
I should go back a bit and mention that as I was working t
Dear Sir,
Do you have a version of mysql that supports
transaction, with auto-commit (rollback and commit)
feature?
>From your manuals, it appears that there is a BDB
version. How/Where can I access it?
Thanks.
Lim Kian Kok.
Singapore.
__
Do You Y
First, for some reason the connection attempt is defaulting to the user
ODBC (probably set in one of the my.* files). If this user does not
exist in the database, it will naturally fail.
Second, concerning the root user, there are actually 2 root user entries
that need the password changed or one
38 matches
Mail list logo
