CREATE TABLE binary_data(
id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,
description CHAR(50), bin_data LONGBLOB,
filename CHAR(50),
filesize CHAR(50),
filetype CHAR(50));INSERT INTO binary_data
(description,bin_data,filename,filesize,filetype)VALUES
('asdf','a','b','c','d');
SELECT * from binary_data;
id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,
description CHAR(50), bin_data LONGBLOB,
filename CHAR(50),
filesize CHAR(50),
filetype CHAR(50));INSERT INTO binary_data
(description,bin_data,filename,filesize,filetype)VALUES
('asdf','a','b','c','d');
SELECT * from binary_data;
id int not null AUTO_INCREMENT,
word_file BLOB,
PRIMARY KEY(id)
);mysql> insert into blobword set word_file=load_file("d:\\a.doc");
Query OK, 1 row affected (0.02 sec)