ot;1" AND vDate = "2012-10-11"
Where I've aliased the SUBSTR of the date and then used the alias in the
WHERE clause of the query. I'm getting an error message now, but I'm
almost certain I've used that syntax before. Am I missing something?
--
Mar
engine
from InnoDB to something else so I can optimize the tables on a regular
basis.
Is it worth the effort? Any caveats?
I've never really encountered this situation before and I'm curious to
see what others have to say on it.
Thanks in advance.
--
Mark Haney
Software Dev
-+
2 rows in set (3.62 sec)
This is better than the 20s+ I was getting before, but still not
acceptable for only 2 machines when I'll have 40+ at production time.
All I need is the most recent record for EACH machine ID, THEN to pull
the machine name from the table that has the
g part of the
query makes me stop and rethink the logic behind the query. So thanks
for that. My SQL brain is still fuzzy, and combined with Vicodin, I'm
no House. I can't function 100% on pain meds.
I'll take a look at this, and if I need any help, I'll holler, but t
I need, so I decided, in my vicodin soaked brain (I have a torn
rotator cuff and tendon in my shoulder) that I should hit the list
before I go any farther.
So, what's the best way, or the most common way to deal with this issue.
I'll be happy to clarify anything in here that doesn&
using both and
honestly haven't found any difference. There may be some difference at
really like transaction levels, but my DBs run pretty much the same
compiled with either.
YMMV.
--
Mark Haney
Software Developer/Consultant
AB Emblem
ma...@abemblem.com
Linux marius.homelinux 3.4
I've had a DEVIL of a time with this problem and I'm sure it's something
simple, but I can't find it anywhere in the documentation or online what the
problem is. Let me explain.
I cannot get any WHILE loop to work from either a CLI or a script on MySQL
5.1.41. For example, this is a simple sc
