Do you agree us and have any suggestions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
MySQL provides an internal function named load_file(). It reads the file
saved on the host server and returns the contents of the file as a
string. This is an appoach to make users can read the file on the host
server directly by using database. But I think this function can be
improved further.
Firstly, load_file() only returns the whole contents of the file. We
need a large buffer(memory) to store it if the file is very large. The
file will be opened, read and closed once we use this file.
Secondly, if we want to read a file on the host server, the only way
provided by mysql is load_file(). But I know Oracle provides a filed
type named bfile, a pointer to the file and we can use this field to
read the file directly. In the customers' opinion, they also have this
kind of requirement.
So we want to add a field type representing a file on the server host
for mysql and make users can read the file conveniently. We can directly
use this field to read the whole or a part of the file.
