REPLACE NULL

[dflow]

this is not working for me

update products
set [RegionID] = 0
where [RegionID] is null

[corbin]

That appears to be SQL Server style syntax.

 

 

Try:

 

UPDATE products SET RegionID = 0 WHERE RegionID IS NULL;

 

The quote identifier (because I can't remember what it's really called) is ` in MySQL.  It's [] in MSSQL.

 

 

Also, what error are you getting?

[dflow]

That appears to be SQL Server style syntax.

 

 

Try:

 

UPDATE products SET RegionID = 0 WHERE RegionID IS NULL;

 

The quote identifier (because I can't remember what it's really called) is ` in MySQL.  It's [] in MSSQL.

 

 

Also, what error are you getting?

 

thanks it was indeed the []