Membuat website sekolah dengan CMS Balitbang

Posted by Unknown Labels: at 4:00 PM

<h2 style="text-align: center;">
Membuat website sekolah dengan CMS Balitbang</h2>
<div style="text-align: left;">
<span style="font-size: small;">Disini saya akan mengoprek CMS Balitbang, yang lalu saya sudah sharing tentang penginstallan CMS Balitbang. Disini saya akan membuat website sekolah saya sendiri yaitu SMK PGRI 1 MEJOBO Kudus, sebelum mengoprek kita terlusuri latar belakang CMS Balitbang dan fitur-fitur yang ada di CMS Balitbang..</span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<u><b>Latar Belakang CMS Balitbang</b></u><b> </b></div>
<div style="text-align: left;">
<span style="font-size: small;"><span style="font-family: Arial,sans-serif; line-height: 150%;">Latar
 Belakang Terciptanya CMS Balitbang adalah dari Salah satu kebijakan 
strategis Kementerian Pendidikan Nasional yang dituangkan dalam Renstra 
Depdiknas 2005-2009 adalah pemanfaatan secara optimal berbagai sarana 
seperti radio, televisi, komputer dan perangkat Teknologi Informasi dan 
Komunikasi (TIK) lainnya untuk digunakan sebagai media pembelajaran</span> </span><b></b></div>
<div style="text-align: left;">
<b><br /></b></div>
<div style="text-align: left;">
<u><b>Fitur yang ada didalam CMS Balitbang , antara lain </b></u></div>
<div style="text-align: left;">
<span style="font-size: small;"><span style="font-family: Arial,sans-serif; line-height: 150%;">Fitur
 yang tersediapun cukup lengkap, seperti: guru, siswa, alumni, banner, 
login member, statistic, agenda, berita, pencarian, info sekolah, galeri
 foto, jajak pendapat, materi ajar, peta situs serta tautan e-learning, 
serta blog.</span></span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<span style="font-size: small;"><span style="font-family: Arial,sans-serif; line-height: 150%;"><b><u>Mari kita mengoprek CMS Balitbang:</u> </b> </span></span></div>
<div style="text-align: left;">
<span style="font-size: small;"><span style="font-family: Arial,sans-serif; line-height: 150%;">1. Mari kita ketikkan ke localhost/cmsbalitbang/admin/admin.php , seperti berikut ini:</span></span></div>
<div style="text-align: left;">
<span style="font-size: small;"><span style="font-family: Arial,sans-serif; line-height: 150%;">a.username dan password: admin </span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_43wStoQ-5TjkCBLtSAVzkvIPU0-i3k138qciSvvewjXjxWjeAhvXkQoW0_Tv4PVujCaEJuA72tnrWmlhx7lEMHQ0Ru-6l2SYolgyMwYn20j97J8mgsm_AehEUROOqcafPSLVF09UkSQ/s1600/Screenshot+from+2016-04-04+15%253A48%253A41.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_43wStoQ-5TjkCBLtSAVzkvIPU0-i3k138qciSvvewjXjxWjeAhvXkQoW0_Tv4PVujCaEJuA72tnrWmlhx7lEMHQ0Ru-6l2SYolgyMwYn20j97J8mgsm_AehEUROOqcafPSLVF09UkSQ/s320/Screenshot+from+2016-04-04+15%253A48%253A41.png" width="320" /></a></div>
<div style="text-align: left;">
<span style="font-size: small;"><span style="font-family: Arial,sans-serif; line-height: 150%;"> 2. Tampilan awal admin seperti dibawah ini dan silakan anda ubah-ubah dengan selera anda masing-masing:</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-jhpTPUSQpi_IL2QNiphrvBqRjW_1QuY9tCqlELWiMNZ9ZxW3ul7RPAyfOY6MujqSjxOt8bZLDEiwHA7-r_WSUuBrDk_yDfWH4prfMAwLdY2VcVi1elY7GVrmfUYt6-PtycGcoNVLuLQ/s1600/Screenshot+from+2016-04-04+15%253A50%253A00.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-jhpTPUSQpi_IL2QNiphrvBqRjW_1QuY9tCqlELWiMNZ9ZxW3ul7RPAyfOY6MujqSjxOt8bZLDEiwHA7-r_WSUuBrDk_yDfWH4prfMAwLdY2VcVi1elY7GVrmfUYt6-PtycGcoNVLuLQ/s320/Screenshot+from+2016-04-04+15%253A50%253A00.png" width="320" /></a></div>
<div style="text-align: left;">
<span style="font-size: small;"><span style="font-family: Arial,sans-serif; line-height: 150%;"> 3. Dibawah ini adalah hasil yang saya udah oprek:</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgh99RlA4aUkl9FfKqM9Eky65kujPboTUmiplTVyuSnqDPoRK1q-tmbITbwHAYVwylUbw3XkHWrneuOS4fDiP4GYbwPNlkIeBAZ_ShcGXNYn2QjfqTfskwfrqcZlYRtCSVSxexpGSgwfOQ/s1600/Screenshot+from+2016-04-04+15%253A52%253A24.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgh99RlA4aUkl9FfKqM9Eky65kujPboTUmiplTVyuSnqDPoRK1q-tmbITbwHAYVwylUbw3XkHWrneuOS4fDiP4GYbwPNlkIeBAZ_ShcGXNYn2QjfqTfskwfrqcZlYRtCSVSxexpGSgwfOQ/s320/Screenshot+from+2016-04-04+15%253A52%253A24.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXB6_WBjBHGH-XYwX_UFF2XaE61r4xU_u-k8B4L6-VPH2GvxXirLewQ51i7yn8QLpP0lh_a0Cz1VrONVBYJrilZtum3_mgR414JUAm2vixbmPdqstCDEcWmOPk22rHCboqtKzZZTcaW5g/s1600/Screenshot+from+2016-04-04+15%253A56%253A47.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXB6_WBjBHGH-XYwX_UFF2XaE61r4xU_u-k8B4L6-VPH2GvxXirLewQ51i7yn8QLpP0lh_a0Cz1VrONVBYJrilZtum3_mgR414JUAm2vixbmPdqstCDEcWmOPk22rHCboqtKzZZTcaW5g/s320/Screenshot+from+2016-04-04+15%253A56%253A47.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVWSdix_FuqJkAWs8B2KGlsCyLhD2kequ6ilnLz7FrH-QxG-3NLJBoS6ga7bnGajVE9Xs6U-YeX06plUgIHmxRcQLmD8KjPPFSjfDzUGy8vurmBnmLFvepQsVrRYoN_WqYQ4s2G7Defr0/s1600/Screenshot+from+2016-04-04+15%253A57%253A15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVWSdix_FuqJkAWs8B2KGlsCyLhD2kequ6ilnLz7FrH-QxG-3NLJBoS6ga7bnGajVE9Xs6U-YeX06plUgIHmxRcQLmD8KjPPFSjfDzUGy8vurmBnmLFvepQsVrRYoN_WqYQ4s2G7Defr0/s320/Screenshot+from+2016-04-04+15%253A57%253A15.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2_DVvZBJCKNE5mA2GdVmO95M4aqMtkJt5namC0nnE29CuAShBc1Gc3DS-EBLuLPMo8QQDplXxPE_31dBV62T483C35L8szS9dhpFfCM8WnLxQXPl57BJd0KXAsRv47Fe3StiBmHB3i94/s1600/Screenshot+from+2016-04-04+15%253A57%253A29.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2_DVvZBJCKNE5mA2GdVmO95M4aqMtkJt5namC0nnE29CuAShBc1Gc3DS-EBLuLPMo8QQDplXxPE_31dBV62T483C35L8szS9dhpFfCM8WnLxQXPl57BJd0KXAsRv47Fe3StiBmHB3i94/s320/Screenshot+from+2016-04-04+15%253A57%253A29.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtry8JtDoG9B57vIFfXN-jMPEgEZOFLLlf5X0d6HrYupHsJaO_YKHFMbHJvOfR7woCF2txZ7BPF_zYYjeTWnk8I039lsi6NhPHIfVzo5d7LR_r3pVcnx_Pe4ZlxL3xCOjHK_feSHwF59E/s1600/Screenshot+from+2016-04-04+15%253A58%253A10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtry8JtDoG9B57vIFfXN-jMPEgEZOFLLlf5X0d6HrYupHsJaO_YKHFMbHJvOfR7woCF2txZ7BPF_zYYjeTWnk8I039lsi6NhPHIfVzo5d7LR_r3pVcnx_Pe4ZlxL3xCOjHK_feSHwF59E/s320/Screenshot+from+2016-04-04+15%253A58%253A10.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEip6vxrc6S1hs3UGe17Erh-adXKHkXCpgEUdWXe2JJD2Np5UbrcyuQqI0AUWJI4gAJvoDVvxzN7Gs0vk-qVydwTaJB6ChP0aOCfYpcNN-BibxH-zjw9qd6iC9oGKGPSxNbpctlQl6wqXZo/s1600/Screenshot+from+2016-04-04+15%253A58%253A34.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEip6vxrc6S1hs3UGe17Erh-adXKHkXCpgEUdWXe2JJD2Np5UbrcyuQqI0AUWJI4gAJvoDVvxzN7Gs0vk-qVydwTaJB6ChP0aOCfYpcNN-BibxH-zjw9qd6iC9oGKGPSxNbpctlQl6wqXZo/s320/Screenshot+from+2016-04-04+15%253A58%253A34.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMRmcWBxbQX-w337M-ErUyjYONFiodWVqTrqW0E_B7c4aI-7pgAGaUhYafWRwtxsi1o3DZYLF0SwlhGJnkKzypm7Hc3Ib-AsfOKQU2hTqN-7kfdkgoHXRtByO91eZcyY9yKochHtHZjb8/s1600/Screenshot+from+2016-04-04+15%253A59%253A26.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMRmcWBxbQX-w337M-ErUyjYONFiodWVqTrqW0E_B7c4aI-7pgAGaUhYafWRwtxsi1o3DZYLF0SwlhGJnkKzypm7Hc3Ib-AsfOKQU2hTqN-7kfdkgoHXRtByO91eZcyY9yKochHtHZjb8/s320/Screenshot+from+2016-04-04+15%253A59%253A26.png" width="320" /></a></div>
Disini saya sudah mengubah semua visi dan misi sekolah, sambutan kepala sekolah, berita, banner, sejarah singkat sekolah, nama-nama gurunya dan prestasi siswa dan yang lainnya walaupun ada beberapa yang saya belum ubah seperti e-learning, komite, dan directory alumni.<br />
<div style="text-align: left;">
<span style="font-size: small;"><span style="font-family: Arial,sans-serif; line-height: 150%;"> </span></span><b><u> </u></b></div>

Membuat website sekolah dengan CMS Balitbang Disini saya akan mengoprek CMS Balitbang, yang lalu saya sudah sharing tentang penginstallan...

Manajement Perpustakaan dengan CMS SLiMs Cendana

Posted by Unknown Labels: at 4:06 PM

<h2 style="text-align: center;">
Manajement Perpustakaan dengan CMS SLiMs Cendana</h2>
<div style="text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigu9EMBSFfYbU54xRPR_QyA2kIJG7iAqPfRtrx289b-vx0i4udPYXJC4MeSTyi1iyUX4EuUpvtlg4S2ydAyBmmTHgqucN4KemMZCqFt7fy1nE0loDu15uBelj4ckul5ouNquWeBa9Yd5k/s1600/Screenshot+from+2016-04-02+16%253A01%253A14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigu9EMBSFfYbU54xRPR_QyA2kIJG7iAqPfRtrx289b-vx0i4udPYXJC4MeSTyi1iyUX4EuUpvtlg4S2ydAyBmmTHgqucN4KemMZCqFt7fy1nE0loDu15uBelj4ckul5ouNquWeBa9Yd5k/s320/Screenshot+from+2016-04-02+16%253A01%253A14.png" width="320" /></a></div>
<br />
Disini saya akan membuat manajement perpustakaan untuk sekolah saya, yang lalu saya sudah sharing tentang cara penginstallannya. SLiMs ini bukan untuk <b>perpustakaan online yaaa tetapi hanya untuk manajement atau memudahkan petugas untuk memelihara buku-bukunyaa. . </b>Lihat gambar diatas ini .. Saya disini pusing untuk pemahaman scriptnya <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />

Manajement Perpustakaan dengan CMS SLiMs Cendana Disini saya akan membuat manajement perpustakaan untuk sekolah saya, yang lalu saya ...

Fungsi-fungsi MySQL

Posted by Unknown Labels: at 3:18 PM

<h2 style="text-align: center;">
Fungsi-fungsi MySQL</h2>
<div style="text-align: left;">
<u><b>Fungsi STRING</b></u></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<b>CONCAT</b></div>
<div style="text-align: left;">
Fungsi ini digunakan untuk menggabungkan dua atau lebih string (kolom).<b> </b>Berikut perintahnya:</div>
<div style="text-align: left;">
#SELECT nm_pelanggan, CONCAT (alamat,' ', telepon) FROM pelanggan;</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjs7LqcRjoH1LY-gOFYny4LMCrzw95nAYmo5HWXP0-5vQyFM48QNKO7-SafqRJ7JkQzZuw5eKiL6fHqkohu_6L5aheGHdgz9c_YqTKRzkE5LpPbWatTjCnAJ_1Mp9NM_WbtGfr3_ofRzb0/s1600/Screenshot+from+2016-04-02+08%253A29%253A49.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="107" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjs7LqcRjoH1LY-gOFYny4LMCrzw95nAYmo5HWXP0-5vQyFM48QNKO7-SafqRJ7JkQzZuw5eKiL6fHqkohu_6L5aheGHdgz9c_YqTKRzkE5LpPbWatTjCnAJ_1Mp9NM_WbtGfr3_ofRzb0/s320/Screenshot+from+2016-04-02+08%253A29%253A49.png" width="320" /></a></div>
<b>CONCAT W_S</b><br />
Fungsi ini digunakan untuk menggabungkan dua atau lebih string (kolom)<br />
dengan separator diantara masing-masing string. Berikut perintahnya:<br />
#SELECT CONCAT_WS (',','Adi','Ida','Edi');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRgJeUBfPlBxec2XWUsghmMqsZaTE5CX4bM-Q-grNAb4rW82gHbMy_mEL3KHqJ5sI0q5tT0V3Y45XiVbUGT_z0xcZncb77U-1nE8fri7LFVdzIQQa4oX6agxRf3gfWD0ewNH7XqiuWMD0/s1600/Screenshot+from+2016-04-02+08%253A36%253A47.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="72" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRgJeUBfPlBxec2XWUsghmMqsZaTE5CX4bM-Q-grNAb4rW82gHbMy_mEL3KHqJ5sI0q5tT0V3Y45XiVbUGT_z0xcZncb77U-1nE8fri7LFVdzIQQa4oX6agxRf3gfWD0ewNH7XqiuWMD0/s320/Screenshot+from+2016-04-02+08%253A36%253A47.png" width="320" /></a></div>
<b>SUBSTR (string, awal, panjang)</b><br />
<b>SUBSTRING (string, awal, panjang)</b><br />
<b>SUBSTRING (string FROM awal FOR panjang)</b><br />
<b>MID (string, awal, panjang)</b><br />
Fungsi ini digunakan untuk mengambil atau memotong string dimulai dari<br />
karakter awal sebanyak panjang karakter. Berikut perintahnya:<br />
#SELECT SUBSTRING('Budi Luhur',1,4)<br />
coba anda memakai perintah diatas, kalau saya memakai syntax diatas error. .<br />
Saya coba untuk tanya sama temen ternyata setelah tulisan SUBSTRING tidak boleh ada spasi<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaNRfGjPQs6Ght3OUmTcTywHHPVFxtNOqeT5JV4jesu5XFffn5dEQQDpi23q5UU7S16FlZXav983wRU6S-OPQEcUsGHbfdaRAH_kPVKNBRRp1FR80XbypqCShHAuhiJRrBSziLSFCFwOo/s1600/Screenshot+from+2016-04-02+09%253A01%253A03.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaNRfGjPQs6Ght3OUmTcTywHHPVFxtNOqeT5JV4jesu5XFffn5dEQQDpi23q5UU7S16FlZXav983wRU6S-OPQEcUsGHbfdaRAH_kPVKNBRRp1FR80XbypqCShHAuhiJRrBSziLSFCFwOo/s320/Screenshot+from+2016-04-02+09%253A01%253A03.png" width="320" /></a></div>
<b>LENGTH (string)</b><br />
<b>OCTET_LENGTH (string)</b><br />
<b>CHAR_LENGTH (string)</b><br />
<b>CHARACTER_LENGTH (string)</b><br />
Fungsi ini digunakan untuk menghitung panjang suatu string. Berikut perintahnya:<br />
#SELECT LENGTH ('Budi Luhur');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-eb-ClByinvzwT9_gC6KchQWCv1uH13ISPvNcXmvMbTHjbhuMWtkpBOKKsKd5Om0HwZYTQxjjYN9IGhtck_X4jPrUSjbf2J4ZR8xvl0VPwToqeCF6MU6QYBaX3FFKiUOQQkiNcFe_sQc/s1600/Screenshot+from+2016-04-02+09%253A07%253A46.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="108" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-eb-ClByinvzwT9_gC6KchQWCv1uH13ISPvNcXmvMbTHjbhuMWtkpBOKKsKd5Om0HwZYTQxjjYN9IGhtck_X4jPrUSjbf2J4ZR8xvl0VPwToqeCF6MU6QYBaX3FFKiUOQQkiNcFe_sQc/s320/Screenshot+from+2016-04-02+09%253A07%253A46.png" width="320" /></a></div>
<br />
<br />
<br />
<br />
<b>LEFT (string, panjang)</b><br />
Fungsi ini digunakan untuk memotong string dari sebelah kiri sebanyak panjang karakter. Berikut perintahnya: <br />
<br />
#SELECT LEFT ('Budi Luhur', 4);<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRferbw9CmBLVfsYNH_J5sZ69dHSOzub34mKtqY1yPqbVfxR-4SNrQJR3g4xuAotc8K3mF3SqqVoKxM7z4_8JLtw3hBCjxwQT1QnNyXTGUd9HS7QB6AqVDXp5U5e10Y5Yr8JflCmPJvL4/s1600/Screenshot+from+2016-04-02+09%253A10%253A44.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="98" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRferbw9CmBLVfsYNH_J5sZ69dHSOzub34mKtqY1yPqbVfxR-4SNrQJR3g4xuAotc8K3mF3SqqVoKxM7z4_8JLtw3hBCjxwQT1QnNyXTGUd9HS7QB6AqVDXp5U5e10Y5Yr8JflCmPJvL4/s320/Screenshot+from+2016-04-02+09%253A10%253A44.png" width="320" /></a></div>
<b></b><b>RIGHT (string, panjang) </b><br />
Fungsi ini digunakan untuk memotong string dari sebelah kanan sebanyak<br />
panjang karakter. Berikut peritahnya:<br />
#SELECT RIGHT('Budi Luhur', 4);<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjF9ZOUH0B3gm7x7szedubdobKeHUWgWaKLf0u7MsTpTdety3Fns7CujYBi6dm-Ib20aMoTquzRxkfGAleClznm-fGi1Rsk1SA6g3bwLkfatNF84B7VOe24DEeZss_RTwKWrmFPPl4vfwM/s1600/Screenshot+from+2016-04-02+09%253A14%253A05.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="100" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjF9ZOUH0B3gm7x7szedubdobKeHUWgWaKLf0u7MsTpTdety3Fns7CujYBi6dm-Ib20aMoTquzRxkfGAleClznm-fGi1Rsk1SA6g3bwLkfatNF84B7VOe24DEeZss_RTwKWrmFPPl4vfwM/s320/Screenshot+from+2016-04-02+09%253A14%253A05.png" width="320" /></a></div>
<b>LTRIM (string)</b><br />
Fungsi ini digunakan untuk menghilangkan spasi di awal string (kiri). Berikut perintahnya:<br />
#SELECT LTRIM (' Budi Luhur');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZUJPqKU0ZRAJ7AvPNM57CApzg_kDlTUrqyE_rM2BMOzNlqcjRPXq07A_vunEODvjV6IDUYac1zFpIOqbYj83jKTLHBeChBIyC5Hs3M6a44XFjN70TS169s9ORbNyPE56f87X4gYbow9o/s1600/Screenshot+from+2016-04-02+09%253A20%253A56.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="108" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZUJPqKU0ZRAJ7AvPNM57CApzg_kDlTUrqyE_rM2BMOzNlqcjRPXq07A_vunEODvjV6IDUYac1zFpIOqbYj83jKTLHBeChBIyC5Hs3M6a44XFjN70TS169s9ORbNyPE56f87X4gYbow9o/s320/Screenshot+from+2016-04-02+09%253A20%253A56.png" width="320" /></a></div>
<b>RTRIM (string)</b><br />
Fungsi ini digunakan untuk menghilangkan spasi di akhir string (kanan). Berikut Perintahnya:<br />
#SELECT RTRIM ('Budi Luhur');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGdWetQOhIIy7SF6lslVPm6zKQBAz_o3y-oJZKnGPjH-bG3pbLSXV0HFPVj9oZ2yDplWT9yKgOmC4UxzkerEGcCTQaMeIqlsB-Thi0kSRd6k1l2FUukCc8JLIONWH7qoPebIWIHwywg2s/s1600/Screenshot+from+2016-04-02+09%253A29%253A07.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="108" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGdWetQOhIIy7SF6lslVPm6zKQBAz_o3y-oJZKnGPjH-bG3pbLSXV0HFPVj9oZ2yDplWT9yKgOmC4UxzkerEGcCTQaMeIqlsB-Thi0kSRd6k1l2FUukCc8JLIONWH7qoPebIWIHwywg2s/s320/Screenshot+from+2016-04-02+09%253A29%253A07.png" width="320" /></a></div>
<b>TRIM (string)</b><br />
Fungsi ini digunakan untuk menghilangkan spasi di akhir string (kanan). Berikut perintahnya:<br />
#SELECT TRIM('Budi Luhur');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYJrk266HUt7LEDx9QKgcYqKhiRx5i4CCF40EchTxABVAFIS_ag8OgyKY-ioalWoUgyMpYH_Ud71gKC4m3AlcXMCkejzZxcA_7KncpxeM1sK4l35ap_YdvgsxE8ypN3MpAK_7jK-RLhK0/s1600/Screenshot+from+2016-04-02+09%253A36%253A21.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="110" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYJrk266HUt7LEDx9QKgcYqKhiRx5i4CCF40EchTxABVAFIS_ag8OgyKY-ioalWoUgyMpYH_Ud71gKC4m3AlcXMCkejzZxcA_7KncpxeM1sK4l35ap_YdvgsxE8ypN3MpAK_7jK-RLhK0/s320/Screenshot+from+2016-04-02+09%253A36%253A21.png" width="320" /></a></div>
<b></b><b>REPLACE (string, from_str, to_str)</b><br />
Fungsi ini digunakan untuk mengganti suatu string dengan string yang lain. Berikut perintahnya:<br />
#SELECT REPLACE ('www.mysql.com', 'w', 'x');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8_p59DPeETEjFeRA0oFuPpjBS8BzfOM_Pz5-ef1XFNSW-O0-w5yvqKh_mm-inFOhA8vydUwdz3p9fcZi5Tkl5Qww-ELzKIiRUw_7fmCWztjFCW5rPH2gIrU8N2R4sfOSAL-rlBbT5WQ8/s1600/Screenshot+from+2016-04-02+09%253A48%253A38.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="77" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8_p59DPeETEjFeRA0oFuPpjBS8BzfOM_Pz5-ef1XFNSW-O0-w5yvqKh_mm-inFOhA8vydUwdz3p9fcZi5Tkl5Qww-ELzKIiRUw_7fmCWztjFCW5rPH2gIrU8N2R4sfOSAL-rlBbT5WQ8/s320/Screenshot+from+2016-04-02+09%253A48%253A38.png" width="320" /></a></div>
<b>REPEAT (string, jumlah)</b><br />
Fungsi ini digunakan untuk menduplikasi suatu string sebanyak jumlah. Berikut perintahnya:<br />
#SELET REPEAT ('Mont', '3');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhl2sGi76pvvUU5Fdw1L1H1CYzaJtUioo2vyWO56AMs0nrIBBN9aKZIYSJ9e0FsVcy5uAwbkzY150ONFq6cioMD3Oc8z2nDK9ziVIIbCZIQJPEclCb-NeIvhKV93Z8Dk2dZiMAICMN20B8/s1600/Screenshot+from+2016-04-02+09%253A51%253A15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="101" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhl2sGi76pvvUU5Fdw1L1H1CYzaJtUioo2vyWO56AMs0nrIBBN9aKZIYSJ9e0FsVcy5uAwbkzY150ONFq6cioMD3Oc8z2nDK9ziVIIbCZIQJPEclCb-NeIvhKV93Z8Dk2dZiMAICMN20B8/s320/Screenshot+from+2016-04-02+09%253A51%253A15.png" width="320" /></a></div>
<b></b><b>REVERSE (string)</b><br />
Fungsi ini digunakan untuk membalik string. Berikut perintahnya:<br />
#SELECT REVERSE ('mysql.com');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk8HfCawy_SOHWwRqJe2AzkvN3iURfsV_jjaAqSREkrdxIenL5bM0_g9knQvr4PQoz0cUcTIbqG3ZLtOakWqcb9aFReHoIPIcZOm_gYaVrQlpe9Hxq4DFk1bCOMMoK51o777mSU-eKFbI/s1600/Screenshot+from+2016-04-02+09%253A54%253A56.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="101" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk8HfCawy_SOHWwRqJe2AzkvN3iURfsV_jjaAqSREkrdxIenL5bM0_g9knQvr4PQoz0cUcTIbqG3ZLtOakWqcb9aFReHoIPIcZOm_gYaVrQlpe9Hxq4DFk1bCOMMoK51o777mSU-eKFbI/s320/Screenshot+from+2016-04-02+09%253A54%253A56.png" width="320" /></a></div>
<b>LCASE (string)</b><br />
<b>LOWER (string)</b><br />
Fungsi ini digunakan untuk mengubah string menjadi huruf kecil (lower-<br />
case). Berikut perintahnya:<br />
#SELECT LOWER ('MySQL');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzYEZVUwZiDba3Ffx-aumFkU86KbeZw7uVmhKZqza8nXu5NPuWyGImvyvxHP0Gkpw8706nvP4yjMtTE-sozcSuqEkgB3nhJkd380f60U7YHitOz2C7ADqzJx528hfKUYM-zCOv1g7-Nls/s1600/Screenshot+from+2016-04-02+09%253A59%253A01.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="114" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzYEZVUwZiDba3Ffx-aumFkU86KbeZw7uVmhKZqza8nXu5NPuWyGImvyvxHP0Gkpw8706nvP4yjMtTE-sozcSuqEkgB3nhJkd380f60U7YHitOz2C7ADqzJx528hfKUYM-zCOv1g7-Nls/s320/Screenshot+from+2016-04-02+09%253A59%253A01.png" width="320" /></a></div>
<b>UCASE (string)</b><br />
<b>UPPER (string)</b><br />
Fungsi ini digunakan untuk mengubah string menjadi huruf kapital (upper-<br />
case). Berikut perintahnya:<br />
#SELECT UPPER ('mysql');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAeu98xXZBr4Tk4vuAXJzKFJBnYu3t4zYQRjUBYpihUOEYzxy_a3-WF4fdpmKL0ANBrmyMmzK38BEXe8FTkh7sK4RsiHfXU0X8PwAvrIgUXrTosRg-voMXFBDCCMw86IEmo7fZhLz3Bv4/s1600/Screenshot+from+2016-04-02+10%253A01%253A39.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="114" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAeu98xXZBr4Tk4vuAXJzKFJBnYu3t4zYQRjUBYpihUOEYzxy_a3-WF4fdpmKL0ANBrmyMmzK38BEXe8FTkh7sK4RsiHfXU0X8PwAvrIgUXrTosRg-voMXFBDCCMw86IEmo7fZhLz3Bv4/s320/Screenshot+from+2016-04-02+10%253A01%253A39.png" width="320" /></a></div>
<u><b>Fungsi Tanggal dan Waktu</b></u><b> </b><br />
Selain fungsi string, MySQL juga memiliki fungsi-fungsi yang berhubungan<br />
dengan operasi tanggal dan waktu (date and time).<br />
<br />
<b>NOW()</b><br />
<b>SYSDATE()</b><br />
Fungsi ini digunakan untuk mendapatkan tanggal dan waktu sistem<br />
sekarang. Berikut perintahnya:<br />
#SELECT NOW();<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrsqWeJPL2caHl8zC3n3t4RJJCYzaXn2-cJSWKDFttA7_VG5-7-sUEHK3Vrh1FZwY82NK_8ZouGsMxnwPyaHGh6AAK8ZdlIae_Vh_f8YG6BZ4-b5z54EVqxfiEgE7mk3LcWhlyr8iuDwM/s1600/Screenshot+from+2016-04-02+10%253A07%253A20.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrsqWeJPL2caHl8zC3n3t4RJJCYzaXn2-cJSWKDFttA7_VG5-7-sUEHK3Vrh1FZwY82NK_8ZouGsMxnwPyaHGh6AAK8ZdlIae_Vh_f8YG6BZ4-b5z54EVqxfiEgE7mk3LcWhlyr8iuDwM/s1600/Screenshot+from+2016-04-02+10%253A07%253A20.png" /></a></div>
<b>MONTH (bulan)</b><br />
Fungsi ini digunakan untuk mendapatkan urutan bulan (integer) dari suatu<br />
tanggal yang diberikan dalam setahun, dimana 1=Januari, 2=Februari, dst. Berikut perintahnya:<br />
#SELECT MONTH ('1982-06-05');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7wEU3HZXGoQ1X4pSXGlzhAC9P_KHKASOnEO9mA1Io_6HGPLDLXYrtw2dNe77WfgMRvvX_5IENBbpCd7mwTNUzfH963ydbVsiyiyXFf-XFC_mpIAlxf_feHWJ7m5EyUt-xyrPzObfNbGA/s1600/Screenshot+from+2016-04-02+10%253A09%253A43.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="104" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7wEU3HZXGoQ1X4pSXGlzhAC9P_KHKASOnEO9mA1Io_6HGPLDLXYrtw2dNe77WfgMRvvX_5IENBbpCd7mwTNUzfH963ydbVsiyiyXFf-XFC_mpIAlxf_feHWJ7m5EyUt-xyrPzObfNbGA/s320/Screenshot+from+2016-04-02+10%253A09%253A43.png" width="320" /></a></div>
<b></b><b>WEEK (tanggal)</b><br />
Fungsi ini digunakan untuk mendapatkan urutan minggu (integer) dari suatu<br />
tanggal yang diberikan dalam setahun. Berikut perintahnya:<br />
#SELECT WEEK ('1982-06-05');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgl7AhwqHkTszP5AwYk1K4sNepKA1NUOf-GxXEd2gF-TBm6EW4Zmx_EWN0n3CnwlqHmI3hX68pM-cmB_cg38cKs1wbNvdYp2ho8JptonXelwzxUHsGZmBohZ8z8T_qR2171NPjqt_jYBnI/s1600/Screenshot+from+2016-04-02+10%253A11%253A48.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="113" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgl7AhwqHkTszP5AwYk1K4sNepKA1NUOf-GxXEd2gF-TBm6EW4Zmx_EWN0n3CnwlqHmI3hX68pM-cmB_cg38cKs1wbNvdYp2ho8JptonXelwzxUHsGZmBohZ8z8T_qR2171NPjqt_jYBnI/s320/Screenshot+from+2016-04-02+10%253A11%253A48.png" width="320" /></a></div>
<b>YEARS (tahun)</b><br />
Fungsi ini digunakan untuk mendapatkan bilangan tahun dari suatu tanggal<br />
yang diberikan. Berikut perintahnya:<br />
#SELECT YEAR (now());<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_m_q7rhXi_2bav6XTM1CEED3dlOCiyVEf3vx6HkYrUlRe1sqTsiEH2ERoDssM_6juI2pPZoLkP9d18hzfH2Q2v2YgznmzERi9wpWCEM3OPXqHgOIR93464_nQUWuR09qp7axCIHh-ZAs/s1600/Screenshot+from+2016-04-02+10%253A14%253A06.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="128" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_m_q7rhXi_2bav6XTM1CEED3dlOCiyVEf3vx6HkYrUlRe1sqTsiEH2ERoDssM_6juI2pPZoLkP9d18hzfH2Q2v2YgznmzERi9wpWCEM3OPXqHgOIR93464_nQUWuR09qp7axCIHh-ZAs/s320/Screenshot+from+2016-04-02+10%253A14%253A06.png" width="320" /></a></div>
<b>HOUR (waktu)</b><br />
Fungsi ini digunakan untuk mendapatkan bilangan jam dari suatu parameter<br />
waktu yang diberikan. Berikut perintahnya:<br />
#SELECT HOUR (now());<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMZqfKrZ1GnffzuXOHMK0mtjDz8FRn0Tz6iPbTy0zT_tU5YtP4yVG2mU5yAyl1hjlaKQ9l91L1T2qxZuOTm8gi2CamsWxxuNziLcfWmKeLnMKMWA6KAye5P8qpxT7eLXX2APmJGsPuYnE/s1600/Screenshot+from+2016-04-02+10%253A16%253A44.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMZqfKrZ1GnffzuXOHMK0mtjDz8FRn0Tz6iPbTy0zT_tU5YtP4yVG2mU5yAyl1hjlaKQ9l91L1T2qxZuOTm8gi2CamsWxxuNziLcfWmKeLnMKMWA6KAye5P8qpxT7eLXX2APmJGsPuYnE/s1600/Screenshot+from+2016-04-02+10%253A16%253A44.png" /></a></div>
<b></b><b>MINUTE (menit)</b><br />
Fungsi ini digunakan untuk mendapatkan bilangan menit dari suatu<br />
parameter waktu yang diberikan. Berikut perintahnya:<br />
#SELECT MINUTE (now());<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisSUw2VEZLR-yphUkgv-n9W_2oLkpPWuuw2SF5DRjV1RnEUyIf97vE8cjCf-Il0nCyVnLkP608fYWAcCX1T_Gp_Kf4dVsg-PqVq0g464-QRYIihhlLEOF3yVWcOaOl4MXsx7DuIDWxgsU/s1600/Screenshot+from+2016-04-02+10%253A19%253A08.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="132" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisSUw2VEZLR-yphUkgv-n9W_2oLkpPWuuw2SF5DRjV1RnEUyIf97vE8cjCf-Il0nCyVnLkP608fYWAcCX1T_Gp_Kf4dVsg-PqVq0g464-QRYIihhlLEOF3yVWcOaOl4MXsx7DuIDWxgsU/s320/Screenshot+from+2016-04-02+10%253A19%253A08.png" width="320" /></a></div>
<b></b><b>SECOND (detik)</b><br />
Fungsi ini digunakan untuk mendapatkan bilangan detik dari suatu waktu<br />
yang diberikan. Berikut perintahnya:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUdQ8cmwHxxrKX8j2f1dkQ8-G3T3fh_i7M1gtPMKk1W9bHdAM-zFJumLZNj37loHBG3xwOkDrL2HrOQF4gSXiDif2whkK6_a9bQ6SCIaSgUPzAN4vnin3SHNiIi9WRPeh2WieMGp0bWcc/s1600/Screenshot+from+2016-04-02+10%253A20%253A54.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="122" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUdQ8cmwHxxrKX8j2f1dkQ8-G3T3fh_i7M1gtPMKk1W9bHdAM-zFJumLZNj37loHBG3xwOkDrL2HrOQF4gSXiDif2whkK6_a9bQ6SCIaSgUPzAN4vnin3SHNiIi9WRPeh2WieMGp0bWcc/s320/Screenshot+from+2016-04-02+10%253A20%253A54.png" width="320" /></a></div>
<b>DATE_ADD(date, INTERVAL expr type)</b><br />
<b>DATE_SUB(date, INTERVAL expr type)</b><br />
<b>ADDDATE(date, INTERVAL expr type)</b><br />
<b>SUBDATE(date, INTERVAL expr type)</b><br />
Fungsi-fungsi diatas digunakan untuk menambah suatu tanggal. Berikut perintahnya:<br />
#SELECT DATE_ADD (now(), INTERVAL 1 DAY);<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4AHQufR6z4R3L0j4_lTDFHVgt7hwu-duV4c_BQqw_kA2ZLLw0n1VVv3rhvdGFH_MjGXup5Cf5uQCMoXlnwJUMIWjTFKSDq9iDlG8u084nxP1TbuKgRnc4HKWr3k4x9QabI9ie_SrRS7o/s1600/Screenshot+from+2016-04-02+10%253A27%253A04.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="92" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4AHQufR6z4R3L0j4_lTDFHVgt7hwu-duV4c_BQqw_kA2ZLLw0n1VVv3rhvdGFH_MjGXup5Cf5uQCMoXlnwJUMIWjTFKSDq9iDlG8u084nxP1TbuKgRnc4HKWr3k4x9QabI9ie_SrRS7o/s320/Screenshot+from+2016-04-02+10%253A27%253A04.png" width="320" /></a></div>
<b>DATE_FORMAT</b><br />
Fungsi ini digunakan untuk mem-format tampilan tanggal.<br />
<b> </b><br />
<b>TIME_FORMAT(time, format)</b><br />
Fungsi ini digunakan untuk mem-format tampilan waktu.<br />
<br />
Berikut ini format tampilan tanggal dan waktu, dan penggunaannya:<br />
%M : Nama bulan (January ... December)<br />
%W : Nama hari dalam seminggu (Sunday...Saturday)<br />
%D : Urutan hari dalam sebulan<br />
%Y : Tahun, 4 digit<br />
%y : Tahun, 2 digit<br />
%a : Nama hari dalam seminggu (Sun...Saturday)<br />
%H : Jam, dalam format 24.<br />
%i : Menit, 00-59<br />
%s : Detik, 00-59<br />
<br />
Berikut perintahnya:<br />
#SELECT DATE_FORMAT (now(), '%d-%M-%Y %H:%i:%s');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEha6CxMjI_ogCQpwxFHxE0mxIW8Kgm-iT_GG66WMNqfNMqRx4RwkiOls1tSvcAgKAI2soLx5fHAAi1wAs9_6GoSFqDo6sQmTvo0rR3uTdVJwAVOPk2b04bDA9BseCQgd7Vl2-0njfwCVzc/s1600/Screenshot+from+2016-04-02+10%253A33%253A04.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="71" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEha6CxMjI_ogCQpwxFHxE0mxIW8Kgm-iT_GG66WMNqfNMqRx4RwkiOls1tSvcAgKAI2soLx5fHAAi1wAs9_6GoSFqDo6sQmTvo0rR3uTdVJwAVOPk2b04bDA9BseCQgd7Vl2-0njfwCVzc/s320/Screenshot+from+2016-04-02+10%253A33%253A04.png" width="320" /></a></div>
<u><b>FUNGSI NUMERIK</b></u><b> </b><br />
MySQL memiliki fungsi-fungsi yang berhubungan dengan operasi numerik,<br />
berikut ini contohnya:<b> </b><br />
<b>OPERASI ARITMATIKA</b><br />
Operasi aritmatika dalam MySQL terdiri dari:<br />
+ : Pertambahan<br />
- : Pengurangan<br />
* : Perkalian<br />
/ : Pembagian<br />
% : Sisa hasil bagi, modulus<br />
<b> </b><br />
Berikut perintahnya:<br />
#SELECT 10+20;<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjs-4J_6nDgfXwxZxiUkDyhsdS70f_JjnLE2EUT7i7_c9ZzlGxb3loj4L2kkcay39P8duIBkSUVOVkuSiVEM8ZSwamoGBal_BCRcR1kDGU7UASpiKZs2JYrPgG3ZZG2qF0c52B6u4L-z0g/s1600/Screenshot+from+2016-04-02+10%253A37%253A30.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjs-4J_6nDgfXwxZxiUkDyhsdS70f_JjnLE2EUT7i7_c9ZzlGxb3loj4L2kkcay39P8duIBkSUVOVkuSiVEM8ZSwamoGBal_BCRcR1kDGU7UASpiKZs2JYrPgG3ZZG2qF0c52B6u4L-z0g/s1600/Screenshot+from+2016-04-02+10%253A37%253A30.png" /></a></div>
#SELECT 10/3;<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5vAvsX5WbNz_16tLTVFQukhwAg6-xp3vYCPisuh7EocAAaTT_BYRK1zHGg2bkdDoH_UZxWqDjswXkZSLreZaZVKeZkO-n6b0eTI9m87xS43D2zj7B0Z8QqS7NcgOPTC12ynfq4XIXz4U/s1600/Screenshot+from+2016-04-02+10%253A39%253A24.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5vAvsX5WbNz_16tLTVFQukhwAg6-xp3vYCPisuh7EocAAaTT_BYRK1zHGg2bkdDoH_UZxWqDjswXkZSLreZaZVKeZkO-n6b0eTI9m87xS43D2zj7B0Z8QqS7NcgOPTC12ynfq4XIXz4U/s1600/Screenshot+from+2016-04-02+10%253A39%253A24.png" /></a></div>
<br />
<br />
<b> </b><br />
<br />

Fungsi-fungsi MySQL Fungsi STRING CONCAT Fungsi ini digunakan untuk menggabungkan dua atau lebih string (kolom). Berikut perintahn...

Dasar-Dasar MySQL

Posted by Unknown Labels: at 11:13 AM

<h2 style="text-align: center;">
Dasar-Dasar MySQL</h2>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizu26fw6-7PH7o5yqVW3PwjS29_b4tD_JdhIpr5ppxAr6XbJjl5WCHPXTcIT9-sR6bHagV39QQZPFndBWx77qpydq7DBcpqq5DREAQi7sdjK2UDsJkkjdeC1HhEZAoRAmMzdebuNgfqjI/s1600/mysql-logo.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="133" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizu26fw6-7PH7o5yqVW3PwjS29_b4tD_JdhIpr5ppxAr6XbJjl5WCHPXTcIT9-sR6bHagV39QQZPFndBWx77qpydq7DBcpqq5DREAQi7sdjK2UDsJkkjdeC1HhEZAoRAmMzdebuNgfqjI/s320/mysql-logo.jpg" width="320" /></a></div>
<b>SQL </b>merupakan singkatan dari Structured Query Language. . SQL atau juga<br />
sering disebut sebagai query merupakan suatu bahasa (language) yang digunakan untuk mengakses database.<br />
<br />
<div style="text-align: left;">
<b>Terdapat 3 (tiga) jenis perintah SQL, yaitu :</b><br />
1. <b>DDL atau Data Definition Language<br />DDL</b> merupakan perintah SQL yang berhubungan dengan pendefinisian suatu<br />
struktur database, dalam hal ini database dan table. Beberapa perintah dasar<br />
yang termasuk DDL ini antara lain :<br />
ƒa. CREATE<br />
ƒb. ALTER</div>
<div style="text-align: left;">
c. RENAME<br />
ƒd. DROP</div>
<div style="text-align: left;">
<br />
2.<b> DML atau Data Manipulation Language</b><br />
<b>DML</b> merupakan perintah SQL yang berhubungan dengan manipulasi atau<br />
pengolahan data atau record dalam table. Perintah SQL yang termasuk dalam<br />
DML antara lain :<br />
ƒa. SELECT<br />
ƒb. INSERT<br />
ƒc. UPDATE<br />
ƒd. DELETE</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
3.<b> DCL atau Data Control Language</b><br />
DCL merupakan perintah SQL yang berhubungan dengan manipulasi user dan<br />
hak akses (priviledges). Perintah SQL yang termasuk dalam DCL antara lain :<br />
ƒa. GRANT<br />
ƒb. REVOKE</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<b>Membuat, Menampilkan, Membuka dan Menghapus Table </b></div>
<div style="text-align: left;">
<br /></div>
<b>Membuat Database, seperti dibawah ini:</b><br />
1. Buka terminal dengan ctrl+alt+t<br />
2. Setelah itu masukkan perintah berikut:<br />
#mysql -u root -p<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhO72Q_5lpSQPrPAa6G65fxv1hi8eTU1_nBhl1qasfsS6tLnQKW54syUy9E7SJwEzYzEZNfAN3PZw6efATlJhQlCSFDTBLU4p_spj4mpHWBH3BIc5HfgOvn0kGDfWMJU8rY5CaYw2RKbi8/s1600/Screenshot+from+2016-04-01+08%253A37%253A41.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="84" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhO72Q_5lpSQPrPAa6G65fxv1hi8eTU1_nBhl1qasfsS6tLnQKW54syUy9E7SJwEzYzEZNfAN3PZw6efATlJhQlCSFDTBLU4p_spj4mpHWBH3BIc5HfgOvn0kGDfWMJU8rY5CaYw2RKbi8/s320/Screenshot+from+2016-04-01+08%253A37%253A41.png" width="320" /></a></div>
Disini saya memakai MariaDB bukan MySQL. Sebenernya MariaDB dan MySQL itu sama akan tetapi untuk yang MariaDB syntaxnya akan berbeda sedikit dengan MySQL. Dalam penulisan syntaxnya jangan lupa memakai titik koma(;) yaaa.. Saya disini suka lupa menambahkan titik koma(;) dan akhirnya error teruss broo.. <br />
3. Langkah Selanjutnya Membuat database, masukkan perintah berikut dibawah ini dan masukkan perintah yang ada dibawahnya lagi:<br />
#CREATE DATABASE nama_database;<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjJcpz6HgElKV7o9B5J99hpH6jmBClWHu6ttqhv9B_aOvfGMQZtmI9HtJ3Eq5uAUyh3lP_0T4Gbmrzzs4-LvqxpAnIIzhM2ov547fh5JsaFeBLtpikpbrD_8bRZyKjQXWFNDn-qlSNQm8/s1600/Screenshot+from+2016-04-01+09%253A41%253A46.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="35" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjJcpz6HgElKV7o9B5J99hpH6jmBClWHu6ttqhv9B_aOvfGMQZtmI9HtJ3Eq5uAUyh3lP_0T4Gbmrzzs4-LvqxpAnIIzhM2ov547fh5JsaFeBLtpikpbrD_8bRZyKjQXWFNDn-qlSNQm8/s320/Screenshot+from+2016-04-01+09%253A41%253A46.png" width="320" /></a></div>
<b>Menampilkan Database</b><br />
<br />
Untuk menampilkan database dengan memasukkan perintah dibawah ini:<br />
#SHOW DATABASES;<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdYpN6LEFE-jhwq5ZUde2KSxPv6yMvx2njjYu22GQsCcYRJQphcoBgi-NRYMwJLP9P-wtlUzXKaBQ7PrKzlz-FSJOeia4htOKXtyDnQuWEeZkZTSzKveHlwMmoAV5zCbyR68hyphenhypheneyksEaU/s1600/Screenshot+from+2016-04-01+10%253A23%253A24.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdYpN6LEFE-jhwq5ZUde2KSxPv6yMvx2njjYu22GQsCcYRJQphcoBgi-NRYMwJLP9P-wtlUzXKaBQ7PrKzlz-FSJOeia4htOKXtyDnQuWEeZkZTSzKveHlwMmoAV5zCbyR68hyphenhypheneyksEaU/s320/Screenshot+from+2016-04-01+10%253A23%253A24.png" width="160" /></a></div>
SHOW DATABASE disini untuk menampilkan semua data yang ada didalam database akan kebuka semua.<br />
<br />
<b>Membuka Database </b><br />
Untuk membuka Database, masukkan perintah dibawah ini:<b> </b> <br />
#USE nama_database;<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-2XltwSN1hO3e14C9_ATC_Hh73cdF31Gj7KwE9_V1r-6zMOGxUhGyJgFEHupmdNSH0b7yws2vGltUpL_GGRXTHyGRhBbl5ijIDiHib6Y_YcCWToPDP43FeZ8XXZAri7CMsrglzPAXJzc/s1600/Screenshot+from+2016-04-01+09%253A42%253A03.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-2XltwSN1hO3e14C9_ATC_Hh73cdF31Gj7KwE9_V1r-6zMOGxUhGyJgFEHupmdNSH0b7yws2vGltUpL_GGRXTHyGRhBbl5ijIDiHib6Y_YcCWToPDP43FeZ8XXZAri7CMsrglzPAXJzc/s1600/Screenshot+from+2016-04-01+09%253A42%253A03.png" /></a></div>
<br />
<br />
<b>Menghapus Database</b><br />
Untuk menghapus Database, masukkan perintah dibawah ini:<br />
#DROP DATABASE penjualan;<b> </b><br />
<div class="separator" style="clear: both; text-align: center;">
<b><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjERnSlV7YiXWJE5hZFIC7-s9KtucNOBi4mxKdB7qCXG71bFJp0Nd3QZL1QBkIzQzsr08-3mqWpBvhf0enkjpca4aXHkBQ9T7Drii1A7kqdvE6IRlrj36s-H3hmwpOubE8Id5QWNwWw2wk/s1600/Screenshot+from+2016-04-01+10%253A29%253A24.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="38" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjERnSlV7YiXWJE5hZFIC7-s9KtucNOBi4mxKdB7qCXG71bFJp0Nd3QZL1QBkIzQzsr08-3mqWpBvhf0enkjpca4aXHkBQ9T7Drii1A7kqdvE6IRlrj36s-H3hmwpOubE8Id5QWNwWw2wk/s320/Screenshot+from+2016-04-01+10%253A29%253A24.png" width="320" /></a></b></div>
<br />
<br />
<b>Membuat, Mengubah dan Menghapus Table</b><br />
<br />
<b>Membuat Tabel Baru</b><br />
Pertama, akan ikuti langkah seperti diatas. Lalu masukkan perintah dibawah ini:<br />
#CREATE TABLE pelanggan (id_pelanggan varchar(5) NOT NULL, nm_pelanggan varchar(30) NOT NULL, alamat text, telepon varchar(20), email varchar(50), PRIMARY KEY (id_pelanggan));<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEie7VYJgsR-Gd7eSe1UeXUSoqsCPI1XqFk3CnmbT2mCR5kWIj03z0KEMnbVO52a4lF1VuyeKzK9K9WoLepeUpzw3I-I6nkxO5X7jq0YaHlyQYqEx59dxQd4VbdK73PxXrn9FzQmvPXtiq8/s1600/Screenshot+from+2016-04-01+10%253A39%253A44.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="35" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEie7VYJgsR-Gd7eSe1UeXUSoqsCPI1XqFk3CnmbT2mCR5kWIj03z0KEMnbVO52a4lF1VuyeKzK9K9WoLepeUpzw3I-I6nkxO5X7jq0YaHlyQYqEx59dxQd4VbdK73PxXrn9FzQmvPXtiq8/s320/Screenshot+from+2016-04-01+10%253A39%253A44.png" width="320" /></a></div>
Keterangan:<br />
a. CREATE TABLE adalah perintah awal untuk membuat table<br />
b. pelanggan yaitu nama tabel yang akan dibuat<br />
c. id_pelanggan,nm_pelanggan,alamat,dan email merupakan nama field<br />
d. varchar dan text yaitu tipe data dari field<br />
e. 5,30,20,50 dibelakang tipe data merupakan panjang maksimal dari suatu field<br />
f. Untuk tipe data text panjang karakter maksimalnya tidak perlu ditentukan.<br />
<br />
Untuk mengecek tabel pelanggan sudah ada atau belum ketikan perintah berikut:<br />
#SHOW TABLES;<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnRFVaESRnYYT6xU6cwleNYYiFKrW7-srEZG_lR-vOCDqpaNbN2t4zv_IZs_HucsrCjG22KkMhRyk3CX3ZiAQHszRG_s1vWLVUNgkzBJm4ff6MGYuFlm3ohRzilrvvv_PiTEl6bKsOmhM/s1600/Screenshot+from+2016-04-01+10%253A47%253A57.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnRFVaESRnYYT6xU6cwleNYYiFKrW7-srEZG_lR-vOCDqpaNbN2t4zv_IZs_HucsrCjG22KkMhRyk3CX3ZiAQHszRG_s1vWLVUNgkzBJm4ff6MGYuFlm3ohRzilrvvv_PiTEl6bKsOmhM/s1600/Screenshot+from+2016-04-01+10%253A47%253A57.png" /></a></div>
<br />
Untuk melihat detail tabel pelanggan, ketikkan perintah berikut ini:<br />
#DESC pelanggan;<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIk3X34teE0qkD_r6f8vDtlEKC9tyMdYhZgbdMTE2U_ZZm230fkqPeoAGOvj8mrA5MWVpcH-Xzu2Cj7XupoltQxs28Lf88HaSYwdcahGZGazQeWFTN1G-oI8NV7do4ytTbek9z4CGQQHc/s1600/Screenshot+from+2016-04-01+10%253A50%253A31.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="123" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIk3X34teE0qkD_r6f8vDtlEKC9tyMdYhZgbdMTE2U_ZZm230fkqPeoAGOvj8mrA5MWVpcH-Xzu2Cj7XupoltQxs28Lf88HaSYwdcahGZGazQeWFTN1G-oI8NV7do4ytTbek9z4CGQQHc/s320/Screenshot+from+2016-04-01+10%253A50%253A31.png" width="320" /></a></div>
<br />
<b>Mengubah Struktur Table dengan ALTER</b><br />
<b><br /></b>
Ada beberapa variasi perintah ALTER untuk mengubah struktur suatu tabel, antara lain:<br />
a. Menambahkan field "tgllahir" ketabel pelanggan, berikut perintahnya:<br />
#ALTER TABLE pelanggan ADD tgllahir date NOTNULL;<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0jJrilU8mdA2Z1ks58i4ubobaqCVa2g74z3xNR5zgzy-Qp6FvYZ7P5BqMSTTsHeRT-C0X4daAFgLKKxKCtjju_mE3VZDX2POzK2jlTnpuiwZQE912A9lcUdkzburHIr_R46oE_JGnQf8/s1600/Screenshot+from+2016-04-01+10%253A56%253A36.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="37" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0jJrilU8mdA2Z1ks58i4ubobaqCVa2g74z3xNR5zgzy-Qp6FvYZ7P5BqMSTTsHeRT-C0X4daAFgLKKxKCtjju_mE3VZDX2POzK2jlTnpuiwZQE912A9lcUdkzburHIr_R46oE_JGnQf8/s320/Screenshot+from+2016-04-01+10%253A56%253A36.png" width="320" /></a></div>
b. Menambahkan Primary Key pada suatu tabel, berikut perintahnya:<br />
#ALTER TABLE pelanggan ADD PRIMARY KEY (id_pelanggan);<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAk9rmERrRz5c8OnK11oY6qCxE4O7HflRro5nf_gW3auQoHWXbUlsVFhbijo4YiDCVdMB8FsTb368aQkZ1ibN7Og-dz1bxoHxOa2OYZwiMQFXr_50ldlSW1X17oo-HSFDwUi4B9R2VXWU/s1600/Screenshot+from+2016-04-01+11%253A01%253A03.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="19" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAk9rmERrRz5c8OnK11oY6qCxE4O7HflRro5nf_gW3auQoHWXbUlsVFhbijo4YiDCVdMB8FsTb368aQkZ1ibN7Og-dz1bxoHxOa2OYZwiMQFXr_50ldlSW1X17oo-HSFDwUi4B9R2VXWU/s320/Screenshot+from+2016-04-01+11%253A01%253A03.png" width="320" /></a></div>
Kenapa error? tadi diawal saya sudah memasukkan primary key, jadi kalau memakai primary key dalam satu table tidak bisa.<br />
c. Menghapus field tgllahir dari tabel pelanggan, berikut perintahnya:<br />
#ALTER TABLE pelanggan DROP tgllahir;<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh191GUhd1BcPQzMcTVigVDJNRG4RCLLnqcd0o_Iysfa9FIwEPxkznhavgs__G-hulS7oFod6Kf873df0t9ptGm88-GYE5-3F1gpWtay8w-JqzqYdiSsXOjvyBaCZsq0HD-tc5olm_iTqk/s1600/Screenshot+from+2016-04-01+11%253A04%253A51.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="35" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh191GUhd1BcPQzMcTVigVDJNRG4RCLLnqcd0o_Iysfa9FIwEPxkznhavgs__G-hulS7oFod6Kf873df0t9ptGm88-GYE5-3F1gpWtay8w-JqzqYdiSsXOjvyBaCZsq0HD-tc5olm_iTqk/s320/Screenshot+from+2016-04-01+11%253A04%253A51.png" width="320" /></a></div>
<b>Mengubah Nama Tabel</b><br />
<br />
Untuk mengubah nama suatu tabel, dapat digunakan perintah SQL berikut ini:<br />
#RENAME TABLE pelanggan TO plg;<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSW5vPTky1cfoMyYh1-3XQN8t0i0cOe6vMD9HVNr34zhKdx-1kyvfGGnILszaWsituBIPRBxUPpffNWn9bak07tO-ZojOesUKRvkYfd8XJsN6N6WSbdpZjEnko8eodLM9wMqwRAEmmd0A/s1600/Screenshot+from+2016-04-01+11%253A08%253A30.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="30" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSW5vPTky1cfoMyYh1-3XQN8t0i0cOe6vMD9HVNr34zhKdx-1kyvfGGnILszaWsituBIPRBxUPpffNWn9bak07tO-ZojOesUKRvkYfd8XJsN6N6WSbdpZjEnko8eodLM9wMqwRAEmmd0A/s320/Screenshot+from+2016-04-01+11%253A08%253A30.png" width="320" /></a></div>
#ALTER TABLE plg RENAME TO pelanggan;<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-8mxtLyHEbm-dYU_3HlO3C32cRpih-s6JUfnKjLZlAdWbh4CWKOtBEPdxgqe_AeYOGTE1f-MDkEk3WmrCojbQNPkDOZF9sbj05M49DFjvJcafSdAgazksUoPeQiq8EjJWF13MK0_Qrms/s1600/Screenshot+from+2016-04-01+11%253A09%253A38.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="30" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-8mxtLyHEbm-dYU_3HlO3C32cRpih-s6JUfnKjLZlAdWbh4CWKOtBEPdxgqe_AeYOGTE1f-MDkEk3WmrCojbQNPkDOZF9sbj05M49DFjvJcafSdAgazksUoPeQiq8EjJWF13MK0_Qrms/s320/Screenshot+from+2016-04-01+11%253A09%253A38.png" width="320" /></a></div>
<br />
<br />
<b>Menghapus Nama Tabel</b><br />
<br />
Untuk menghapus sebuah tabel , maka ini perintahnya:<br />
#DROP TABLE pelanggan;<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyyCTDkcKoCdAUnwSya9rfid30__wSGDZASF6nM4HsGZ6WkVJMf5lbSe5vG3efjYDXHtTTI8T-M_FRrymHwmRaoLbeu31WDQhlPdOIzEW_3HGdsFlXrP05My0LFxGwm1lWuyskkswnQ1Q/s1600/Screenshot+from+2016-04-01+11%253A12%253A47.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="39" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyyCTDkcKoCdAUnwSya9rfid30__wSGDZASF6nM4HsGZ6WkVJMf5lbSe5vG3efjYDXHtTTI8T-M_FRrymHwmRaoLbeu31WDQhlPdOIzEW_3HGdsFlXrP05My0LFxGwm1lWuyskkswnQ1Q/s320/Screenshot+from+2016-04-01+11%253A12%253A47.png" width="320" /></a></div>
<br />
<b>Menambah Record dengan INSERT</b><br />
<br />
Kita akan menambahkan sebuah record kedalam tabel <b>pelanggan </b>yang telah kita buat sebelumnya, berikut perintahnya:<br />
#INSERT INTO pelanggan VALUES ('P0001', 'Achmad Solichin', 'Jakarta Selatan', '0217327762', 'achmatid@gmail.com');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgACTsAi9KS5Ikh7Ed2TlC8aCwoH78pZb7Ccn3MWsTJIxx3gQqPeYtLNZE5Ib1ywIp5R8Rpmkcohas01Z-6LRtbDjCpT4g0bDN5mVoxTbXoc40vtJIfmc6Tj1dOBVWhekookyWMheKhsLs/s1600/Screenshot+from+2016-04-01+13%253A54%253A59.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="36" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgACTsAi9KS5Ikh7Ed2TlC8aCwoH78pZb7Ccn3MWsTJIxx3gQqPeYtLNZE5Ib1ywIp5R8Rpmkcohas01Z-6LRtbDjCpT4g0bDN5mVoxTbXoc40vtJIfmc6Tj1dOBVWhekookyWMheKhsLs/s320/Screenshot+from+2016-04-01+13%253A54%253A59.png" width="320" /></a></div>
Setelah berhasil dieksekusi, maka record atau data dalam tabel pelanggan akan bertambah, berikut perintahnya:<br />
#SELECT * FROM pelanggan;<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoH2jvoznRFw3O9x3V5TYKOOwHxiMuqFdaNXYFTlGvQC-y5qHmD2sU7LuScAJ1iIMq6I2LtO7b5FlBcq0cnd7ennqIEwbND1TtjTGtRt8flp6bK0LJHujun5Fig5_Rfidxs5E2UTXKTWY/s1600/Screenshot+from+2016-04-01+13%253A58%253A30.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoH2jvoznRFw3O9x3V5TYKOOwHxiMuqFdaNXYFTlGvQC-y5qHmD2sU7LuScAJ1iIMq6I2LtO7b5FlBcq0cnd7ennqIEwbND1TtjTGtRt8flp6bK0LJHujun5Fig5_Rfidxs5E2UTXKTWY/s320/Screenshot+from+2016-04-01+13%253A58%253A30.png" width="320" /></a></div>
<b>Mengedit Record dengan UPDATE</b><br />
<br />
Berikut ini perintah UPDATE tabel pelanggan , berikut ini:<br />
1. Mengubah alamat menjadi "Tangerang" untuk pelanggan yang mempunyai ID 'P0001':<br />
#UPDATE pelanggan SET alamat 'Tangerang' WHERE id_pelanggan='P0001'<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIe-aCuOXd3cfyVfi36J5E3TSpriLOlz9eSTmwKmmf8wwXSUQClcKjkSBGHCDjQwgIVQ1wyzTOyKMy3eELrpkTPGhOKd2Z_lC1Mv1bNj6UfzqQvlIPRoPUrZSsWe59VgKCbWk7lVdLin0/s1600/Screenshot+from+2016-04-01+14%253A07%253A25.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="36" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIe-aCuOXd3cfyVfi36J5E3TSpriLOlz9eSTmwKmmf8wwXSUQClcKjkSBGHCDjQwgIVQ1wyzTOyKMy3eELrpkTPGhOKd2Z_lC1Mv1bNj6UfzqQvlIPRoPUrZSsWe59VgKCbWk7lVdLin0/s320/Screenshot+from+2016-04-01+14%253A07%253A25.png" width="320" /></a></div>
<b></b><b>Menghapus Record dengan DELETE</b><br />
<br />
Berikut ini perintah DELETE tabel pelanggan, berikut ini:<br />
1. Menghapus data pelanggan yang mempunyai id_pelanggan P0005<br />
#DELETE FROM pelanggan WHERE id_pelanggan='P0005'<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxJX-OLd5YGorwFlm3ZkvJVbgM9K6EMQYqhRmWAtUpL0RqFJ3Ktm0lKf1KZiFUg7nkXGk5dxMw7or7AAAQ-k-HEtUcUT_8100_wuGAggA7GHjXwYCjTG6VAM7ZFIPmDBBdLCd5fthyWuE/s1600/Screenshot+from+2016-04-01+14%253A19%253A19.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="21" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxJX-OLd5YGorwFlm3ZkvJVbgM9K6EMQYqhRmWAtUpL0RqFJ3Ktm0lKf1KZiFUg7nkXGk5dxMw7or7AAAQ-k-HEtUcUT_8100_wuGAggA7GHjXwYCjTG6VAM7ZFIPmDBBdLCd5fthyWuE/s320/Screenshot+from+2016-04-01+14%253A19%253A19.png" width="320" /></a></div>
<b></b><b>Menampilkan Record dengan SELECT</b><br />
<br />
Berikut ini perintah SELECT tabel pelanggan, berikut ini:<br />
1. Menampilkan seluruh data atau record (*) dari tabel pelanggan, berikut ini:<br />
#SELECT * FROM pelanggan<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsBQaHAcENX0Qps6jre8ZyAdQTUtZgmPit9RawsB6ina4B0j3KNzA1CGIUiaAInmr8RwDn_LvvOx39M8R0Es-8M588bbnFSmQV845tqz69LJAfy7QiLO5aQb1vp1kkcF5h4IeqWW8Dhvo/s1600/Screenshot+from+2016-04-01+14%253A24%253A29.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="162" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsBQaHAcENX0Qps6jre8ZyAdQTUtZgmPit9RawsB6ina4B0j3KNzA1CGIUiaAInmr8RwDn_LvvOx39M8R0Es-8M588bbnFSmQV845tqz69LJAfy7QiLO5aQb1vp1kkcF5h4IeqWW8Dhvo/s320/Screenshot+from+2016-04-01+14%253A24%253A29.png" width="320" /></a></div>
<br />

Dasar-Dasar MySQL SQL merupakan singkatan dari Structured Query Language. . SQL atau juga sering disebut sebagai query merupakan suatu ...