mysql> delete from oxartextends where OXID in ("test0","test1","test2","test3");
Query OK, 1 row affected (0.00 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, 2 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, 2 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, 2 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('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, 2 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, 2 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, 2 rows affected, 7 warnings (0.01 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 rows affected, 7 warnings (0.00 sec)

mysql>
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>