Re: problem of load_file() in mysql 5.5

[JI MIN]

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.