store image in database in matlab

main.m
% read the image file
img = imread('image.jpg');

% convert the image to binary format
img_binary = reshape(dec2bin(img(:),8).'-'0',[],8);
img_dec = bi2de(img_binary);
img_binary_string = mat2str(img_binary);

% establish a connection to the database
conn = database('database_name', 'username', 'password', 'Vendor', 'MySQL', 'Server', 'localhost');

% define a table to store the image data
tablename = 'image_table';
colnames = {'id', 'image_data'};
coltypes = {'INT(11)', 'BLOB'};
colsize = {[], []};
create_table = sprintf('CREATE TABLE IF NOT EXISTS %s (%s %s(%s), %s %s(%s));', tablename, colnames{1}, coltypes{1}, colsize{1}, colnames{2}, coltypes{2}, colsize{2});
exec(conn, create_table);

% insert the image data into the table
data = {[1, img_dec]};
insert_data = sprintf('INSERT INTO %s (%s,%s) VALUES (%d, "%s")', tablename, colnames{1}, colnames{2}, data{1,1}, img_binary_string(2:end-1));
exec(conn, insert_data);

% close the database connection
close(conn);
976 chars
27 lines