Create mysql database from xml file

After inserting the data, a message will be shown to the user about how many rows are newly added into the database. In case of any error occurrences, then the error message will be shown to the user about the cause of the error. This code checks the condition for the response text created during the process of inserting XML data into the database table. This response text is to acknowledge the user about the result of the MySQL insert. Do you want to build a modern, lightweight, responsive website quickly?

Contact Me. This is an ongoing effort to support XML imports and exports with relational databases using Perl and Java. This is a community-oriented open source project being managed on SourceForge. Would you like a slice? What are your experiences with XML and relational databases? Join the discussion below or send us an e-mail with your thoughts. Editor's Picks.

The best programming languages to learn in Check for Log4j vulnerabilities with this simple-to-use script. TasksBoard is the kanban interface for Google Tasks you've been waiting for. Paging Zefram Cochrane: Humans have figured out how to make a warp bubble.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 9 years, 4 months ago. Active 7 years, 3 months ago. Viewed 6k times. Improve this question. Amr Amr 1 1 gold badge 8 8 silver badges 13 13 bronze badges. Add a comment. Active Oldest Votes.

Improve this answer. Jainendra Jainendra Isn't there a way to do it with pure SQL syntax?? Use PHP to do this.