MySQL Forums
Forum List  »  Quality Assurance

problem of load_file() in mysql 5.5
Posted by: JI MIN
Date: October 24, 2012 01:53PM

Hello everyone,
I want to use load_file() function to upload xml documents into a table. I grant the table with the FILE privilege(using "grant all on tablename.* to 'root'@'localhost'").I am sure that The xml file is located on the MySQL server host. It is just on the desktop. and when I using load_file() function in mysql (insert into `test` values(load_file('C:\Users\think\Desktop\city.xml'))), the error "#1048 - Column 'content' cannot be null" shows. Sometimes when I change the path of the xml file, it can work but sometimes it cannot.I dont know the reason. I dont know how to slove this problem.

Options: ReplyQuote


Subject
Views
Written By
Posted
problem of load_file() in mysql 5.5
3841
October 24, 2012 01:53PM
1724
October 24, 2012 02:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.