StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
9609504
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-03-07T21:40:15.143
FavoriteCount
0
LastActivityDate
2012-03-07T21:53:03.080
LastEditDate
2012-03-07T21:53:03.080
LastEditorUserId
1169578
OwnerUserId
1169578
ParentId
9609347
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
<p>Here is how to implicitly get the last cell. Note that you can reference a particular object in the rows or cells array using the square bracket notation, and that due to arrays indexing starting at 0 you must subtract 1 from the length to use it as a valid last index.</p> <p>This example show cases some of the things you can do:</p> <pre><code><!DOCTYPE html> <html> <head> <title>Table test</title> <script language="javascript" type="text/javascript"> function init() { var table = document.getElementById("table1"); var lastRowIndex = table.rows.length-1; var lastCellIndex = table.rows[lastRowIndex].cells.length-1; alert( table.rows[lastRowIndex].cells[lastCellIndex].innerHTML ); // alerts the cell's containing HTML, or 9 var lastCell = table.rows[lastRowIndex].cells[lastCellIndex]; // contains a reference to the last cell } window.onload = init; </script> </head> <body> <table id="table1"> <tr><td>1</td><td>2</td><td>3</td></tr> <tr><td>4</td><td>5</td><td>6</td></tr> <tr><td>7</td><td>8</td><td>9</td></tr> </table> </body> </html> </code></pre> <p>Suppose you had an arbitrary table with 8 columns and 4 rows as in the following example, and wanted cell in column 5 and row 3 to get that cell you'd want to grab a reference to the table (such as through <code>getElementById</code>) and then select for the right row and column through <code>rows</code> and <code>cells</code> making sure to subtract 1 due to arrays indexing starting at 0. See this example:</p> <pre><code><!DOCTYPE html> <html> <head> <title>Table test</title> <script language="javascript" type="text/javascript"> function init() { var table = document.getElementById("table1"); var column5Row3 = table.rows[2].cells[4]; // contains a reference to the cell that is in the 3rd row, and 5th column alert( column5Row3.innerHTML ); // alerts that cell's innerHTML (or Y) } window.onload = init; </script> </head> <body> <table id="table1"> <tr><td>1</td><td>2</td><td>3</td><td>4</td><td>5</td><td>6</td><td>7</td><td>8</td></tr> <tr><td>2</td><td>x</td><td>x</td><td>x</td><td>x</td><td>x</td><td>x</td><td>x</td></tr> <tr><td>3</td><td>x</td><td>x</td><td>x</td><td>Y</td><td>x</td><td>x</td><td>x</td></tr> <tr><td>4</td><td>x</td><td>x</td><td>x</td><td>x</td><td>x</td><td>x</td><td>x</td></tr> </table> </body> </html> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POGet last row of table attribute
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USuser17753
UserOwnerUserId
1. USuser17753
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. 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.