%Set preferences with setdbprefs.
setdbprefs('DataReturnFormat', 'cellarray');
setdbprefs('NullNumberRead', 'NaN');
setdbprefs('NullStringRead', 'null');
%Make connection to database. Note that the password has been omitted.
%Using ODBC driver.
conn = database('drilingdata', '', '');
%Read data from database.
% sqlquery = strcat('SELECT `邻井`.`井号` ,`邻井`.`井型`', ' FROM `邻井` ');
sqlquery = strcat('select * from 邻井');
%
curs = exec(conn, sqlquery);
curs = fetch(curs);
close(curs);
%Assign data to output variable
untitled = curs.Data;
[x,y]=size(untitled);
disp([x,y]);
disp(untitled);
%Close database connection.
close(conn);
%Clear variables
clear curs conn