@Aleos : You made my week This worked perfectly:
INSERT INTO `global_reg_value` (`account_id`, `str`, `value`, `type`) SELECT `account_id`, `key`, `value`, 2 FROM `acc_reg_num_db` WHERE `key` NOT LIKE '#%$';
INSERT INTO `global_reg_value` (`account_id`, `str`, `value`, `type`) SELECT `account_id`, `key`, `value`, 2 FROM `acc_reg_str_db` WHERE `key` LIKE '#%$';
INSERT INTO `global_reg_value` (`char_id`, `str`, `value`, `type`) SELECT `char_id`, `key`, `value`, 3 FROM `char_reg_num_db` WHERE `key` NOT LIKE '%$';
INSERT INTO `global_reg_value` (`char_id`, `str`, `value`, `type`) SELECT `char_id`, `key`, `value`, 3 FROM `char_reg_str_db` WHERE `key` LIKE '%$';
Thanks a lot !