fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
I don't see how either of those requirements necessitates complicating a complex query even further.
-
Correct.
-
Why not the same field as for dlocation?
-
PHP Script to Insert CSV into MySQL with first row as field names
fenway replied to hybmg57's topic in MySQL Help
There's a CSV ENGINE type that makes all of this not an issue. -
As long as you're not searching for a specific part of this string, it doesn't matter how it's stored.
-
That's not really a question.
-
That's a UTF-8 issue -- not a CSV issue.
-
If you break this out into another table, you're just looking at yet another join.
-
That's a PHP issue, now, isn't it?
-
We can't possibly help you if you can't share enough of the informationh.
-
You mean a JOIN?
-
Yes -- you'll have to remove the duplicates first.
-
You can't limit an inner join -- you''ll need to use a derived table for table.
-
Query time taking too long and using too much cpu.. How can I optimise this?
fenway replied to lynxus's topic in MySQL Help
That's all meaningless data -- show us EXPLAIN output. -
As usual, echo the actual sql statement, and the accompanying error.
-
You need a LEFT JOIN.
-
What's the issue now?
-
Sorry, what's the question?
-
Then your logic is backwards -- there's an overlap somewhere.
-
Same here.
-
Echo the actual statements.
-
Use: ORDER BY col_A = 'ddd', RAND()
-
Sorry, why do you want these merged?
-
Why have I had to change this query after upgrading to MySQL5?
fenway replied to MargateSteve's topic in MySQL Help
If you change FROM goals, games to FROM (goals,games) you'll be ok. In general, don't mix comma and JOIN syntax. -
Why the subquery -- just substract.