1. Menambahkan primary key pada table
mysql>
alter table pelanggan add constraint
-> fk primary key(kode);
Query
OK, 16 rows affected (0.60 sec)
Records:
16 Duplicates: 0 Warnings: 0
2. Menambahkan field baru pada table pelanggan
mysql>
alter table pelanggan
-> add pembayaran char(30) not null;
Query
OK, 16 rows affected (0.42 sec)
Records:
16 Duplicates: 0 Warnings: 0
mysql> describe
pelanggan;
+------------+----------+------+-----+---------+-------+
| Field | Type
| Null | Key | Default | Extra |
+------------+----------+------+-----+---------+-------+
| kode | int(11) | NO
| PRI | 0 | |
| nama | char(20) | YES | |
NULL | |
| alamat | char(30) | YES | |
NULL | |
| kota | char(20) | YES | |
NULL | |
| notelp | char(20) | YES | |
NULL | |
| tipe | char(10) | YES | |
NULL | |
| pembayaran | char(30)
| NO | | NULL
| |
+------------+----------+------+-----+---------+-------+
7 rows in set (0.19 sec)
3.
Mengisi data pada field pembayaran.
mysql> update pelanggan
->
set pembayaran='bulanan'
->
where kode='123';
Query OK, 1 row affected (0.10 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='tahunan'
->
where kode='124';
Query OK, 1 row affected (0.10 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='bulanan'
->
where kode='125';
Query OK, 1 row affected (0.40 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='bulanan'
->
where kode='126';
Query OK, 1 row affected (0.06 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='tahunan'
->
where kode='127';
Query OK, 1 row affected (0.06 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='mingguan'
->
where kode='128';
Query OK, 1 row affected (0.11 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='mingguan'
->
where kode='129';
Query OK, 1 row affected (0.08 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='bulanan'
->
where kode='130';
Query OK, 1 row affected (0.48 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='bulanan'
->
where kode='131';
Query OK, 1 row affected (0.10 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='tahunan'
->
where kode='132';
Query OK, 1 row affected (0.07 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='tahunan'
->
where kode='133';
Query OK, 1 row affected (0.08 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='mingguan'
->
where kode='134';
Query OK, 1 row affected (0.07 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='mingguan'
->
where kode='135';
Query OK, 1 row affected (0.08 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='tahunan'
->
where kode='136';
Query OK, 1 row affected (0.04 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='mingguan'
->
where kode='137';
Query OK, 1 row affected (0.45 sec)
Rows matched: 1
Changed: 1 Warnings: 0
mysql> update pelanggan
->
set pembayaran='bulanan'
->
where kode='138';
Query OK, 1 row affected (0.07 sec)
Rows matched: 1
Changed: 1 Warnings: 0
4.
Tidak ada komentar:
Posting Komentar