Re: Efficiently modeling sets and subsets in lattice-like structure

2007-05-30 Thread mizioumt
Hi Kelly, I'm pretty sure there's no universal efficient solution to this problem, this must be the well known answer you are looking for. The pure mathematics of 'very hard' could be very hard to express, though. So before you choose a solution you need to find out more about the actual grap

Re: spool data/log into a file.

2007-04-26 Thread mizioumt
most likely you just need to redirect STDERR to tee as well so it's not a mysql problem: mysql -u -p -f << eof 2>&1 | tee ttt.txt ... assuming it's Bourne or ksh, don't remember what's csh for 2>&1 Regards, Michael -Original Message- From: [EMAIL PROTECTED] To: mysql@lists.mysql.com S

Re: Safe DB Distribution

2007-01-30 Thread mizioumt
I think in the software world pretty much anything can be done, not 100% to the specs but using the 'for all practical purposes' criteria. it's a matter of the cost but the PHP + mysql combination certainly can't protect the datamodel because most of it can be hacked from the data files themselves

Re: Safe DB Distribution

2007-01-30 Thread mizioumt
> You will not be able to search on encrypted fields. Right. There are ways around it but obviously all sorts of subtle application work will go with the data, depending on what exactly is that you are trying to protect. Overall my opinion is that if you distribute it in a country where softwa

Re: Safe DB Distribution

2007-01-30 Thread mizioumt
Something like distributing files with encrypted data in most columns can be done, with the encryption key being a combination of some hardware-related stuff such as MAC address that the user will provide to you, and the key you generate and provide to the user. Of course it creates a problem when

Re: General MySQL Question: Ed Reed (CA, United States of America) Medium

2007-01-30 Thread mizioumt
Hi Ed, the subject line of your message indicates you live in California in which case Santa Clara won't add much to the experience, but most other people could enjoy visiting California a lot especially if they don't mind dedicating entire day driving to Sierra Nevada. One off the beaten path

Re: [OT} How to pronounce GIF

2007-01-19 Thread mizioumt
Hi, gif will inevitably gravitate towards jif for the same reason SQL is sequel and lib, as in /usr/lib, is often 'libe'. The reasons are described in the Appendix to Orwell's 1984 which is dedicated to newspeak, look for 'duckspeak' in particular, and the consideration of 'Minitruethful' vs 'M

Re: mysql on a NAS

2006-11-28 Thread mizioumt
Hi, OCFS is a cluster filesystem so running two mysqld over the same OCFS directory is exactly the same as running two mysqlds over the same directory in a local filesystem on the same machine which is strictly prohibited. If you decide to consider mysql clustering over ocfs please keep in mi

Re: finding NULL records

2006-11-17 Thread mizioumt
Thanks, I just couldn't remember English for 'ternary'. Remembering the and/or tables for the logic became trivial when I replaced 'NULL' for 'UNKNOWN' but 'UNKNOWN' doesn't exist as an SQL keyword. I suspect the founding fathers chose NULL over words like UNKNOWN to try avoid philosophical debate

Re: finding NULL records

2006-11-17 Thread mizioumt
Well, I'm not sure about the exact definition of 'all'. NULL OR TRUE /* result is TRUE, example (NULL = NULL) OR (1 = 1) */ and so on. Didn't try to execute the actual SQL with such a close, though. Thanks, Michael -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]

Re: finding NULL records

2006-11-15 Thread mizioumt
trying to revive an old thread for fun... I inherited a system in which the code was writing the string "NULL" into a CHAR field. This is what happens when one of the most innovative concepts of SQL gets overlooked or understressed which it seems to be in most modern SQL books. The thing i

Re: Group By question

2006-08-31 Thread mizioumt
select * from t where emailaddress in (select emailaddress from t group by emailaddress having count(*) > 1) order by emailaddress; Thanks, Michael -Original Message- From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wed, 30 Aug 2006 5:17 PM Subject: Group By question I have a tab

Re: mysqlmanager logging?

2006-05-05 Thread mizioumt
Hi, you sort of suggest to look further beyond file permission problems but if I may: > drwx--x--x 2 mysql mysql 1752 2006-05-01 09:33 mysql doesn't look quite right, lack of read permissions to group/other. Thanks, Michael Izioumtchenko -Original Message- From: sheeri kritzer <[EM