Saindra Santyadiputra

CREATE TABLE TBLPM

mysql> create table tblpm
-> (idtblpm int not null primary key,
-> data char(10))
-> engine=innodb;
Query OK, 0 rows affected (0.08 sec)


CREATE TABLE TBLCASCADE

mysql> create table tblcascade
-> (idtblpm int not null,
-> idtblcascade int not null primary key,
-> data char(10),
-> foreign key (idtblpm) references tblpm(idtblpm) ON UPDATE CASCADE
-> )ENGINE=INNODB;
Query OK, 0 rows affected (0.08 sec)


INSERT VALUE TO TBLPM

mysql> insert into tblpm values
-> ('1','A'),
-> ('2','B'),
-> ('3','C'),
-> ('4','D'),
-> ('5','E');
Query OK, 5 rows affected (0.03 sec)
Records: 5 Duplicates: 0 Warnings: 0


INSERT VALUE TO TBLCASCADE

mysql> insert into tblcascade values
-> ('1','1','A'),
-> ('2','2','B'),
-> ('3','3','C'),
-> ('4','4','D'),
-> ('5','5','E');
Query OK, 5 rows affected (0.06 sec)
Records: 5 Duplicates: 0 Warnings: 0


CHANGING VALUE IN TBPM

mysql> update tblpm set idtblpm='9' where idtblpm='1';
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0

SHOW VALUE TBLPM

mysql> select * from tblpm order by data asc;
+---------+------+
| idtblpm | data |
+---------+------+
| 9 | A |
| 2 | B |
| 3 | C |
| 4 | D |
| 5 | E |
+---------+------+
5 rows in set (0.00 sec)


VALUE ON TBLCASCADE HAS BEEN CHANGED TOO

mysql> select * from tblcascade order by data asc;
+---------+--------------+------+
| idtblpm | idtblcascade | data |
+---------+--------------+------+
| 9 | 1 | A |
| 2 | 2 | B |
| 3 | 3 | C |
| 4 | 4 | D |
| 5 | 5 | E |
+---------+--------------+------+
5 rows in set (0.00 sec)
5 rows in set (0.00 sec)