Hello,
I am running into a problem with MySQL. I just can't figure it out and I
have spent several days scouring the Internet for ideas. I have a query that
joins 3 tables and I just cannot stop it from using filesort.
The three tables are "prop_data2", "prop_data_int", and "prop_data_string".
Sam, I am constantly coding with PHP and MySQL. As far as:
>Would you agree that sorting small row sets on the client with say PHP
>is more efficient than asking a busy MySQL server with many clients to
>o ORDER BY so that FILESORT or TEMPORARY can be avoided ?
I have learned to let MySQL do any
I am having a problem determining the best SQL DB schema to use. I have a
table
which stores attributes on homes, attributes such as "square footage",
"price", or "includes pool". Now the problem I am having is how to store the
actual value of the attributes. An attribute like "square footage" or
Hello,
I am trying to understand a fundamental concept here. Lets say we have two
tables:
CREATE TABLE codewords (id INT UNSIGNED not null AUTO_INCREMENT, word
VARCHAR (60) not null , fkey_humanword INT UNSIGNED not null , PRIMARY KEY
(id), INDEX (id), UNIQUE (id))
CREATE TABLE humanword (id IN
The easiest way is simply to copy the files. Go to the directory that mysql
was installed to. There should be a subdirectory called data. Under that
should be a subdirectory named after your database. You can simply copy that
entire subdirectory to a mysql server and the database will be copied ov
