Re: The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file!

2005-04-14 Thread Jonathan Wright
7; in order to work. Otherwise set $cfg['PmaAbsoluteUri_DisableWarning'] = TRUE; In order to disable the warnings. -- Jonathan Wright Life has no meaning unless we can enjoy what we've been given -- Running on Gentoo Linux (2.6.10-gentoo-r7-djnauk-b03 i686 AMD Athlon(tm) XP 2100+ GNU

Re: How does a multi-row INSERT work?

2005-03-31 Thread Jonathan Wright
y but according to the manual, a multi-row INSERT is faster. I think you're looking for something like INSERT INTO table [ (x, y, z) ] VALUES (a, b, c), (d, e, f), (h, i, j); -- Jonathan Wright Life has no meaning

Re: Primary Keys, Multiple Index and Searching

2005-02-25 Thread Jonathan Wright
udied), and I'm interested to know how the query is optimized given a multiple column searches and possible multiple indexes. :) -- Jonathan Wright Life has no meaning unless we can enjoy what we've been given -- Running on Gentoo Linux (2.6.10-gentoo-r7-djnauk-b03 i686 AMD At

Primary Keys, Multiple Index and Searching

2005-02-24 Thread Jonathan Wright
es MySQL (currently 4.0.14, although it'll be running on 3.23.53 eventually) allow the searching of multiple indexes, or is it better to specify multiple indexes with similar columns to maximize performance? Thanks, -- jonathan wright // mail at djnauk.co.uk // running on gentoo linux // life has n