Tutorial Koding

Membuat login aman dari SQL Injection

Malem semua kali ini saya akan memposting tentang membuat login aman dari SQL Injection,<br />
ya walaupun ini cara lama,mungkin ada yang belum tau :D<br />
<span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 21px; text-align: justify;">Secara singkat <b>SQL injection</b> adalah menambahkan perintah SQL Query melalui dengan tujuan untuk memodifikasi sql query yang sudah ada atau menciptakan SQL Query baru.</span><br />
<span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 21px; text-align: justify;">Sebagai contoh :</span><br />
<span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 21px; text-align: justify;">saya mempunyai SQL Query untuk login program yang saya buat dengan VB.NET seperti ini</span><br />
<blockquote class="tr_bq">
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;">select username,password from admin where username=' " & txt_username.text & " ' and password=' " & txt_password.text & " '</span></span> </blockquote>
<div style="text-align: justify;">
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;">tapi jika pengguna program menginputkan username 'OR '1'='1 dan password 'OR '1'='1 lalu </span></span><br />
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;"><br /></span></span></div>
<div style="text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMP64NU4_DVkcHkB9cOaA368TZayO0TQyRfEE9es-UEdV2bbPSyVEW66gbsnntAkuwnDCfpj0VNBpaAz5Cnv_A5WQbdB00r08yM4bl2bEoR2IFRiAwzpkRkVUpgUWPlZoLZYclNfheS2VC/s1600/Screenshot_2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMP64NU4_DVkcHkB9cOaA368TZayO0TQyRfEE9es-UEdV2bbPSyVEW66gbsnntAkuwnDCfpj0VNBpaAz5Cnv_A5WQbdB00r08yM4bl2bEoR2IFRiAwzpkRkVUpgUWPlZoLZYclNfheS2VC/s320/Screenshot_2.png" width="320" /></a></div>
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;">setelah program di jalankan maka SQL Query kita akan menjadi seperti ini :</span></span></div>
<blockquote class="tr_bq">
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;">select username,password from admin where username=' ' or '1'='1' and password=' ' or '1'='1'</span></span> </blockquote>
maka ini akan menghasilkan nilai TRUE, sehingga user (anonymous) berhasil login ke aplikasi yang kita buat tanpa perlu mengetahui username atau password yang sebenarnya<br />
<br />
Tapi, ada beberapa cara yang dapat digunakan untuk mengatasi agar hal itu tidak terjadi<br />
<br />
1. Menghilangkan karakter kutip 1 (') sebagai contoh replace(txt_username.text," ' ","")<br />
sebagai contoh :<br />
<blockquote class="tr_bq">
select username,password from admin where username=' " & Replace(txt_username.Text, " ' ", "") & " ' and password=' " & replace(txt_password.Text," ' ","") & " '</blockquote>
2. Membatasi MaxLength Textbox sesuai dengan Lenght Field yang ada di database dengan itu maka user tidak bisa mengisi Textbox secara bebas<br />
<br />
cara diatas adalah beberapa cara yang dapat digunakan dari sekumpulan cara yang dapat digunakan untuk membuat login aman dari SQL Injection<br />
<br />
cara diatas juga berlaku untuk bahasa pemrograman lain seperti PHP,C#,VB.NET dan lain - lain<br />
kita hanya perlu menerapkan logika yang sama dengan bahasa pemrograman yang kita gunakan<br />
sekian postingan saya malam ini semoga dapat menambah wawasan kita semua

Membuat login aman dari SQL Injection

Malem semua kali ini saya akan memposting tentang membuat login aman dari SQL Injection, ya walaupun ini cara lama,mungkin ada yang belum tau :D Secara singkat SQL injection adalah menambahkan perintah SQL Query melalui dengan tujuan untuk memodifikasi sql query yang sudah ada atau menciptakan SQL Q…

24Oct2013

Mengatasi error "String or binary data would be truncated. The statement has been terminated."

<span style="font-family: Courier New, Courier, monospace;">Malam semua setelah beberapa jam yang lalu saya memposting tentang <a href="http://dwirandyherdinanto.blogspot.com/2013/10/crud-dengan-vbnet-bagian-1.html" target="_blank">CRUD dengan VB.NET Bagian 1</a> kali ini saya akan memposting </span><br />
<span style="font-family: Courier New, Courier, monospace;">C<b>ara mengatasi error "String or binary data would be truncated.</b></span><br />
<pre class="brush: sql; title: ; notranslate" title=""><b><span style="font-family: Courier New, Courier, monospace;">The statement has been terminated."</span></b></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">yah beberapa waktu yang lalu saya pernah mengalami mengalami error tersebut</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">saya sempat bingung juga kenapa bisa terjadi error tersebut,padalah script untuk insert data nya sudah benar</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">lalu setelah searching di google saya menemukan solusinya</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">ternyata error itu disebabkan karena kita menginputkan data yang karakternya melebihi dari Lenght column yang kita buat</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">sebagai contoh saya membuat table sebagai berikut</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">create table customer (</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">kd_customer varchar(5) not null primary key,</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">nama varchar(30) not null,</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">alamat varchar(30) not null)</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">lalu saya insert data dengan script sebagai berikut</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">insert into customer (kd_customer,nama,alamat) values ('CUS123','Dwi Randy Herdinanto','Bandar Jaya')</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">maka ketika dijalankan akan muncul error seperti gambar di bawah ini</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEii6zFJ7SsnTJfNyBPDeaeqKoIq1DhIaIcpKnmezgE3aHe4XSP65DWkH_uyrqRHcUfktSbiaDGxgjZQJwpEy2FuShuf7H39dVlRThF6gB6c96P_pwzP68zLoM1e6QI8YFZ8V3EcKNjRp-Of/s1600/Screenshot_3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="154" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEii6zFJ7SsnTJfNyBPDeaeqKoIq1DhIaIcpKnmezgE3aHe4XSP65DWkH_uyrqRHcUfktSbiaDGxgjZQJwpEy2FuShuf7H39dVlRThF6gB6c96P_pwzP68zLoM1e6QI8YFZ8V3EcKNjRp-Of/s320/Screenshot_3.png" width="320" /></a></div>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">kenapa terjadi error seperti gambar itu?</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">itu terjadi karena saya mengisi kd_customer dengan cus123 yang panjang kakternya 6, sedangkan pada column kd_customer Lenght nya hanya 5,</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">namun jika kita insert dengan script sebagai berikut</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">insert into customer (kd_customer,nama,alamat) values ('CUS12','Dwi Randy Herdinanto','Bandar Jaya')</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">maka ketika dijalankan akan akan berhasil disimpan seperti gambar di bawah ini</span></pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyvqoev2vJcb5KkUfa1kkfKHzIB0UTi7YQR895YpxqID-qRGrifCPSG_TikSYZmarRXTDlLk1T3uYpi0IMvMFg3nwSHA83wRU-vOP08N6F0W5qz71BQcVFct9SNp8lkO2uUIwJB4dsm2KA/s1600/Screenshot3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="154" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyvqoev2vJcb5KkUfa1kkfKHzIB0UTi7YQR895YpxqID-qRGrifCPSG_TikSYZmarRXTDlLk1T3uYpi0IMvMFg3nwSHA83wRU-vOP08N6F0W5qz71BQcVFct9SNp8lkO2uUIwJB4dsm2KA/s320/Screenshot3.png" width="320" /></a></div>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">yah sekian postingan saya kali ini</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">semoga bermanfaat bagi yang membaca :D</span></pre>

Mengatasi error "String or binary data would be truncated. The statement has been terminated."

Malam semua setelah beberapa jam yang lalu saya memposting tentang CRUD dengan VB.NET Bagian 1 kali ini saya akan memposting Cara mengatasi error "String or binary data would be truncated. The statement has been terminated." yah beberapa waktu yang lalu saya pernah mengalami mengalami error tersebu…

22Oct2013

CRUD dengan VB.NET bagian 1

<span style="font-family: Arial, Helvetica, sans-serif;">Malam semua sebelum saya menlanjutkan postingan ini ada baiknya anda membaca<a href="http://adf.ly/cvtUd" rel="nofollow" target="_blank"> cara mengkoneksikan VB.NET ke SQL Server 2008</a> kali ini saya akan memposting tutorial CRUD dengan VB.NET</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Apa itu CRUD? CRUD singkatan dari CREATE, RENAME, UPDATE, DELETE<b style="background-color: white; color: #555555; font-size: 12px; line-height: 20px;">. </b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b style="background-color: white; line-height: 20px;">CRUD</b><span style="background-color: white; line-height: 20px;"> adalah operasi </span><b style="background-color: white; line-height: 20px;">Create</b><span style="background-color: white; line-height: 20px;">, </span><b style="background-color: white; line-height: 20px;">read</b><span style="background-color: white; line-height: 20px;">, </span><b style="background-color: white; line-height: 20px;">update</b><span style="background-color: white; line-height: 20px;">, dan </span><b style="background-color: white; line-height: 20px;">delete</b><span style="background-color: white; line-height: 20px;"> pada database. Jadi tentu kita butuh database untuk menerapkan </span><b style="background-color: white; line-height: 20px;"><u>CRUD</u></b><span style="background-color: white; line-height: 20px;">. sebelum memulai CRUD dengan VB.NET ada baiknya anda membaca <a href="http://adf.ly/cvcGa" rel="nofollow" target="_blank">Syntak Dasar SQL Server</a>.</span></span><br />
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: white; line-height: 20px;">Oke langsung saja </span></span></div>
<div>
<br />
<span style="background-color: white; font-family: Arial, Helvetica, sans-serif; line-height: 20px;">1. Tambahkan sebuah table ke database latihan sebagai berikut:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif; line-height: 20px;">create table siswa</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">(nis varchar(10) not null primary key,</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">nm_siswa varchar(30) not null,</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">alamat varchar(50) not null,</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">jenis_kelamin varchar(15) not null )</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">2. Buka project yang kita buat sebelumnya yang bernama KoneksiKeSqlServer </span></span><br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">3. Setelah project berhasil dibuka lalu Klik menu Project - Add Windows Form pada kolom Name ketikan FrmCrud</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEij6GVXVdbMs3kwEnpPtE66R2ZkPwIfwBIeMVmRSPmeJuTX8K2sUGJF0JXVybOUstXo5tL8riDoBGJRZJoPZv6lR_9qI291oCLQlXsdpFiluTATmSzBVgbWrzPR1Gd0E07L4X0P05PbDLRt/s1600/Screenshot_1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="CRUD dengan VB.NET bagian 1" border="0" height="177" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEij6GVXVdbMs3kwEnpPtE66R2ZkPwIfwBIeMVmRSPmeJuTX8K2sUGJF0JXVybOUstXo5tL8riDoBGJRZJoPZv6lR_9qI291oCLQlXsdpFiluTATmSzBVgbWrzPR1Gd0E07L4X0P05PbDLRt/s320/Screenshot_1.png" title="CRUD dengan VB.NET bagian 1" width="320" /></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">4. lalu desain form seperti gambar dibawah ini</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifhu9904w698_UYtX8nldN2Wo5BMWjRMil_Zv2t3woYdDfPYlmu-HttNS0wvuZyR5vX5Z7OyjKZpF61oriODUlTZT0mgJ7JjeK9EfMYC0vDboFChzMvVNeOVbG9j4TERPxJKEDSOD61Gqu/s1600/CRUD_dengan_VB.NET_bagian_1_2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="CRUD dengan VB.NET bagian 1" border="0" height="175" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifhu9904w698_UYtX8nldN2Wo5BMWjRMil_Zv2t3woYdDfPYlmu-HttNS0wvuZyR5vX5Z7OyjKZpF61oriODUlTZT0mgJ7JjeK9EfMYC0vDboFChzMvVNeOVbG9j4TERPxJKEDSOD61Gqu/s320/CRUD_dengan_VB.NET_bagian_1_2.png" title="CRUD dengan VB.NET bagian 1" width="320" /></a></div>
<br />
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184;">
 <tbody>
<tr>
  <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
Object</div>
</td>
  <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
Property<o:p></o:p></div>
</td>
  <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
Value<o:p></o:p></div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Textbox1<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Name<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Txt_nis<o:p></o:p></div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Textbox2<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Name<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Txt_nama<o:p></o:p></div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Textbox3<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Name<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Txt_alamat<o:p></o:p></div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Combobox1<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Name<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Cbo_kelamin<o:p></o:p></div>
</td>
 </tr>
<tr style="height: 4.85pt; mso-yfti-irow: 5;">
  <td style="border-top: none; border: solid black 1.0pt; height: 4.85pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Button1<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; height: 4.85pt; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Name<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; height: 4.85pt; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Btn_cari<o:p></o:p></div>
</td>
 </tr>
<tr style="height: 4.85pt; mso-yfti-irow: 6;">
  <td style="border-top: none; border: solid black 1.0pt; height: 4.85pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; height: 4.85pt; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Text<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; height: 4.85pt; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Cari<o:p></o:p></div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Button2<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Name<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Btn_tambah<o:p></o:p></div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Text<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Tambah<o:p></o:p></div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Button3<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Name<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Btn_tutup<o:p></o:p></div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Text<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Tutup<o:p></o:p></div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Button4<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Name<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Btn_simpan<o:p></o:p></div>
</td>
 </tr>
<tr>
  <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Text<o:p></o:p></div>
</td>
  <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Simpan<o:p></o:p></div>
</td>
 </tr>
</tbody></table>
</div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: white; line-height: 20px;"><br /></span></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: white; line-height: 20px;">5. klik 2 kali pada form data siswa lalu ketikan script di bawah ini:</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">Imports System.Data.SqlClient</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">Imports System.Xml</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">Public Class FrmCrud</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    Sub awal()</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_nis.Text = ""</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_nama.Text = ""</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_alamat.Text = ""</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Cbo_kelamin.Text = ""</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Cbo_kelamin.Items.Clear()</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Cbo_kelamin.Items.Add("Laki - Laki")</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Cbo_kelamin.Items.Add("Perempuan")</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_tutup.Text = "Tutup"</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_cari.Enabled = False</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_simpan.Enabled = False</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_tambah.Enabled = True</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_tutup.Enabled = True</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_nis.Enabled = False</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_nama.Enabled = False</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_alamat.Enabled = False</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Cbo_kelamin.Enabled = False</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    End Sub</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    Private Sub FrmCrud_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Call ambilkoneksi()</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Call awal()</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    End Sub</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    Private Sub Btn_tambah_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_tambah.Click</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_nis.Enabled = True</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_nama.Enabled = True</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_alamat.Enabled = True</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Cbo_kelamin.Enabled = True</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_simpan.Enabled = True</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_cari.Enabled = True</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_tambah.Enabled = False</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_tutup.Text = "Batal"</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    End Sub</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    Private Sub Btn_simpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_simpan.Click</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        If Txt_nis.Text = "" Or Txt_nama.Text = "" Or Txt_alamat.Text = "" Or Cbo_kelamin.Text = "" Then</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            MsgBox("Data belum lengkap", MsgBoxStyle.Information, "Informasi")</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Else</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            cmd = New SqlCommand("select nis from siswa where nis='" & Txt_nis.Text & "'", conn)</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            rd = cmd.ExecuteReader</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            rd.Read()</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            If rd.HasRows Then</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                MsgBox("NIS Sudah digunakan", MsgBoxStyle.Information, "informasi")</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                rd.Close()</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            Else</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                rd.Close()</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                cmd = New SqlCommand("insert into siswa (nis,nm_siswa,alamat,jenis_kelamin) values ('" & Txt_nis.Text & "','" & Txt_nama.Text & "','" & Txt_alamat.Text & "','" & Cbo_kelamin.Text & "')", conn)</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                cmd.ExecuteNonQuery()</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                MsgBox("Data berhasil disimpan", MsgBoxStyle.Information, "Informasi")</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                Call awal()</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            End If</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        End If</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">       </span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    End Sub</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    Private Sub Btn_tutup_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_tutup.Click</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        If Btn_tutup.Text = "Batal" Then</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            Call awal()</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Else</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            Me.Close()</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        End If</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    End Sub</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    Private Sub Btn_cari_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_cari.Click</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        If Txt_nis.Text = "" Then</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            MsgBox("Nis masih kosong", MsgBoxStyle.Exclamation, "Peringatan")</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Else</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        cmd = New SqlCommand("select nis,nm_siswa,alamat,jenis_kelamin from siswa where nis='" & Txt_nis.Text & "'", conn)</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        rd = cmd.ExecuteReader</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        rd.Read()</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            If rd.HasRows Then</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                Txt_nis.Text = rd("nis")</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                Txt_nama.Text = rd("nm_siswa")</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                Txt_alamat.Text = rd("alamat")</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                Cbo_kelamin.Text = rd("jenis_kelamin")</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                Btn_simpan.Enabled= False</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            Else</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                MsgBox("Data tidak ditemukan")</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            End If</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            rd.Close()</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        End If</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    End Sub</span></span><br />
<span style="line-height: 20px;"><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"></span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">End Class</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">6. Lalu jalankan program dengan cara tekan F5,</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgam9Gz2rFtAB88tGZfSqcYxE8Z9bpPtc8BkZP3QJ_bgKPaA_77ZjacK8lvQ0ieGj6sm-wrzmqku5aglkEukI0Xn10p-2EXNYgtnDWID-0B1zvK6uxknDTfU_W_PPaUp2V23CiiHtQTw5uE/s1600/CRUD_dengan_VB.NET_Bagian_1_3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="CRUD dengan VB.NET bagian 1" border="0" height="178" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgam9Gz2rFtAB88tGZfSqcYxE8Z9bpPtc8BkZP3QJ_bgKPaA_77ZjacK8lvQ0ieGj6sm-wrzmqku5aglkEukI0Xn10p-2EXNYgtnDWID-0B1zvK6uxknDTfU_W_PPaUp2V23CiiHtQTw5uE/s320/CRUD_dengan_VB.NET_Bagian_1_3.png" title="CRUD dengan VB.NET bagian 1" width="320" /></a></div>
<span style="font-family: Arial, Helvetica, sans-serif; line-height: 20px;"><br /></span>
<br />
<blockquote class="tr_bq">
<div style="text-align: center;">
Jika anda ingin mendownload source code silahkan klik <a href="http://adf.ly/cshu9" rel="nofollow" target="_blank">disini</a></div>
<div style="text-align: center;">
dan untuk passwordnya <a href="http://adf.ly/fHCDH">disini</a></div>
</blockquote>
<span style="font-family: Arial, Helvetica, sans-serif; line-height: 20px;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif; line-height: 20px;">semoga berhasil</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">sekian postingan saya kali ini.</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">untuk selanjutnya pada postingan CRUD dengan VB.NET bagian 2 saya akan menambahkan Update dan Delete data</span></span></div>

CRUD dengan VB.NET bagian 1

Malam semua sebelum saya menlanjutkan postingan ini ada baiknya anda membaca cara mengkoneksikan VB.NET ke SQL Server 2008 kali ini saya akan memposting tutorial CRUD dengan VB.NET Apa itu CRUD? CRUD singkatan dari CREATE, RENAME, UPDATE, DELETE. CRUD adalah operasi Create, read, update, dan delete…

22Oct2013

Memasang Alexa Rank Di Blog

<span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Malam semua kali ini saya akan posting tetang cara Memasang Alexa Rank Di Blog,sebelumnya kita harus mengetahui apakah yang dimaksud dengan Alexa Rank?</span><br />
<span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Alexa Traffic Rank adalah perkiraan secara kasar popularitas sebuah Blog atau Website di negara tertentu maupun secara Global.bahkan banyak situs-situs yang terkenal juga menggunakannya, menjadikannya salah satu rujukan peringkat sebuah situs.</span><br /><br />
<div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;">
<a href="http://1.bp.blogspot.com/-MZJlL-edbtM/UdmMjXjg2BI/AAAAAAAAFRc/GOKBnwQ_zfE/s1600/New+Picture.jpg" imageanchor="1" style="clear: left; color: #0c6708; float: left; margin-bottom: 1em; margin-right: 1em; text-decoration: none;"><img alt="Memasang Alexa Rank Di Blog" border="0" height="120" src="http://1.bp.blogspot.com/-MZJlL-edbtM/UdmMjXjg2BI/AAAAAAAAFRc/GOKBnwQ_zfE/s200/New+Picture.jpg" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" title="Memasang Alexa Rank Di Blog" width="200" /></a></div>
<span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Alexa menyediakan informasi mengenai popularitas banyaknya pengunjung harian, tampilan halaman, kata kunci, kategori dan lainnya yang perbaharui (update) setiap hari. Maka dengan memasang Alexa akan mendapatkan keuntungan lebih, agar analisa data-data lebih akurat.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><br />
<span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Untuk menggunakan Alexa tidak selalu harus memasang widget-nya, tetapi yang paling penting adalah memasang meta name-nya diletakan dibagian "head".</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Daftar Alexa ada yg gratis dan berbayar, Berikut cara memasang Alexa meta name, langkah ini digunakan untuk mengklaim kepemilikan sebuah situs:</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">1. Kunjungi situs alexa.com</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">2. Daftar (Create an Account alias sign up) seperti pada umumnya menggunakan email ataupun facebook.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">3. Verifikasi email dari alexa (jika menggunakan email) Klik link tautannya.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">    Verifikasi notifikasi jika menggunakan facebook.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">    Kalau sudah masuk, diatas biasanya ada tulisan 'Welcome'.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">4. Setelah selesai verifikasi, kunjungi halaman   http://www.alexa.com/siteowners/claim</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">    Perhatikan: Pilih Verify Ownership (Select Verify)</span><br />
<div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;">
<br /></div>
<div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;">
<a href="http://1.bp.blogspot.com/-53EHN3CF50M/UdmGNzSQDDI/AAAAAAAAFP8/MVf0Yk-p7JY/s1600/Verify+Ownership+1.jpg" imageanchor="1" style="color: #0c6708; text-decoration: none;"><img border="0" src="http://1.bp.blogspot.com/-53EHN3CF50M/UdmGNzSQDDI/AAAAAAAAFP8/MVf0Yk-p7JY/s1600/Verify+Ownership+1.jpg" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; background-position: initial initial; background-repeat: initial initial; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" width="450" /></a></div>
<br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">5. Masukan nama Blog atau website dalam kotak tersedia, jika sudah yakin pilihannya maka lanjutkan (Get Started).</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">6. Halaman berikutnya Pilih Free (Yang Gratis).</span><br />
<div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;">
<br /></div>
<div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;">
<a href="http://4.bp.blogspot.com/-nWGQfgh1dOk/UdmI6Q-wolI/AAAAAAAAFQk/JzvjNxACH5M/s1600/Free.jpg" imageanchor="1" style="color: #0c6708; text-decoration: none;"><img border="0" src="http://4.bp.blogspot.com/-nWGQfgh1dOk/UdmI6Q-wolI/AAAAAAAAFQk/JzvjNxACH5M/s1600/Free.jpg" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; background-position: initial initial; background-repeat: initial initial; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" width="450" /></a></div>
<br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">7. Di Halaman </span><b style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Claim Your Site</b><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">    Pilih metode yang kedua (</span><b style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">option 2</b><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">) untuk verifikasi situs, Pilihan ini direkomendasikan.</span><br />
<div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;">
<br /></div>
<div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;">
<a href="http://3.bp.blogspot.com/-nFzxoAIC5ps/UdmI697XYCI/AAAAAAAAFQ8/7HfmM4zINpc/s1600/Meta+Name.png" imageanchor="1" style="color: #0c6708; text-decoration: none;"><img border="0" src="http://3.bp.blogspot.com/-nFzxoAIC5ps/UdmI697XYCI/AAAAAAAAFQ8/7HfmM4zINpc/s1600/Meta+Name.png" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; background-position: initial initial; background-repeat: initial initial; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" width="600" /></a></div>
<br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Keterangan gbr, contoh <meta name=”alexaVerifyID” content=”</span><b style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">xxxxxxxxxxxxxxxxx</b><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">” /></span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">8. Buka Tab Halaman baru, Login ke Blog, buka Template Blog anda (Edit Template), Copy dan masukan kode meta name yang diberi tanda, di bagian “head” template atau diatas</span><b style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;"><b:skin></b><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;"> setelah itu save template.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">9. Kembali ke halaman verifikasi Alexa, kemudian Klik Verify my ID, Jika benar maka akan ada notifikasi berhasil - your site is succesfully claimed.</span><br />
<div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;">
<br /></div>
<div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;">
<a href="http://3.bp.blogspot.com/-Vz3oH4Iciw0/UdmI6E5iCmI/AAAAAAAAFQc/F2Hngt2DfsM/s1600/Claimed.png" imageanchor="1" style="color: #0c6708; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="76" src="http://3.bp.blogspot.com/-Vz3oH4Iciw0/UdmI6E5iCmI/AAAAAAAAFQc/F2Hngt2DfsM/s320/Claimed.png" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; background-position: initial initial; background-repeat: initial initial; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" width="320" /></a></div>
<br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">10. Sampai langkah ini sebenarnya telah selesai. Tambahan berikut, jika melakukan langkah berikutnya bisa mengisi data-data jika diinginkan (pilihan mau diisi atau tidak).</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><br />
<div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;">
<a href="http://1.bp.blogspot.com/-oNGQPCj9Ekk/UdmI6dnPrYI/AAAAAAAAFQs/I285jHZBdyo/s1600/Data.jpg" imageanchor="1" style="color: #0c6708; text-decoration: none;"><img border="0" src="http://1.bp.blogspot.com/-oNGQPCj9Ekk/UdmI6dnPrYI/AAAAAAAAFQs/I285jHZBdyo/s1600/Data.jpg" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; background-position: initial initial; background-repeat: initial initial; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" width="400" /></a></div>
<br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Demikian cara memasang meta name Alexa, mudah-mudahan bermanfaat. Jika sudah terpasang, mudah-mudahan analisa terhadap Alexanya lebih akurat, karena telah terdaftar. Jika anda ingin memasang widgetnya pun mudah, tergantung kemauan.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Berikut </span><b style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Cara Memasang Widget Alexa Di Blog</b><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">1. Kunjungi link ini   http://www.alexa.com/siteowners/widgets</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">2. Masukan URL Blog kedalam Kotak sesuai widget yang diinginkan, Klik Build Widget.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><br />
<div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;">
<a href="http://3.bp.blogspot.com/-7WQzLrudm_s/UdmI7ZKEDRI/AAAAAAAAFRA/ZmHzC1lU8fc/s1600/Widget.jpg" imageanchor="1" style="color: #0c6708; text-decoration: none;"><img border="0" src="http://3.bp.blogspot.com/-7WQzLrudm_s/UdmI7ZKEDRI/AAAAAAAAFRA/ZmHzC1lU8fc/s1600/Widget.jpg" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; background-position: initial initial; background-repeat: initial initial; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" width="600" /></a></div>
<br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">3. Copy Kode yang tersedia dalam kotak sesuai model widgetnya.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><br />
<div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;">
<a href="http://3.bp.blogspot.com/-35u34_4mJr4/UdmI7V4Ug6I/AAAAAAAAFQ4/7QaIL-2lWmw/s1600/kode+widget.jpg" imageanchor="1" style="color: #0c6708; text-decoration: none;"><img border="0" src="http://3.bp.blogspot.com/-35u34_4mJr4/UdmI7V4Ug6I/AAAAAAAAFQ4/7QaIL-2lWmw/s1600/kode+widget.jpg" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; background-position: initial initial; background-repeat: initial initial; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" width="600" /></a></div>
<br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">4. Masukan kode widgetnya di Add a Gadget (HTML/JavaScript)  Di Blog.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">    atau dimana saja ingin dipasangkan pada Template di dalam Blog.</span><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">.</span>

Memasang Alexa Rank Di Blog

Malam semua kali ini saya akan posting tetang cara Memasang Alexa Rank Di Blog,sebelumnya kita harus mengetahui apakah yang dimaksud dengan Alexa Rank? Alexa Traffic Rank adalah perkiraan secara kasar popularitas sebuah Blog atau Website di negara tertentu maupun secara Global.bahkan banyak situs-si…

19Oct2013

Syntak Dasar SQL

<div class="" style="clear: both; text-align: left;">
<span style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt; margin: 0px; padding: 0px; vertical-align: baseline;">Malam semua <a href="http://dwirandyherdinanto.blogspot.com/2013/10/cara-menginstal-sql-server-2008_12.html" target="_blank"> </a>kali ini saya akan posting tentang <span style="color: blue;"><a href="http://dwirandyherdinanto.blogspot.com/2013/10/syntak-dasar-sql-server.html" rel="nofollow" target="_blank">Syntak Dasar SQL </a> </span>Secara umum, SQL terdiri dari dua bahasa, yaitu</span><span style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt; margin: 0px; padding: 0px; vertical-align: baseline;"><b><i> </i></b></span><span style="color: black; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt;"><b><i><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="color: black;">Data Definition</span> Language</span><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> (DDL)</span></i></b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> dan </span><a href="http://id.wikipedia.org/w/index.php?title=Data_Manipulation_Language&action=edit&redlink=1" style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;" title="Data Manipulation Language (halaman belum tersedia)"><i><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="color: black;"><b>Data</b><span style="font-style: normal;"> </span><b>Manipulation Language</b></span></span></i></a><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><i><b> (DML). </b></i></span></span></div>
<div class="post-body entry-content" style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; width: 580px;">
<div class="MsoNormal" style="border: 0px; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">baiklah saya akan menjelaskan pengertian Data Definition Language (DDL) dan Data Manipulation Language(DML)</span></div>
<div class="MsoNormal" style="border: 0px; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="MsoNormal" style="border: 0px; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><i>Data Definition Language</i><span style="font-style: normal; font-weight: 100;"><o:p></o:p></span></span></span></b></div>
<div class="MsoNormal" style="border: 0px; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">DDL digunakan untuk mendefinisikan, mengubah, serta menghapus </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">basis data</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> dan objek-objek yang diperlukan dalam basis data, misalnya </span><i><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;">tabel</span><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">, </span><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;">view</span><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;">, </span><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;">user</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;">, dan sebagainya. Secara umum, DDL yang digunakan adalah </span><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"><i>CREATE</i></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"> untuk membuat objek baru, </span><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"><i>USE</i></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"> untuk menggunakan objek, </span><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"><i>ALTER</i></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"> untuk mengubah objek yang sudah ada, dan </span><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"><i>DROP</i></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"> untuk menghapus objek. DDL biasanya digunakan oleh </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">administrator</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"> basis data dalam pembuatan sebuah </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">aplikasi</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"> basis data.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>CREATE</b></span><b style="font-weight: 100;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><o:p></o:p></span></b></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>CREATE</b></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="color: lime;"> </span>digunakan untuk membuat basis data maupun objek-objek basis data. SQL yang umum digunakan adalah:</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: #f9f9f9; line-height: 20.796875px;"><b><span style="font-family: Georgia, Times New Roman, serif;">CREATE DATABASE nama_basis_data</span></b></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="background-color: #f9f9f9; line-height: 20.796875px;"><b><span style="font-family: Georgia, Times New Roman, serif;">CREATE TABLE nama_tabel</span></b></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt; margin: 0px; padding: 0px; vertical-align: baseline;"><b>CREATE TABLE</b></span><span style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt; margin: 0px; padding: 0px; vertical-align: baseline;"> membuat tabel baru pada basis data yang sedang aktif. Secara umum, perintah ini memiliki bentuk</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<b style="font-family: Georgia, 'Times New Roman', serif; line-height: 15.6pt;">CREATE TABLE [<i>nama_tabel</i>]</b></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><b>(<o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><b>nama_field1 tipe_data [constraints][,<o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><b>nama_field2 tipe_data,<o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><b>...]<o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><b>)</b></span></span></div>
</div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Keterangan :<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><i style="font-style: normal; font-weight: 100;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">nama_field</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> adalah nama</span><i><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">kolom</span><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> (field)</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> yang akan dibuat. Beberapa sistem manajemen basis data mengizinkan penggunaan spasi dan karakter nonhuruf pada nama kolom.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><i style="font-style: normal;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">tipe_data</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> tergantung implementasi sistem manajemen basis data. Misalnya, pada </span><a href="http://id.wikipedia.org/wiki/MySQL" style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;" title="MySQL"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="color: black;">MySQL</span></span></a><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, tipe data dapat berupa </span><i><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">VARCHAR</span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">TEXT</span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">BLOB</span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">ENUM</span></i><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><i>, dan sebagainya.</i><o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><i style="font-style: normal;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">constraints</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> adalah batasan-batasan yang diberikan untuk tiap kolom. Ini juga tergantung implementasi sistem manajemen basis data, misalnya </span><i><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">NOT NULL</span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">UNIQUE</span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">,</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> dan sebagainya. Ini dapat digunakan untuk mendefinisikan </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><i>kunci primer</i></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> (<i>primary key</i>) dan </span><i><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">kunci </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;">tamu</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> (<i>foreign key</i>).<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Satu tabel boleh tidak memiliki kunci primer sama sekali, namun sangat disarankan mendefinisikan paling tidak satu kolom sebagai kunci primer.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh:</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b></b></span><br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">CREATE TABLE user<o:p></o:p></span></span></b></span></div>
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>
</b></span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">(<o:p></o:p></span></span></b></span></div>
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>
</b></span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">username VARCHAR(15) CONSTRAINT PRIMARY KEY,<o:p></o:p></span></span></b></span></div>
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>
</b></span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">password VARCHAR(20) NOT NULL,<o:p></o:p></span></span></b></span></div>
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>
</b></span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">tgl_lahir DATETIME<o:p></o:p></span></span></b></span></div>
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>
</b></span>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">);</span></span></b></span></div>
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>
</b></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">akan membuat tabel </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">user</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> seperti berikut:<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="background-color: #f9f9f9; border-collapse: collapse; border: none; margin: 0px; padding: 0px; text-align: center; vertical-align: baseline;"><tbody style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
<tr style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><u><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">username</span></u></b><b><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><o:p></o:p></span></b></span></div>
</td><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<b><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">password<o:p></o:p></span></span></b></div>
</td><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<b><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">tgl_lahir</span></span></b></div>
</td></tr>
</tbody></table>
</div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 18pt;"><br /></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<a href="http://id.wikipedia.org/w/index.php?title=Data_Manipulation_Language&action=edit&redlink=1" style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 24px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;" title="Data Manipulation Language (halaman belum tersedia)"><i><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="color: black;"><b>Data</b><span style="font-style: normal;"> </span><b>Manipulation Language</b></span></span></i></a><span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 18pt;"><br />DML digunakan untuk memanipulasi data yang ada dalam suatu tabel. Perintah yang umum dilakukan adalah: </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><b>Data Manipulation Language<o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-variant: normal; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;">  </span></span></span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">untuk menampilkan data<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-variant: normal; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></span></span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;">INSERT</span></b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> untuk menambahkan data baru</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-weight: 100; line-height: 18pt; margin: 0px; padding: 0px; text-indent: -0.25in; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></span></span><span style="border: 0px; line-height: 18pt; margin: 0px; padding: 0px; text-indent: -0.25in; vertical-align: baseline;"><b>UPDATE</b></span><span style="border: 0px; line-height: 18pt; margin: 0px; padding: 0px; text-indent: -0.25in; vertical-align: baseline;"><b> </b>untuk mengubah data yang sudah ada</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-variant: normal; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></span></span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;">DELETE</span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">untuk menghapus data<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></b></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span></b><b style="font-weight: 100;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><o:p></o:p></span></b></span></div>
<div class="MsoNormal" style="border: 0px; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b style="font-style: normal;"><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">adalah perintah yang paling sering digunakan pada SQL,</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>SELECT</b></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> digunakan untuk menampilkan data dari satu atau lebih tabel, biasanya dalam sebuah basis data yang sama. Secara umum, perintah </span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>SELECT</b></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> memiliki bentuk lengkap: ( </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><i>QUERY BUDIN</i></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> )</span></span></div>
<div class="MsoNormal" style="border: 0px; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT [nama_tabel|alias.]nama_field1 [AS alias1] [, nama_field2, ...]<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM nama_tabel1 [AS alias1] [INNER|LEFT|RIGHT JOIN tabel2 ON <i>kondisi_penghubung</i>]<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">[, nama_tabel3 [AS alias3], ...]<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">[WHERE <i>kondisi</i>]<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">[ORDER BY nama_field1 [ASC|DESC][, nama_field2 [ASC|DESC], ...]]<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">[GROUP BY nama_field1[, nama_field2, ...]]<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">[HAVING <i>kondisi_aggregat</i>]</span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Keterangan :</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></span></span><i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">kondisi</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> adalah syarat yang harus dipenuhi suatu data agar ditampilkan.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-weight: 100; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></span></span><i style="font-style: normal;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">kondisi_aggregat</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> adalah syarat khusus untuk </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"><i>fungsi aggregat</i></span></span></div>
<div class="MsoNormal" style="border: 0px; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">Kondisi dapat dihubungkan dengan </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><i>operator logika</i></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, misalnya </span><i><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">AND</span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">OR</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, dan sebagainya.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh:<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">Diasumsikan terdapat tabel </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">user</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> yang berisi data sebagai berikut.<o:p></o:p></span></span></div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="background-color: #f9f9f9; border-collapse: collapse; border: none; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><tbody style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
<tr style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div align="center" class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">username</span></b><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><o:p></o:p></span></b></span></div>
</td><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div align="center" class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">password<o:p></o:p></span></span></b></div>
</td><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div align="center" class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">tgl_lahir<o:p></o:p></span></span></b></div>
</td><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div align="center" class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">jmlh_trans<o:p></o:p></span></span></b></div>
</td><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div align="center" class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">total_trans<o:p></o:p></span></span></b></div>
</td></tr>
<tr style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Abdi</span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">6487AD5EF<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">19-09-1997<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">6<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">10.000<o:p></o:p></span></span></div>
</td></tr>
<tr style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Bagoes<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">97AD4erD<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">21-11-1994<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">3</span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">33.000</span></div>
</td></tr>
<tr style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Chairul<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">548794654<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">06-08-1990<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">24<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">312.150<o:p></o:p></span></span></div>
</td></tr>
<tr style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Dani<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FLKH947HF<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">02-04-1990<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">5</span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">12000</span></div>
</td></tr>
<tr style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Eka<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">94RER54<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">15-08-1995<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">34<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">50.000<o:p></o:p></span></span></div>
</td></tr>
</tbody></table>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh Pertama : Cara tampilkan seluruh data.</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"></span><br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT *<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM user</span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh 2: Tampilkan pengguna yang memiliki jumlah transaksi lebih dari 5</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"></span><br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT *<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM user<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">WHERE jmlh_trans > 5</span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh 3: Tampilkan username pengguna yang bertransaksi kurang dari 10 dan nilainya lebih dari 1.000.</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"></span><br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT username<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM user<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">WHERE jmlh_trans < 10 AND total_trans > 700</span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh 4: Tampilkan total nominal transaksi yang sudah terjadi.</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"></span><br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT SUM(total_trans) AS total_nominal_transaksi<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM user</span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh 5: Tampilkan seluruh data diurutkan berdasarkan jumlah transaksi terbesar ke terkecil.</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"></span><br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT *<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM user<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">ORDER BY jmlh_trans DESC</span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><b><br /></b></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><b>Fungsi aggregat<o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Beberapa SMBD memiliki fungsi aggregat, yaitu fungsi-fungsi khusus yang melibatkan sekelompok data (aggregat). Secara umum fungsi aggregat adalah:<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></span></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">SUM</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> untuk menghitung total nominal data<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">COUNT</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> untuk menghitung jumlah kemunculan data</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt; margin: 0px; padding: 0px; text-indent: -0.25in; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></span></span><span style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt; margin: 0px; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">AVG</span><span style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt; margin: 0px; padding: 0px; text-indent: -0.25in; vertical-align: baseline;"> untuk menghitung rata-rata sekelompok data</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">MAX</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> dan </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">MIN</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> untuk mendapatkan nilai maksimum/minimum dari sekelompok data.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">Fungsi aggregat digunakan pada bagian </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">. Syarat untuk fungsi aggregat diletakkan pada bagian </span><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">HAVING</span></b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, bukan </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">WHERE</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><b>Subquery<o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Ada kalanya <i>query</i> dapat menjadi kompleks, terutama jika melibatkan lebih dari satu tabel dan/atau fungsi aggregat. Beberapa SMBD mengizinkan penggunaan <i>subquery</i>. Contoh:<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Tampilkan username pengguna yang memiliki jumlah transaksi terbesar.</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"></span><br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT username<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM user<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">WHERE jmlh_trans =<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">(<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT MAX(jmlh_trans)<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM user<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">)</span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">INSERT</span></b><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><o:p></o:p></span></b></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">INSERT digunakan untuk menyimpan data dalam tabel dengan sintaks sebagai berikut :</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: #f9f9f9; font-family: Georgia, 'Times New Roman', serif; line-height: 20.796875px;">INSERT INTO [NAMA_TABLE] (NAMA_FIELD1,NAMA_FIELD2, NAMA_FIELD3) VALUES ('NILAI1', 'NILAI2', 'NILAI3');</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 20.796875px;">Contoh :</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 20.796875px;">INSERT INTO tbl_user (nama,alamat,password) VALUES ('Dwi Randy Herdinanto','Bandar Jaya','pass123')</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 20.796875px;"><br /></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">UPDATE</span></b><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><o:p></o:p></span></b></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Update digunakan untuk mengubah data dengan syntak sebagai berikut :</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: #f9f9f9; font-family: Georgia, 'Times New Roman', serif; line-height: 20.796875px;">UPDATE [NAMA_TABLE] SET [NAMA_FIELD]=[NILAI] WHERE [KONDISI]</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh:</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: #f9f9f9; font-family: Georgia, 'Times New Roman', serif; line-height: 20.796875px;">UPDATE tbl_user set password="pass123" where username="test"</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: #f9f9f9; font-family: Georgia, 'Times New Roman', serif; line-height: 20.796875px;"><br /></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">DELETE</span></b><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><o:p></o:p></span></b></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Delete digunakan untuk menghapus data dengan syntak sebagai berikut :</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: #f9f9f9; font-family: Georgia, 'Times New Roman', serif; line-height: 20.796875px;">DELETE FROM [NAMA TABLE] WHERE [KONDISI]</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh:</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: #f9f9f9; font-family: Georgia, 'Times New Roman', serif; line-height: 20.796875px;">DELETE FROM TEST WHERE NAMA='test';</span></span></div>
<div class="MsoNormal" style="border: 0px; font-family: inherit; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; clear: both; font-family: inherit; font-size: 13px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</div>
</div>

Syntak Dasar SQL

Malam semua kali ini saya akan posting tentang Syntak Dasar SQL Secara umum, SQL terdiri dari dua bahasa, yaitu Data Definition Language (DDL) dan Data Manipulation Language (DML). baiklah saya akan menjelaskan pengertian Data Definition Language (DDL) dan Data Manipulation Language(DML) Data De…

17Oct2013

Tutorial Koding

Membuat login aman dari SQL Injection

Mengatasi error "String or binary data would be truncated. The statement has been terminated."

CRUD dengan VB.NET bagian 1

Memasang Alexa Rank Di Blog

Syntak Dasar SQL

Popular Posts

Random

Recent Comment