SQL code needed to update products table

[ewramos]

My zencart needs help. While entering new products I entered incorrect info for 'Product Qty Units:' field in the add new products form.

I can see that the database named ewramos_zenc1 has a table named products and a field called products_quantity_order_units.

This field currently holds a value of 1000 but needs a value of 1.

Can anyone supply SQLcode to update the field?

I'm no database guy so the help pretty much has to be 'cut and paste'.

Thanks in advance...

[ewramos]

I found a snipit of code. Can any confirm that it is correct before I blow-up my database?

UPDATE ewramos_zenc1 SET products_quantity_order_units = 1

[Ajeh]

You need to use the name of the products table and not the database:

UPDATE products SET products_quantity_order_units = 1;

Be sure to backup your database first ...