MySQL Forums
Forum List  »  Quality Assurance

Re: problem of load_file() in mysql 5.5
Posted by: JI MIN
Date: October 24, 2012 02:11PM

here is the code:
CREATE TABLE `test` (
`id` int(11) NOT NULL auto_increment,
`content` blob NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1_swedish_ci;


sql>grant all on text.* to 'root'@'localhost'

sql>insert into `test` values(null, load_file('C:\Users\think\Desktop\city.xml'))

error "#1048 - Column 'content' cannot be null" shows.

Options: ReplyQuote


Subject
Views
Written By
Posted
3726
October 24, 2012 01:53PM
Re: problem of load_file() in mysql 5.5
1657
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.