Member Avatar

In my database table, 16 rows are inserted with null values for all columns. How can I delete these rows using SQL statement?

  • 3 Contributors
  • forum 2 Replies
  • 130 Views
  • 1 Day Discussion Span
  • comment Latest Post Latest Post by darkagn

Recommended Answers

Answered by darkagn 315 in a post from

To stop it from happening in the future, consider adding a primary key to the table. By definition a PK is not nullable and will help identify the records when they are inserted. For more information on primary keys see this

Jump to Post

All 2 Replies

Member Avatar

Something like this:

DELETE FROM my_table WHERE col1 IS NULL AND col2 IS NULL AND col3 IS NULL AND col4 IS NULL
Member Avatar

To stop it from happening in the future, consider adding a primary key to the table. By definition a PK is not nullable and will help identify the records when they are inserted. For more information on primary keys see this W3Schools page on the subject.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!