Creative in the Art of Digital Technology: MYSQL

Tampilkan postingan dengan label MYSQL. Tampilkan semua postingan

Home > Posts filed under MYSQL

Tutorial CRUD Dengan Delphi 7 Koneksi MYSQL

<p><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg57FuWlqDIV6ghcpHJpLDwNZLrOo__Co349Vg58-VbDdGdTsbGzw7NV-VSGbw4ZTkQUWuIFWXlMYjT2e5Kalukp9H6oE1gyhvM7RVXSEi-vI15CxyXAPvqybQSldP1L2T6ENX7zIIcZs-d/s1600/crud1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="217" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg57FuWlqDIV6ghcpHJpLDwNZLrOo__Co349Vg58-VbDdGdTsbGzw7NV-VSGbw4ZTkQUWuIFWXlMYjT2e5Kalukp9H6oE1gyhvM7RVXSEi-vI15CxyXAPvqybQSldP1L2T6ENX7zIIcZs-d/s320/crud1.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
Gambar diatas merupakan hasil dari tutorial dibawah ini</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Baiklah sekarang saya akan membuat tutorial CRUD apa itu CRUD ?? hehee...CRUD itu adalah singkatan dari CREATE , READ , UPDATE dan DELETE udah tau yahh...  :D</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Tutorial ini adalah sambungan dari <a href="http://meta-aksara.blogspot.co.id/2017/05/mengkoneksikan-delphi-7-ke-mysql-dengan.html" target="_blank">Mengkoneksikan Delphi 7 ke MYSQL Dengan Zeoslib</a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
1.nah silakan kawan - kawan design tampilan FORM nya seperti dibawah ini :<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8SqiVgwPrIOi237LZ6vJbRoYzuKPIdyrI5mGI2EYjYB2gfaU0xizS80lIVxxBz558uglnubaIJwNkk7YeKiOJOXTupzqkjVwYGUuPhWLJG2rKD0Iewq0DIz1J0nHeuR5GHOk4eYUn8ASF/s1600/crud2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="221" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8SqiVgwPrIOi237LZ6vJbRoYzuKPIdyrI5mGI2EYjYB2gfaU0xizS80lIVxxBz558uglnubaIJwNkk7YeKiOJOXTupzqkjVwYGUuPhWLJG2rKD0Iewq0DIz1J0nHeuR5GHOk4eYUn8ASF/s320/crud2.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
2.Gambar diatas saya menambahkan component LABEL , EDIT dan BUTTON silakan sesuaikan yah tampilan nya.. serapih mungkin biar enak dilihat nya ... :p</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
3.Jika sudah kawan kawan sekarang klik 2 kali pada BUTTON -> TAMBAH dan ketik koding dibawah ini : </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both;">
procedure TForm1.Button1Click(Sender: TObject);</div>
<div class="separator" style="clear: both;">
begin</div>
<div class="separator" style="clear: both;">
     barang.Append;</div>
<div class="separator" style="clear: both;">
     Edit1.Enabled:=True;</div>
<div class="separator" style="clear: both;">
     Edit2.Enabled:=True;</div>
<div class="separator" style="clear: both;">
     Edit3.Enabled:=True;</div>
<div class="separator" style="clear: both;">
     Edit4.Enabled:=True;</div>
<div class="separator" style="clear: both;">
     Edit1.SetFocus;</div>
<div class="separator" style="clear: both;">
end;</div>
<br />
4.Lalu klik 2 kali pada BUTTON -> BATAL  dan  ketik koding dibawah ini :<br />
<br />
procedure TForm1.Button5Click(Sender: TObject);<br />
begin<br />
     Edit1.Clear;<br />
     Edit2.Clear;<br />
     Edit3.Clear;<br />
     Edit4.Clear;<br />
     Edit1.Enabled:=False;<br />
     Edit2.Enabled:=False;<br />
     Edit3.Enabled:=False;<br />
     Edit4.Enabled:=False;<br />
     barang.Cancel;<br />
end;<br />
<br />
5.Lalu klik 2 kali pada BUTTON -> SIMPAN dan ketik koding dibawah ini :<br />
<br />
procedure TForm1.Button4Click(Sender: TObject);<br />
begin<br />
     if Edit1.Text = '' then<br />
        begin<br />
             ShowMessage('Kode Barang Masih Kosong');<br />
             Exit;<br />
        end<br />
        else<br />
            begin<br />
                   barangkdbrg.Value    :=Edit1.Text;<br />
                   barangnamabrg.Value  :=Edit2.Text;<br />
                   barangjenisbrg.Value :=Edit3.Text;<br />
                   barangqty.Value      :=StrToInt(Edit4.Text);<br />
                   barang.Post;<br />
                   ShowMessage('Data Tersimpan');<br />
<br />
                   Edit1.Clear;<br />
                   Edit2.Clear;<br />
                   Edit3.Clear;<br />
                   Edit4.Clear;<br />
<br />
                   Edit1.Enabled:=False;<br />
                   Edit2.Enabled:=False;<br />
                   Edit3.Enabled:=False;<br />
                   Edit4.Enabled:=False;<br />
            end;<br />
<br />
6.Lalu klik 2 kali pada BUTTON -> GANTI dan ketik koding dibawah ini :<br />
<br />
procedure TForm1.Button2Click(Sender: TObject);<br />
begin<br />
     Edit1.Enabled:=True;<br />
     Edit2.Enabled:=True;<br />
     Edit3.Enabled:=True;<br />
     Edit4.Enabled:=True;<br />
<br />
     Edit1.Text   :=barangkdbrg.Value;<br />
     Edit2.Text   :=barangnamabrg.Value;<br />
     Edit3.Text   :=barangjenisbrg.Value;<br />
     Edit4.Text   :=IntToStr(barangqty.Value);<br />
<br />
     barang.Edit;<br />
<br />
    <br />
end;<br />
<br />
7..Lalu klik 2 kali pada BUTTON -> HAPUS dan ketik koding dibawah ini :<br />
<br />
procedure TForm1.Button3Click(Sender: TObject);<br />
begin<br />
        barang.delete;<br />
       Showmessage('Data Terhapus');<br />
end;<br />
<br />
<br />
OK..!! beres ... :D nah sekarang pencet F9 untuk menjalankan aplikasinya .. :D<br />
<br />
<br />
Create : Abednego,S.T<br />
<br />
<br />
<br /></p>

Gambar diatas merupakan hasil dari tutorial dibawah ini Baiklah sekarang saya akan membuat tutorial CRUD apa itu CRUD ?? hehee......

Mengkoneksikan Delphi 7 ke MYSQL Dengan Zeoslib

<p><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdm_2wzH5DSqkWmQB5GtHHDJi9aVo7APABAL73PTet3IZv3vtLuAM8qLqInRpjYci_gWluGgNXCq6olQLNwD74rEek9GU7Fiu758_f4zuJRGfvrdLlNRx59Qu9ul_pjLE4PVL5F7A7mQ7G/s1600/dbgrid14.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="197" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdm_2wzH5DSqkWmQB5GtHHDJi9aVo7APABAL73PTet3IZv3vtLuAM8qLqInRpjYci_gWluGgNXCq6olQLNwD74rEek9GU7Fiu758_f4zuJRGfvrdLlNRx59Qu9ul_pjLE4PVL5F7A7mQ7G/s320/dbgrid14.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
Gambar diatas merupakan hasil dari tutorial dibawah ini</div>
<br />
Tutorial ini adalah kelanjutan dari tutorial dari  <span style="background-color: white; color: #2b2828; font-family: "droid sans"; font-size: 23.4px;">Cara Instal Zeos Pada Delphi 7 </span><br />
bisa dilihat pada link disini : <span style="background-color: white; color: #2b2828; font-family: "droid sans";"><a href="http://meta-aksara.blogspot.co.id/2017/05/cara-instal-zeos-pada-delphi-7.html" target="_blank">Cara Instal Zeos Pada Delphi 7</a> <span style="font-size: x-small;"> </span></span><br />
nah apabila sudah di instal ZEOSLIB nya ... lalu sekarang adalah tahapan untuk mengkoneksikan DELPHI 7 ke database MYSQL dengan ZEOSLIB ...<br />
<br />
1.Buka apliakasi delphi 7<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0-GoYC0lITpsQ85F49h1IKd3yPyAUKqAnyCHUQN5A0uYtRRy_Jwge3nC3Tn3Sm7c45YAxN8tb0lJQj4ei-MigunZq0WmRoUseG8IPbsq_JrjXQOU77z0HK5tC229qoO4Vt9dGVf-wIfbY/s1600/form+delphi1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0-GoYC0lITpsQ85F49h1IKd3yPyAUKqAnyCHUQN5A0uYtRRy_Jwge3nC3Tn3Sm7c45YAxN8tb0lJQj4ei-MigunZq0WmRoUseG8IPbsq_JrjXQOU77z0HK5tC229qoO4Vt9dGVf-wIfbY/s320/form+delphi1.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
2.Cari pallet DATA CONTROLS</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj958wBF4pTV63b8m1D4zdK2Jk7FK27ehQY95jRTwH46ajCK8KjkgWHpAsywN6W8ju7wcuh4M88Mp3ERJNpQUF59ialfFLdfxzwyafDBy5W0HNjib1WRqzNq_aW9no9A2Q-9wlvEA3K1Jss/s1600/dbgrid.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="46" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj958wBF4pTV63b8m1D4zdK2Jk7FK27ehQY95jRTwH46ajCK8KjkgWHpAsywN6W8ju7wcuh4M88Mp3ERJNpQUF59ialfFLdfxzwyafDBy5W0HNjib1WRqzNq_aW9no9A2Q-9wlvEA3K1Jss/s320/dbgrid.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
3.Klik DBGRID dan simpan di FORM ... lalu sesuaikan tampilannya seperti gambar dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQHP7Q-z613bvE8PhGEmNk46rnAdsao2rzxjr472O5MLnjgE39dED_3FClJhL5zhUX4QTB4GSs5RrbBRxP8fumxrh-APoXEL-AwvR16-kWBHNLkCWnQDQRneYMNszBtZ7US6aqBcM7rDrL/s1600/dbgrid1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="183" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQHP7Q-z613bvE8PhGEmNk46rnAdsao2rzxjr472O5MLnjgE39dED_3FClJhL5zhUX4QTB4GSs5RrbBRxP8fumxrh-APoXEL-AwvR16-kWBHNLkCWnQDQRneYMNszBtZ7US6aqBcM7rDrL/s320/dbgrid1.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
4.Setelah design FORM nya sekarang kawan cari pallet Zeos Acces ligat gambar dibawah :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTjZSEJZiIZQ-6YJBfyX98l641sd93fzcqj8ucCpudISTOuvVlZLyYrAHvGUMyiTBjBA7dSZkULBjrL6qd_HtvYghtui47ftiuUoy_ZPfb2kfoXGCVT30uXlaAC9KwbrMaX6bhoT0f39qP/s1600/dbgrid2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="134" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTjZSEJZiIZQ-6YJBfyX98l641sd93fzcqj8ucCpudISTOuvVlZLyYrAHvGUMyiTBjBA7dSZkULBjrL6qd_HtvYghtui47ftiuUoy_ZPfb2kfoXGCVT30uXlaAC9KwbrMaX6bhoT0f39qP/s320/dbgrid2.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
5.Component dalam Zeoslib </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGJaAUDDCteJSzFxe5z_OLaCy0B5BxMB2pAq6_r6GXZvKc2TkpOA0mnmFS_4TwAIMGMBvlvsDJaKcnIolrwUXuOaWbYP9qP7-1HdcCSgzeBotcEtFdOGecLl5dc6XU9InEEvB3e2_7sQI2/s1600/dbgrid3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="36" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGJaAUDDCteJSzFxe5z_OLaCy0B5BxMB2pAq6_r6GXZvKc2TkpOA0mnmFS_4TwAIMGMBvlvsDJaKcnIolrwUXuOaWbYP9qP7-1HdcCSgzeBotcEtFdOGecLl5dc6XU9InEEvB3e2_7sQI2/s320/dbgrid3.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
6.Setelah itu kawan pilih Zconnection dan Zquery pada pallet Zeoslib tersebut seperti pada gambar dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5rnZZNhY6XIis_3PGvbFASfIxKfYnEff2UaeGUKTwh3INHQLddS0U36Ln3Rkw5vFNesxP5YK3o2ychL6f30XoaFl4lb69uRyP86N4mh45MpgUh6_HXOW8nvTu4uxV6zJ2eMR7ZEO5ODe4/s1600/dbgrid4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="244" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5rnZZNhY6XIis_3PGvbFASfIxKfYnEff2UaeGUKTwh3INHQLddS0U36Ln3Rkw5vFNesxP5YK3o2ychL6f30XoaFl4lb69uRyP86N4mh45MpgUh6_HXOW8nvTu4uxV6zJ2eMR7ZEO5ODe4/s320/dbgrid4.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
7.Setelah itu kawan cari component DATASOURCE pada pallet DATA ACCES seperti gambar dibah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgocAMAGaFVsdyRJYBFtKM38G7idG7IDkR-OzHp4wkVLVTh6PnbAcOXU3sBFzT4bz6LR0T_F_M-POvwG9XlZIYdfNPgqyTn2WxBuziy-aPqUwZc76Mi5UnhUfujgtrVgxyh1AeRBSZ6mgxd/s1600/dbgrid5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgocAMAGaFVsdyRJYBFtKM38G7idG7IDkR-OzHp4wkVLVTh6PnbAcOXU3sBFzT4bz6LR0T_F_M-POvwG9XlZIYdfNPgqyTn2WxBuziy-aPqUwZc76Mi5UnhUfujgtrVgxyh1AeRBSZ6mgxd/s1600/dbgrid5.jpg" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
8.Setelah itu kawan pilih DATASOURCE (DB) pada pallet DATA ACCES lihat gambar dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjY-499lmdFKoyZxAwgaFtQt3TZHt8HmTy1MPDGljM8T9YUdGE_Hlo9OCacKGSCLzrK8iMBN_yHjo5HDwwe-d_ItzUGxxLdyQDtHprn3RXRD8ZUomP3rm1U6qhuFp7fLc_sT9SzbdfiN1lG/s1600/dbgrid6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="246" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjY-499lmdFKoyZxAwgaFtQt3TZHt8HmTy1MPDGljM8T9YUdGE_Hlo9OCacKGSCLzrK8iMBN_yHjo5HDwwe-d_ItzUGxxLdyQDtHprn3RXRD8ZUomP3rm1U6qhuFp7fLc_sT9SzbdfiN1lG/s320/dbgrid6.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
9.nah component yang dibutuhkan sudah siap dipakai ... sekarang tinggal cara SETTING componentnya.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
10.Sekarang klik pada Zconnection nya dan silakan isi PROPERTIES nya seperti gambar dibawah ini:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj90zaVs6iX58I9jrobIONA_KdYDHjf4Gl7KfHSdBAlcQLxRWcrf6zd5xwLHEGTupsIkTE_HmP5cKdGVqBrmA8byG9rBbYu1AaG2I81DTUYZd2wV4hRg99KDrokW-zRk9RPOT35QdEFvmbT/s1600/dbgrid7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj90zaVs6iX58I9jrobIONA_KdYDHjf4Gl7KfHSdBAlcQLxRWcrf6zd5xwLHEGTupsIkTE_HmP5cKdGVqBrmA8byG9rBbYu1AaG2I81DTUYZd2wV4hRg99KDrokW-zRk9RPOT35QdEFvmbT/s320/dbgrid7.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
11.Jika sudah di SETTING ... sekarang klik pada ZQuery nya , lihat gambar dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3sQnWEeKAcqNdAayLjlqaxLkG0mp6iKSmlqiOKkzRNFmRJ-h5eeNr-EKHc2lgsrSV3U6b0_Id6gjlgyvHqtauD34Q1LLexrDqz6Hdt0j-kRiGPSo_VF75Z87z_2t_T-fxkmN_0iSSFOCA/s1600/dbgrid8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3sQnWEeKAcqNdAayLjlqaxLkG0mp6iKSmlqiOKkzRNFmRJ-h5eeNr-EKHc2lgsrSV3U6b0_Id6gjlgyvHqtauD34Q1LLexrDqz6Hdt0j-kRiGPSo_VF75Z87z_2t_T-fxkmN_0iSSFOCA/s320/dbgrid8.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
12.Setelah itu masih pada ZQuery ... kawan cari PROPERTIES pada ZQuery  -> SQL (String) </div>
<div class="separator" style="clear: both; text-align: left;">
jika sudah menemukan klik BUTTON yang kecil tersebut ... maka tampilannya akan berubah menjadi seperti ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzNlISeFNyKw-fEVbJVEDvD4vZR89nNk95MbOck7ru_yAfVOBh9r3Q7W6nAfa0nrI1kzie-aqelF6FX2xEf9iR0gptJ6XL1rwtgo3AWRna7hx6Ctk8iRMezkqXqklogy4BdHl_zasxky4H/s1600/dbgrid9.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="206" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzNlISeFNyKw-fEVbJVEDvD4vZR89nNk95MbOck7ru_yAfVOBh9r3Q7W6nAfa0nrI1kzie-aqelF6FX2xEf9iR0gptJ6XL1rwtgo3AWRna7hx6Ctk8iRMezkqXqklogy4BdHl_zasxky4H/s320/dbgrid9.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
13.Nah sekarang tinggal memasukan Query nya ... silakan ketik Querynya seperti ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFLczrxNOtfMzJom1twvdj2nmRNpfmAMw8cDcx5YcJGSvNBAJJ4vkZeiSQRD0SHbJhAO0-ozISqYT7py13a-AEndWmQB9P7BXFKiWNVxiI5DL2FVJ4YxIaLnos9992GJ3XBQoKlCBepbpU/s1600/dbgrid10.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="204" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFLczrxNOtfMzJom1twvdj2nmRNpfmAMw8cDcx5YcJGSvNBAJJ4vkZeiSQRD0SHbJhAO0-ozISqYT7py13a-AEndWmQB9P7BXFKiWNVxiI5DL2FVJ4YxIaLnos9992GJ3XBQoKlCBepbpU/s320/dbgrid10.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
14.Dan klik BUTTON OK...</div>
<div class="separator" style="clear: both; text-align: left;">
15.Masih pada ZQuery ... sekarang kawan cari PROPERTIES -> Active posisinya paling atas </div>
<div class="separator" style="clear: both; text-align: left;">
Active awalnya di isi dengan FALSE .. nah sekarang ganti dengan TRUE </div>
<div class="separator" style="clear: both; text-align: left;">
16.Dan sekarang kawan klik component DATASOURCE dan setting PROPERTIES nya seperti gambar dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPbtyd_S2GGzNaQl2CPciHolHVlNiUjA3qdPJo6n7x9HzZMe9dwtfILN2UB6NxRPysMqHdb-H7cmoxbiQJ3FLLUGYWxDmZDFi2gjZu9hMEhPqz29KRAiO-4Mem9YdxpNaEgthBs9NWPpS3/s1600/dbgrid11.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPbtyd_S2GGzNaQl2CPciHolHVlNiUjA3qdPJo6n7x9HzZMe9dwtfILN2UB6NxRPysMqHdb-H7cmoxbiQJ3FLLUGYWxDmZDFi2gjZu9hMEhPqz29KRAiO-4Mem9YdxpNaEgthBs9NWPpS3/s320/dbgrid11.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
17.Gambar diatas settingan nya belum di input nah sekarang lihat hasil setingan DATASOURCE tersebut pada gambar dibawah ini : </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1FM_IDP64yDrWGgDGd9si8OrrIzapehhD0w2_Vaw5gbxZZrS-mi8F0OxFnnR6-vxZPBaUtGGp8LGLmXKS_U2mDLrMKXfqcInWT6jQQ_y3e0AIP2TxFyFXzw6BVk3ywFCdsSJBs-hZBujq/s1600/dbgrid12.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="181" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1FM_IDP64yDrWGgDGd9si8OrrIzapehhD0w2_Vaw5gbxZZrS-mi8F0OxFnnR6-vxZPBaUtGGp8LGLmXKS_U2mDLrMKXfqcInWT6jQQ_y3e0AIP2TxFyFXzw6BVk3ywFCdsSJBs-hZBujq/s320/dbgrid12.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
18.Setingan DATASOURCE sudah beres ... nah sekarang kita seting DBGRID nya untuk tahapan akhir... sekarang klik pada DBGRID nya dan cari DATASOURCE pada PROPERTIES... jika sudah ketemu DATASOURCE nya silakan isi dengan "dsbarang" lihat gambar dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiL-AhK8dWfoDxPAgds6OhhhJjhYM6DMvBUWEGa_Hv_0mDgMQ499lmxNrOL0xNa9ne0zfkrpqYY9g-Ev7KQ_8ZErocM7tLzIl5ARbJtOGZE1ImsfnOSLEZAYiuIHw3nOxp9hK1YUswU_1XI/s1600/dbgrid13.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiL-AhK8dWfoDxPAgds6OhhhJjhYM6DMvBUWEGa_Hv_0mDgMQ499lmxNrOL0xNa9ne0zfkrpqYY9g-Ev7KQ_8ZErocM7tLzIl5ARbJtOGZE1ImsfnOSLEZAYiuIHw3nOxp9hK1YUswU_1XI/s320/dbgrid13.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
19.Sekarang kaawan pencet F9 untuk menjalakan APLIKASI nya.. :D</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Create : Abednego,S.T</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<br />
<span style="background-color: white; color: #2b2828; font-family: "droid sans"; font-size: 23.4px;"><br /></span>
<span style="background-color: white; color: #2b2828; font-family: "droid sans"; font-size: 23.4px;"><br /></span></p>

Gambar diatas merupakan hasil dari tutorial dibawah ini Tutorial ini adalah kelanjutan dari tutorial dari Cara Instal Zeos Pada Del...

Tutorial Membuat Database Dengan Navicat Part 3

<p><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlXlmv0yKKsstImyoJN2yoyEUNjcC7wKUt2p-KNWAGUKF5wAxjTPUc8sI73OAofsW0L1c9U8YL0OOwwzv1CIrxZpfQs2QkLIWc6SerA6kccCebYoXWlws3hfEZ4y6w_-T3FJoJa3eCA3NL/s1600/hasilquery2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="133" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlXlmv0yKKsstImyoJN2yoyEUNjcC7wKUt2p-KNWAGUKF5wAxjTPUc8sI73OAofsW0L1c9U8YL0OOwwzv1CIrxZpfQs2QkLIWc6SerA6kccCebYoXWlws3hfEZ4y6w_-T3FJoJa3eCA3NL/s320/hasilquery2.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
Gambar ini adalah hasil dari tutorial dibawah ini</div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: left;">
oke kita lanjutkan Tutorial Membuat Database Dengan Navicat Part 2 yang sebelumnya nah sekarang yang part 3 .. hehe... langsung saja ya... </div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
kita akan memasukan data pada tabel yang kita buat sebelumnya ... tahapannya adalah sebagai berikut :</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
1.klik menu query seperti gambar dibawah ini :</div>
<div style="text-align: left;">
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDnFFbHb5TZUbj349frwjJZTxy5DXXCvjejnx-kbXlHa7Ib5edTPfmxFoyuU2qKeWVEepGIL5hDvz4zTtRXcWoDRY6GhpBFQmVdU5JT2GlBzu-4eZC60WE4StMuZYZ6xUH2tLr2tQ7B86_/s1600/navicat8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDnFFbHb5TZUbj349frwjJZTxy5DXXCvjejnx-kbXlHa7Ib5edTPfmxFoyuU2qKeWVEepGIL5hDvz4zTtRXcWoDRY6GhpBFQmVdU5JT2GlBzu-4eZC60WE4StMuZYZ6xUH2tLr2tQ7B86_/s320/navicat8.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
2.ketik query nya seperti ini : INSERT into barang VALUES ('002','ASSUS ROG','LAPTOP',30)</div>
<div class="separator" style="clear: both; text-align: left;">
3.kalo sudah klik tombol RUN yang warna hijau </div>
<div class="separator" style="clear: both; text-align: left;">
4.dan hasilnya seperti gambar dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHyfc-4-yzGiL0A70U1oIwizRFFHIR1cQPqGR151MlaQ-tIqT-anJbC85ifZPR84cuLqeouWexyXh9BOyeKC8eIB-j1MSg6l6Lm1yaJCre8RbBtjUD3Blbi5z-WFVBDH8KVfo9uA4nHN26/s1600/hasilquery1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="198" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHyfc-4-yzGiL0A70U1oIwizRFFHIR1cQPqGR151MlaQ-tIqT-anJbC85ifZPR84cuLqeouWexyXh9BOyeKC8eIB-j1MSg6l6Lm1yaJCre8RbBtjUD3Blbi5z-WFVBDH8KVfo9uA4nHN26/s320/hasilquery1.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
5.berhasil dan sudah jadi isi dari tabel tersebut ... untuk mengeceknya kawan tinggal klik menu TABLE pada navicat hasilnya seperti digambar dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgvK__Ltk8ldYiMsKekH4MrPb1W_7d87e3t0f6DFfgvHAb_SS4dL7u6aZN4NpcAJ28PT19ytpMAD-rpatijxQzUYaFUVD7i3dsZa3pS23VVre1BF0HF2DO6a4QIoEjr_7HbNXsnssSAADD/s1600/tabel7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="178" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgvK__Ltk8ldYiMsKekH4MrPb1W_7d87e3t0f6DFfgvHAb_SS4dL7u6aZN4NpcAJ28PT19ytpMAD-rpatijxQzUYaFUVD7i3dsZa3pS23VVre1BF0HF2DO6a4QIoEjr_7HbNXsnssSAADD/s320/tabel7.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
6.lalu klik 2 kali pada tabel barang tersebut ... hasil tampilannya seperti gambar dibah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi73xP7QS-E-9_K6jfuZOxqRCSo8Mt00_YgPUw91nhianHJyQbdYc4fpoaB_4wRWoWNQi9gdNCX69-yyQFcg4hh5erwqh0t-Pnn0PdN5yiSBmIiShiNhRFxEpkBqP5lKM_DMsLwb9nOOOjz/s1600/hasilquery2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="133" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi73xP7QS-E-9_K6jfuZOxqRCSo8Mt00_YgPUw91nhianHJyQbdYc4fpoaB_4wRWoWNQi9gdNCX69-yyQFcg4hh5erwqh0t-Pnn0PdN5yiSBmIiShiNhRFxEpkBqP5lKM_DMsLwb9nOOOjz/s320/hasilquery2.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
dan berhasil ... :D sudah ada isinya tuh pada tabel barang...</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Create : Abednego,S.T </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
</div>
</p>

Gambar ini adalah hasil dari tutorial dibawah ini oke kita lanjutkan Tutorial Membuat Database Dengan Navicat Part 2 yang sebel...

Tutorial Membuat Database Dengan Navicat Part 2

<p><div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8_TdJLbAs_db0013-1d33LTyVXO5elENKVjtJ6m9rLpHM2CeOWAVxQF-0JM_QIeqopp4k_s9kLQJ3xrGT817HJoMH-UJUdtXy1tQLGTYqjRHqbix6w0FjV_2gkeLAkaXs7Jt0Bc9K23Bn/s1600/nav1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="162" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8_TdJLbAs_db0013-1d33LTyVXO5elENKVjtJ6m9rLpHM2CeOWAVxQF-0JM_QIeqopp4k_s9kLQJ3xrGT817HJoMH-UJUdtXy1tQLGTYqjRHqbix6w0FjV_2gkeLAkaXs7Jt0Bc9K23Bn/s320/nav1.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
Gambar ini adalah hasil dari tutorial dibawah ini</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
Tulisan sebelum nya tentang <a href="http://meta-aksara.blogspot.co.id/2017/05/tutorial-membuat-database-dengan-navicat.html" target="_blank">Tutorial Membuat Database Dengan Navicat Part 1</a> adalah cara membuat database... nah kali ini saya akan menjelaskan cara membuat tabel dengan navicat...<br />
saya akan memakai database yang sudah dibuat pada tutorial sebelumnya yahhh....ok langsung aja kita buat tabelnya... :D tahapannya sebgai berikut :<br />
<br />
1.buka navicatnya ..<br />
2.lihat pada kiri atas .. disitu ada nama database yang pernah kita buat sebelumnya<br />
3.klik 2 kali pada database nya.... nanti muncul tampilan gambar dibawah ini :<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6V5snEl6-QSi4Be_v4_CgJGZ8H2GDLJUDKCXwL0s7cvRp4Ehnw2QjyttdEDwCfRwENwNrxN91AH_PVIQS6DuB-Hi_IzvroDgUB9ajyAFdsoT6fk1_CmXyxceGE7h8zk0wINp18RBSw0i8/s1600/tabel1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6V5snEl6-QSi4Be_v4_CgJGZ8H2GDLJUDKCXwL0s7cvRp4Ehnw2QjyttdEDwCfRwENwNrxN91AH_PVIQS6DuB-Hi_IzvroDgUB9ajyAFdsoT6fk1_CmXyxceGE7h8zk0wINp18RBSw0i8/s1600/tabel1.jpg" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
4.nah disitu nama databasenya adalah "abcde" yang sebelumnya kita buat pada tutorial pertama</div>
<div class="separator" style="clear: both; text-align: left;">
5.setelah itu ada menu Queries pada database "abcde" tersebut silakan kalian pilih dan klik kanan Queriesnya dan klik NEW QUERY seperti gambar dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPqf7V7ADgfnk8-XE9pj9GAnJsLaN_5R2gD18Zlfg4wN80ndcXdMWgejEXBxTGqYeIxfENOJC9iTvVLEY9FGQM8g0fAKF_HnfSgY5ft5kwpd5NJrWPh9MlSChICsccYb0w7LkIku_qZAMt/s1600/tabel2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPqf7V7ADgfnk8-XE9pj9GAnJsLaN_5R2gD18Zlfg4wN80ndcXdMWgejEXBxTGqYeIxfENOJC9iTvVLEY9FGQM8g0fAKF_HnfSgY5ft5kwpd5NJrWPh9MlSChICsccYb0w7LkIku_qZAMt/s320/tabel2.jpg" width="261" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
6.setelah klik NEW QUERY tampilan dilayar navicat akan seperti ini : </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7y9bbJ4Fu_stLRQGC6wgPS30XnlfiMiDUB6XHBQ8Bf7GiL3omznVIWdN-g2mXm-9m0LT45jLL5pQLNy4DrIUuNiF_6vElYxsxC2Bj2nhxXTocN9UAGjFCCVKO5lz_4yuVz1F6iq6-LjG1/s1600/tabel3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="163" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7y9bbJ4Fu_stLRQGC6wgPS30XnlfiMiDUB6XHBQ8Bf7GiL3omznVIWdN-g2mXm-9m0LT45jLL5pQLNy4DrIUuNiF_6vElYxsxC2Bj2nhxXTocN9UAGjFCCVKO5lz_4yuVz1F6iq6-LjG1/s320/tabel3.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
7.setelah itu kalian baru deh membuat tabel pada QUERY EDITOR ... nah silakan kalian ketik query yang saya buat di dalam layar QUERY EDITOR seperti gambar dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPuRWr9NI7Va8sjajzk4ACzCulkhZfgbTv0-ez5gOhtDOENvBlHMfqAXKUznfd88Z6XsaS1WscOtOgOIgB2revN8esgwtbZ1fwKmQ7RVJe1rAWEg98nSAYFl6Ees5pyZL0K3hag9ZPGd7i/s1600/tabel4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="309" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPuRWr9NI7Va8sjajzk4ACzCulkhZfgbTv0-ez5gOhtDOENvBlHMfqAXKUznfd88Z6XsaS1WscOtOgOIgB2revN8esgwtbZ1fwKmQ7RVJe1rAWEg98nSAYFl6Ees5pyZL0K3hag9ZPGd7i/s320/tabel4.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
8.nah kalo sudah diketik query nya silakan pencet tombol warna hijau yang tulisannya RUN  diatas menu query editor</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
9.apabila sudah di RUN ... akan menghasilkan tampilan seperti ini : </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfDXL2OOY29WgJGl35bGnPeGc9L66rSle3jxRwo6IPldpk0L3fUEPRyCLgGh85Squ5AKBG2PVHECvWzkJvYg5YJPf7oGBaOvCRJTmZVQx8mTJ5YBox67lfrIvEeo6_1ql_VufhBw4Q-gmg/s1600/tabel5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfDXL2OOY29WgJGl35bGnPeGc9L66rSle3jxRwo6IPldpk0L3fUEPRyCLgGh85Squ5AKBG2PVHECvWzkJvYg5YJPf7oGBaOvCRJTmZVQx8mTJ5YBox67lfrIvEeo6_1ql_VufhBw4Q-gmg/s320/tabel5.jpg" width="206" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
10.nah berhasil deh membuat tabel nya.. mudahkan .. :D</div>
<div class="separator" style="clear: both; text-align: left;">
11.untuk mengecek tabelnya kalian silakan pilih dan klik menu TABLE pada navicat lihat gambar dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgou5PosF8Ni3OlFGU82E0I_sdgZuBPcfmLnuBg2olMc3KYRuSkRpOpuRelMA-beNipy6bCVEr2VTjh8DnkCYh1u1FJ8wBJtGSHtvIM7u3_lz7iu0YmiXEBpq4LzjCwmhh6Dt1E_A3pF235/s1600/tabel6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgou5PosF8Ni3OlFGU82E0I_sdgZuBPcfmLnuBg2olMc3KYRuSkRpOpuRelMA-beNipy6bCVEr2VTjh8DnkCYh1u1FJ8wBJtGSHtvIM7u3_lz7iu0YmiXEBpq4LzjCwmhh6Dt1E_A3pF235/s1600/tabel6.jpg" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
12.setelah diklik akan menghasilkan tampilan layar berikut :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLJBBQgB7WycPBygWLHBODDvYLVtUvLphsR-L5FCn4GZ2oSBJ7QRTsf_Q0ZUkX_qY_hDPxXFrYzjmcUiCEFf8ApV9OFyqQKwyYOTgKOdGGytqbWTTFWAPZuiOY5RITO0qEHYLqtnyvgiiU/s1600/tabel7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="178" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLJBBQgB7WycPBygWLHBODDvYLVtUvLphsR-L5FCn4GZ2oSBJ7QRTsf_Q0ZUkX_qY_hDPxXFrYzjmcUiCEFf8ApV9OFyqQKwyYOTgKOdGGytqbWTTFWAPZuiOY5RITO0qEHYLqtnyvgiiU/s320/tabel7.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
13.jreng... jreng... hahaahaha... berhasil deh ada tabel barang nya yang tadi kalian buat ... :D</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
demikian cara / Tutorial Membuat Database Dengan Navicat Part 2 nantikan tutorial part 3 nya yahhh.. :D</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Create : Abednego,S.T </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<br /></p>

Gambar ini adalah hasil dari tutorial dibawah ini Tulisan sebelum nya tentang Tutorial Membuat Database Dengan Navicat Part 1 a...

Alur Proses Data Absensi Siswa dan Staf Sekolah

<p><div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUMyVshRWI5bPryXpEWb6wSagV75Bsm1De8_DusEQxDs3-4wCYwZZgQ3-oIekeUtECyQQn0trYNGiczT4qdBt836xggiDvynTp92t7WnnLn9FDYPmFEtRH2efQN1r_c2Yt7vqFSo5eVAnJ/s1600/alur+data+absensi+sekolah.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUMyVshRWI5bPryXpEWb6wSagV75Bsm1De8_DusEQxDs3-4wCYwZZgQ3-oIekeUtECyQQn0trYNGiczT4qdBt836xggiDvynTp92t7WnnLn9FDYPmFEtRH2efQN1r_c2Yt7vqFSo5eVAnJ/s320/alur+data+absensi+sekolah.jpg" width="281" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="" style="clear: both; text-align: left;">
Teknology semakin berkembang dan sangat cepat .. nah pada kali ini saya akan memberikan alur data proses absensi di kalangan sekolah SD,SMP dan SMK/A , Diagram adalah design yang sangat penting dalam membuat suatu aplikasi .... ok nih lihat gambar dibawah ini biar jelas .. :D</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
pada gambar diatas menunjukan bahwa aplikasi absensi berbasis fringer print sudah support SMS kepada orang tua.. tujuan nya adalah untuk memantau anak dari orang tua supaya terlihat jelas bahwa anka tersebut dateng kesekolah atau tidak... heheehe :D</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Create : Abednego,S.T</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<br /></p>

Teknology semakin berkembang dan sangat cepat .. nah pada kali ini saya akan memberikan alur data proses absensi di kalangan sekola...

Tutorial Membuat Database Dengan Navicat Part 1

<p><div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqwfGeevWL7uEbf-48pH2dJ2wDmuWJ4QEdnIAJoCQ76B6p1MDZfWdmElbC0UhyphenhyphenGfvgt_G-W4-inUYfz5MQZbzO_o82SpeMn3SPBMg6TlZWmGoGX-y1_nJSV19g_FtC89onElyqNYH5qDm3/s320/navicat11.jpg" /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
Gambar ini adalah hasil dari tutorial dibawah ini</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Yoi..... kawan sekarang saya akan memberikan tutorial cara membuat database dengan aplikasi NAVICAT .... kalo yang belum punya aplikasi navicat nya bisa di download <a href="https://www.navicat.com/download" target="_blank">disi<span id="goog_1459880830"></span><span id="goog_1459880831"></span>ni</a><br />
<br />
ok langsung bahas aja ya... biar ga banyak basa - basi... hahah.... apabila udah di instal aplikasinya hasilnya seperti gambar dibawah ini :<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRewDaBDsJ2UaL_MYQl3Gg30mpvEYEYOdeXngbSaSu7A6VfZQagYeSa1M7z-diujysKdWauuIuQc7ftRYEdAonkUQWmVQYi4JghKZDRA7vCPtNQhaoMm7bwSHW3yjUI1C-b3ghn9VK7Kyw/s1600/navicat1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRewDaBDsJ2UaL_MYQl3Gg30mpvEYEYOdeXngbSaSu7A6VfZQagYeSa1M7z-diujysKdWauuIuQc7ftRYEdAonkUQWmVQYi4JghKZDRA7vCPtNQhaoMm7bwSHW3yjUI1C-b3ghn9VK7Kyw/s320/navicat1.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Untuk membuat koneksi database kita harus membuat antar koneksi dengan aplikasi navicat</div>
<div class="separator" style="clear: both; text-align: left;">
berikut tahapannya :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
1.klik pada menu connection pada disamping atas dan pilih MYSQL seperti gambar dibawah :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTJnTyqX-0rV7bF62qY2rsxDKesmgRNex8t4lr8Eu-3SohpkZ3RlyeLI8IBtMna9rwF3zjPWGRUFgf_YhPZp4yKuwtCotDJV99bW49f1lhE5hO0XklbtqqJQeXTYP9anURxRRUuDlliwx/s1600/navicat2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTJnTyqX-0rV7bF62qY2rsxDKesmgRNex8t4lr8Eu-3SohpkZ3RlyeLI8IBtMna9rwF3zjPWGRUFgf_YhPZp4yKuwtCotDJV99bW49f1lhE5hO0XklbtqqJQeXTYP9anURxRRUuDlliwx/s1600/navicat2.jpg" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
2.Apabila sudah di klik MYSQL nya akan muncul tampilan dibawah ini  dan silakan kalian isi sesuai gambar yang saya buat</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8BLe2kYKtVFxL0HVL-YSNVwjUzoM4YkZ9ZHych-WZ99m0ZDYX1RPXdJpKzNOKTmTn9sINDaUa7gSTcgJyn6f-jLP0yi9Vx3_13MnjeCkbt7uH2U4GMzxsSDZJOcXoIPmjlT3JSrfaObv7/s1600/navicat3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8BLe2kYKtVFxL0HVL-YSNVwjUzoM4YkZ9ZHych-WZ99m0ZDYX1RPXdJpKzNOKTmTn9sINDaUa7gSTcgJyn6f-jLP0yi9Vx3_13MnjeCkbt7uH2U4GMzxsSDZJOcXoIPmjlT3JSrfaObv7/s320/navicat3.jpg" width="286" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
3.Apabila sudah diisi pencet tombol Test Connection hasilnya seperti dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNKubIYZ2Nc-cEy4XHvw4FSV37TAq0ySqWNNEMATrZ0B8nibV1TMZBw7IBwz8CR1nFa6xh87GNPhSi9ghBjMzn5r1Z4HJrI4xpv72IYJrdruL6EGaRNc_bqDphsW37w1KJMuehY9k4GblW/s1600/navicat4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNKubIYZ2Nc-cEy4XHvw4FSV37TAq0ySqWNNEMATrZ0B8nibV1TMZBw7IBwz8CR1nFa6xh87GNPhSi9ghBjMzn5r1Z4HJrI4xpv72IYJrdruL6EGaRNc_bqDphsW37w1KJMuehY9k4GblW/s320/navicat4.jpg" width="281" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
4.Setelah itu tekan tombol OK...</div>
<div class="separator" style="clear: both; text-align: left;">
5.Hasilnya seperti gambar dibawah ini hehe... udah berhasil tuh membuat koneksinya</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlhSVQGySovt35JmtD5uys576NT1-_mvl3DcD5IyFC8oFu1E13HDQok5hNE7xksNfuzVGlwNaXVRmHfbHr_8YpI8e9YafnUL4H6oTsFTVbD5NYWq2ln2SHOvLYU6JjCe3u3afroARLqyUs/s1600/navicat5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlhSVQGySovt35JmtD5uys576NT1-_mvl3DcD5IyFC8oFu1E13HDQok5hNE7xksNfuzVGlwNaXVRmHfbHr_8YpI8e9YafnUL4H6oTsFTVbD5NYWq2ln2SHOvLYU6JjCe3u3afroARLqyUs/s1600/navicat5.jpg" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
6.Nah... sekarang tinggal membuat databasenya..</div>
<div class="separator" style="clear: both; text-align: left;">
7.Setelah itu klik kanan pada koneksi database tersebut seperti gambar dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5DM1IbEMqaigZEei__xYq3oI_uyT4s_auKU1lEikwhQ_9fCkamIMiD24z2jqwHdeblUlctDOVYHVLhD1mCxX57DpmGLDCVS1vKPN2pZ4rZ_oedwk8hSYd0D1jYp-N6XHnDp8124_Fi3cB/s1600/navicat6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5DM1IbEMqaigZEei__xYq3oI_uyT4s_auKU1lEikwhQ_9fCkamIMiD24z2jqwHdeblUlctDOVYHVLhD1mCxX57DpmGLDCVS1vKPN2pZ4rZ_oedwk8hSYd0D1jYp-N6XHnDp8124_Fi3cB/s320/navicat6.jpg" width="190" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
8.Pilih Open Connection dan klik </div>
<div class="separator" style="clear: both; text-align: left;">
9.nah statusnya sekarang udah terbuka koneksinya</div>
<div class="separator" style="clear: both; text-align: left;">
10.Habis itu silakan cari tombol QUERY dan klik nanti akan ada cara menambahkan QUERY untuk membuat databasenya perhatikan gambar berikut :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgez1oqB_laTHAIZ6FshOaEJC4pXQH5FUvRA0rq1o06WHyI6AVzqHtJKTXHgOLgE6xY3E-8mvH-WefYh3nRG4tfE2OtfTtcYDXeX-TaEx9Tymf2_KYN73mb9F15Jbsu7mD8Y9OauSFwrc2X/s1600/navicat7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="100" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgez1oqB_laTHAIZ6FshOaEJC4pXQH5FUvRA0rq1o06WHyI6AVzqHtJKTXHgOLgE6xY3E-8mvH-WefYh3nRG4tfE2OtfTtcYDXeX-TaEx9Tymf2_KYN73mb9F15Jbsu7mD8Y9OauSFwrc2X/s320/navicat7.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
11.klik NEW QUERY nya nanti akan muncul tampilan editor QUERY seperti gambar dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg64tNPfUjZTappVu1cyqVcaox1adGUmYUfqTRnNcqPcU9X7v_QTl8kSIHFBYZOFTzgmqNbvgJ1wSt8odZEbGBpIdhtxIYn3JbVa2w6_PJz3cYsUp4KxOCztLgGM85-sTFqByupYoNq6R1G/s1600/navicat8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg64tNPfUjZTappVu1cyqVcaox1adGUmYUfqTRnNcqPcU9X7v_QTl8kSIHFBYZOFTzgmqNbvgJ1wSt8odZEbGBpIdhtxIYn3JbVa2w6_PJz3cYsUp4KxOCztLgGM85-sTFqByupYoNq6R1G/s320/navicat8.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
12.Udah samakan tampilannya... sekarang tinggal ketik QUERY nya lihat gambar dibawah ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXzyeRI6YyeFJD5asYxFEOc-HQp0O5Cat96IIDGe7YCQuToqUAlfQJjR8-tGXohnTMLYXqYqW_Y2RsROchGHNinCbu95ct_qnpEMlt3tY31lP60vWkj2v114Re3_7znj3UklzAe10pAkVV/s1600/navicat9.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="204" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXzyeRI6YyeFJD5asYxFEOc-HQp0O5Cat96IIDGe7YCQuToqUAlfQJjR8-tGXohnTMLYXqYqW_Y2RsROchGHNinCbu95ct_qnpEMlt3tY31lP60vWkj2v114Re3_7znj3UklzAe10pAkVV/s320/navicat9.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
13.Jika sudah diketik querynya habis itu klik tombol RUN yang warna hijau diatas query editor</div>
<div class="separator" style="clear: both; text-align: left;">
14.Apabila sudah di klik hasilnya seperti ini :</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEgrD7L7sgCL368kqiwRCAIm-7gpauON19W4k7mfZ3Za2HmrWmYRknx5yia-yoNCuREwQsf0oW6vAa7YTNbHE2UrVQYQZhVP_BsuX81GjfjEbxWp90VTzyHEGsH3Kz06yW1VU5T8fhyBNH/s1600/navicat10.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEgrD7L7sgCL368kqiwRCAIm-7gpauON19W4k7mfZ3Za2HmrWmYRknx5yia-yoNCuREwQsf0oW6vAa7YTNbHE2UrVQYQZhVP_BsuX81GjfjEbxWp90VTzyHEGsH3Kz06yW1VU5T8fhyBNH/s320/navicat10.jpg" width="311" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
15.Ok berhasil buat databasenya ... </div>
<div class="separator" style="clear: both; text-align: left;">
16.Bila ingin melihat databasenya klik kanan koneksi databasenya trus cari REFRESH </div>
<div class="separator" style="clear: both; text-align: left;">
17.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqwfGeevWL7uEbf-48pH2dJ2wDmuWJ4QEdnIAJoCQ76B6p1MDZfWdmElbC0UhyphenhyphenGfvgt_G-W4-inUYfz5MQZbzO_o82SpeMn3SPBMg6TlZWmGoGX-y1_nJSV19g_FtC89onElyqNYH5qDm3/s1600/navicat11.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqwfGeevWL7uEbf-48pH2dJ2wDmuWJ4QEdnIAJoCQ76B6p1MDZfWdmElbC0UhyphenhyphenGfvgt_G-W4-inUYfz5MQZbzO_o82SpeMn3SPBMg6TlZWmGoGX-y1_nJSV19g_FtC89onElyqNYH5qDm3/s320/navicat11.jpg" width="215" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
18.Silakan lihat pada list database koneksi  kawan....</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
*Untuk tutorial selanjutkan tentang cara membuat tabel dengan QUERY.... see u ... </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Create : Abednego,S.T</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<br /></p>

Gambar ini adalah hasil dari tutorial dibawah ini Yoi..... kawan sekarang saya akan memberikan tutorial cara membuat database deng...

Trigger MySQL Mengurangi Stok

<p><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJXdCUNblAV-K0D8lswb-zgBzdUmuG-6Ee3DJo5IgrQGmLLtmQ3obDEiUGkYyQCHnMM-q9NMGV2nfMktS_pEC06qGbA6WtwqMU41rmbY8TqH47ePadF5a4Kuv-fFgCW2n-8vU2L0n5Boee/s1600/mysql.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="142" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJXdCUNblAV-K0D8lswb-zgBzdUmuG-6Ee3DJo5IgrQGmLLtmQ3obDEiUGkYyQCHnMM-q9NMGV2nfMktS_pEC06qGbA6WtwqMU41rmbY8TqH47ePadF5a4Kuv-fFgCW2n-8vU2L0n5Boee/s320/mysql.jpg" width="320" /></a></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">Apa
itu TRIGGER?? silahkan googling pasti bnyak sekali penjelasanya, saya coba
mengartikan menurut saya pribadi. trigger adalah bahasa Inggris dalam bahasa
Indonesia nya adalah “pemicu” nah apa yang dipicu tentu saja adalah sebuah
fungsi atau prosedur yang dikerjakan oleh database, jadi di dalam koding
pembuatan program tentusaja akan menguntungkan kita karena beberapa code yang
biasanya lewat program jadi terpangkas.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">Bagaimana
menjalankan TRIGGER?? tentu saja akan banyak menemukan artikel juga kalau kita
googling, mungkin semua database juga memiliki aturan yang sama soal trigger
tidak tahu juga kalau ada yang lain. ada 6 Event untuk mengaktifkan/dimana
trigger dipasang yaitu :<o:p></o:p></span></div>
<ol start="1" type="1">
<li class="MsoNormal" style="line-height: normal; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">AFTER/BEFORE INSERT ( trigger
     aktif setelah/sebelum record baru diinsert)<o:p></o:p></span></li>
<li class="MsoNormal" style="line-height: normal; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">AFTER/BEFORE UPDATE (
     trigger aktif setelah/sebelum record diupdate)<o:p></o:p></span></li>
<li class="MsoNormal" style="line-height: normal; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">AFTER/BEFORE DELETE (
     trigger aktif setelah/sebelum record dihapus)<o:p></o:p></span></li>
</ol>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">Soal
penggunaan logika dan algoritma trigger sebenarnya sama saja, cuman saya
sendiri tidak terbiasa dengan bahasa trigger jadi ya agak kesulitan memainkan
fungsi yang agak kompleks, oke langsung saja saya akan memberikan contoh yang
sangat simple yaitu menambah dan mengurangkan stok, anggap saja ini sistem
persediaan, kita akan bermain didatabase saja contoh menggunakan XAMPP ver
1.8.1 kalau ada perbedaan harap menyesuaikan ya :D<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">pertama-tama
kita buat dulu database sederhana kita beri nama : <b>Inventory</b>, atau
terserah apalah bagi yang belum bisa buat.</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">oke
selanjutnya kita buat tabel-tabelnya yaitu barang, jual, dan beli<o:p></o:p></span></div>
<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable">
 <tbody>
<tr>
  <td style="padding: 0in 0in 0in 0in;"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">1<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">2<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">3<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">4<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">5<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">6<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">7<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">8<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">9<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">10<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">11<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">12<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">13<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">14<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">15<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">16<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">17<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">18<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">19<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">20<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">21<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">22<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">23<o:p></o:p></span></div>
</td>
  <td style="padding: 0in 0in 0in 0in;"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;">CREATE</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">TABLE</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">IF
  NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">EXISTS `barang` (</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> `kodebrg`
  varchar(15) NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">NULL,</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> `nama`
  varchar(15) NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">NULL,</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> `satauan`
  varchar(5) NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">NULL,</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> `stok` int(11)
  NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">NULL,</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> PRIMARY</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">KEY</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">(`kodebrg`)</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;">) ENGINE=InnoDB
  DEFAULT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">CHARSET=latin1;</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;">CREATE</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">TABLE</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">IF
  NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">EXISTS `beli` (</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> `nofaktur`
  varchar(15) NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">NULL,</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> `tgl` date</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">NULL,</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> `kodebrg`
  varchar(15) NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">NULL,</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> `qty` int(11)
  NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">NULL,</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> PRIMARY</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">KEY</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">(`nofaktur`)</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;">) ENGINE=InnoDB
  DEFAULT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">CHARSET=latin1;</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;">CREATE</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">TABLE</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">IF
  NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">EXISTS `jual` (</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> `nofaktur`
  varchar(15) NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">NULL,</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> `tgl` date</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">NULL,</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> `kodebrg`
  varchar(15) NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">NULL,</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> `qty` int(11)
  NOT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">NULL,</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> PRIMARY</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">KEY</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">(`nofaktur`)</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;">) ENGINE=InnoDB
  DEFAULT</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">CHARSET=latin1;</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
</td>
 </tr>
</tbody></table>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">perhatikan
struktur tabel agar trigger bisa di eksekusi!! pakek analogi sederhana kita
akan mengurangi stok dari tabel barang kita lock PK(Primary Key)-nya dalam
kasus ini <b>kodebrg</b> ini kita jadikan senjata ditabel lain untuk memicu
trigger nantinya, atau bahasa mudahnya tabel yang akan dipasang trigger <b>harus
memiliki field</b> tabel yang akan di kenakan trigger.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">jika
sudah jadi masukan beberapa data barang lewat menu Insert, saya coba seperti
tampak pada gambar dibawah ini :<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiC95bciX46YqTPVB9lrvTQLZ2iiUvDRb5HjGxGzdetUfhTv-m_3ceOW1oVPNVgF3GLsMF7nhdZYqjV9AUQPdlpIPjfot-KyjN5RMnyl4McZ90jOiGlnaUGceiA9t1Rml_OVKMZU_Ivl61o/s1600/triger.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="119" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiC95bciX46YqTPVB9lrvTQLZ2iiUvDRb5HjGxGzdetUfhTv-m_3ceOW1oVPNVgF3GLsMF7nhdZYqjV9AUQPdlpIPjfot-KyjN5RMnyl4McZ90jOiGlnaUGceiA9t1Rml_OVKMZU_Ivl61o/s320/triger.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">selanjutnya
coba kita pasang Trigger di tabel jual, kita gunakan fasilitas yang sudah ada
saja perhatikan gambar :<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsrrz4fK53q1n9NsD3xCyOqKVHqB1L91drywzTOhh3Q6-FdlyxbKtKlHhqXHCqY1Fy30H0Hn8tb0mMv0xu5ZptO7mZ7ul8CoxYZEfHUvDXsnMlok_FLGFpXsPVP0sofUZjwBRTR3y1ZbpQ/s1600/triger2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="76" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsrrz4fK53q1n9NsD3xCyOqKVHqB1L91drywzTOhh3Q6-FdlyxbKtKlHhqXHCqY1Fy30H0Hn8tb0mMv0xu5ZptO7mZ7ul8CoxYZEfHUvDXsnMlok_FLGFpXsPVP0sofUZjwBRTR3y1ZbpQ/s320/triger2.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">maka
akan tampak tampilan jendela trigger seperti gambar dibawah :<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwZeKEfssPPIFxd21NbAoVkjXoaW16wa4FYcCgStZnh5Erqt-NJzZqQhV07xWKkDGQUkqqQ6TZoukm2X5xRSDUgmrHUn6oAZAl73uMFPd7_MTH9UxnGjO2Kgx4MTXvoVt2D-H-_384np-g/s1600/triger3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwZeKEfssPPIFxd21NbAoVkjXoaW16wa4FYcCgStZnh5Erqt-NJzZqQhV07xWKkDGQUkqqQ6TZoukm2X5xRSDUgmrHUn6oAZAl73uMFPd7_MTH9UxnGjO2Kgx4MTXvoVt2D-H-_384np-g/s320/triger3.jpg" width="302" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">Penjelasanya
:<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<b><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">- Trigger name</span></b><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> : nama trigger (terserah isikan nama apa saja cuman buat
mempermudah saat edit dsb).<br />
<b>- Table</b> : dimana Trigger tersebut aktif<br />
<b>- Time serta Event</b> : sudah dijelaskan diatas yaitu waktu dimana trigger
dieksekusi<br />
(jika diterjemahkan maka trigger dengan nama : TG_STOKUPDATE_JUAL akan aktif
setelah tabel jual melakukan insert record)<br />
<b>- Definition</b> : adalah isi trigger yang kita buat, penjelasan<o:p></o:p></span></div>
<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable">
 <tbody>
<tr>
  <td style="padding: 0in 0in 0in 0in;"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">1<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">2<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">3<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">4<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">5<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">6<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">7<o:p></o:p></span></div>
</td>
  <td style="padding: 0in 0in 0in 0in;"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;">BEGIN</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> UPDATE</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">barang
  SET</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">stok=stok-NEW.qty</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> //mengupdate
  tabel barang filed stok, dimana stok=stok (dikurangi)</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> //NEW.qty
  maksutnya field qty dari record baru yang di insert</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">ditabel
  jual</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> WHERE</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> </span><span style="font-family: "courier new"; font-size: 10.0pt;">kodebrg=NEW.kodebrg;</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;"> //dimana
  kodebrg nya adalah field kodebrg dari record baru yang diinsert ditabel jual</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "courier new"; font-size: 10.0pt;">END</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
</td>
 </tr>
</tbody></table>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<b><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">- Definer</span></b><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> : yang menggunakan trigger, root@% (maksutnya user root di
semua ip) bisa juga root@localhost, atau ip yg diperbolehkan saja
root@192.168.1.1 misalnya.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">Setelah itu lakukan cara yang sama
tambahkan trigger pada tabel beli tidak perlu takut salah karena bisa diedit
juga, karena logikanya jika kita beli maka nambah stok maka cukup sedikit
dirubah pada tanda matematisnya menjadi  :<br />
<b><i>UPDATE barang SET stok=stok+NEW.qty</i></b><o:p></o:p></span></div>
<div class="separator" style="clear: both;">
</div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">Oke sekarang coba lakukan insert di
tabel jual maupun beli lewat mysql saja, perhatikan baik2 stoknya jangan salah
menuliskan kode barang karena klo salah trigger tidak jalan, lihat gambar :<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSX0krlIi85b_bv-WUr8kFxXRHPSRl0xSmC3cIeLVnr3zk-IejummBvJC_FSpGaW9fbbAE9J2ptsol0WmnTAy8wG9BTbSywaIyrTBzKogyJZX6ROh1l2QLowIVkRcR8NP-5E5SJxTcpCx5/s1600/triger4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="148" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSX0krlIi85b_bv-WUr8kFxXRHPSRl0xSmC3cIeLVnr3zk-IejummBvJC_FSpGaW9fbbAE9J2ptsol0WmnTAy8wG9BTbSywaIyrTBzKogyJZX6ROh1l2QLowIVkRcR8NP-5E5SJxTcpCx5/s320/triger4.jpg" width="320" /></a></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">Maksutnya kita akan menjual barang
dengan kodebrg BR001 sejumlah 3, nah setelah di eksekusi coba buka tabel barang
yang tadinya barang dengan kode BR001 (Rinso) stok: 10, sekarang berkurang
menjadi 7. lakukan test juga pada tabel beli maka stok akan otomatis bertambah…<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">bagi yang ingin mencoba silahkan
download file sql ujicoba tersebut </span><a href="http://www.mediafire.com/?ts5hzrvrtm3ardf" target="_blank" title="inventory.sql"><span style="color: blue; font-family: "times new roman" , "serif"; font-size: 12.0pt;">disini</span></a><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
</div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">selamat mencoba dan semoga menambah
manfaat  :D<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;">Create : Abednego,S.T</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><br /></span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;">
<span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><br /></span></div>
</p>

Apa itu TRIGGER?? silahkan googling pasti bnyak sekali penjelasanya, saya coba mengartikan menurut saya pribadi. trigger adalah bahasa In...

Tutorial Belajar MySQL : Definisi MySQL dan Keunggulan MySQL

<p><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOhNsaJbXOUNaAcKswTY7jApuGUZPQtfJw7gvYQ7o7aZ6gAy6GVUOW21dmw9nr9RYvcxdax3p14UxpY0SjO8JtrgsOfkF6OCxR7Q2hjkq4v2zX2vx1TN4xHQUklpoVZGB7Izsb9ZGMyIbZ/s1600/mysql.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="142" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOhNsaJbXOUNaAcKswTY7jApuGUZPQtfJw7gvYQ7o7aZ6gAy6GVUOW21dmw9nr9RYvcxdax3p14UxpY0SjO8JtrgsOfkF6OCxR7Q2hjkq4v2zX2vx1TN4xHQUklpoVZGB7Izsb9ZGMyIbZ/s320/mysql.jpg" width="320" /></a></div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
       </div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Mengawali tutorial belajar MySQL  pada Tutorial MySQL kali ini kita akan membahas tentang pengertian MySQL dan kelebihan MySQL jika dibandingkan dengan aplikasi database lainnya. Kepopuleran MySQL tidak hanya karena gratis, tetapi juga merupakan sebuah aplikasi database yang dapat disandingkan dengan aplikasi database berbayar lain, seperti <strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Oracle</strong> dan <strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Microsoft SQL Server</strong>.</div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Kepopuleran MySQL juga disebabkan karena <strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">MySQL</strong> merupakan aplikasi standar dalam pengembangan web, bersama dengan <em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Web Server Apache</strong></em>, dan bahasa pemograman <em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">PHP</strong></em>.</div>
<h3 style="background-color: white; border: 0px; box-sizing: border-box; color: #2b2c33; font-family: Raleway; font-size: 28px; font-stretch: inherit; font-variant-numeric: inherit; font-weight: normal; line-height: 1.4; margin: 0px 0px 12px; padding: 0px; vertical-align: baseline;">
Definisi MySQL sebagai RDBMS Management</h3>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Bagi mahasiswa maupun <em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">web developer</em>, kalau bicara database, kemungkinan besar akan membicarakan MySQL. Tapi, kenapa harus MySQL? Bagaimana dengan Oracle? Jawaban singkat, padat dan tepat adalah: <span style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">gratis</span> dan <span style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">user friendly</span>.</div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
MySQL adalah salah satu aplikasi <strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">RDBMS (Relational Database Management System)</strong>. Pengertian sederhana RDBMS adalah: aplikasi database yang menggunakan <strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">prinsip relasional</strong>. Apa itu prinsip relasional? Kita akan membicarakannya dalam tutorial berikutnya.</div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
MySQL juga bukan satu-satunya RDBMS, list lengkapnya ada di wikipedia. Diantaranya yang banyak dikenal adalah: <span style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><b>Oracle, Sybase, Microsoft Access, Microsoft SQL Server, dan PostgreSQL.</b></span></div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
MySQL bersifat gratis dan open source. Artinya setiap orang boleh menggunakan dan mengembangkan aplikasi ini. Namun walaupun gratis, MySQL di support oleh ribuan programmer dari seluruh dunia, dan merupakan sebuah aplikasi RDBMS yang lengkap, cepat, dan reliabel.</div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Berikut beberapa keunggulan MySQL dibandingkan dengan RDBMS lainnya:</div>
<h4 style="background-color: white; border: 0px; box-sizing: border-box; color: #2b2c33; font-family: Raleway; font-size: 24px; font-stretch: inherit; font-variant-numeric: inherit; font-weight: normal; line-height: 1.4; margin: 0px 0px 12px; padding: 0px; vertical-align: baseline;">
Speed / Kecepatan Data</h4>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Sebuah studi dari eWeek di February 2002 yang membandingkan performa kecepatan MySQL dengan RDBMS lainnya, seperti <em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Microsoft SQL Server 2000, IBM DB2, Oracle 9i dan Sybase</em> :</div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
<b>“<span style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">MySQL has the best overall performance and that MySQL scalability matches Oracle … MySQL had the highest throughput, even exceeding the numbers generated by Oracle</span>.”</b></div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Yang terjemahan bebasnya, MySQL memiliki kecepatan yang lebih dibandingkan pesaing yang berbayar. Bagi anda ingin membaca paper tersebut, tersedia di situs MySQL</div>
<h4 style="background-color: white; border: 0px; box-sizing: border-box; color: #2b2c33; font-family: Raleway; font-size: 24px; font-stretch: inherit; font-variant-numeric: inherit; font-weight: normal; line-height: 1.4; margin: 0px 0px 12px; padding: 0px; vertical-align: baseline;">
Reliability</h4>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Biasanya sesuatu yang gratis susah diandalkan, bahkan banyak bug dan sering hang. Tidak demikian dengan MySQL, karena sifatnya yang open source, setiap orang dapat berkontribusi memeriksa bug dan melakukan <em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">test case</em> untuk berbagai skenario yang memerlukan sistem 24 jam online, multi-user dan data ratusan GB. Hasilnya, MySQL merupakan RDBMS yang reliabel namun memiliki performa diatas rata-rata.</div>
<h4 style="background-color: white; border: 0px; box-sizing: border-box; color: #2b2c33; font-family: Raleway; font-size: 24px; font-stretch: inherit; font-variant-numeric: inherit; font-weight: normal; line-height: 1.4; margin: 0px 0px 12px; padding: 0px; vertical-align: baseline;">
Skalability / Skala</h4>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
MySQL dapat memproses data yang sangat besar dan kompleks, tanpa ada penurunan performa yang berarti, juga mendukung sistem multi-prosesor. MySQL juga dipakai oleh perusahaan-perusahaan besar di dunia, seperti <em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Epson, New York Times, Wikipedia, Google, Facebook, </em>bahkan<em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> NASA</em>.</div>
<h4 style="background-color: white; border: 0px; box-sizing: border-box; color: #2b2c33; font-family: Raleway; font-size: 24px; font-stretch: inherit; font-variant-numeric: inherit; font-weight: normal; line-height: 1.4; margin: 0px 0px 12px; padding: 0px; vertical-align: baseline;">
User Friendly / IDE</h4>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Instalasi dan mempelajari MySQL cukup mudah dan tidak dipusingkan dengan banyak settingan. Cukup <a href="http://www.mysql.com/downloads/mysql/" rel="nofollow" style="background-color: transparent; border: 0px; box-sizing: border-box; color: #2482c1; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration-line: none; vertical-align: baseline;" target="_blank">download aplikasi MySQL</a> dan install, kita dapat menggunakan MySQL dalam waktu kurang dari 5 menit (dengan asumsi tidak mati lampu).</div>
<h4 style="background-color: white; border: 0px; box-sizing: border-box; color: #2b2c33; font-family: Raleway; font-size: 24px; font-stretch: inherit; font-variant-numeric: inherit; font-weight: normal; line-height: 1.4; margin: 0px 0px 12px; padding: 0px; vertical-align: baseline;">
Portability and Standard Compliance</h4>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Database MySQL dapat dengan mudah berpindah dari satu sistem ke sistem lainnya. Misalkan dari sistem Windows ke Linux. Aplikasi MySQL juga dapat berjalan di sistem <strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Linux</strong> (<em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">RedHat, SuSE, Mandrake, Debian</em>), <strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Embedded Linux</strong> (<em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">MontaVista, LynuxWorks BlueCat</em>),<strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Unix</strong> (<em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Solaris, HP-UX, AIX</em>), BSD (Mac OS X, FreeBSD), <strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Windows</strong> (<em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Windows 2000, Windows NT</em>) dan <strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">RTOS</strong> (<em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">QNX</em>).</div>
<h4 style="background-color: white; border: 0px; box-sizing: border-box; color: #2b2c33; font-family: Raleway; font-size: 24px; font-stretch: inherit; font-variant-numeric: inherit; font-weight: normal; line-height: 1.4; margin: 0px 0px 12px; padding: 0px; vertical-align: baseline;">
Multiuser Support Database</h4>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Dengan menerapkan <strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">arsitektur client-server</strong>. Ribuan pengguna dapat mengakses database MySQL dalam waktu yang bersamaan.</div>
<h4 style="background-color: white; border: 0px; box-sizing: border-box; color: #2b2c33; font-family: Raleway; font-size: 24px; font-stretch: inherit; font-variant-numeric: inherit; font-weight: normal; line-height: 1.4; margin: 0px 0px 12px; padding: 0px; vertical-align: baseline;">
Internationalization Aplication</h4>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Atau dalam bahasa sederhananya, mendukung beragam bahasa. Dengan dukungan terhadap unicode, maka aksara non-latin seperti jepang, cina, dan korea bisa digunakan di dalam MySQL.</div>
<h4 style="background-color: white; border: 0px; box-sizing: border-box; color: #2b2c33; font-family: Raleway; font-size: 24px; font-stretch: inherit; font-variant-numeric: inherit; font-weight: normal; line-height: 1.4; margin: 0px 0px 12px; padding: 0px; vertical-align: baseline;">
Wide Application Support System</h4>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Biasanya database RDBMS tidak digunakan sendirian, namun ditemani dengan aplikasi atau bahasa pemograman lainnya untuk menyediakan interface, seperti<em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> C, C++, C#, Java, Delphi, Visual Basic,  Perl Python dan PHP</em>. Kesemua itu di dukung oleh API (Application Programming Interface) oleh MySQL.</div>
<h4 style="background-color: white; border: 0px; box-sizing: border-box; color: #2b2c33; font-family: Raleway; font-size: 24px; font-stretch: inherit; font-variant-numeric: inherit; font-weight: normal; line-height: 1.4; margin: 0px 0px 12px; padding: 0px; vertical-align: baseline;">
Open Source Code / Free User</h4>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Kitapun bisa (jika mampu dan mengerti), mengembangkan MySQL dengan mempelajari kode programmnya. MySQL di kembangkan dengan bahasa C and C++. Bahkan sudah terdapat berbagai variasi rasa RDBMS baru yang dikembangkan dari code MySQL, diantaranya: <em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Drizzle, MariaDB, Percona Server dan OurDelta</em>.</div>
<hr style="background-color: white; border-bottom-color: rgba(0, 0, 0, 0.1); border-bottom-style: solid; border-image: initial; border-left: none; border-right: none; border-top: none; box-sizing: content-box; clear: both; color: #272727; font-family: "Open Sans"; font-size: 16px; height: 0px; margin: 20px 0px; position: relative; width: 729.859px;" />
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Sekian tentang pengertian dan kelebihan MySQL, serta alasan kenapa MySQL lebih banyak digunakan dan populer di kalangan web programmer. Namun jika kita bertanya kepada pegawai IT perusahaan enterprise besar, mereka mungkin akan menyebutkan <em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Oracle</strong> </em>atau <em style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><strong style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Microsoft SQL Server</strong></em> sebagai RDBMS favorit.</div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Untuk tutorial selanjutnya, kita akan membahas tentang sejarah dan masa depan MySQL, apakah pembelian MySQL oleh Oracle membuat MySQL tidak lagi gratis dan bebas digunakan? </div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; box-sizing: border-box; color: #272727; font-family: "Open Sans"; font-size: 16px; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 20px; padding: 0px; vertical-align: baseline;">
Ok kawan... tunggu ya tutorial MYSQL nya ... :D</div>
</p>

Mengawali tutorial belajar MySQL pada Tutorial MySQL kali ini kita akan membahas tentang pengertian MySQL dan kelebihan MySQL ...