fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
I'm sorry, you're storing *what* in the session variable?
-
I'm not sure exactly what you're asking.
-
I can't stand workbench -- they made it very annoying to edit individual rows -- especially those without PKs.
-
Just use underscores, like Perl.
-
Solved how?
-
I wish I had this much free time.
-
Probably because it's an auto-increment value -- but still a bad, bad idea.
-
Yes, but you are supposed to know which one you chose -- i.e. separated by tab, quote spaces, etc.
-
EXPLAIN would have helped a lot here.
-
And OBVIOUSLY you're not sending your passwords across the network so they will end up logs. And OBVIOUSLY you're not storing your passwords in plaintext. And OBVIOUSLY you're using a case-senstive collation.
-
It's troubling that you export your data, but you don't understand how, or why, it works.
-
Well, for starters, there's no way to ensure that each column contains the same type of information. Then there's the issue of unweildly queries, like the one above. And good luck ever re-partitioning.
-
Yeah, agreed -- some of them are huge.
-
ORDER BY RAND() performs very poorly on any reasonable amount of data. Which, IMHO, is fine, because very few real-world problems need totally random (or truly random) anyway.
-
CONVERT_TZ and the current timezone will help.
-
The usual consideration is whether or not you want it to be timezone aware.
-
Yeah -- it's always easiest to get in to the DB first, and then manipulate it. FWIW, there is a CSV engine type.
-
"clickable in SQL" doesn't mean anything. What are you actually trying to do -- and why do you want SQL to do it for you?
-
Trouble Displaying Data From A Mysql Database Into Flash
fenway replied to dinita's topic in MySQL Help
Solved? How? -
You'll need multiple field values for VALUES -- i.e. VALUES (one,two), (three,four).
-
mysql_result() is less than ideal -- better to use a fetch call and get back a hash -- that will also make it clear what's going wrong. Also, you're completely open to SQL injection.
-
Count Number Of Words In Output And Display "..." Link If To Many Words
fenway replied to elite311's topic in MySQL Help
Personally, I've never been a fan of SQL_CALC_FOUND_ROWS; it's so rare that (a) you need an exact count and (B) users need to be able to get to the last page. -
It's important to recognize that checking a column that's been NULL-ed out by a non-matching LEFT JOIN can't ever succeed.
-
Myisam Table: Composite Key As Substitute For Foreign Key?
fenway replied to nodirtyrockstar's topic in MySQL Help
The question is really why you think you need FK constraints. -
Actually, there are many reasons to store serialized data -- but very few beginners have *good* reasons to do so. Short answer: if you're even going to need to query, join on, or change, an individual piece of this 'array', then it should not be an array.