mysql> delete from oxartextends where OXID in ("test0","test1","test2","test3"); Query OK, 1 row affected (0.09 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC) VALUES ('test0','inserted 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC = 'updated 0'; Query OK, 1 row affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test0','inserted 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'updated 1'; Query OK, 0 rows affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test0','inserted 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'updated 2'; Query OK, 0 rows affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test0','inserted 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'updated 3'; Query OK, 0 rows affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) V ALUES ('test1','inserted 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'updated 1'; Query OK, 1 row affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test1','inserted 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'updated 2'; Query OK, 0 rows affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test1','inserted 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'updated 3'; Query OK, 0 rows affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC) VALUES ('test1','inserted 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC = 'updated 0'; Query OK, 0 rows affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test2','inserted 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'updated 2'; Query OK, 1 row affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test2','inserted 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'updated 3'; Query OK, 0 rows affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC) VALUES ('test2','inserted 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC = 'updated 0'; Query OK, 0 rows affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test2','inserted 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'updated 1'; Query OK, 0 rows affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test3','inserted 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'updated 3'; Query OK, 1 row affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC) VALUES ('test3','inserted 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC = 'updated 0'; Query OK, 0 rows affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test3','inserted 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'updated 1'; Query OK, 0 rows affected, 7 warnings (0.00 sec) mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test3','inserted 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'updated 2'; Query OK, 0 rows affected, 7 warnings (0.00 sec) mysql> select OXID,OXLONGDESC,OXLONGDESC_1,OXLONGDESC_2,OXLONGDESC_3 from oxartextends where OXID in ("test0","test1","test2","test3"); +-------+------------+--------------+--------------+--------------+ | OXID | OXLONGDESC | OXLONGDESC_1 | OXLONGDESC_2 | OXLONGDESC_3 | +-------+------------+--------------+--------------+--------------+ | test0 | inserted 0 | updated 1 | updated 2 | updated 3 | | test1 | updated 0 | inserted 1 | updated 2 | updated 3 | | test2 | updated 0 | updated 1 | inserted 2 | updated 3 | | test3 | updated 0 | updated 1 | updated 2 | inserted 3 | +-------+------------+--------------+--------------+--------------+ 4 rows in set (0.00 sec) mysql>