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 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.