[SOLVED] deleting blank rows

[jakebur01]

Hey,

 

I have some rows in my mysql table that have blank fields as part numbers. I want to delete all of the rows that have blank part numbers.

 

would it be like:

 

delete from table where partnumber = '0';

???

[Lumio]

try it

[jakebur01]

dude I would but I have like 80,000 rows of product and I don't need to risk screwing anything up.

 

 

[phast1]

It depends on the type of field and the current value for "blank" rows.. Look at the data in your table and see what value is in the part number field and use that in your delete statement.. If the field is really blank, then you would probably use:

 

delete from table where partnumber = '';

 

Or, if that field has NULL values for the blank ones, then you would use:

 

delete from table where partnumber = NULL;

 

[jakebur01]

I appreciate it.

 

[phast1]

ALWAYS MAKE A BACKUP OF YOUR DATA BEFORE TRYING ANYTHING!!

 

I think there is also a way to run a query in test mode in order to see what the result would be without actually doing it, but I can't remember how off the top of my head..

 

[pocobueno1388]

Try this:

mysql_query("DELETE table WHERE partnumber = '' ");

 

Why don't you make a select statement that finds all the blank rows and print them out to make sure the delete query will be safe to do?

 

$sql = mysql_query("SELECT * FROM table WHERE partnumber="" ");

while ($row = mysql_fetch_assoc($sql)){
   echo $row['col'].'<br>';
}