Merge two table

Radhi

Active member
Hello
I have two table of xf_ip
Who carry ip records, old and new
I want to merge them two while keeping new records and adding old ones
To become one table.

Structure of table

Code:
CREATE TABLE `xf_ip` (
  `ip_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` int(10) UNSIGNED NOT NULL,
  `action` varbinary(25) NOT NULL DEFAULT '',
  `ip` varbinary(16) NOT NULL,
  `log_date` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


Shaper in ip_id
How to merge?
 
Top Bottom