summaryrefslogtreecommitdiff
path: root/update.sql
diff options
context:
space:
mode:
authorBenjamin Franzke <bfr@qbus.de>2015-02-18 15:48:18 +0100
committerBenjamin Franzke <bfr@qbus.de>2015-02-18 15:54:24 +0100
commitaceed71c01b9a25ee4fc70074d3edbd7c95042ad (patch)
tree04c1409cfc7449a03b37e47559acd5c3baf52c44 /update.sql
downloadendnote-import-aceed71c01b9a25ee4fc70074d3edbd7c95042ad.zip
endnote-import-aceed71c01b9a25ee4fc70074d3edbd7c95042ad.tar.gz
endnote-import-aceed71c01b9a25ee4fc70074d3edbd7c95042ad.tar.bz2
Implement simple xml import using xsl and load xml
Diffstat (limited to 'update.sql')
-rw-r--r--update.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/update.sql b/update.sql
new file mode 100644
index 0000000..c745643
--- /dev/null
+++ b/update.sql
@@ -0,0 +1,6 @@
+START TRANSACTION;
+DELETE FROM tx_likat_pubs_domain_model_publications;
+LOAD XML LOCAL INFILE './dbxml.xml'
+ INTO TABLE tx_likat_pubs_domain_model_publications
+ ROWS IDENTIFIED BY '<publication>';
+COMMIT;