Matlab select query incorrectly handling null

Running a simple mysql select query (select * from table) using the SELECT(CONN,QUERY) command. If I run the query through the command line I can view the data as expected. There are a few columns where every value is null which is correct for the data. If I run the query through the Matlab select command all row columns except one return as expected. One column instead of reading all NULL as it should, returns all -2147483648. Any help is appreciated.

 채택된 답변

Allan Brett
Allan Brett 2021년 2월 17일

0 개 추천

For those who run into this problem.
Go to section: Change Missing Values in Imported Data Using Vector Indexing

추가 답변 (1개)

Fiza
Fiza 2024년 5월 3일
편집: Walter Roberson 2024년 5월 3일

0 개 추천

% Read the image
f=imread('f.jpg');
b=imread('f2.jpg');
%convert images to grayscale
if size(f,3)==3
f=rgb2gray(f);
end
if size(b,3)==3
b=rgb2gray(b);
end
% perform normalized cross-correlation
R=normxcorr2(f,b);

댓글 수: 2

Fiza
Fiza 2024년 5월 3일
Need to correct this
I don't understand how this solves the problem of what MATLAB returns for missing values in a database query?

댓글을 달려면 로그인하십시오.

카테고리

제품

릴리스

R2020b

태그

질문:

2021년 2월 16일

댓글:

2024년 5월 3일

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by