update.sql


1
2
3
4
5
6
7
8
9
10

START TRANSACTION;
DELETE FROM tx_likat_pubs_domain_model_publications;
DELETE FROM tx_likat_pubs_domain_model_authors;
LOAD XML LOCAL INFILE './dbxml.xml'
	INTO TABLE tx_likat_pubs_domain_model_publications
	ROWS IDENTIFIED BY '<publication>';
LOAD XML LOCAL INFILE './dbxml.xml'
	INTO TABLE tx_likat_pubs_domain_model_authors
	ROWS IDENTIFIED BY '<author>';
COMMIT;