StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16451263
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-05-08T22:26:11.353
FavoriteCount
0
LastActivityDate
2013-05-08T22:46:41.103
LastEditDate
2013-05-08T22:46:41.103
LastEditorUserId
1410836
OwnerUserId
1410836
ParentId
16450931
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
sub_id is listed as a primary key From the <a href="http://dev.mysql.com/doc/refman/5.7/en/create-table.html" rel="nofollow">MySQL docs</a> (5.7, but other versions say the same thing): <blockquote> A PRIMARY KEY is a unique index where all key columns must be defined as NOT NULL. If they are not explicitly declared as NOT NULL, MySQL declares them so implicitly (and silently). </blockquote> As to the discussion about the Non-null columns having a Default of <code>NULL</code>... The <code>NULL</code> value in the <code>Default</code> column means that there is no default, not that the default is <code>NULL</code>. Fiddle: <a href="http://sqlfiddle.com/#!2/c718d/1" rel="nofollow">http://sqlfiddle.com/#!2/c718d/1</a> If I create a simple table like so: <pre><code>CREATE TABLE name_num( Number INT PRIMARY KEY, Name TEXT NOT NULL ); </code></pre> And then do <code>desc name_num</code>, I get: <pre><code>| FIELD | TYPE | NULL | KEY | DEFAULT | EXTRA | --------------------------------------------------- | Number | int(11) | NO | PRI | (null) | | | Name | text | NO | | (null) | | </code></pre> Again, from the <a href="http://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html" rel="nofollow">MySQL docs</a>: <blockquote> If the column cannot take NULL as the value, MySQL defines the column with no explicit DEFAULT clause. Exception: If the column is defined as part of a PRIMARY KEY but not explicitly as NOT NULL, MySQL creates it as a NOT NULL column (because PRIMARY KEY columns must be NOT NULL), but also assigns it a DEFAULT clause using the implicit default value. To prevent this, include an explicit NOT NULL in the definition of any PRIMARY KEY column. </blockquote>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POALTER TABLE not letting me set NULL or default value?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USMichaelJCox
UserOwnerUserId
1. USMichaelJCox
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
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
CommentsPostId
1. CO`form_id` is a nullable column and it's part of the primary key though...
 singulars
 PostPostId
 PO
 UserUserId
 USAbe Miessler
2. COform_id is not nullable (Null NO) but it has a default of NULL.
 singulars
 PostPostId
 PO
 UserUserId
 USMichaelJCox

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.