Problems with 4.1.1 on Mac OS X

2004-01-07 Thread Martin Hampl 
Hi,

I just installed version 4.1.1 on Mac OS X.

If I enter 'show tables;' after starting mysqld_safe it just says

ERROR:
No query specified
The same happens if I try 'CREATE DATABASE menagerie;'

Why?

Thanks,
Martin.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Searching on Two Keys with OR?

2003-08-14 Thread Martin Hampl 
I think I have a similar problem... I am thinking abeout switching to a 
different DBMS. Can anyone tell me something about PostgreSQL?

Thanks in advance,
Martin.
Am Donnerstag, 07.08.03, um 03:32 Uhr (Europe/Zurich) schrieb Steven 
Roussey:

ORing on two different fields is what I have been asking about :).
This is not optimized, and I don't think it is set to be optimized 
until
5.1 (as per someone else's comment).

Using a composite index was suggested
This is bad information. It works for AND, not for OR.

You have two workarounds: temp tables and unions.

You can have it use one index, though. And you can give it a hint on
which index it ought to use if you think you know better than the
optimizer.
At any rate, this is one of MySQL's deficiencies that many of us have
worked around for a long time.
--steve-



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]