Ok I tried the following
SELECT dealer_id, auto_id, bid_amount FROM bids WHERE bid_amount=(SELECT
MAX(bid_amount) FROM bids WHERE auto_dealer_id='3');
which gives
+---+-++
| dealer_id | auto_id | bid_amount |
+---+-++
| 3 | 12 |
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
is there, performance wise, any difference whether I create one index
for multiple fields or each field with its own index? I'm running 4.0.16.
thx,
- - Markus
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.1 (MingW32)
Comment: Using GnuPG
No errrs on the error log.. This is very weird...
|-Original Message-
|From: ? ??? [mailto:[EMAIL PROTECTED]
|Sent: Wednesday, March 15, 2006 6:12 AM
|To: Anton Krall; mysql@lists.mysql.com
|Subject: Re: mysql.sock gone
|
|Look at mysql's error log
Hi, Mark!
Of course, it depends on queries you are running.
I beleive you can find all anwers here:
http://dev.mysql.com/doc/refman/5.0/en/indexes.html
http://dev.mysql.com/doc/refman/5.0/en/multiple-column-indexes.html
http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
Markus Fischer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
thanks, somehow I wasn't able to find those pages.
Basically, this means if I've a table like this
id1
id2
id3
id4
id5
and I've two different select statements:
select * from ... where id1 = .. and id2 = ..
and the other being
select * from
Hi!
Server system SBS (Novell Small Business suite) 6.5 sp 1 with MySQL
ver. 4.0.15a, PHP 4.2.3, all of them on same machine.
After restart server command the MySQL server is loading and
unloading immediately.
The error file : MYSQL:/data/WEB.err contain the following
text:
Hi,
is it possible to get information about tables by doing queries on some system
tables? I am using mysql version 4.1.11 on debian sarge.
In my case I need to know which columns (names and types) a table has, and how
the primary key is defined.
How can I get this information out of mysql by
Hello Yves,
is it possible to get information about tables by doing queries on some
system
tables? I am using mysql version 4.1.11 on debian sarge.
In my case I need to know which columns (names and types) a table has, and
how
the primary key is defined.
How can I get this information out
On Friday 17 March 2006 15:52, Martijn Tonies wrote:
Hello Yves,
Hello Martijn,
is it possible to get information about tables by doing queries on some
system
tables? I am using mysql version 4.1.11 on debian sarge.
In my case I need to know which columns (names and types) a table
If you upgrade to mysql 5.0.x there are also the
The INFORMATION_SCHEMA tables that return meta information
about tables.
AFAIK they may not be available in pre 5.0 versions.
Keith
In theory, theory and practice are the same;
in practice they are not.
To unsubscribe from this list, please see
Try DESC table_name.
Yves Glodt пишет:
On Friday 17 March 2006 15:52, Martijn Tonies wrote:
Hello Yves,
Hello Martijn,
is it possible to get information about tables by doing queries on some
system
tables? I am using mysql version 4.1.11 on debian sarge.
In my case I need to know which
Hello Yves,
is it possible to get information about tables by doing queries on
some
system
tables? I am using mysql version 4.1.11 on debian sarge.
In my case I need to know which columns (names and types) a table has,
and
how
the primary key is defined.
How
What you are looking for is the INFORMATION_SCHEMA views, but they are not
available before 5.0. Until then you have to parse the show create table
or DESCRIBE tablename may be easier to parse
mysql describe organizations;
On Friday 17 March 2006 16:50, Martijn Tonies wrote:
Hello Yves,
snip
As I said -- take a look at the SHOW commands in the documentation :-)
show columns from TABLE seems to be what I need, thanks to you and the other
posters, have a nice weekend! (and sorry for the noise)
best regards,
Gregory Machin wrote:
Ok I tried the following
SELECT dealer_id, auto_id, bid_amount FROM bids WHERE bid_amount=(SELECT
MAX(bid_amount) FROM bids WHERE auto_dealer_id='3');
which gives
+---+-++
| dealer_id | auto_id | bid_amount |
+---+-++
All,
Is there a recommended GUI that will administer multiple MySQL 4.x
databases. I need the ability to monitor connections, health, users, etc.
and notify me when there is a problem with an instance.
Regards,
Alan L. Fisher
GPI
--
MySQL General Mailing List
For list archives:
On 3/17/06, Alan Fisher [EMAIL PROTECTED] wrote:
All,
Is there a recommended GUI that will administer multiple MySQL 4.x
databases. I need the ability to monitor connections, health, users, etc.
and notify me when there is a problem with an instance.
Regards,
Alan L. Fisher
GPI
--
I am having a problem where I cannot seem to increase the max_join_size
of 4.1.18 above a hard limit that is way too low for my use. Has anyone
run into this and know of a solution that does not involve upgrading to
5.x.x? (That is presently not an option for another month or so.) I also
want
I'm still having a problem starting MySQL.
I get the following message:
Unable to initialise database connection: Can't connect to local MySQL server
through socket '/var/run/mysqld/mysqld.sock'
I've check the /etc/mysql/my.cnf and the sock file is supposed to load in
'/var/run/mysqld.
Thanks
Jon Miller wrote:
I'm still having a problem starting MySQL.
I get the following message:
Unable to initialise database connection: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
I've check the /etc/mysql/my.cnf and the sock file is supposed to load in
http://nagios.org
We use that to monitor dozens of servers, over 1000 individual items
(disk space, web server up/down, etc). We also do some heavy monitoring
of oracle databases and some moderate mysql monitoring. It can be
easily adapted to do what you want. And it's free!
Dan.
I'm moving a database to a new server. I'm using MySQL v5.0.16
on 'Windows. I used the MySQL Administrator to backup on the old
system and restore on the new one. Everything is fine _except_ on the
new server, some queries take 2-3 minutes with MySQL using 100% of the
CPU. I've dropped
I'm trying to restore a database from a dump as part of my
make-sure-this-will-restore-just-in-case process and I get the
following error...
ERROR at line 1189: Unknown command '\''.
The only thing I've been able to find is this bug report...
http://bugs.mysql.com/bug.php?id=9756
...which
Have you tried Repair table or if InnoDB
ALTER TABLE ENGINE=InnoDB;
Sometimes I've noticed after a restore or after adding lots of rows
performance is slow. REPAIR or the ALTER TABLE fixes it.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, March 17,
Have you tried Repair table or if InnoDB
ALTER TABLE ENGINE=InnoDB;
Sometimes I've noticed after a restore or after adding lots of rows
performance is slow. REPAIR or the ALTER TABLE fixes it.
I'll try that. Thanks.
What's curious is that I've got one backup I can restore and have fine
[EMAIL PROTECTED] wrote:
I'm moving a database to a new server. I'm using MySQL v5.0.16
on 'Windows. I used the MySQL Administrator to backup on the old
system and restore on the new one. Everything is fine _except_ on the
new server, some queries take 2-3 minutes with MySQL using 100% of
Hi,
I could write a quick script to fix the following, but just out of
curiosity, if there's a quicker way to do it from the mysql command line,
that'd be cool to know.
I've got a few thousand rows of data that have URI escaped characters in them,
and I've fixed the code that was doing it, but
Hi guys,
I am kinda new to mysql and on my endeavour to build a backend for a
site i am building, i need to fetch data from a couple of tables, but
dont know how to do it with a single select.
Heres the problem:
first table (products):
id
id_type
David,
- Original Message -
From: David Felio [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 16, 2006 11:31 PM
Subject: Errors 1005 and 1025 - but not foreign keys
I got an error 1025 trying to rename an InnoDB table. When I go to
look in the database
29 matches
Mail list logo