SQL copy from one table to another

advertisements

I need to copy some field from one table to another.

first table is called phpbb_karma, second one is smf_log_karma

I need the following structure:

user_id -> id_executor
poster_id -> id_target
log_time -> karma_time
action -> karma_action

I ran the following query:

INSERT INTO
`smf_log_karma`
(`id_executor`, `id_target`, `log_time`, `action`)
SELECT
(`user_id`, `poster_id`, `karma_time`, `karma_action`)
AS
`id_executor`, `id_target`, `log_time`, `action`
FROM
`phpbb_karma`

and it returned

#1241 - Operand should contain 1 column(s)

Any help would be appreciated, thanks.


INSERT INTO
        `smf_log_karma`
        (`id_executor`, `id_target`, `log_time`, `action`)

   SELECT
        `user_id`, `poster_id`, `karma_time`, `karma_action`
        FROM
        `phpbb_karma` AS T1
 WHERE NOT EXISTS    (
                SELECT 1
                FROM `smf_log_karma` AS T2
                WHERE
               (T2.id_executor = T1.user_id) );