{"id":359,"date":"2010-05-04T22:39:28","date_gmt":"2010-05-04T14:39:28","guid":{"rendered":"https:\/\/umarzuki.org\/blogku\/?p=359"},"modified":"2010-05-04T22:39:28","modified_gmt":"2010-05-04T14:39:28","slug":"bermain-dengan-mysql-1","status":"publish","type":"post","link":"https:\/\/umarzuki.org\/blog\/2010\/05\/04\/bermain-dengan-mysql-1\/","title":{"rendered":"Bermain dengan MySQL #1"},"content":{"rendered":"<p>Pada distro berdasarkan Debian, MySQL boleh dipasang dengan memasang pakej mysql-server<br \/>\n<code># aptitude install mysql-server<\/code><\/p>\n<p>Jika anda ingin mencuba-cuba bermain dengan pengkalan data yang telah banyak data didalamnya, dapatkan sakila dari <a href=\"http:\/\/dev.mysql.com\/doc\/index-other.html\">http:\/\/dev.mysql.com\/doc\/index-other.html<\/a><\/p>\n<p>Untuk memasangnya, lakukan seperti di dalam artikel berikut<br \/>\n<a href=\"http:\/\/dev.mysql.com\/doc\/sakila\/en\/sakila.html#sakila-installation\">http:\/\/dev.mysql.com\/doc\/sakila\/en\/sakila.html#sakila-installation<\/a><\/p>\n<p>Anda boleh query pengkalan data dan tables-nya melalui baris arahan seperti berikut:<br \/>\n<code># mysql sakila -u root -pabc123 -e \"show tables;\"<\/code><\/p>\n<p>Perhatikan selepas -p adalah abc123 yang merupakan kata laluan untuk pengguna root pelayan MySQL tersebut<\/p>\n<p>Selamat mencuba!<br \/>\nLaman manual untuk MySQL 5.1 (versi dasar untuk Debian 6) boleh disemak di <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/\">http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/<\/a> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pada distro berdasarkan Debian, MySQL boleh dipasang dengan memasang pakej mysql-server # aptitude install mysql-server Jika anda ingin mencuba-cuba bermain dengan pengkalan data yang telah banyak data didalamnya, dapatkan sakila dari http:\/\/dev.mysql.com\/doc\/index-other.html Untuk memasangnya, lakukan seperti di dalam artikel berikut http:\/\/dev.mysql.com\/doc\/sakila\/en\/sakila.html#sakila-installation Anda boleh query pengkalan data dan tables-nya melalui baris arahan seperti berikut: # mysql [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44],"tags":[148,149],"class_list":["post-359","post","type-post","status-publish","format-standard","hentry","category-pengkalan-data","tag-bash","tag-mysql"],"_links":{"self":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/posts\/359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/comments?post=359"}],"version-history":[{"count":0,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/posts\/359\/revisions"}],"wp:attachment":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/media?parent=359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/categories?post=359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/tags?post=359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}