WHERE (NOT) EXISTS problem

anything at all. MySQL ignores the SELECT list in such a subquery, so it makes no difference." Thanks in advance Michael -- Michael Fischer Happiness is a config option. [EMAIL PROTECTED]Recompile and be happy. -- MySQL Genera

Re: BINARY(N) as primary key?

On Wed, Nov 08, Jon Frisby wrote: > On Nov 7, 2006, at 6:47 PM, Michael Fischer wrote: > > > > > Any thoughts on using BINARY(N) or CHAR(N) as a primary key? > > > > Performance issues? In mysql, in general? > > > > Yes, in the context of the applic

SUBSTR(...) on BINARY column?

and RIGHT() might be my friends? I haven't been able to set up sufficient experiments yet. Can anyone confirm, or make further suggestions? Michael -- Michael Fischer Happiness is a config option. [EMAIL PROTECTED]Recompile and be happy. --

Slightly bizzare query strategy

ontain the expected value. Playing games with subqueries has been equally unsuccessful. Thanks in advance. Michael -- Michael Fischer Happiness is a config option. [EMAIL PROTECTED]Recompile and be happy. -- MySQL General Mailing List For list arc

BINARY(N) as primary key?

Any thoughts on using BINARY(N) or CHAR(N) as a primary key? Performance issues? In mysql, in general? Yes, in the context of the application, there is a very good reason for doing this, and not using an auto increment integer. Michael -- Michael Fischer Happiness is

Re: Unable to designate host

e mysql won't recognize them until a > restart. Bingo! Thank you. Michael Fischer -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Unable to designate host

' command is what I want for the value of the host columns in the mysql db? If so, what might I have done wrong? Suggestions? TIA. Michael Fischer -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.

Archive?

Hello, is there a browseable archive for this list? I would as soon look it over, if it exists, before posting what may be an FAQ. TIA Michael Fischer -- [EMAIL PROTECTED] - Before posting, please check: http