Need help resolving SQL IMPORT ERROR
SQL file with the following type of code to fill a table with data from an xml file causes SQL errors in XAMPP/Mariadb SQL admin
INSERT INTO Some_Table (Some_Field) VALUES('0', 'TagName', $FILE{/FilePath/FileName.xml} )
Error refers to the $ preceding File and the {} brackets and suggests looking in the mariadb documentation for the cause
Either not wording my searches correctly or not understanding the error ... to me, it sounds as if MariaDB doesn't support the sql xml parser? If not, then what might provide a work around to load the xml files other than a manual import?
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.