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
Shaper in ip_id
How to merge?
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?