Welcome, Guest. Please login or register.

Author Topic: Menampilkan Nilai yang Unique di MySQL  (Read 1085 times)

Offline Adi Sunardy

  • The man who sold the world
  • Administrator
  • Hero Member
  • *****
  • Posts: 595
  • Just an Ordinary Man

  • Activity
    0.6%
  • OS:
  • Windows 7 Windows 7
  • Browser:
  • Firefox 3.6.13 Firefox 3.6.13
    • sharing is caring
Menampilkan Nilai yang Unique di MySQL
« on: February 25, 2011, 04:58:06 PM »
Hari ini saya mendapatkan email dari Bang Zahridani yang bertanya mengenai bagaimana menampilkan data yang unique dari sebuah tabel dengan data yang cenderung berantakan menggunakan MySQL. Berikut adalah contoh data yang dimaksud:

NIMNamaAlamat
11adimedan
12jackyuke
44penanpenayong
11adimedan
87jmemalay
44penanpenayong
11adimedan
12jackyuke
13adimedan

Untuk menjawab pertanyaan di atas, saya mencoba memaparkan dengan mencreate satu database dengan nama "Zahri", 1 tabel dengan nama "Test" dengan struktur dan data di atas.

Berikut capturannya:

Quote
[root@sitari ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3641
Server version: 5.1.52 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| cacti              |
| mysql              |
| test               |
| zahri              |
+--------------------+
5 rows in set (0.00 sec)

mysql> use zahri;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-----------------+
| Tables_in_zahri |
+-----------------+
| Test            |
+-----------------+
1 row in set (0.00 sec)

mysql> select * from Test;
+-----+-------+----------+
| NIM | Nama  | Alamat   |
+-----+-------+----------+
|  11 | adi   | medan    |
|  12 | jack  | yuke     |
|  11 | adi   | medan    |
|  12 | jack  | yuke     |
|  44 | penan | penayong |
|  11 | adi   | medan    |
|  87 | jme   | malay    |
|  44 | penan | penayong |
|  11 | adi   | medan    |
|  12 | jack  | yuke     |
|  13 | adi   | medan    |
+-----+-------+----------+
11 rows in set (0.00 sec)

mysql> select distinct Nama from Test;
+-------+
| Nama  |
+-------+
| adi   |
| jack  |
| penan |
| jme   |
+-------+
4 rows in set (0.00 sec)

mysql> select distinct NIM,Nama,Alamat from Test;
+-----+-------+----------+
| NIM | Nama  | Alamat   |
+-----+-------+----------+
|  11 | adi   | medan    |
|  12 | jack  | yuke     |
|  44 | penan | penayong |
|  87 | jme   | malay    |
|  13 | adi   | medan    |
+-----+-------+----------+
5 rows in set (0.00 sec)


Semoga Berguna :)
Jabat Erat,


Adi Sunardy
You are not allowed to view links. Register or Login

 
Share this topic...
In a forum
(BBCode)
In a site/blog
(HTML)


Related Topics

  Subject / Started by Replies Last post
5 Replies
2378 Views
Last post April 12, 2009, 02:56:11 PM
by rogol script
0 Replies
1022 Views
Last post March 21, 2011, 01:24:34 PM
by Adi Sunardy
0 Replies
865 Views
Last post April 11, 2011, 07:16:20 AM
by staff forum EUS
0 Replies
321 Views
Last post June 16, 2011, 07:58:42 AM
by staff forum EUS
0 Replies
277 Views
Last post September 06, 2011, 01:08:44 AM
by staff forum EUS