Binary Log and Load Data Local

le" local or otherwise has HUGE implications when you are looking at a backup strategy. Am I missing some thing here? Are there any work arounds, or should it be said that if you want EXACT replication of data DON'T use "Load data infile"? Thanks Clyde England -

Merge Table weird result - bug?

the merge table I used mysqldump and then cut and paste. This was also the method I used to create table2 from table1, so I am quite sure all the table definitions are the same. Could this be a bug? Am I missing something here? Thanks Clyde England PS I get the feeling it is the index that is

Re: Select * from names where words(name) = 3

near instant on my now aging P500 256mb PC) Thanks again. Clyde England *** REPLY SEPARATOR *** On 8/01/2003 at 11:45 PM Dan Nelson wrote: >In the last episode (Jan 09), Clyde England said: >> I have a database of names and would like to do a selection based on >>

Select * from names where words(name) = 3

Hi All, Not sure how to do this (or even if you can) but thought I would ask anyway. I have a database of names and would like to do a selection based on the number or words in a name eg the name "Peter Smith" has 2 words the name "Peter John Smith" has 3 words the name "Peter John Fred Smith" h