Delete from table where is null




















I have a database that contains an inventory that was uploaded from excel and for some reason it inserted about 15 rows with all NULLS. There are many ways to do this. Learn More. Ask a question. Quick access.

Search related threads. Remove From My Forums. You are not adding anything new. Sure this is the same answer as Phil, but I like this answer more because it has documentation. Arsen Khachaturyan Arsen Khachaturyan 6, 4 4 gold badges 35 35 silver badges 37 37 bronze badges. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Linked 0. Each column must have a datatype. The child data is NOT deleted.

It specifies what to do with the child data when the parent data is updated. It means that no action is performed with the child data when the parent data is deleted or updated. It means that the child data is either deleted or updated when the parent data is deleted or updated.



0コメント

  • 1000 / 1000