Store XML to Mysql
I need to store XML(Rss feed) to mysql. How to store with out d开发者_Python百科uplicate ? How to check them please help me for this.
Thank you.
LOAD XML LOCAL INFILE 'your file path' INTO TABLE yourSchema.yourTable rows identified by '<name_the_tag>';
If you have already set the columns correctly, this will not make the rows duplicate.
精彩评论