Re: feature suggestion - indexes with "where" clause or similar

2002-11-18 Thread Daniel Koch
keys is. The only requirement is that the column be low-cardinality. It basically works like this: true 01101 false 10010 One bitmap is stored for each possible value of the column. In this case the false bitmap shows that the first and fourt

Re: feature suggestion - indexes with "where" clause or similar

2002-11-18 Thread Daniel Koch
ing a BITMAP index, like Oracle. They're perfect for indexing boolean true/false columns or any column that has a small number of possible values. -- Daniel Koch <[EMAIL PROTECTED]> - Before posting, please check

Re: running sql scripts with 'source'

2002-11-05 Thread Daniel Koch
Don Vu wrote: Hi guys, I have a script in my home directory that i want others to be able to run. I 'chmod 777'ed the file and the folder it lives in and people still can't run it when they are at the mysql prompt and type "source /path/to/script/scriptname.sql". I can execute that script, even

Re: HA of MySQL

2002-10-07 Thread Daniel Koch
On Mon, 2002-10-07 at 10:30, Jeremy Tinley wrote: > Howdy, > > There has been some interest lately in HA of MySQL services both in my > company and on the list. A few of us here sat down on Friday (at 5PM no > less) and started hashing out the details of providing such a service. > Following sev

Re: Fw: Complex SQL assistance

2002-07-27 Thread Daniel Koch
On Fri, 2002-07-26 at 05:17, Corey Wallis wrote: > Peoples, > > I'm currently trying to work out if this is possible by SQL. I have the need > to use SQL and only SQL to achieve the following. > > If a record exists and meets a certain criteria (i.e. field X = '1234') then > update the record.

Re: MYSQL 4.0

2002-06-27 Thread Daniel Koch
Arul wrote: >Hi > >Any idea when MySQL 4.0 stable release will be made.. >As of now only Alpha is released.. > >Also any sites which run on 4.0 Alpha > > > 4.0.1 has been very stable for us: [root@db1 root]# mysqladmin version mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i6