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