How to delete data that is empty in SQL?

To remove empty data, you can use the following SQL statement:

DELETE FROM 表名 WHERE 列名 IS NULL;

The table name refers to the name of the table with the data to be deleted, and the column name refers to the name of the column to be deleted if it is empty. Use IS NULL to determine if a certain column is empty. If a column is empty, the data in that row will be deleted.

Leave a Reply 0

Your email address will not be published. Required fields are marked *


广告
Closing in 10 seconds
bannerAds