コピー元DB:customer
コピー先DB:customer_history
仮レコード:customer_tmp
CREATE TEMPORARY TABLE `customer_tmp` SELECT * from `customer` where id=’19’;
UPDATE `customer_tmp` set id = ‘NULL’;
INSERT INTO `customer_history` SELECT * FROM `customer_tmp`;
プログラミング Web屋@ NISHI
コピー元DB:customer
コピー先DB:customer_history
仮レコード:customer_tmp
CREATE TEMPORARY TABLE `customer_tmp` SELECT * from `customer` where id=’19’;
UPDATE `customer_tmp` set id = ‘NULL’;
INSERT INTO `customer_history` SELECT * FROM `customer_tmp`;
コメントを残す