| Oracle/MySQL 관련 게시판 |
|---|
| 2012/04/03(23:29) from 210.119.45.104 | |
| 작성자 : 주인장 | 조회수 : 3344 , 줄수 : 3 |
| [MySQL] A 테이블에서 B테이블로 select, insert로 옮기기 |
|---|
|
> insert into a_table (name, email, phone) select name, email, phone from b_table > insert into a_table (name, email, phone) select AES_ENCRYPT(name, 'key'), AES_ENCRYPT(email, 'key'), AES_ENCRYPT(phone, 'key') from b_table |
|
|