How to check NULL Values from MYSQL database column

2019 5 16
1 个回答
更新时间：2024 10 21
21 次查看（30 天）

0 个投票

Hello all,
I want to implement below statement of Mysql database in matlab to detect null values of column.
Mysql query:
SELECT * FROM table_name WHERE column IS NULL
Can anybody help me with this? how can I implement the same in Matlab?
Regards,
Raj

2 个评论
显示 无 隐藏 无

Raj Tailor
Raj Tailor 2019-5-16
Hello TADA,
I want to query the data from the database which has NULL values (no value/empty) in column.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Piyush Kumar
Piyush Kumar 2024-10-21
编辑：Piyush Kumar 2024-10-21

0 个投票

Hi,
To fetch those rows from a database where a column is empty or null in SQL, you can use COALESCE(column, ”) or column IS NULL OR column = ”. These queries fetch rows where the specified column contains an empty string or null value.
To execute this query in MATLAB,
  • Use the database function to establish a connection to the database
  • Use the fetch function to import data into MATLAB workspace from the execution of SQL statement

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by