tag:blogger.com,1999:blog-61926730220343048222023-06-20T21:36:53.329-07:00Pemahaman Tentang MYSQL untuk pemula yang sedang menjalani proses belajaralfisarhttp://www.blogger.com/profile/10263899974428969676noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6192673022034304822.post-86378867949050322912014-09-11T23:27:00.001-07:002014-09-11T23:27:22.322-07:00NIAT SHALAT SUNAT DAN SHALAT FARDHU JUM'AT<a href="http://bhantana.blogspot.com/2010/01/niat-shalat-sunat-dan-shalat-fardhu.html">NIAT SHALAT SUNAT DAN SHALAT FARDHU JUM'AT</a>alfisarhttp://www.blogger.com/profile/10263899974428969676noreply@blogger.com0tag:blogger.com,1999:blog-6192673022034304822.post-7630314686821254852013-06-28T01:54:00.000-07:002013-06-28T01:54:09.544-07:00<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:DontVertAlignCellWithSp/>
<w:DontBreakConstrainedForcedTables/>
<w:DontVertAlignInTxbx/>
<w:Word11KerningPairs/>
<w:CachedColBalance/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267">
<w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" Priority="39" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" Name="toc 9"/>
<w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}
</style>
<![endif]-->
<br />
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 20.0pt; letter-spacing: -.85pt; mso-fareast-font-family: "Times New Roman"; mso-themecolor: text1;">Pengertian
Mysql</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; letter-spacing: -.85pt; mso-fareast-font-family: "Times New Roman"; mso-themecolor: text1;">Pengertian MySQL</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-themecolor: text1;">MySQL</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-themecolor: text1;"> adalah
sebuah </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><a href="http://id.wikipedia.org/wiki/Perangkat_lunak" title="Perangkat lunak"><span style="color: black; mso-themecolor: text1;">perangkat lunak</span></a><span style="color: black; mso-themecolor: text1;"> sistem manajemen </span><a href="http://id.wikipedia.org/wiki/Basis_data" title="Basis data"><span style="color: black; mso-themecolor: text1;">basis data</span></a><span style="color: black; mso-themecolor: text1;"> </span><a href="http://id.wikipedia.org/wiki/SQL" title="SQL"><span style="color: black; mso-themecolor: text1;">SQL</span></a><span style="color: black; mso-themecolor: text1;"> (</span><a href="http://id.wikipedia.org/wiki/Bahasa_Inggris" title="Bahasa Inggris"><span style="color: black; mso-themecolor: text1;">bahasa
Inggris</span></a><span style="color: black; mso-themecolor: text1;">: <i>database
management system</i>) atau DBMS yang </span><a href="http://id.wikipedia.org/w/index.php?title=Multithread&action=edit&redlink=1" title="Multithread (halaman belum tersedia)"><i><span style="color: black; mso-themecolor: text1;">multithread</span></i></a></span><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-themecolor: text1;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Basis data </span></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">(atau <b><i>database</i></b>)
adalah kumpulan informasi yang disimpan di</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">dalam komputer secara sistematik
sehingga dapat diperiksa menggunakan suatu</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">program
komputer untuk memperoleh informasi dari basis data tersebut</span><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; letter-spacing: .85pt; mso-fareast-font-family: "Times New Roman"; mso-themecolor: text1;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Untuk mengelola <i>database </i>diperlukan
suatu perangkat lunak yang disebut</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">DBMS </span></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">(<i>Database
Management System</i>). DBMS merupakan suatu sistem</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">perangkat lunak yang memungkinkan
user (pengguna) untuk membuat,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">memelihara, mengontrol, dan
mengakses <i>database </i>secara praktis dan efisien.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Dengan DBMS, user akan lebih
mudah mengontrol dan memanipulasi data yang</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">ada.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Sedangkan <b>RDBMS </b>atau <i>Relationship
Database Management System</i></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">merupakan salah satu jenis DBMS
yang mendukung adanya <i>relationship </i>atau</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">hubungan antar tabel. Di samping
RDBMS, terdapat jenis DBMS lain, misalnya</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<i><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Hierarchy
</span></i><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">DBMS,
<i>Object Oriented </i>DBMS, dsb.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; letter-spacing: .85pt; mso-fareast-font-family: "Times New Roman";"></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Table</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Sebuah tabel merupakan kumpulan
data (nilai) yang diorganisasikan ke dalam</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">baris (record) dan kolom (field).
Masing-masing kolom memiliki nama yang</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">spesifik dan unik.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Field</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<i><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Field </span></i><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">merupakan kolom
dari sebuah table. <i>Field </i>memiliki ukuran <i>type </i>data</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">tertentu yang menentukan
bagaimana data nantinya tersimpan.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Record</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Field merupakan sebuah kumpulan
nilai yang saling terkait.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Key</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Key merupakan suatu field yang
dapat dijadikan kunci dalam operasi tabel.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Dalam konsep database, key
memiliki banyak jenis diantaranya Primary Key,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Foreign Key, Composite Key, dll.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">SQL</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">SQL atau Structured Query
Language merupakan suatu bahasa (<i>language</i>) yang</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">digunakan
untuk mengakses database. SQL sering disebut juga sebagai query.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "Times New Roman","serif"; font-size: 12pt;"> </span><!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves>false</w:TrackMoves>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:DontVertAlignCellWithSp/>
<w:DontBreakConstrainedForcedTables/>
<w:DontVertAlignInTxbx/>
<w:Word11KerningPairs/>
<w:CachedColBalance/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267">
<w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" Priority="39" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" Name="toc 9"/>
<w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}
</style>
<![endif]-->
</div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">MyISAM</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Tipe tabel MyISAM merupakan tipe
tabel yang sederhana, stabil dan mudah</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">digunakan. Jika kita akan
menyimpan data sederhana yang tidak terlalu rumit,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">maka gunakanlah tipe tabel ini.
Kelebihan utama MyISAM adalah kecepatan dan</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">kestabilannya. Jika kita memilih
tipe tabel MyISAM, maka MySQL secara otomatis</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">akan menentukan salah satu dari
tiga jenis tabel MyISAM, yaitu :</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">a. <b>MyISAM static</b>. Jenis
ini digunakan ketika semua kolom dalam tabel</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">didefinisikan dengan ukuran yang
pasti (fixed). Dengan kata lain, tidak ada</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">kolom yang memiliki tipe seperti
VARCHAR, TEXT dan BLOB. Karena sifatnya</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">yang fixed, maka jenis ini akan
lebih cepat, aman dan stabil.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">b. <b>MyISAM dymanic</b>. Jenis
ini digunakan ketika terdapat kolom dengan tipe</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">yang dinamis, seperti tipe kolom
VARCHAR. Keuntungan utama dari jenis ini</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">adalah ukuran yang dinamis. Jadi
sifatnya lebih efektif karena ukuran data</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">(file) menyesuaikan isi dari
masing-masing kolom (field).</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">c. <b>MyISAM Compressed</b>.
Kedua jenis MyISAM, static dan dynamic dapat</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">dikompresi menjadi satu jenis
yaitu MyISAM Compressed dengan perintah</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">myisamchk. Tentunya hasilnya
lebih kecil dari segi ukuran. Tabel yang</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">terkompresi tidak dapat dikenakan
operasi seperti INSERT, UPDATE dan</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">DELETE.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">InnoDB</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Tipe tabel InnoDB merupakan tipe
tabel MySQL yang mendukung proses</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">transaksi. Tipe ini memiliki
beberapa keunggulan, antara lain:</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">a. Mendukung transaksi antar
tabel.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">b. Mendukung row-level-locking.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">c. Mendukung Foreign-Key
Constraints.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">d. Crash recovery.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">HEAP</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Tabel dengan tipe HEAP tidak
menyimpan datanya di hardisk, tetapi</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">menyimpan di RAM (memori). Tipe
tabel ini biasanya digunakan sebagai tabel</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">sementara (temporary). Tabel
secara otomatis akan dihapus (hilang) dari MySQL</span></div>
<div class="MsoNormal" style="tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">saat koneksi ke server
diputus atau server MySQL dimatikan.</span></div>
<div class="MsoNormal" style="tab-stops: 105.9pt;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Tipe Tabel yang
Lain</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Selain 3 (tiga) tipe tabel
diatas, yaitu MyISAM, InnoDB dan HEAP, MySQL</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">juga mendukung tipe tabel yang
lain, yaitu:</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">a. <b>BDB</b>. Tipe tabel ini
mirip tipe tabel InnoDB, namun penggunaannya belum</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">maksimal.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">b. <b>Archieve</b>. Tipe ini
tersedia sejak MySQL versi 4.1. Tipe ini digunakan untuk</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">menyimpan tabel yang terkompresi,
dimana biasanya digunakan dalam</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">proses backup.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">c. <b>CSV</b>. Tipe ini digunakan
untuk menyimpan data dalam bentuk file text yang</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">dibatasi dengan koma (delimiter).
Tipe ini tersedia sejak MySQL versi 4.1.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">d. <b>NDB Table </b>(MySQL
Cluster). Tersedia sejak MySQL versi 4.1.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">e. <b>Federated </b>(External
Tables). Tipe ini tersedia sejak MySQL versi 5.0.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Tipe-tipe Field
(Kolom) MySQL</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">MySQL memiliki cukup banyak tipe
data untuk field (kolom) tabel. Tipe field</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">(kolom) ini menentukan besar
kecilnya ukuran suatu tabel. Tipe field di MySQL</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">setidaknya terbagi menjadi
beberapa kelompok, yaitu numerik, string, date-andtime,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">dan kelompok himpunan (set dan
enum). Masing-masing tipe field memiliki</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">batasan lebar dan ukurannya.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Tipe Numeric</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Tipe data numerik digunakan untuk
menyimpan data numeric (angka). Ciri</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">utama data numeric adalah suatu
data yang memungkinkan untuk dikenai</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">operasi aritmatika seperti
pertambahan, pengurangan, perkalian dan pembagian.</span></div>
<div class="MsoNormal" style="tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Berikut ini tipe field
(kolom) di MySQL yang termasuk ke dalam kelompok tip.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><span style="mso-spacerun: yes;"> </span><span style="color: black;">1. TINYINT</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data bilangan bulat positif</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">dan negatif.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: -128 s/d 127</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Ukuran
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 1 byte (8 bit).</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">2. SMALLINT</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data bilangan bulat positif</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">dan negatif.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: -32.768 s/d 32.767</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Ukuran
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 2 byte (16 bit).</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">3. MEDIUMINT</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data bilangan bulat positif</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">dan negatif.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: -8.388.608 s/d 8.388.607</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Ukuran
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 3 byte (24 bit).</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">4. INT</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data bilangan bulat positif</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">dan negatif.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: -2.147.483.648 s/d 2.147.483.647</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Ukuran
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 4 byte (32 bit).</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">5. BIGINT</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data bilangan bulat positif</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">dan negatif.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: ± 9,22 x 1018</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Ukuran
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 8 byte (64 bit).</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">6. FLOAT</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data bilangan pecahan</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">positif dan negatif
presisi tunggal.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: -3.402823466E+38 s/d -1.175494351E-38, 0, dan</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">1.175494351E-38 s/d 3.402823466E+38.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Ukuran
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 4 byte (32 bit).</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">7. DOUBLE</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data bilangan pecahan</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">positif dan negatif
presisi ganda.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: -1.79...E+308 s/d -2.22...E-308, 0, dan</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">2.22...E-308 s/d
1.79...E+308.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Ukuran
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 8 byte (64 bit).</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">8. REAL</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Merupakan sinonim
dari DOUBLE.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">9. DECIMAL</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data bilangan pecahan</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">positif dan negatif.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: -1.79...E+308 s/d -2.22...E-308, 0, dan</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">2.22...E-308 s/d
1.79...E+308.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Ukuran
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 8 byte (64 bit).</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">10. NUMERIC</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Merupakan sinonim
dari DECIMAL.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Tipe
Date dan Time</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Tipe data <i>date </i>dan
<i>time </i>digunakan untuk menyimpan data tanggal dan</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">waktu. Berikut ini
tipe field (kolom) di MySQL yang termasuk ke dalam kelompok</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">tipe <i>date </i>dan <i>time</i>:</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">11. DATE</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data tanggal.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 1000-01-01 s/d 9999-12-31 (YYYY-MM-DD)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Ukuran
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 3 byte.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">12. TIME</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data waktu.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: -838:59:59 s/d +838:59:59 (HH:MM:SS)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Ukuran
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 3 byte.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">13. DATETIME</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data tanggal dan waktu.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: '1000-01-01 00:00:00' s/d '9999-12-31 23:59:59'</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Ukuran
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 8 byte.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">14. YEAR</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data tahun dari tanggal.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 1900 s/d 2155</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Ukuran
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 1 byte.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Tipe
String (Text)</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Tipe data string
digunakan untuk menyimpan data string (text). Ciri utama</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">data string adalah
suatu data yang memungkinkan untuk dikenai operasi</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">aritmatika seperti
pertambahan, pengurangan, perkalian dan pembagian. Berikut</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">ini tipe field
(kolom) di MySQL yang termasuk ke dalam kelompok tipe string:</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">15. CHAR</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data string ukuran tetap.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 0 s/d 255 karakter</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">16. VARCHAR</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data string ukuran dinamis.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 0 s/d 255 karakter (versi 4.1), 0 s/d 65.535 (versi 5.0.3)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">17. TINYTEXT</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data text.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 0 s/d 255 karakter (versi 4.1), 0 s/d 65.535 (versi 5.0.3)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">18. TEXT</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data text.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 0 s/d 65.535 (216 - 1) karakter</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">19. MEDIUMTEXT</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data text.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 0 s/d 224 - 1 karakter</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">20. LONGTEXT</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data text.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 0 s/d 232 - 1 karakter</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Tipe
BLOB (Biner)</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Tipe data blob
digunakan untuk menyimpan data biner. Tipe ini biasanya</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">digunakan untuk
menyimpan kode-kode biner dari suatu file atau object. BLOB</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">MySQL 5 : Dari Pemula
Hingga Mahir versi 1.0 (Januari 2010)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">merupakan singkatan
dari Binary Large Object. Berikut ini tipe field (kolom) di</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">MySQL yang termasuk
ke dalam kelompok tipe blob:</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">21. BIT (sejak versi
5.0.3)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data biner.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 64 digit biner</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">22. TINYBLOB</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data biner.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 255 byte</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">23. BLOB</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data biner.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 216 - 1 byte</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">24. MEDIUMBLOB</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data biner.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 224 - 1 byte</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">25. LONGBLOB</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: digunakan untuk menyimpan data biner.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: 232 - 1 byte</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Tipe
Data yang Lain</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Selain tipe data di
atas, MySQL juga menyediakan tipe data yang lain. Tipe</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">data di MySQL mungkin
akan terus bertambah seiring dengan perkembangan</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">versi MySQL. Berikut
ini beberapa tipe data tambahan MySQL:</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">26. ENUM</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: enumerasi (kumpulan data).</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: sampai dengan 65535 string.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">27. SET</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Penggunaan
</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: combination (himpunan data).</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 12.0pt; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">Jangkauan </span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">: sampai dengan 255 string anggotas.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 12.0pt; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div align="center" class="MsoNormal" style="line-height: normal; margin-top: 12.0pt; mso-layout-grid-align: none; text-align: center; text-autospace: none;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 20.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast;">Langkah-langkah membuat database dan merancang database </span></b></div>
<div align="center" class="MsoNormal" style="line-height: normal; margin-top: 12.0pt; mso-layout-grid-align: none; text-align: center; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 12.0pt; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-layout-grid-align: none; mso-list: l0 level1 lfo2; text-autospace: none; text-indent: -.25in;">
<span class="hps"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">NULL</span></b></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-layout-grid-align: none; text-autospace: none;">
<span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">Jika</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">kolom
dalam tabel</span> <span class="hps">adalah opsional</span>, <span class="hps">kita
dapat</span> <span class="hps">menyisipkan catatan baru</span> <span class="hps">atau
memperbarui</span> <span class="hps">catatan yang ada</span> <span class="hps">tanpa
menambahkan</span> <span class="hps">nilai ke</span> <span class="hps">kolom ini</span>.
<span class="hps">Ini berarti bahwa</span> <span class="hps">lapangan</span> <span class="hps">akan disimpan</span> <span class="hps">dengan nilai</span> <span class="hps">NULL</span>.<br />
<br />
<span class="hps">Nilai NULL</span> <span class="hps">diperlakukan berbeda</span> <span class="hps">dari</span> <span class="hps">nilai-nilai lain</span>.<br />
<br />
<span class="hps">NULL</span> <span class="hps">digunakan sebagai</span> <span class="hps">tempat untuk</span> <span class="hps">nilai yang tidak diketahui</span>
<span class="hps">atau</span> <span class="hps">tidak dapat diterapkan</span>.<br />
<br />
<span class="hps">Catatan</span> <span class="hps">Catatan</span>: <span class="hps">Hal
ini tidak mungkin</span> <span class="hps">untuk membandingkan</span> <span class="hps">NULL</span> <span class="hps">dan</span> <span class="hps">0</span>,
mereka <span class="hps">tidak setara</span>.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoListParagraphCxSpLast" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-layout-grid-align: none; mso-list: l0 level1 lfo2; text-autospace: none; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">NOT
</span></b></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">NULL</span></b></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">kendala</span> <span class="hps">memaksa</span> <span class="hps">lapangan
untuk</span> <span class="hps">selalu mengandung</span> <span class="hps">nilai.</span>
<span class="hps">Ini berarti</span> <span class="hps">bahwa Anda tidak dapat</span>
<span class="hps">menyisipkan catatan baru</span>, <span class="hps">atau
memperbarui</span> <span class="hps">rekor</span> <span class="hps">tanpa
menambahkan</span> <span class="hps">nilai ke</span> <span class="hps">bidang ini</span>.<br />
</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">REATE
TABLE Persons<br />
(<br />
P_Id int NOT NULL,<br />
LastName varchar(255) NOT NULL,<br />
FirstName varchar(255),<br />
Address varchar(255),<br />
City varchar(255)<br />
);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 12.0pt; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-layout-grid-align: none; mso-list: l1 level1 lfo1; text-autospace: none; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">CREATE DATABASE</span></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> untuk membuat
database </span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Contoh : </span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-layout-grid-align: none; text-autospace: none;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">CREATE DATABASE</span></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> database_name</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-layout-grid-align: none; text-autospace: none;">
<br /></div>
<div class="MsoListParagraphCxSpLast" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-layout-grid-align: none; mso-list: l1 level1 lfo1; text-autospace: none; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">CREATE</span></b></span><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">TABLE</span></span></b><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> pernyataan</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">digunakan untuk</span> <span class="hps">membuat tabel</span> <span class="hps">dalam database</span>.<br />
<span class="hps">Tabel</span> <span class="hps">tersebut akan disusun dalam</span>
<span class="hps">baris dan kolom</span>, dan <span class="hps">setiap tabel</span>
<span class="hps">harus memiliki nama</span>.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"></span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 12.0pt; mso-layout-grid-align: none; text-autospace: none; text-indent: .5in;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Contoh :</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-layout-grid-align: none; text-autospace: none;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">CREATE
TABLE </span></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">pelanggan
(</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none; text-indent: .5in;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">id_pelanggan
varchar(5) NOT NULL,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none; text-indent: .5in;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">nm_pelanggan
varchar(30) NOT NULL,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none; text-indent: .5in;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">alamat text,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none; text-indent: .5in;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">telepon varchar
(20),</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none; text-indent: .5in;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">email varchar
(50),</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none; text-indent: .5in;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">PRIMARY
KEY(id_pelanggan)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none; text-indent: .5in;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-layout-grid-align: none; text-autospace: none; text-indent: .5in;">
<br /></div>
<div class="MsoListParagraph" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-add-space: auto; mso-layout-grid-align: none; mso-list: l1 level1 lfo1; text-autospace: none; text-indent: -.25in;">
<span class="hps"><span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">INSERT</span></b></span><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">INTO</span></span></b><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">digunakan untuk menyisipkan</span> <span class="hps">catatan</span>
<span class="hps">baru dalam</span> <span class="hps">tabel</span></span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">/memasukam
data ke dalam table</span></span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">.</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"><br />
</span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">CONTOH
:</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">INSERT
INTO nama_table (kolom1,kolom2,….)values (‘data1’,’data2’,….);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Missal:</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-layout-grid-align: none; text-autospace: none;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Insert
into data_table (nama,umur) values (‘budi’,’33’)</span></div>
<div class="MsoListParagraphCxSpFirst" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-list: l1 level1 lfo1; tab-stops: 105.9pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast;">UPDATE</span></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast;"> di gunakan untuk
memperbarui ctatan ataw memodifikasi data pada suatu table </span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast;">Contoh :</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">UPDATE table_name<br />
SET column1=value, column2=value,...<br />
WHERE some_column=some_value</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Missal :</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Update<span style="mso-spacerun: yes;">
</span>data_penduduk<span style="mso-spacerun: yes;"> </span>set nama=’budi
santosa’,umur=’30’,where id=1</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-list: l1 level1 lfo1; tab-stops: 105.9pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast;">DELETE</span></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast;"> </span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">digunakan untuk</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">menghapus</span> <span class="hps">record dalam sebuah tabel</span>.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast;"></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast;">CONTOH :</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">DELETE FROM table_name<br />
WHERE some_column=some_value</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Missal :</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Delete from data_penduduk where
nama=”alfie”</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-list: l1 level1 lfo1; tab-stops: 105.9pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">SELECT</span></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><span style="mso-spacerun: yes;"> </span>di gunakan untuk menampilkan database ataw
mengambil dan memilih data dari database </span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Contoh :</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">SELECT *FROM<span style="mso-spacerun: yes;"> </span>nama_table ;(untuk menampilkan data table
semua )</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Contoh ke 2 ;</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Untuk menampilkan data yang di pilih
ataw di ingin kan oleh kita :</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Misal 1:</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">select
id_pegawai,tgl_masuk,gaji from nama_table;</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;">misal2:</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">SELECT * FROM BUBUR_CIANJUR WHERE ID_PEGAWAI='467892';</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-list: l1 level1 lfo1; tab-stops: 105.9pt; text-indent: -.25in;">
<span style="color: black; font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">ORDER</span></b></span><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">BY</span></span></b><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">kata kunci</span> <span class="hps">yang digunakan</span> <span class="hps">untuk mengurutkan</span> <span class="hps">hasil</span>-set <span class="hps">oleh satu atau lebih</span> <span class="hps">kolom</span>.<br />
<br />
<span class="hps">ORDER</span> <span class="hps">BY</span> <span class="hps">kata
kunci</span> <span class="hps">macam</span> <span class="hps">catatan</span> <span class="hps">dalam urutan</span> <span class="hps">secara default</span>. <span class="hps">Untuk mengurutkan</span> <span class="hps">catatan</span> <span class="hps">dalam urutan</span> <span class="hps">menurun</span>, <span class="hps">Anda</span>
<span class="hps">dapat menggunakan kata kunci</span> <span class="hps">DESC</span>.</span><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt;"></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span class="hps"><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Contoh
:</span></b></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">SELECT <em>column_name</em>,<em>column_name</em><br />
FROM <em>table_name</em><br />
ORDER BY <em>column_name</em>,<em>column_name</em> ASC|DESC;<span class="hps"></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<span class="hps"><span lang="IN" style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">SQL</span></b></span><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps">PRIMARY KEY</span></span></b><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps"></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">kendala</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">unik
mengidentifikasi</span> <span class="hps">setiap record</span> <span class="hps">dalam
tabel database</span>.<br />
<span class="hps">Primary key</span> <span class="hps">harus mengandung</span> <span class="hps">nilai-nilai unik</span>.<br />
<span class="hps">Sebuah kolom</span> <span class="hps">kunci primer</span> <span class="hps">tidak dapat berisi</span> <span class="hps">nilai NULL</span>.<br />
<span class="hps">Setiap tabel</span> <span class="hps">harus memiliki</span> <span class="hps">kunci utama</span>, <span class="hps">dan</span> <span class="hps">setiap
tabel</span> <span class="hps">hanya dapat memiliki</span> <span class="hps">satu</span>
<span class="hps">primary key</span>.<br />
<span class="hps">SQL</span> <span class="hps">PRIMARY KEY</span> <span class="hps">Kendala</span>
<span class="hps">pada</span> <span class="hps">CREATE TABLE</span></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">Berikut</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">SQL</span> <span class="hps">menciptakan</span> <span class="hps">PRIMARY KEY</span> <span class="hps">pada kolom</span> <span class="hps">"</span>P_Id" <span class="hps">ketika "</span>Orang" tabel <span class="hps">dibuat</span>:</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Contoh :</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"><br />
<br />
</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">CREATE
TABLE Persons<br />
(<br />
P_Id int NOT NULL,<br />
LastName varchar(255) NOT NULL,<br />
FirstName varchar(255),<br />
Address varchar(255),<br />
City varchar(255),<br />
PRIMARY KEY (P_Id)<br />
);</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-list: l1 level1 lfo1; tab-stops: 105.9pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">DROP ialah untuk
menghapus </span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">DROP DATABASE</span></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> </span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Contoh :</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">DROP DATABASE database_name</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">DROP TABLE</span></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Contoh : </span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">DROP TABLE table_name</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span class="hps"><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">DROP</span></b></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"> INDEX</span></b></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"><span style="mso-spacerun: yes;"> </span><span class="hps"><span lang="IN">digunakan untuk</span></span><span lang="IN"> <span class="hps">menghapus</span> <span class="hps">indeks dalam</span> <span class="hps">tabel</span>.</span></span><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"></span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">CONTOH :</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">ALTER TABLE table_name DROP INDEX
index_name</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-list: l1 level1 lfo1; tab-stops: 105.9pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">ALTER</span></b></span><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">TABLE</span></span></b><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> pernyataan</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">digunakan untuk menambah</span>, <span class="hps">menghapus</span>, <span class="hps">atau memodifikasi</span> <span class="hps">kolom dalam</span> <span class="hps">tabel yang ada</span>.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Contoh :</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-bottom: 10.0pt; margin-left: .75in; margin-right: 0in; margin-top: 12.0pt; mso-add-space: auto; mso-list: l2 level1 lfo3; tab-stops: 105.9pt; text-indent: -.25in;">
<span style="font-size: 12.0pt; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: Calibri; mso-hansi-font-family: Calibri;"><span style="mso-list: Ignore;">-<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">Untuk
menambahkan kolom</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">dalam
sebuah tabel,</span> <span class="hps">gunakan sintaks berikut</span>:</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-bottom: 10.0pt; margin-left: .75in; margin-right: 0in; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Missal
:</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-bottom: 10.0pt; margin-left: .75in; margin-right: 0in; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">ALTER
TABLE table_name<br />
ADD column_name datatype</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-bottom: 10.0pt; margin-left: .75in; margin-right: 0in; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-bottom: 10.0pt; margin-left: .75in; margin-right: 0in; margin-top: 12.0pt; mso-add-space: auto; mso-list: l2 level1 lfo3; tab-stops: 105.9pt; text-indent: -.25in;">
<span style="font-size: 12.0pt; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: Calibri; mso-hansi-font-family: Calibri;"><span style="mso-list: Ignore;">-<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">Untuk
menghapus</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">kolom</span> <span class="hps">dalam
sebuah tabel,</span> <span class="hps">gunakan sintaks berikut</span> <span class="hps">(perhatikan bahwa</span> <span class="hps">beberapa</span> <span class="hps">sistem database</span> <span class="hps">tidak mengijinkan</span> <span class="hps">menghapus</span> <span class="hps">kolom</span>):</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-bottom: 10.0pt; margin-left: .75in; margin-right: 0in; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Missal
:</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-bottom: 10.0pt; margin-left: .75in; margin-right: 0in; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">ALTER
TABLE table_name<br />
DROP COLUMN column_name</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-bottom: 10.0pt; margin-left: .75in; margin-right: 0in; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-bottom: 10.0pt; margin-left: .75in; margin-right: 0in; margin-top: 12.0pt; mso-add-space: auto; mso-list: l2 level1 lfo3; tab-stops: 105.9pt; text-indent: -.25in;">
<span style="font-size: 12.0pt; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: Calibri; mso-hansi-font-family: Calibri;"><span style="mso-list: Ignore;">-<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">Untuk
mengubah</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">tipe data</span> <span class="hps">dari
kolom</span> <span class="hps">dalam sebuah tabel,</span> <span class="hps">gunakan
sintaks berikut</span>:</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-bottom: 10.0pt; margin-left: .75in; margin-right: 0in; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">Missal
:</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-bottom: 10.0pt; margin-left: .75in; margin-right: 0in; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">ALTER
TABLE table_name<br />
MODIFY column_name datatype</span></div>
<div class="MsoListParagraphCxSpLast" style="line-height: normal; margin-bottom: 10.0pt; margin-left: .75in; margin-right: 0in; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 12.0pt; tab-stops: 105.9pt;">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; mso-list: l1 level1 lfo1; tab-stops: 105.9pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">SQL<span style="mso-spacerun: yes;"> </span>JOIN</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">digunakan</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps">untuk
menggabungkan</span> <span class="hps">baris dari</span> <span class="hps">dua atau</span>
<span class="hps">lebih tabel</span>, <span class="hps">berdasarkan</span> <span class="hps">bidang</span> <span class="hps">umum di antara mereka</span>.<br />
<br />
<span class="hps">Jenis yang paling umum</span> <span class="hps">dari</span> <span class="hps">bergabung adalah</span>: <span class="hps">SQL</span> </span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"><span style="mso-spacerun: yes;"> </span></span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;">INNER</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> </span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;">JOIN</span></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN;"> <span class="hps"><span lang="IN">(</span></span><span lang="IN">join <span class="hps">sederhana)</span>. <span class="hps">Sebuah</span> <span class="hps">SQL</span>
<span class="hps">INNER JOIN</span> <span class="hps">mengembalikan semua</span> <span class="hps">baris</span> <span class="hps">dari beberapa tabel</span> <span class="hps">di mana</span> <span class="hps">kondisi bergabung</span> <span class="hps">terpenuhi</span>.<br />
<br />
<span class="hps">Mari kita lihat</span> <span class="hps">pilihan</span> <span class="hps">dari</span> <span class="hps">"</span>Perintah" <span class="hps">tabel</span></span></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"></span></div>
<div class="MsoListParagraphCxSpLast" style="line-height: normal; margin-top: 12.0pt; mso-add-space: auto; tab-stops: 105.9pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-no-proof: yes;"><img height="237" src="file:///C:%5CDOCUME%7E1%5Ctelkom%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_image002.jpg" width="624" /></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt;"></span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">Perhatikan</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps">bahwa</span> <span class="hps">"</span>Pelanggan" <span class="hps">di</span> <span class="hps">kolom</span> <span class="hps">"</span>Perintah"
<span class="hps">tabel</span> <span class="hps">mengacu pada</span> <span class="hps">pelanggan dalam</span> <span class="hps">"Pelanggan</span>"
tabel. <span class="hps">Hubungan antara</span> <span class="hps">dua tabel</span> <span class="hps">di atas adalah</span> <span class="hps">kolom</span> <span class="hps">"</span>Pelanggan".<br />
<span class="hps">Kemudian</span>, <span class="hps">jika kita</span> <span class="hps">menjalankan</span> <span class="hps">pernyataan SQL berikut</span> <span class="hps">(</span>yang berisi <span class="hps">INNER JOIN</span>):</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"></span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-no-proof: yes;"><img height="97" src="file:///C:%5CDOCUME%7E1%5Ctelkom%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_image004.jpg" width="624" /></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"></span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">itu akan menghasilkan</span></span><span class="shorttext"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> </span></span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">sesuatu seperti ini</span></span><span class="shorttext"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">:</span></span><span class="shorttext"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"></span></span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-no-proof: yes;"><img height="158" src="file:///C:%5CDOCUME%7E1%5Ctelkom%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_image006.jpg" width="624" /></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"></span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<br /></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<br /></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">Berbeda</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps">SQL</span> </span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">JOINs</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"><br />
<br />
<span class="hps">Sebelum kita melanjutkan</span> <span class="hps">dengan
contoh-contoh</span>, <span class="hps">kami akan memberikan daftar</span> <span class="hps">jenis</span> <span class="hps">SQL</span> <span class="hps">berbeda</span>
<span class="hps">BERGABUNG</span> <span class="hps">Anda</span> <span class="hps">dapat
menggunakan</span>:</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"></span></div>
<div class="MsoListParagraphCxSpFirst" style="margin-left: .75in; mso-add-space: auto; mso-list: l2 level1 lfo3; tab-stops: 61.6pt; text-indent: -.25in;">
<span class="hps"><span style="font-size: 12.0pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: Calibri; mso-hansi-font-family: Calibri;"><span style="mso-list: Ignore;">-<span style="font: 7.0pt "Times New Roman";">
</span></span></span></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">INNER JOIN :</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps"><span lang="IN">Mengembalikan</span></span><span lang="IN"> <span class="hps">semua baris</span> <span class="hps">ketika ada</span> <span class="hps">setidaknya satu</span> <span class="hps">pertandingan</span> <span class="hps">di</span> <span class="hps">KEDUA</span> <span class="hps">tabel</span></span></span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">/
hanya akan di tampilkan baris-baris<span style="mso-spacerun: yes;"> </span>yang
satu sama lain memiliki ke cocokan .</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: .75in; mso-add-space: auto; mso-list: l2 level1 lfo3; tab-stops: 61.6pt; text-indent: -.25in;">
<span class="hps"><span style="font-size: 12.0pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: Calibri; mso-hansi-font-family: Calibri;"><span style="mso-list: Ignore;">-<span style="font: 7.0pt "Times New Roman";">
</span></span></span></span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">LEFT JOIN</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">: <span class="hps">Kembali semua</span> <span class="hps">baris dari tabel</span>
<span class="hps">kiri</span>, <span class="hps">dan baris</span> <span class="hps">yang
cocok</span> <span class="hps">dari tabel kanan</span></span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">/akan
menampilkan semua table sisi kiri ,walaupun data di pasangan joinnya yg di sisi
kanan nilai nya tidak sama ataupun berisi null.</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: .75in; mso-add-space: auto; mso-list: l2 level1 lfo3; tab-stops: 61.6pt; text-indent: -.25in;">
<span class="hps"><span style="font-size: 12.0pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: Calibri; mso-hansi-font-family: Calibri;"><span style="mso-list: Ignore;">-<span style="font: 7.0pt "Times New Roman";">
</span></span></span></span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">RIGHT JOIN</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">:</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"> </span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">Kembali</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps">semua baris</span> <span class="hps">dari tabel kanan</span>, <span class="hps">dan baris</span> <span class="hps">yang cocok</span> <span class="hps">dari
tabel</span> <span class="hps">kiri</span></span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">/dan
ini kebalikan dari left joint ,akan menampilkan semua isi table sisi kanan
,walaupun data di pasangan join nya yang yg disisi kiri nilai nya tidak
sama<span style="mso-spacerun: yes;"> </span>atau pun berisi null.</span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-left: .75in; mso-add-space: auto; mso-list: l2 level1 lfo3; tab-stops: 61.6pt; text-indent: -.25in;">
<span class="hps"><span style="font-size: 12.0pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: Calibri; mso-hansi-font-family: Calibri;"><span style="mso-list: Ignore;">-<span style="font: 7.0pt "Times New Roman";">
</span></span></span></span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">FULL JOIN:</span></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps"><span lang="IN">Kembali</span></span><span lang="IN"> <span class="hps">semua baris</span> <span class="hps">ketika</span> <span class="hps">ada kecocokan</span> <span class="hps">dalam SATU</span> <span class="hps">dari</span> <span class="hps">tabel</span></span></span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">/akan
menampilkan semua isi table sisi kiri walaupun data di pasangan join nya yang
sisi kanan nilai nya null atau sebalik nya .</span></span></div>
<div class="MsoNormal" style="tab-stops: 61.6pt;">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l1 level1 lfo1; tab-stops: 61.6pt; text-indent: -.25in;">
<span class="hps"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">INNER JOIN :</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps"><span lang="IN">Mengembalikan</span></span><span lang="IN"> <span class="hps">semua baris</span> <span class="hps">ketika ada</span> <span class="hps">setidaknya satu</span> <span class="hps">pertandingan</span> <span class="hps">di</span> <span class="hps">KEDUA</span> <span class="hps">tabel</span></span></span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">/
hanya akan di tampilkan baris-baris<span style="mso-spacerun: yes;"> </span>yang
satu sama lain memiliki ke cocokan .</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Contoh:</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
<em>column_name(s)</em><br />
FROM <em>table1</em><br />
INNER JOIN <em>table2</em><br />
ON <em>table1.column_name</em>=<em>table2.column_name</em>;</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Missal
:</span></div>
<div class="MsoListParagraphCxSpLast" style="tab-stops: 61.6pt;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
</span></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">a.nama,b,penyakit<b style="mso-bidi-font-weight: normal;"> FROM<span style="mso-spacerun: yes;">
</span></b>pasien a <b style="mso-bidi-font-weight: normal;">INNER JOIN </b>penyakit
b <b style="mso-bidi-font-weight: normal;">ON</b><span style="mso-spacerun: yes;">
</span>b.id=a.id;</span></div>
<div class="MsoNormal" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-no-proof: yes;"><img height="170" src="file:///C:%5CDOCUME%7E1%5Ctelkom%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_image008.jpg" width="274" /></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"></span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l1 level1 lfo1; tab-stops: 61.6pt; text-indent: -.25in;">
<span class="hps"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">LEFT JOIN</span></b></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">: <span class="hps">Kembali semua</span> <span class="hps">baris
dari tabel</span> <span class="hps">kiri</span>, <span class="hps">dan baris</span>
<span class="hps">yang cocok</span> <span class="hps">dari tabel kanan</span></span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">/akan
menampilkan semua table sisi kiri ,walaupun data di pasangan joinnya yg di sisi
kanan nilai nya tidak sama ataupun berisi null</span></span></div>
<div class="MsoListParagraphCxSpLast" style="tab-stops: 61.6pt;">
<span class="hps"><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">CONTOH </span></b></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">:</span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
<em>column_name(s)</em><br />
FROM <em>table1</em><br />
LEFT JOIN <em>table2</em><br />
ON <em>table1.column_name</em>=<em>table2.column_name</em>;</span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">MISAL
:</span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
a.nama,b.penyakit FROM pasein a LEFT JOIN penyakit b on b.id=a.id;</span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-no-proof: yes;"><img height="160" src="file:///C:%5CDOCUME%7E1%5Ctelkom%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_image010.jpg" width="220" /></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"></span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l1 level1 lfo1; tab-stops: 61.6pt; text-indent: -.25in;">
<span class="hps"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span></span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">RIGHT JOIN</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">:</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"> </span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">Kembali</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps">semua baris</span> <span class="hps">dari tabel kanan</span>, <span class="hps">dan baris</span> <span class="hps">yang cocok</span> <span class="hps">dari
tabel</span> <span class="hps">kiri</span></span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">/dan
ini kebalikan dari left joint ,akan menampilkan semua isi table sisi kanan
,walaupun data di pasangan join nya yang yg disisi kiri nilai nya tidak
sama<span style="mso-spacerun: yes;"> </span>atau pun berisi null.</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">CONTOH
:</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
<em>column_name(s)</em><br />
FROM <em>table1</em><br />
RIGHT JOIN <em>table2</em><br />
ON <em>table1.column_name</em>=<em>table2.column_name</em>;</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Missal:</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
a.nama,b.penyakit FROM pasein a RIGHT JOIN penyakit b ON b.id=a.id;</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-no-proof: yes;"><img height="157" src="file:///C:%5CDOCUME%7E1%5Ctelkom%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_image012.jpg" width="229" /></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"></span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l1 level1 lfo1; tab-stops: 61.6pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">FORMAT</span></b></span><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> </span></b><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"><span style="mso-spacerun: yes;"> </span><span class="hps">adalah
fungsi yang digunakan</span> <span class="hps">untuk memformat</span> <span class="hps">bagaimana</span> <span class="hps">lapangan</span> <span class="hps">yang
akan ditampilkan</span>.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"></span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
FORMAT(column_name,format) FROM table_name;</span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-add-space: auto; mso-list: l1 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">SQL </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">AND</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> & </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">OR</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> Operator<br />
<br />
Operator AND menampilkan catatan jika kedua kondisi pertama DAN kondisi kedua
benar.<br />
<br />
Operator OR menampilkan catatan jika salah kondisi ATAU kondisi kedua pertama
adalah benar.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"></span></div>
<div class="MsoListParagraphCxSpLast" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">CONTOH
:</span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
column_name(s)<br />
FROM table_name<br />
WHERE condition<br />
AND|OR condition</span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Missal1:</span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
* FROM Customers<br />
WHERE Country='Germany'<br />
AND City='Berlin';</span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Missal2:</span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
* FROM Customers<br />
WHERE City='Berlin'<br />
OR City='München';</span></div>
<div class="MsoNormal" style="tab-stops: 61.6pt;">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l1 level1 lfo1; tab-stops: 61.6pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">BETWEEN </span></div>
<div style="margin-left: .5in; text-align: justify;">
<span class="hps"><span lang="IN" style="mso-ansi-language: IN;">Operator</span></span><span lang="IN" style="mso-ansi-language: IN;"> <span class="hps">memilih</span> <span class="hps">nilai-nilai</span>
<span class="hps">dalam kisaran.</span> <span class="hps">Nilai-nilai</span> <span class="hps">dapat angka,</span> <span class="hps">teks, atau</span> <span class="hps">tanggal</span>.</span></div>
<div style="margin-left: .5in; text-align: justify;">
Contoh :</div>
<div style="margin-left: .5in;">
SELECT <em>column_name(s)</em><br />
FROM <em>table_name</em><br />
WHERE <em>column_name </em>BETWEEN <em>value1</em> AND <em>value2;</em></div>
<div style="margin-left: .5in;">
<br /></div>
<div style="margin-left: .5in;">
Misal 1:</div>
<div style="margin-left: .5in;">
SELECT * FROM Products<br />
WHERE Price BETWEEN 10 AND 20;</div>
<div style="margin-left: .5in;">
Missal 2 :</div>
<div style="margin-left: .5in;">
SELECT * FROM Products<br />
WHERE Price NOT BETWEEN 10 AND 20;</div>
<div style="margin-left: .5in;">
Missal 3:</div>
<div style="margin-left: .5in; text-align: justify;">
Pernahkah kita menemui kasus
dimana kita harus mencari data penjualan antara tanggal 2009-07-22 s.d
2009-08-30 ? Jika ya, kita dapat menggunakan perintah BETWEEN dalam database
mysql. Berikut ini cara penggunaannya :</div>
<div style="margin-left: .5in;">
SELECT * FROM sales WHERE tgltransaksi BETWEEN
2009-07-22 AND 2009-08-30 ORDER BY id DESC</div>
<div style="margin-left: .5in; text-align: justify;">
Maka hasil query tersebut akan
menghasilkan data penjualan pada range tanggal 22 Juli 2009 s.d 30 Agustus
2009. Lalu bagaimana jika kita harus mencari data penjualan di luar periode itu
? kita cukup menambahkan <strong>NOT</strong> di depan BETWEEN seperti contoh
berikut :</div>
<div style="margin-left: .5in; text-align: justify;">
SELECT * FROM sales WHERE
tgltransaksi <strong>NOT</strong> BETWEEN 2009-07-22 AND 2009-08-30 ORDER BY id
DESC</div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l1 level1 lfo1; tab-stops: 61.6pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">IN
</span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Menentukan
nilai di dalam .</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Contoh
:</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
<em>column_name(s)</em><br />
FROM <em>table_name</em><br />
WHERE <em>column_name</em> IN (<em>value1</em>,<em>value2</em>,...);</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Missal:</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
* FROM Customers<br />
WHERE City IN ('Paris','London');</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; tab-stops: 61.6pt; text-indent: -.25in;">
<span class="hps"><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">MAX</span></b></span><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> </span></b><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">fungsi mengembalikan nilai</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps">terbesar</span> <span class="hps">dari
kolom</span> <span class="hps">yang dipilih</span></span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">.</span></div>
<div class="MsoListParagraphCxSpLast" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Contoh
:</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-indent: .5in;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">SELECT MAX(column_name) FROM
table_name;</span></div>
<div class="MsoListParagraphCxSpFirst" style="tab-stops: 61.6pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; tab-stops: 61.6pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">MIN</span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Fungsi
mengembalikan nilai terkecil dari kolom yang di pilih</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Contoh
:</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
MIN(column_name) FROM table_name;</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; tab-stops: 61.6pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SUM</span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">mengembalikan fungsi</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps">jumlah total</span> <span class="hps">dari
kolom</span> <span class="hps">numerik</span></span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">contoh
:</span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
SUM(column_name) FROM table_name;</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; tab-stops: 61.6pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">ROUND</span></b></span><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> </span></b><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">(</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">) <span class="hps">adalah fungsi yang digunakan</span> <span class="hps">untuk membulatkan</span> <span class="hps">bidang angka</span> <span class="hps">dengan jumlah</span> <span class="hps">desimal</span> <span class="hps">yang
ditentukan</span>.</span><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"></span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span class="hps"><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Contoh :</span></b></span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
ROUND(column_name,decimals) FROM table_name;</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; tab-stops: 61.6pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">LEN</span></b></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps">(</span>) fungsi <span class="hps">mengembalikan
panjang</span> <span class="hps">nilai</span> <span class="hps">dalam kolom teks</span>.</span><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"></span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">contoh
:</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">SELECT
LEN(column_name) FROM table_name;</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; tab-stops: 61.6pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">CHECK</span></b></span><span class="hps"><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> </span></b></span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">kendala</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps">digunakan untuk</span> <span class="hps">membatasi</span>
<span class="hps">rentang nilai</span> <span class="hps">yang dapat ditempatkan</span>
<span class="hps">dalam kolom</span>.<br />
<br />
<span class="hps">Jika anda mendefinisikan suatu</span> <span class="hps">kendala </span></span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">CHECK
</span></span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">pada</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps">kolom</span> <span class="hps">memungkinkan</span>
<span class="hps">nilai-nilai</span> <span class="hps">tertentu saja</span> <span class="hps">untuk kolom ini</span>.<br />
<br />
<span class="hps">Jika anda mendefinisikan suatu</span> <span class="hps">kendala </span></span><span class="hps"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">CHECK
</span></span><span class="hps"><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;">atas meja</span></span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: IN;"> <span class="hps">dapat</span> <span class="hps">membatasi</span>
<span class="hps">nilai dalam</span> <span class="hps">kolom</span> <span class="hps">tertentu berdasarkan</span> <span class="hps">nilai-nilai dalam</span> <span class="hps">kolom lain</span> <span class="hps">pada baris</span>.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"></span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Contoh
: </span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">CREATE
TABLE Persons<br />
(<br />
P_Id int NOT NULL,<br />
LastName varchar(255) NOT NULL,<br />
FirstName varchar(255),<br />
Address varchar(255),<br />
City varchar(255),<br />
CHECK (P_Id>0)<br />
);</span></div>
<div class="MsoListParagraphCxSpMiddle" style="tab-stops: 61.6pt;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; tab-stops: 61.6pt; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">ENUM
</span></b></div>
<div class="MsoListParagraphCxSpLast" style="tab-stops: 61.6pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Untuk
menentukan yang sudah pasti semisal (‘islam’,’non islam’)</span></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<br /></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<br /></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<br /></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<br /></div>
<div class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt;">
<br /></div>
<div align="center" class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt; text-align: center;">
<br /></div>
<div align="center" class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt; text-align: center;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Sekian dari saya dan bila saya mendapatkan ilmu kembali
saya akah bagikan kepada kalian semua …. </span></div>
<div align="center" class="MsoNormal" style="text-align: center;">
<span style="font-family: "Blackadder ITC"; font-size: 14.0pt; line-height: 115%;">ingat
!!!!!</span></div>
<div align="center" class="MsoNormal" style="text-align: center;">
<span style="font-family: "Blackadder ITC"; font-size: 14.0pt; line-height: 115%;">kita
belajar ingin bisa dan kita bisa karena ingin belajar !!!</span></div>
<div align="center" class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt; text-align: center;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;">Mohon maaf bila ada kata-kata atau penjelasan yang kurang
di mengerti .</span></div>
<div align="center" class="MsoNormal" style="margin-left: 0.5in; text-align: center;">
<span style="font-family: "Times New Roman","serif"; font-size: 12pt; line-height: 115%;">SUKSES UNTUK KITA SEMUA ! </span></div>
salam,<br />
<br />
<div align="center" class="MsoNormal" style="margin-left: .5in; tab-stops: 61.6pt; text-align: center;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; line-height: 115%;"><span style="mso-tab-count: 1;"> </span><span style="mso-tab-count: 1;"> </span><span style="mso-tab-count: 1;"> </span><span style="mso-tab-count: 1;"> </span><span style="mso-tab-count: 1;"> </span><span style="mso-tab-count: 1;"> </span><span style="mso-tab-count: 1;"> </span><span style="mso-tab-count: 1;"> </span><span style="mso-tab-count: 1;"> <b> </b></span><b>alfisar
</b></span></div>
alfisarhttp://www.blogger.com/profile/10263899974428969676noreply@blogger.com0