fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
Sounds like a JOIN.
-
Sure... SELECT INTO OUTFILE.
-
Nope -- but depending on what you need, you can always store the unix timestamp in microseconds as a BIGINT UNSIGNED.
-
Sorry, I don't follow -- why can't you just update a status field?
-
SQL_CALC_FOUND_ROWS() is much, much slower than COUNT(*) -- don't return the actual result set if all you need in a count.
-
Well, you haven't posted ANY mysql statements.
-
Using Boolean Fulltext Searching with Multiple Keywords
fenway replied to ximenao's topic in MySQL Help
Show the CREATE TABLE output. -
Yes, you should be able to hit 2K with 4 users.
-
Just add some ORs to the where clause -- not that this is particularly efficient.
-
Well, start debugging -- figure out which part isn't working.
-
supplied argument is not a valid MySQL result resource? Help
fenway replied to decneo's topic in MySQL Help
That was the example. -
Sorry, I don't follow.
-
There are many ways to handle this... if it's a limited number, you might just want to CROSS JOIN in multiple times.
-
Check that the recordset is what you expect.
-
That's PHP, not mysql.
-
What makes you that it's not working?
-
That issue has nothing to do with mysql... that's your web server's problem.
-
Oh, it's there... look where mysql was installed.
-
DECIMAL -- try (10,3).
-
Then check the actual value.
-
No, you don't -- don't even try. Trust me.
-
Find which query is causing the problem, and check mysql_error().
-
Trigger - preventing insert of an end date before its begin date
fenway replied to Axeia's topic in MySQL Help
If it's broken, debugging = simplying. This is why no one can solve problems anymore. -
What error message??????
-
Trigger - preventing insert of an end date before its begin date
fenway replied to Axeia's topic in MySQL Help
Simplify your IF -- and check the syntax.