fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
PHP Script to Insert CSV into MySQL with first row as field names
fenway replied to hybmg57's topic in MySQL Help
See here. -
See here for starters.
-
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?