Merge tabeller

INSERT INTO members
SELECT members_import.* FROM members_import LEFT JOIN members ON members_import.id=members.id WHERE members.id IS NULL

UPDATE members LEFT JOIN members_import ON members.id=members_import.id
SET members.status=X WHERE members_import.id IS NULL

Og det er kun et gæt !

Hej

Den kommer med følgende fejl i den første:

"Not unique table/alias : members"

/Sune

fik den løst, men nu er der en anden :

"INSERT TABLE members isnt allowed in FROM table list"

/Sune

til oplysning så benytter jeg mysql 3.23.45

Hm.

Jeg har ingen gode ideer med hensyn til den fejl.

Fandt følgende på www.mysql.com

It's okay to use a subquery for assignment within an UPDATE statement, since subqueries are legal in UPDATE and in DELETE statements as well as in SELECT statements. However, you cannot use the same table, in this case table t1, for both the subquery's FROM clause and the update target.

Det betyder vel at jeg må have en temp_tabel?!?

/Sune

Lyder sådan.

lukker