Matlab select query incorrectly handling null

조회 수: 5 (최근 30일)
Allan Brett
Allan Brett 2021년 2월 16일
댓글: Walter Roberson 2024년 5월 3일
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일
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일
% 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
Walter Roberson
Walter Roberson 2024년 5월 3일
I don't understand how this solves the problem of what MATLAB returns for missing values in a database query?

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

카테고리

Help CenterFile Exchange에서 Database Toolbox에 대해 자세히 알아보기

태그

제품


릴리스

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by