MariaDB [test]> delete from t1;

Query OK, 2 rows affected (0.04 sec)

MariaDB [test]> load xml infile '/home/elenst/tmp/t1.xml' into table t1;

Query OK, 2 rows affected (0.04 sec)                 

Records: 2  Deleted: 0  Skipped: 0  Warnings: 0

MariaDB [test]> select * from t1;

+------+

| i    |

+------+

|    1 |

|    2 |

+------+

2 rows in set (0.00 sec)

20150114 20:47:51,wheezy-64,root,localhost,12,139,QUERY,test,'delete from t1',0

20150114 20:47:55,wheezy-64,root,localhost,12,141,QUERY,test,'select * from t1',0