Dennis Williamson

less info
stack exchange network profile network profile
113 reputation
6
bio website blog.denniswilliamson.us
location United States
age
visits member for 1 year, 4 months
seen 3 hours ago
stats profile views 4

     I am the first user
   to earn at least 10,000
  reputation points each

       

          on all three of
        Stack Overflow,
       Server Fault and
           Super User.

     I am also the first user to
surpass 20,000 points on each
         of the three sites.

Are you a Stackathlete?

Check the standings on

Profile: I'm a Unix/Linux sysadmin


15 Actions

suggestions reviews revisions comments badges posts accepts all
2d
 awarded  Popular Question
Mar
1
 awarded  Popular Question
Apr
18
 accepted “on duplicate key update” all the non-key fields mentioned in the insert
Apr
18
 comment “on duplicate key update” all the non-key fields mentioned in the insert
It's definitely no less verbose. However, it benefits from being much more maintainable since the literals only have to be specified once each. +1 and accepted.
Apr
18
 comment How can I select the latest record having one state where no later records exist with any other state?
I had to use @ts = MAX(`timestamp`) AS ts and AND tt.`timestamp` > @ts in order to avoid an error message "ERROR 1247 (42S22): Reference 'ts' not supported (reference to group function)". I'm still getting some false returns where later non-down records exist. Do you have any suggestions for diagnosing this? So far I've tried splitting the queries and the subquery compared to a literal (from MAX(`timestamp`) substituted for ts returns a record which should cause the HAVING NOT EXISTS to fail but doesn't.
Apr
15
 revised How can I select the latest record having one state where no later records exist with any other state?
additional information
Apr
15
 revised How can I select the latest record having one state where no later records exist with any other state?
additional information
Apr
15
 awarded  Editor
Apr
15
 revised How can I select the latest record having one state where no later records exist with any other state?
correct a typo
Apr
15
 asked How can I select the latest record having one state where no later records exist with any other state?
Jan
11
 awarded  Supporter
Jan
11
 awarded  Scholar
Jan
11
 comment “on duplicate key update” all the non-key fields mentioned in the insert
Option 1 had no effect. Option 2 (my original version) works, but is unpleasantly verbose. Thanks for your assistance.
Jan
7
 awarded  Student
Jan
7
 asked “on duplicate key update” all the non-key fields mentioned in the insert