----------------
-- MySQL 접속
----------------
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21
Server version: 5.1.32-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
----------------
-- 데이터베이스 선택
----------------
mysql> use events;
Database changed
----------------
-- 임시테이블 생성 및 데이터 조회
----------------
mysql> create table test (
-> c_pk int not null primary key,
-> c_value varchar(50) null
-> );
Query OK, 0 rows affected (0.09 sec)
mysql> select * from test;
Empty set (0.00 sec)
----------------
-- 임시 테이블에 테스트 데이터 넣기
----------------
mysql> insert into test (c_pk, c_value) values (1, 'AA');
Query OK, 1 row affected (0.06 sec)
mysql> insert into test (c_pk, c_value) values (2, 'BB');
Query OK, 1 row affected (0.03 sec)
mysql> insert into test (c_pk, c_value) values (3, 'CC');
Query OK, 1 row affected (0.03 sec)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from test;
+------+---------+
| c_pk | c_value |
+------+---------+
| 1 | AA |
| 2 | BB |
| 3 | CC |
+------+---------+
3 rows in set (0.00 sec)
----------------
-- ■ 존재하는 ROW 에 대하여 replace into 구문을 사용.
----------------
mysql> replace into test (c_pk, c_value) values (2, 'ZZ');
Query OK, 2 rows affected (0.05 sec)
mysql> select * from test;
+------+---------+
| c_pk | c_value |
+------+---------+
| 1 | AA |
| 2 | ZZ |
| 3 | CC |
+------+---------+
3 rows in set (0.00 sec)
----------------
-- ■ 존재하지 않는 ROW 에 대하여 replace into 구문을 사용.
----------------
mysql> replace into test (c_pk, c_value) values (9, 'RR');
Query OK, 1 row affected (0.05 sec)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from test;
+------+---------+
| c_pk | c_value |
+------+---------+
| 1 | AA |
| 2 | ZZ |
| 3 | CC |
| 9 | RR |
+------+---------+
4 rows in set (0.00 sec)
mysql>
오라클9i 이상에선 MERGE INTO 구문을 사용하여 REPLACE INTO 구문을 대체할 수 있음.
대체적으로 매우 간단한 개념.
EOF : Zany (2009-04-15)
|
|
|
