Uncategorized

Tutorial Basis Data dengan MySQL : Studi Kasus II (Memasukkan Data)

Di tutorial sebelumnya teah dijelaskan cara membuat database, tabel, dan relasi antar tabel. Pada tutorial ini akan disertakan cara mengisi tabel-tabel tersebut dengan berbagai macam data yang diperlukan. Command MySQL dan hasil keluarannya akan ditampilkan pada bagian-bagian sebagai berikut :

1). Memasukkan Data pada Tabel “ME”

mysql> insert into ME values(1001, 'George', 'Washington', 'Presiden Amerika I');
Query OK, 1 row affected (0.27 sec)
mysql> insert into ME values(1002, 'John', 'Adams', 'Presiden Amerika II');
Query OK, 1 row affected (0.25 sec)
mysql> insert into ME values(1003, 'Thomas', 'Jefferson', 'Presiden Amerika III');
Query OK, 1 row affected (0.02 sec)
mysql> insert into ME values(1004, 'James', 'Madison', 'Presiden Amerika IV');
Query OK, 1 row affected (0.03 sec)
mysql> insert into ME values(1005, 'James', 'Monroe', 'Presiden Amerika V');
Query OK, 1 row affected (0.05 sec)
mysql> select *from ME;
+-------+------------+------------+----------------------+
| my_id | first_name | last_name  | other_details        |
+-------+------------+------------+----------------------+
|  1001 | George     | Washington | Presiden Amerika I   |
|  1002 | John       | Adams      | Presiden Amerika II  |
|  1003 | Thomas     | Jefferson  | Presiden Amerika III |
|  1004 | James      | Madison    | Presiden Amerika IV  |
|  1005 | James      | Monroe     | Presiden Amerika V   |
+-------+------------+------------+----------------------+
5 rows in set (0.09 sec)


2). Memasukkan Data pada Tabel “SOCIAL_NETWORKS”

mysql> insert into SOCIAL_NETWORKS values(696318116, 'www.facebook.com', 'Facebook');
Query OK, 1 row affected (0.27 sec)
mysql> insert into SOCIAL_NETWORKS values(16814316, 'www.twitter.com', 'Twitter');
Query OK, 1 row affected (0.27 sec)
mysql> insert into SOCIAL_NETWORKS values(209111681, 'www.friendster.com', 'Friendster');
Query OK, 1 row affected (0.27 sec)
mysql> insert into SOCIAL_NETWORKS values(741201211, 'www.plurk.com', 'Plurk');
Query OK, 1 row affected (0.27 sec)
mysql> select *from SOCIAL_NETWORKS;
+--------------+--------------------+---------------------+
| network_code | network_name       | network_description |
+--------------+--------------------+---------------------+
|    168143162 | www.twitter.com    | Twitter             |
|    209111681 | www.friendster.com | Friendster          |
|    696318116 | www.facebook.com   | Facebook            |
|    741201211 | www.plurk.com      | Plurk               |
+--------------+--------------------+---------------------+
4 rows in set (0.01 sec)

3). Memasukkan Data pada Tabel “MY_EMAIL_LOGINS”

mysql> insert into MY_EMAIL_LOGINS values('gwashington', 1001, 696318116, ‘2009-12-19’
009, 'thomas_jefferson@gmail.com', 'jefferson03', 'Alamat email T. Jefferson');
Query OK, 1 row affected (0.02 sec)
mysql> insert into MY_EMAIL_LOGINS values('jadams', 1002, 696318116, ‘2009-12-20’
9, 'james_madison@gmail.com', 'madison04', 'Alamat email J. Madison');
Query OK, 1 row affected (0.03 sec)
mysql> insert into MY_EMAIL_LOGINS values('tjefferson', 1003, 696318116, ‘2009-12-21’, 'thomas_jefferson@gmail.com', 'jefferson03', 'Alamat email T. Jefferson');
Query OK, 1 row affected (0.02 sec)
mysql> insert into MY_EMAIL_LOGINS values('jmadison', 1004, 696318116, ‘2009-12-20’, 'james_madison@gmail.com', 'madison04', 'Alamat email J. Madison');
Query OK, 1 row affected (0.03 sec)
mysql> insert into MY_EMAIL_LOGINS values('jmonroe', 1005, 696318116, ‘2009-12-19’, 'john_monroe@gmail.com', 'monroe_05', 'Alamat email J. Monroe');
Query OK, 1 row affected (0.06 sec)
mysql> select *from MY_EMAIL_LOGINS;
+-------------+-------+--------------+----------------+-------------------------
----+-------------------+----------------------------+
| my_login    | my_id | network_code | date_signed_up | my_email_name
| my_email_password | other_details              |
+-------------+-------+--------------+----------------+-------------------------
----+-------------------+----------------------------+
| gwashington |  1001 |    696318116 | 2009-12-19     | george_washington@gmail.
com | washington01      | Alamat email G. Washington |
| jadams      |  1002 |    696318116 | 2009-12-20     | john_adams@gmail.com
| adams02           | Alamat email J. Adams      |
| jmadison    |  1004 |    696318116 | 2009-12-21     | james_madison@gmail.com
| madison04         | Alamat email J. Madison    |
| jmonroe     |  1005 |    696318116 | 2009-12-20     | john_monroe@gmail.com
| monroe_05         | Alamat email J. Monroe     |
| tjefferson  |  1003 |    696318116 | 2009-12-19     | thomas_jefferson@gmail.c
om  | jefferson03       | Alamat email T. Jefferson  |
+-------------+-------+--------------+----------------+-------------------------
----+-------------------+----------------------------+
5 rows in set (0.00 sec)

4). Memasukkan Data pada Tabel “MY_BOXES”

mysql> insert into SENT_MESSAGES values ('001', 'gwashington', '2009-12-19', 'ja
mes_monroe@gmail.com', 'Greeting', 'Good night, Sir', '');
Query OK, 1 row affected (0.08 sec)
mysql> insert into SENT_MESSAGES values ('002', 'gwashington', '2009-12-19', 'jo
hn_adams@gmail.com', 'Introduction', 'Nice to meet you', '');
Query OK, 1 row affected (0.05 sec)
mysql> select *from SENT_MESSAGES;
+------------+-------------+------------+------------------------+--------------
+------------------+---------------+
| message_id | my_login    | date_sent  | to_email_address       | subject
| message          | other_details |
+------------+-------------+------------+------------------------+--------------
+------------------+---------------+
| 001        | gwashington | 2009-12-19 | james_monroe@gmail.com | Greeting
| Good night, Sir  |               |
| 002        | gwashington | 2009-12-19 | john_adams@gmail.com   | Introduction
| Nice to meet you |               |
+------------+-------------+------------+------------------------+--------------
+------------------+---------------+
2 rows in set (0.00 sec)

5). Memasukkan Data pada Tabel “NOTIFICATIONS”

mysql> insert into NOTIFICATIONS values ('001', 'gwashington', '2009-12-19', 'Up
date Status', 'Staying at home...', '');
Query OK, 1 row affected (0.27 sec)
mysql> insert into NOTIFICATIONS values ('002', 'gwashington', '2009-12-20', 'Up
date Status', 'have a nice day...', '');
Query OK, 1 row affected (0.05 sec)
mysql> select *from NOTIFICATIONS;
+-----------------+-------------+---------------+---------------+---------------
-----+---------------+
| notification_id | my_login    | date_received | subject       | message
| other_details |
+-----------------+-------------+---------------+---------------+---------------
-----+---------------+
| 001             | gwashington | 2009-12-19    | Update Status | Staying at hom
e... |               |
| 002             | gwashington | 2009-12-20    | Update Status | have a nice da
y... |               |
+-----------------+-------------+---------------+---------------+---------------
-----+---------------+

6). Memasukkan Data pada Tabel “UPDATES”

mysql> insert into UPDATES values ('001', 'gwashington', '2009-12-22', 'Update S
tatus', 'Having a dinner', '');
Query OK, 1 row affected (0.08 sec)
mysql> insert into UPDATES values ('002', 'gwashington', '2009-12-22', 'Update S
tatus', 'Time to sleep', '');
Query OK, 1 row affected (0.03 sec)
mysql> select *from UPDATES;
+-----------+-------------+---------------+---------------+-----------------+---
------------+
| update_id | my_login    | date_received | subject       | message         | ot
her_details |
+-----------+-------------+---------------+---------------+-----------------+---
------------+
| 001       | gwashington | 2009-12-22    | Update Status | Having a dinner |
|
| 002       | gwashington | 2009-12-22    | Update Status | Time to sleep   |
|
+-----------+-------------+---------------+---------------+-----------------+---
------------+
2 rows in set (0.00 sec)

Pada tutorial selanjutnya, akan diberikan cara melakukan operasi Query pada MySQL. Semoga bermanfaat…