topic %SQL delete from temp table driving me mad in Data Engineering https://community.databricks.com/t5/data-engineering/sql-delete-from-temp-table-driving-me-mad/m-p/95695#M39152 <P>Hello there, i have a temp table where i want to remove a null / empty values ( see below )</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RobDineen_0-1729682455777.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/12225iBBD3F2F5F7093FEE/image-size/medium?v=v2&amp;px=400" role="button" title="RobDineen_0-1729682455777.png" alt="RobDineen_0-1729682455777.png" /></span></P><P><BR />if there are no rows to delete, then shouldn't it just say Zero rows affected?</P><P>&nbsp;</P> Wed, 23 Oct 2024 11:21:46 GMT RobDineen 2024-10-23T11:21:46Z %SQL delete from temp table driving me mad https://community.databricks.com/t5/data-engineering/sql-delete-from-temp-table-driving-me-mad/m-p/95695#M39152 <P>Hello there, i have a temp table where i want to remove a null / empty values ( see below )</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RobDineen_0-1729682455777.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/12225iBBD3F2F5F7093FEE/image-size/medium?v=v2&amp;px=400" role="button" title="RobDineen_0-1729682455777.png" alt="RobDineen_0-1729682455777.png" /></span></P><P><BR />if there are no rows to delete, then shouldn't it just say Zero rows affected?</P><P>&nbsp;</P> Wed, 23 Oct 2024 11:21:46 GMT https://community.databricks.com/t5/data-engineering/sql-delete-from-temp-table-driving-me-mad/m-p/95695#M39152 RobDineen 2024-10-23T11:21:46Z Re: %SQL delete from temp table driving me mad https://community.databricks.com/t5/data-engineering/sql-delete-from-temp-table-driving-me-mad/m-p/95863#M39184 <P><a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/126224">@RobDineen</a>&nbsp;<BR />This should answer your question:&nbsp;<A href="https://community.databricks.com/t5/get-started-discussions/how-to-create-temporary-table-in-databricks/m-p/67774/highlight/true#M2956" target="_blank">https://community.databricks.com/t5/get-started-discussions/how-to-create-temporary-table-in-databricks/m-p/67774/highlight/true#M2956</A><BR /><BR />Long story short, don't use it.</P> Thu, 24 Oct 2024 07:35:39 GMT https://community.databricks.com/t5/data-engineering/sql-delete-from-temp-table-driving-me-mad/m-p/95863#M39184 daniel_sahal 2024-10-24T07:35:39Z Re: %SQL delete from temp table driving me mad https://community.databricks.com/t5/data-engineering/sql-delete-from-temp-table-driving-me-mad/m-p/95912#M39187 <P>Excellent, thank you&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/79106">@daniel_sahal</a>&nbsp;</P> Thu, 24 Oct 2024 09:01:40 GMT https://community.databricks.com/t5/data-engineering/sql-delete-from-temp-table-driving-me-mad/m-p/95912#M39187 RobDineen 2024-10-24T09:01:40Z