fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
Well, it's still limited to 65k.
-
Or use SHOW CREATE TABLE.
-
Echo the actual queries, not your code.
-
The query determine what "matches" -- with your LEFT JOINs and such -- and you choose with matching table rows get deleted.
-
The refman is your friend.
-
Using php to create and setup mysql database, tables, foreign keys, etc..
fenway replied to wrstrong's topic in MySQL Help
mysql_num_rows($result, $connection) Should only take one parameter... according to the refman. -
No idea... but that's a PHP DB class issue, not a mysql problem.
-
I don't understand the question.
-
[SOLVED] INSERT into table every ID from another table?
fenway replied to josborne's topic in MySQL Help
You're not closing your column list with a parent. -
Well, I don't see any reference to month/year in your join condition.
-
Just suggesting that BETWEEN is a simpler operator to use.
-
The error was simply the fact that the outer table alias isn't visible to the subqueries.
-
With DATE_FORMAT().
-
"Topic solved" button right above the quick reply area.
-
Well, the query looks like it should be OK.... have you checked the output values of created and pasttime?
-
That's *precisely* what enum does. But aschk is correct -- ENUM is usually a futile shortcut for non-system fields.
-
Then please post your solution for everyone's benefit.
-
Leave your WHERE clause as-is, and add an expression to your column list -- like CURDATE() BETWEEN start AND end
-
Like with yet another JOIN?
-
What does "slip out" mean?
-
You can try using multi-valued INSERT statements... but yes, php has a max execution time.
-
Use table aliases and prefixes.
-
Both PHP and MySQL offer md5 functions.
-
You could use IF() to check for the Y condition in the order by clause.
-
Huh? You're only getting back one field.