Advertisement
Guest User

Untitled

a guest
Dec 15th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 1.76 KB | None | 0 0
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <posts>
  3.   <row Id="1" PostTypeId="1" CreationDate="2011-01-03T20:46:02.927" Score="180" ViewCount="172059" Body="&lt;p&gt;What are the main differences between InnoDB and MyISAM?&lt;/p&gt;&#xA;" OwnerUserId="8" LastActivityDate="2017-03-09T13:33:47.627" Title="What are the main differences between InnoDB and MyISAM?" Tags="&lt;mysql&gt;&lt;innodb&gt;&lt;myisam&gt;" AnswerCount="10" CommentCount="1" FavoriteCount="105" />
  4.   <row Id="2" PostTypeId="1" AcceptedAnswerId="4" CreationDate="2011-01-03T20:46:32.393" Score="63" ViewCount="8595" Body="&lt;p&gt;What version control methodologies help teams of people track database schema changes?&lt;/p&gt;&#xA;" 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="&lt;mysql&gt;&lt;version-control&gt;&lt;schema&gt;" AnswerCount="5" CommentCount="11" FavoriteCount="33" />
  5.   <row Id="3" PostTypeId="1" CreationDate="2011-01-03T20:48:58.913" Score="25" ViewCount="768" Body="&lt;p&gt;I used to label columns in my databases like this:&lt;/p&gt;&#xA;&#xA;&lt;pre&gt;&lt;code&gt;user_id&#xA;user_name&#xA;user_password_hash&#xA;&lt;/code&gt;&lt;/pre&gt;&#xA;&#xA;&lt;p&gt;To avoid conflicts when joining two tables, but then I learnt some more on how to alias tables, and I stopped doing this. &lt;/p&gt;&#xA;&#xA;&lt;p&gt;What is an effective way of labeling columns in a database? Why?&lt;/p&gt;&#xA;" 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="&lt;database-design&gt;&lt;erd&gt;" AnswerCount="10" CommentCount="4" FavoriteCount="11" />
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement