Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-8"?>
- <posts>
- <row Id="1" PostTypeId="1" CreationDate="2011-01-03T20:46:02.927" Score="180" ViewCount="172059" Body="<p>What are the main differences between InnoDB and MyISAM?</p>
" OwnerUserId="8" LastActivityDate="2017-03-09T13:33:47.627" Title="What are the main differences between InnoDB and MyISAM?" Tags="<mysql><innodb><myisam>" AnswerCount="10" CommentCount="1" FavoriteCount="105" />
- <row Id="2" PostTypeId="1" AcceptedAnswerId="4" CreationDate="2011-01-03T20:46:32.393" Score="63" ViewCount="8595" Body="<p>What version control methodologies help teams of people track database schema changes?</p>
" OwnerUserId="7" LastEditorUserId="97" LastEditDate="2011-01-06T11:25:12.520" LastActivityDate="2017-08-16T09:08:33.070" Title="How can a group track database schema changes?" Tags="<mysql><version-control><schema>" AnswerCount="5" CommentCount="11" FavoriteCount="33" />
- <row Id="3" PostTypeId="1" CreationDate="2011-01-03T20:48:58.913" Score="25" ViewCount="768" Body="<p>I used to label columns in my databases like this:</p>

<pre><code>user_id
user_name
user_password_hash
</code></pre>

<p>To avoid conflicts when joining two tables, but then I learnt some more on how to alias tables, and I stopped doing this. </p>

<p>What is an effective way of labeling columns in a database? Why?</p>
" OwnerUserId="17" LastEditorUserId="97" LastEditDate="2011-01-06T11:30:53.230" LastActivityDate="2013-01-22T19:43:56.357" Title="What is an effective way of labeling columns in a database?" Tags="<database-design><erd>" AnswerCount="10" CommentCount="4" FavoriteCount="11" />
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement