WHERE (NOT) EXISTS problem

2007-01-31 Thread Michael Fischer
. Thanks in advance Michael -- Michael Fischer Happiness is a config option. [EMAIL PROTECTED]Recompile and be happy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: BINARY(N) as primary key?

2006-11-08 Thread Michael Fischer
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 application, there is a very good reason for doing

BINARY(N) as primary key?

2006-11-07 Thread Michael Fischer
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

Slightly bizzare query strategy

2006-11-07 Thread Michael Fischer
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 archives: http://lists.mysql.com/mysql

SUBSTR(...) on BINARY column?

2006-11-07 Thread Michael Fischer
() 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. -- MySQL General

Re: Unable to designate host

2001-02-18 Thread Michael Fischer
Thank you. Michael Fischer -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

Archive?

2001-02-17 Thread Michael Fischer
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

Unable to designate host

2001-02-17 Thread Michael Fischer
he 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.com/manual.php (the manual) ht