Hasil Tugas Sistem Basis Data

Nama              : Karta Yulis

NPM                : 12110901

Kelas               : SI-M1209

Microsoft Windows [Version 6.1.7601]

Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\HP>cd\

C:\>cd apache\mysql\bin

C:\apache\mysql\bin>mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 6 to server version: 3.23.47-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database jojo;

Query OK, 1 row affected (0.00 sec)

mysql> use jojo;

Database changed

mysql> create table film

    -> (kode_film varchar(15),

    -> nama_film varchar(20),

    -> jenis_film varchar(15),

    -> no_bangku varchar(10),

    -> harga integer(10));

Query OK, 0 rows affected (0.02 sec)

mysql> insert into film (kode_film)

    -> values

    -> ('S/RAM/001/100'),('L/CIN/002/120'),('H/KUC/002/100'),

    -> ('L/FS6/001/150'),('L/OVJ/005/160'),('S/HAT/001/100');

Query OK, 6 rows affected (0.00 sec)

Records: 6  Duplicates: 0  Warnings: 0

mysql> update film set

    -> nama_film = case

    -> when mid(kode_film,3,3)='RAM' then 'RAMBO'

    -> when mid(kode_film,3,3)='CIN' then 'CINTA'

    -> when mid(kode_film,3,3)='KUC' then 'KUCHI OH'

    -> when mid(kode_film,3,3)='FS6' then 'FASTFARIOUS 6'

    -> when mid(kode_film,3,3)='OVJ' then 'OPERA VAN JAVA'

    -> when mid(kode_film,3,3)='HAT' then 'HATI'

    -> end;

Query OK, 6 rows affected (0.00 sec)

Rows matched: 6  Changed: 6  Warnings: 0

mysql> update film set

    -> Jenis_film = case

    -> when left(kode_film,1)='S' then 'Sinetron'

    -> when left(kode_film,1)='L' then 'Laga'

    -> else 'Holywood'

    -> end;

Query OK, 6 rows affected (0.00 sec)

Rows matched: 6  Changed: 6  Warnings: 0

mysql> update film set

    -> no_bangku = case

    -> when mid(kode_film,7,3)='001' then 'Bangku 001'

    -> when mid(kode_film,7,3)='002' then 'Bangku 002'

    -> when mid(kode_film,7,3)='005' then 'Bangku 005'

    -> end;

Query OK, 6 rows affected (0.00 sec)

Rows matched: 6  Changed: 6  Warnings: 0

mysql> update film set

    -> harga = case

    -> when right(kode_film,3)='100' then '100000'

    -> when right(kode_film,3)='120' then '120000'

    -> when right(kode_film,3)='150' then '150000'

    -> else '160000'

    -> end;

Query OK, 6 rows affected (0.00 sec)

Rows matched: 6  Changed: 6  Warnings: 0

mysql> select*from film;

+---------------+----------------+------------+------------+--------+

| kode_film     | nama_film      | jenis_film | no_bangku  | harga  |

+---------------+----------------+------------+------------+--------+

| S/RAM/001/100 | RAMBO          | Sinetron   | Bangku 001 | 100000 |

| L/CIN/002/120 | CINTA          | Laga       | Bangku 002 | 120000 |

| H/KUC/002/100 | KUCHI OH       | Holywood   | Bangku 002 | 100000 |

| L/FS6/001/150 | FASTFARIOUS 6  | Laga       | Bangku 001 | 150000 |

| L/OVJ/005/160 | OPERA VAN JAVA | Laga       | Bangku 005 | 160000 |

| S/HAT/001/100 | HATI           | Sinetron   | Bangku 001 | 100000 |

+---------------+----------------+------------+------------+--------+

6 rows in set (0.00 sec)

mysql>