Matlab select query incorrectly handling null

5 visualizaciones (últimos 30 días)
Allan Brett
Allan Brett el 16 de Feb. de 2021
Comentada: Walter Roberson el 3 de Mayo de 2024
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.

Respuesta aceptada

Allan Brett
Allan Brett el 17 de Feb. de 2021
For those who run into this problem.
Go to section: Change Missing Values in Imported Data Using Vector Indexing

Más respuestas (1)

Fiza
Fiza el 3 de Mayo de 2024
Editada: Walter Roberson el 3 de Mayo de 2024
% 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 comentarios
Fiza
Fiza el 3 de Mayo de 2024
Need to correct this
Walter Roberson
Walter Roberson el 3 de Mayo de 2024
I don't understand how this solves the problem of what MATLAB returns for missing values in a database query?

Iniciar sesión para comentar.

Etiquetas

Productos


Versión

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by