StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8570279
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-12-20T03:00:09.683
FavoriteCount
0
LastActivityDate
2015-08-06T23:40:42.760
LastEditDate
2015-08-06T23:40:42.760
LastEditorUserId
14860
OwnerUserId
14860
ParentId
8570216
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
Let's examine some simple code in a system where integers are four bytes long: <pre><code>int xyzzy[] = {3,1,4,1,5,9,2,6,5,3,5,8,9}; // 13 integers printf ("%d\n"", sizeof(xyzzy)); // 13 * 4 = 52 printf ("%d\n"", sizeof(int)); // 4 printf ("%d\n"", sizeof(xyzzy) / sizeof(int)); // 52 / 4 = 13 </code></pre> As per that final line, that calculation is a way to get the number of items in an array. As an aside, I prefer the construct: <pre><code>sizeof(xyzzy) / sizeof(*xyzzy) </code></pre> since that will continue to work even if I change the type of <code>xyzzy</code> to <code>double</code> for example. It means I only need to change the one line where the variable is declared rather than hunting for all the size calculations as well. In fact I even have a favorite macro for this: <pre><code>#define numof(x) (sizeof(x) / sizeof(*x)) </code></pre> to make my code a little smaller. In terms of what that <code>for</code> loop is doing exactly (and, by the way, it's not technically the second <code>for</code> loop since there's only one, but it is the second loop), it basically iterates through every value of <code>i</code> (staring at 0, the first index) until it reaches either the point beyond the last element or it finds an element with the desired item code. On exit from that loop, <code>i</code> will be set to the number of elements if the item code wasn't found or set to the correct index if it was found, hence the <code>if</code> statement following that <code>for</code> loop.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POunable to understand sizeof
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USpaxdiablo
UserOwnerUserId
1. USpaxdiablo
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POunable to understand sizeof
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

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.