```
Column1  Column2  Column3  Column4  Column5  Column6
NULL    NULL     NULL   NULL     NULL     NULL

```

I have tried the following queries:

1.

```
Delete from tablename where column1 = NULL

```

2.

```
Delete from tablename where column1 IS NULL

```

The second query completed successfully but it said 0 rows affected.