On 8/23/06, Gregor Reich <[EMAIL PROTECTED]> wrote:
Hi all
Is there a possibility to have some tables write-protected while others
in the same db are not (and yet the write-protected ones are updatable
through the replication mechanism, ie. there are tables on a slave
server). I guess that both,
On 8/17/06, Chris <[EMAIL PROTECTED]> wrote:
> Unfortunately didn't that help, it leads to:
> ++-+---+---+---
>
> | id | select_type | table | type | possible_keys
> | key | key_len | ref | rows| Extra
>
On 8/17/06, Chris <[EMAIL PROTECTED]> wrote:
Jon Molin wrote:
> Hi list
>
> I have 5 tables:
>
> words (word_id int auto_increment, word varbinary(40)) (has ~3.5M
> rows) with the keys:
> PRIMARY KEY (`word_id`),UNIQUE KEY `word_ind` (`word`)
>
> phrases (phr
Hi list
I have 5 tables:
words (word_id int auto_increment, word varbinary(40)) (has ~3.5M
rows) with the keys:
PRIMARY KEY (`word_id`),UNIQUE KEY `word_ind` (`word`)
phrases (phrase_id int auto_increment, phrase varbinary(100)) (has
~11M rows) with the keys:
PRIMARY KEY (`phrase_id`),UNIQUE
On 7/25/06, Chris White <[EMAIL PROTECTED]> wrote:
On Tuesday 25 July 2006 02:10 am, Jon wrote:
> CREATE PROCEDURE sp_test1 (IN some_limit int)
> select * from some_table limit some_limit;
>
> and
> CREATE PROCEDURE sp_test2 (IN some_table table)
> select * from some_table;
Well, first off wi
