fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
TLDR... try again.
-
1205: Lock wait timeout exceeded; try restarting transaction
fenway replied to br0ken's topic in MySQL Help
Lots of things... show innodb status would tell you exactly. -
BIGINT should never be used for anything -- ever.
-
What error? What mysql version?
-
Then post the solution.
-
sql query returning back rows based on the date field
fenway replied to aarbrouk's topic in MySQL Help
Then tell us. -
Are you getting the right results? I only see a single "LIKE".
-
You can use the information_schema tables in mysql 5...
-
That's going to be impossible... why not just JOIN them to have the relationship captured in each row?
-
an ORDER BY clause will make them alphabetical... the layout has nothing to do with mysql.
-
Failed how?
-
Well, you can checksum the tables for starters...
-
You can use FIND_IN_SET() to find the "3"... but I'm not sure what else you mean.
-
Wait.. which statment throws that error?
-
What does "not loading" even mean?
-
FIXED AND SOLVED -- how?
-
Well, what about $query?
-
Drop the parens for the if... otherwise, it references the IF() function.
-
that is latin1...
-
We can't guess your statement or your table structures.
-
Need Help with MySQLDumper - Importing a large DB file
fenway replied to Haplo's topic in MySQL Help
And you've read the sticky in the child board already? -
OMG, seriously?
-
Are these many-to-many relationships? You might actually be "joining" in multiple records.
-
Isn't the second query covered by the first one?
-
Then post the solution, please!!!