Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You should be much more hesitant to use the datetime as a primary key anyway because of the wild and wooly world of timezones, leapseconds, and lots of other things that will surprise you. There is absolutely no guarantee that <code>a1 = datetime('now')</code> is always less than or equal to the next invocation of <code>a2 = datetime('now')</code></p> <p>Read this article, about 1/3 the way down he starts talking about dates, times, and timezones. This should convince you that you should not be trying to do what you are asking for in this question:</p> <p><a href="https://msmvps.com/blogs/jon_skeet/archive/2009/11/02/omg-ponies-aka-humanity-epic-fail.aspx" rel="nofollow">https://msmvps.com/blogs/jon_skeet/archive/2009/11/02/omg-ponies-aka-humanity-epic-fail.aspx</a></p> <p>If I wanted a quick and dirty hack work around, I would put the insert into a while loop and catch the error when the insert failed, and then try again 1 millisecond later. This is bad, and is like leaving a huge mess in the bedroom, but sometimes it is necessary because redesigning the table to have a sensible primary key would take too long.</p> <p>However, if you do this, be prepared for the code to be sitting in that while loop, trying and waiting patiently for tens of milliseconds, and when it finally does find an open slot, it doesn't do what you expect because it appears BEFORE another entry that occurred in the future (which was actually in the past). Thinking about that makes my head hurt. </p>
    singulars
    1. This table or related slice is empty.
    1. POTime as key into SQL causes error
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USEric Leschinski
    1. USEric Leschinski
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1 "huge mess..."
      singulars
      1. PO
      1. USpodiluska
    2. COThanks, also very good article!
      singulars
      1. PO
      1. USdac2009
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload