Siapkan databasenya dan
Tabelnya
badi@localhost ~]$
mysql -u root
Welcome to the MySQL
monitor. Commands end with ; or \g.
Your MySQL connection
id is 32
Server version: 5.1.32
Source distribution
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> use simpeg;
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> select *
from pegawai;
+-------+-----------------------+--------+------+-------+
| NIP | NAMA | ALAMAT
| SEKS | AGAMA |
+-------+-----------------------+--------+------+-------+
| 10002 | Endang
Susilowati sss | Madiun | P | ISLAM |
| 10003 | Made Saputra
| Bali | L | HINDU |
| 10004 | Bejo |
Bantul | L | BUDHA |
+-------+-----------------------+--------+------+-------+
3 rows in set (0.00
sec)