Member Avatar for bnitishpai

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
  • 2 Replies
  • 153 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by darkagn
Member Avatar for AleMonteiro

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 for darkagn

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.