Archive for Juli 2013

Apa itu MySQL

Jumat, 26 Juli 2013
Posted by Ozzy
A. Penertian MySQL          

data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBxQPEBQUEBIQFBUQFBIVFhAQFBUQEhAUFBcXFxcVFRQZHighGBonHBQYITQtJTUrLjAuGB8zODMsQygtMCsBCgoKDg0OGhAQGywkICYsLywsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLP/AABEIAMABBwMBEQACEQEDEQH/xAAcAAEAAgMBAQEAAAAAAAAAAAAABgcBBAUIAwL/xABOEAABAwIDAwYGDQkHBQEAAAABAAIDBBEFEiEGMUEHEyJRYYEUMjVxkZIjNEJSU2Jyc3ShsbLTFRYXM2SCg7PDQ5OUotHS4SVUVaPBJP/EABoBAQACAwEAAAAAAAAAAAAAAAAEBQECAwb/xAAxEQEAAgEDAgMGBgIDAQAAAAAAAQIDBBESITEyM1ETFCJBYXEFIzSBkfBigiTB8aH/2gAMAwEAAhEDEQA/ALxQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEHxq6lkLHPkc1jGAlz3kNa0DiSUiJnpDEzERvLl4dtVR1D8kNVA5x1DMwDj5gbX7ltOO8d4aRlpPzdpauggICAgICAgICAgICAgICAgICAgICAgICAgICAgIBQVry1udzVKHF4gMx54s37hl85tzhHC4HYpGm7yiavtG/bdnEuSqknjD6OV8Rc0FpLueicDqHa9L0FZrqbxPxRuxbSUmN6uFR7Q1+AStixAOmgdo12YyaD4GV1r2v4rrdy3mlMsb16S5xkyYZ2t2Sel5XKF7rObVRj3z42Fv+R7j9S5zpbxDtGrxpdhON09Y0uppo5QN+Q3LflN3t71wtWa93et627OisNxAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEHOx7CI62B8Ewu2QbxvaRqHNPAgratprO8Nb0i9dpQLYLE5cOq3YXWm9rmmlO5w1dlHxSASOogt6lIy1i9faVRMN5pb2dv2WLWNjLCZgwsaC484A5oAGpN+xRo336Jk7bdXAp8HwzEIi6KGjlYSQXwsY0g8ekwAgrfles9ZcuGO8dIRDG+TOWmfz+EzSNezpCFzsr9NcrJNzh2P0PErtXPFul4R76aazyxy39kOUjNJ4NiTeZnacnOOGRjnCwyyNPiOPqns0CxkwdOVOsN8Wo68b91jgqMlsoCAgICAgICAgICAgICAgICAgICAgICAgICDCCueWShc2GCsi0kpJR0+pryMpPWA9rfWPWpGnnvX1RNVG0RePknmGVjamCOVvizMa8cdHC9vrXC0bTsk1nlWJcPZrZQUNXVSxuAiqebLIGiwjIuXdm8m3UDZdL5OVYj0c8eLhaZj5pOuTsiu22xcWJx3NmTtByTAb9PEk98z6xw4364ss0n6OGbBGSPqiGxG1stBN+T8Tu3KQyOV5vzfBrSeMZ4O4ebd2y4q3jlVww5ppbhdbAKiJzKAgICAgICAgICAgICAgICAgICAgICAgICAg0MdwxtXTSwP3TMLb2vlPuXW7CAe5ZrbjbdrevKswhPJNi5bHJh9R0Z6N7wGE3zMLiSAeOVxPcWrvqK7zzjtKNpr7fBPeFiKOlsoMEIIdykbIjEacujaPCIQTGdxkbreInqPC+4+crthycJ69kfUYYvHTu53JPtYamM0tQTz1O3oud40kY01+M3QG++47Vtnx7TyjtLTTZuUcZ7wsNR0sQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQYKCquUKjH5ZofBQWVMrmukkad7Wua1pI7GNffrAAUvFP5dt+yFmj82vHutUKImsoCDCCmeUKkOFYrDWwDoyuMhaOL26St/ea6/ncVNwz7THNZV2evs8kXhcNNO2RjXsN2vaHNcOLXC4PoKhTG07LCJ3jd9kZEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQYKCuMGb4TtLVyO1FJEGMv7klrGm3eZPWUm3TDEeqJWOWeZ9FjqMlsoCAgjPKHgHh9DIxovJH7JF152g9HvBLe9dcV+Nt3HPj50mHA5G8e5+lNM89OlPRvvdE8kj1TcebKt9TTa2/q5aTJyrxn5LFUdLEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQYKCt9l381tFiEZ3yMDx5rRv+yQehSb9cVZRMfTNaGvywbUyQGOmp3ljnASyPabOADugy41Fy0k9gHWVnT4otvMtdVmmu0Qn2zmKtraWKdv9qwEj3r9zm9xBCj3rxtslY7cqxLprVuIMFBSuPNOB42J2giCcl5Ddzo36TMt1tccwHyVNr+bi2+auv+Vm3+S54Zg9oc0hzXC4cDcEHcQVCnosImJ7PojIgICAgICAgICAgICAgICAgICAgICAgIMFBWvKHE7D6+mxONpLGkRTho1sbtB6tWuI14tapOH46zRDzxNLxkhHaiePFNomZcs0DubAu27XRshzOBBHBxdvXWI9ni+rhMxlzfR39hJ3YVXzYbOTzcrjJTPdudfcAfjNHrNPWuWWOdIvH7u+GZx3nHP7LOUZMEBBw9rNmYsTh5ubM0tOZkrLZ43cbX3g7iP+CN8d5pO8OeTFXJG0oEzY3FMLObD6kTMF/YCS2/8ACf0Ce0EFSJy47+KEX2OXH1pLv7L8oTZ5PB65ngtSDlyvuyOR17Wbm1aSdwPcSuV8O0b16w649RvPG/SU5XFJZQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEHwrKVkzHRyta9jxZzHjM1wPAhImYneGJiJ6OPgWx1JQyOkp4cr3AjO5znloO8NzE5R5lvbJa3dzphrSd4NrdmY8QjbcmOaEh8NQzx4ng3HnbcC47Ad4CUyTX7GTFF/u++A4g97eaqg1lTE0c41viSDdz0XWwn0G4O5YtEb7x2bUtMx17uuFq3ZQEH5JQ7IbttS4ZWNyVdRTRytHRk52NszO4m7m9h+pdsc5K9YhHy1x2j4pR/ZPbHwKdtHVVUNVC+whrY35yy5sGTEnQacd195G7pkxco5RGzljzcLcLTutNRU37F0GnVYtBCbSzwsJNrPka036rErMVmWs3rHeW1HKHAFpDgdxaQQfMVhmJ3ftGRBhBq1uJQwfrpoo7/AAj2sv6SsxWZ7NZtWO8vrT1LJBeN7HjrY4OHpCTGzMTE9n2WGRAQEBAQYQFgEBATeAum4XQFncZWBhZBBr1VGyQsc4dKJ2Zrmktc3rFx7k21G48UiWJjdsBY3hllZBBDOVLCZ6mivTPlDoXZ3RRuc3nmWsQQPGI3gHqK7YLRFuqPqa2tT4Vc8nWD4bWHJVvkE1zlic8RRSg7sjhZxcOq/pUrPe9eteyHp6Y7eLutjD9iqCAgspIbttZ0g50i3Hp317VDnLee8p1cOOPkkK5uyDcrmMy0lE0QOLHTyCMyNJDmNylxykbictu9d9PWLX6ouqvNadFEsjLibAkgFx4mzRckqw6Qq+tkv5MdpXUVYyJzzzFQ4Mcwnose6wZIBwN7A9h13C3HPj3rM/NI02Xjbaey/wAKuWzKDibYY4KCjln0LmizGn3UjtGjzX1PYCt8dOdohzy34VmXnKeaWqlLnl8sshJJN3OdYEnuAB8wCtIitY6KeZtaerY2fxiSinZLE5zcjmlzWmwkZfpNcNxBF9/YeC1yUi0SzjyTS0bPT4VUu2UBAQEGEHL2kxbwOndLbMRZrW8C52gv2bz3KPqs3scc2dcGL2t4qq2Wvqq+UNzySOedI2nK3TXRtwB3rz05c2e20T+y7jHiw13mP3b7djK0jxQOwyD/AOFdo0Opn/1ynWYP7D9fmXW+9b/ehZ9w1P8AZPfcH9hj8y633rf7wJ7hqf7J77g/sJtsZhslLTlk4AcZHO0dm0Ibx7irXR4r4se11bqslcmTlRDNo9sJppHNge6OIEgZOi99tMxdvHcqvVa+9rTWnSFjp9FSsRNo3lz6DAquqGeNj3A/2j3hubvcblcMeDUZY3ru65M+HHO07Nv8za33n/sb/quvuWp/sufvmD+w/MmyNa0X5sm3vZGk9wusTo9TEb/9sxq8E/8Aj5YVtNU0r7Oe97WmzopSXbtCATq0rXFrMuK20zvHpLbJpcWSvSNpWPi1U2bDppGeLJTSPHXYxkjvV5lvF8FrR6KfFXjmrWfX/tVGFPPhEWp/Wx8fjBedw3tOSvX5r3NWIx2+y7wvVw84ysjFkEF2y5N4a4mWAiCY6kgXilPx2jce0d4K748816T1hGy6at+sdJczZ/G6zCJG0+Ktc6ne4MirL52xk6Brn+9+VYjtG7a1KXjenf0aUvfHPG/b1WYHKMmK35cvacH0j+m9SdL4pQtb4I+6A8mdK2bEY45BdskdQxw62uheD9qk6idqboulje+ziY5hrqOplgffNC8tzbiRva7vaQe9dKW51iXPJXhaY9HoHYPHPDqGKQkF7RzcvzjAAbjhfR37yrctON5hbYb86RKRLm6qW5acc52oZSsN20/TfbdzrxoO5v3yp2lptHJW6zJvPGHN2DwPPTV1W8aQ080cZI3vew5yOqzbD98rbNfrFYaYMfwzaUIUie0o0d3p7aXEjSUk07WhxhYXhhNg63AlVNK8rbLu9uNd1d4Tysyz1EMRpYgJpoYy4SOJaJHtaSBbhdSb6bjEzuh01k2tEbLXCiJ7KDibZY06go5J2Ma8x5LNcSAczg3ePOt8deVtnPLfhXdBNn+VKaqq4YHU8LRNI1hc1ziQCd4XfJpuNd90XHq5vaK7JTykj/8AGPnWfY5Uf4n5P7rz8P8AN/ZEtgZQ2uZmNszXtF+JLdB9SrPw6YjNG6fromcU7LZXpFEJ0BOg+VT4jvku+wrF/DLNfFCiSvHS9PC7sFbamht8FHu+SF67D4I+zzWXxz927ZdWgUFO7Zi1fPb3zfrY1eX123t7PQaPyYTeh8iO+iz/AHXq3p+i/wBVXf8AVfvCucJ9sQ/Ox/eCosHmV+64zeXb7LyXrYebFkEGEHxq6VkzHMkY17HghzHDM1wPAhInbsxMRMbS1MDwvwSMxMe50bXHmmuuTDGQLRZiSXAG9uoWHC5za3Kd2tK8Y2hB+XL2pB9I/pvUjS+KUXW+CPug/JN5Wg+TN/KcpGp8CNpPMSfltwL9XWMHVDLYecxuP1t9VctLfvV31mPtaHN5GMb5mqfTOPRqRdvZKzh3tv6oW2qpvHKGmjybW4yt7G8SbSU8s7/FhY51uLiBo0dpNh3qFWvKYiFhe3GJl5mqp5KmZz3XdJPITYb3Pe7cO82CtYiKwpJmb2+6+ZMFFBgksDbXZTSl7h7qRzSXn0n0AKv58skSteHDFMfR58VjPaVTXu9I8oHkur+ZcqzF44XGby5UFsv7fpPpVL/OYrHL4JVWHzIenQqpdsoIjyreSZ/4X8xq7afxwj6ny5UxsL5TpPn4/tU7P5cq7T+ZD0XiFCyojdHKMzX7xu3agg8CCqfJjrkrNbdl3S9qW5V7q+xHk+maTzD2SN4B/Qf2DqJ9Cpcn4ZkjwTutqfiNZ8cNb83sTHCb/EN/3rn7rq/Wf5Z940vp/wDGHYFibdbT6dVQHH0B+qe76uOu8/yRn0s/KP4fCh2rq6Z9nvc8NNnRTC5Ft4zWzNOn/C1prs+K3xdfpLe+kw5K716brJoMSbVU3OsuA9jtDvaRcEdxV5TLGXFzj0VF8c48nGVKleUl6OF44N7Xh+ai+6F6/D4I+zzWTxz924ujRgoKe209vz/Kb9xi8vrvPs9Bo/Jqm9D5Ed9Fn+69W9P0X+qsv+q/2hXGE+2IfnY/vBUODzK/db5vLt9l5L10PNiyCAgICCteXL2pB9I/pvUnS+KULW+CPug/JN5Wg+TN/KcpGp8tG0nmLx2gwptZTSwP3SsLQbXyu9y4doIB7lArbjO6zvTlWYeaRzlJUe9lppfVkid/q1WnS1fuputLfZYnKnta2ppaWKE6VDGVEg4gahrD+8HeoO+NgxcbTM/JM1OaLViI+bmckOBeE1vPOHQpAH9hldcMHdq7uC31N+NdvVz0uPlbl6Le2v8AJ9V9Hm+6VCx+OFhl8EvMqtJ7Spa+J6Q5QPJdX8y5VmLxwuM3lyoLZg2rqQncKqm16vZWKyyeCfsqsPmQ9PBVK7ZQRHlV8lT/AML+Y1dtP44R9T5cqY2F8p0nz8f2qbn8Eq7T+ZD0oqxcsIwyjIUFO7ZOBr57EHpAadYa0FeW1sx7e2y/0cfk1TrYbyaP4/3nK50P6b+VbrP1H8KsK85Pddx2XXgMwfSwlhuOaYLjrDQD9YXrcNotjrMPN5omLzv6ozj+0tZRPyvigc13iSgPDX/5tD2KBqdZmwW2mvT1TMGmxZo6W6+je2X2ubV+xy5Y5dbNHiyD4pPHsXXS66uXpbpLnqdJOLrHWEE2wkDq6ctIIzgXHWGtB+sEKm10xOe2y00kbYa7pzQj/oh+iz/derin6P8A1lV3/Vf7QrfDHhs8ROgEkZJ6gHBUOHpkrP1XOWN8do+i8QV66OzzTKyCASsdhGZ8ele72EMDPZC1zmSTOlbEQ17w1lsrbkAbyVBtqbTPwx/YSYw1iPidHBMX8IBDg1r2ta7om7JI3i7ZGX1ynt1B0XfBm9p37tMuLh27IlyzUUs9LA2GKWUie5bDG+UgZHakNBsFYaa0Vt1V2rrNqxtCG8mGD1MWKQvlpqqNobNd8kMkbBeNwF3OaANV31F62ptEo+lx2rfeYXooCzVDysbGyun8LpY3SNkDRLHE0uka8aZ8o1LSABpuI7dJmnyxEcZV+pwTM8qq9pcCqZnBkdNUOcdLc28W4XJIs0dp0Umb1jvKJGK8z2X9sFs7+TqNkTrc44l8pGt3u4X4gAAdyrst+dt1rgx8KbN3ayMuoalrWuc50EoDWAuc4lpsA0ak+Za08UNsngl52/N2s/7Kt/w03+1WU5K7d4VMYr79npespWzxvjkaHMkaWuadzmkWIVZEzE7wuJrvG0qX2h5KqmF5NIRPHvaC4Mmb2EGwd5x6AptNTWY2srsmktE71azI8djGUflGzdLXc7d8bW62/Jn0Y/5Eer9Olx4/+Q7mkfYFj8n6G+o+rQxp2Lcw/wAM8N5nTPzoOTxha/fZb09ly6bNLzm4/F2aGwvlOk+fj+1ZzeXLXT+ZC8ttzOKdvg3O5+cF+ZzZstje+XhuXn9d7T2f5e+/0ej0fs/afmbbfVCM+J/t/okVRy1n1WO2l+hnxP8Ab/RInLWf5G2l+jDjiRFj4dr84m+snp1Z/wCLHo+mF7FVMzhzjeZbfVzyC7uaN589lnF+H5slt7dGMmuxUjavVZmG0DKeJsUfisFtd56ye0m5V/ix1x0ikdlPkvN7TaUD2j2HkEjpKUBzXEnmrgPYTqQ2+hCp9V+HW5csf8LLT66sV43/AJcSmhr6a7Y2VjOsRskLSevQEFRK11OLpXeEm9tPk622fqpkxCZpZIyse02u18TyOz3KXnVXja28wxX3as7xMRLn1OGTwtD5IpYxcAPc0tseGvArjbBkpHKYmHeubHfpvEvpgVA2pnbHJK2MOPjO3uN/FbwzHtWcGKMl4i07Nc+ScdN6wuSGlayMRtHQa0MDfigWt6F6mtKxXjHZ5+bTNt/mrzG9hJWOLqa0jCSQwkNezs10cPrVJn/DbxO+PrC1w6+u21+7ntgxKEBrRWtA3BheWjzW0XGK6ykbRu6zOlt16M58T/b/AESJvrP8mNtL9DPif7f6JE5az/JnbS/RKdhTUkzeF+EbmZeezfGvlzdysdB7aeXtd/3QdZ7KNvZ7fs1qii5sMinErRTxTRxSRRySNkzOYY3XjG8BhBad/C60nHx2i3yiYj6sxflvNfnMTLs4FRudN4Q+PmrQsgjitltG0hxcW+5u7cDqANVJ0+OeXtJjbptEOGW/w8InfrukFlNRxBlAQYQZQEGEGljWJNpKeSd4cWwtLy1lsxA6rkC6zWu87Q1vaKxvKD/pgo/gKz1YvxFI91v6ovvtPST9MNH8BWerF+Inutj32nofpho/gKz1YvxE91se+09Eb255SGV9M6nghka2QtzSTFoIDSHWDWk8R1rri081tvLjm1MXrxhxeTHB5KnEYnsaebpniSSS3RbYEtbf3xNhbqueC31F4isw56akzeJeg7KtWwgLIIFkBYBZGVgE2HyqadsjCx7Q5rhYtcLghYvSto2tHRmszWd4QKv5PHGQmCVgYdQ2TNmb2XA1Cpsn4VPLek9FpT8RjjtaOqVbP0tTCzJUvjkDR0ZGl2fzOuNfPvVlpqZaV45J3QM1sdp3rGzr2UlxE2BBlBiyBZYCyDKyCAgICAgICDSxnDW1dPJBIXBszCxxYQHAHqJBF+5ZrPGd4a2rFo2lB/0P0Xw1b68P4Ske9XRvc6fU/Q/RfDVvrw/hJ71c9zx/Vn9D9F8NW+vD+EnvVz3PH9WzQclNBEbu8Im3aTSCw7mNbfvWs6m8tq6XHCY4fh8VOwRwRsjY3cyNoaO06cVxmZnrLvWsV6Q2lhsICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg//9k=        MySQL adalah pogram aplikasi database yang berbasis dan open source. MySQL mampu menanani database yang kompleks dan cukup besar. MySQL juga dapat menangani database client server.  MySQL AB membuat MySQL sebagai perangkat lunak gratis di bawah lisensi GNU General Public License (GPL), tetapi mereka juga menjual dibawah lisensi komersial untuk kasus-kasus dimana penggunaannya tidak cocok dengan penggunaan GPL. Tidak seperti Apache yang merupakan software yang dikembangkan oleh komunitas umum, dan hak cipta untuk kode sumber dimiliki oleh penulisnya masing-masing, MySQL dimiliki dan disponsori oleh sebuah perusahaan komersial Swedia yaitu MySQL AB. MySQL AB memegang penuh hak cipta hampir atas semua kode sumbernya. Orang yang mendirikan MySQL AB adalah: David Axmark dan Allan Larsson berasal dari Swedia, dan Michael "Monty" Widenius berasal dari Finlandia.
clip_image001[10] Fungsi dari  MYSQL dapat kita definisikan antara lain;     
    *menyimpan data itu sudah pasti 
    *mengaksesnya dengan cepat 
    *mengubahnya (insert,update,delete) melakukan itu semua dengan mudah
clip_image001[11] Beberapa kelebihan MySQL antara lain :
    *Free (bebas didownload)
    *Stabil dan tangguh
    *Fleksibel dengan berbagai pemrograman
    *Security yang baik
    *Dukungan dari banyak komunitas
    *Kemudahan management database.
    *Mendukung transaksi
    *Perkembangan software yang cukup cepat.

B.Fitur-fitur MySQL

Seperti hal nya aplikasi atau software lain,MySQL juga mempunyai fitur-fitur tersendiri,antara lain sebagai berikut :
  •   Relational Database SystemSeperti halnya software database lain yang ada di pasaran, MySQL termasuk RDBMS.
  •  Arsitektur Client-Server. MySQL memiliki arsitektur client-server dimana server database MySQL terinstal di server. Client MySQL dapat berada di komputer yang sama dengan server, dan dapat juga di komputer lain yang berkomunikasi dengan server melalui jaringan bahkan internet. 
  • Mengenal perintah SQL standar. SQL (Structured Query Language) merupakan suatu bahasa standar yang berlaku di hampir semua software database. MySQL mendukung SQL versi SQL:2003. 
  • Mendukung Sub Select. Mulai versi 4.1 MySQL telah mendukung select dalam select (sub select). 
  • Mendukung Views. MySQL mendukung views sejak versi 5.0 
  • Mendukung Stored Prosedured (SP). MySQL mendukung SP sejak versi 5.0 
  • Mendukung Triggers. MySQL mendukung trigger pada versi 5.0 namun masih terbatas.      Pengembang MySQL berjanji akan meningkatkan kemampuan trigger pada versi 5.1. 
  •  Mendukung replication. 
  • Mendukung transaksi. 
  • Mendukung foreign key. 
  • Tersedia fungsi GIS. 
  • Free (bebas didownload) 
  • Stabil dan tangguh 
  • Fleksibel dengan berbagai pemrograman 
  • Security yang baik 
  • Dukungan dari banyak komunitas 
  • Perkembangan software yang cukup cepat.
Welcome to My Blog

Popular Post

Ozzy Adha. Diberdayakan oleh Blogger.
function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } }
Firefly Pointer 2

- Copyright © 2013 My Blog :) -Dark Amaterasu Template -