Jump to content

Archived

This topic is now archived and is closed to further replies.

neugi

Copy Data problem

Recommended Posts

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

Share this post


Link to post
Share on other sites
What didn't work?

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.