BUAT KODE "UPDATE"

Kita belajar menggunakan PHP TRIAT mengenai UPDATE. Ini merupakan cara Pengkodean karakter.
ok langsung saja buka prongamnya dan ikuti printah berikut.

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\YUYUN PURNOMO>cd\apache\mysql\bin

C:\apache\mysql\bin>mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.47-nt



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

mysql> create database YUYUN;
Query OK, 1 row affected (0.00 sec)

mysql> use YUYUN;
Database changed
mysql> create table BIOSKOP(
    -> kd_film varchar(10),
    -> nama_film varchar(25),
    -> jenis varchar(15),
    -> No_bangku varchar(10),
    -> nama_anda varchar(20));
Query OK, 0 rows affected (0.01 sec)

mysql> insert into BIOSKOP (kd_film) values
    -> ('S-01*01'),('L-02*02'),('H-03*03');
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> select*from BIOSKOP;
+---------+-----------+-------+-----------+-----------+
| kd_film | nama_film | jenis | No_bangku | nama_anda |
+---------+-----------+-------+-----------+-----------+
| S-01*01 | NULL      | NULL  | NULL      | NULL      |
| L-02*02 | NULL      | NULL  | NULL      | NULL      |
| H-03*03 | NULL      | NULL  | NULL      | NULL      |
+---------+-----------+-------+-----------+-----------+
3 rows in set (0.00 sec)

mysql> update BIOSKOP set nama_film = case
    -> when mid(kd_film,3,2) = '01' then 'Rambo'
    -> when mid(kd_film,3,2) = '02' then 'OVJ'
    -> when mid(kd_film,3,2) = '03' then 'Fs6'
    -> end;
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql> update BIOSKOP set jenis = case
    -> when left(kd_film,1) = 'S' then 'Sinetron'
    -> when left(kd_film,1) = 'L' then 'Laga'
    -> when left(kd_film,1) = 'H' then 'Hollywood'
    -> end;
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql> update BIOSKOP set No_bangku = case
    -> when right(kd_film,2) = '01' then 'Bangku 01'
    -> when right(kd_film,2) = '02' then 'Bangku 02'
    -> when right(kd_film,2) = '03' then 'Bangku 03'
    -> end;
Query OK, 3 rows affected (0.01 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql> update BIOSKOP set nama_anda = case
    -> when mid(kd_film,5,1) = '*' then 'YUYUN'
    -> end;
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql> select*from BIOSKOP;
+---------+-----------+-----------+-----------+-----------+
| kd_film | nama_film | jenis     | No_bangku | nama_anda |
+---------+-----------+-----------+-----------+-----------+
| S-01*01 | Rambo     | Sinetron  | Bangku 01 | YUYUN    |
| L-02*02 | OVJ       | Laga      | Bangku 02 | YUYUN    |
| H-03*03 | Fs6       | Hollywood | Bangku 03 | YUYUN    |
+---------+-----------+-----------+-----------+-----------+
3 rows in set (0.00 sec)

mysql>