Copy Data problem

[neugi]

Hi,

i want to copy some data form one db to a other.

i tried this syntax but it don't worked:
[code]
INSERT INTO `testbd`.`ARTIKEL`
SELECT *
FROM `testdb2`.`ARTIKEL` , `testdb`.`ARTIKEL`
WHERE `testdb2`.`ARTIKEL`.`ARTNUM` >

MAX( `testdb`.`ARTIKEL`.`ARTNUM` )[/code]

what i want is, take all the article that are missing in the first databas and put it into the other database. based on the ARTNUM field.

best

[fenway]

What didn't work?

[Barand]

try [code]
INSERT INTO `testbd`.`ARTIKEL`
SELECT b.*
FROM `testdb2`.`ARTIKEL` b
LEFT JOIN `testdb`.`ARTIKEL` a
ON a.ARTNUM = b.ARTNUM
WHERE a.ARTNUM IS NULL[/code]

[SQL_F1]

or

[code]
INSERT IGNORE INTO `testbd`.`ARTIKEL`
SELECT *
FROM `testdb2`.`ARTIKEL`
[/code]
to insert ALL the missing ones
although it seems you want to be inserting only the newer ones:
[code]

INSERT INTO `testbd`.`ARTIKEL`
SELECT *
FROM `testdb2`.`ARTIKEL`
WHERE `testdb2`.`ARTIKEL`.`ARTNUM` >
(SELECT MAX( `testdb`.`ARTIKEL`.`ARTNUM` )
    FROM  `testdb`.`ARTIKEL`
)
[/code]

[SQL_F1]

or

[code]
INSERT IGNORE INTO `testbd`.`ARTIKEL`
SELECT *
FROM `testdb2`.`ARTIKEL`
[/code]
to insert ALL the missing ones
although it seems you want to be inserting only the newer ones:
[code]

INSERT INTO `testbd`.`ARTIKEL`
SELECT *
FROM `testdb2`.`ARTIKEL`
WHERE `testdb2`.`ARTIKEL`.`ARTNUM` >
(SELECT MAX( `testdb`.`ARTIKEL`.`ARTNUM` )
    FROM  `testdb`.`ARTIKEL`
)
[/code]