AcidLava Posted November 14 Share Posted November 14 Hello, On PS 8.1, I'm looking for a SQL request or any way to mass update all my product to the "Used" state. Thanks for your feedback Link to comment Share on other sites More sharing options...
Renaud B Posted November 15 Share Posted November 15 Hello, This shoudl do it: UPDATE ps_product SET `condition` = "used" Link to comment Share on other sites More sharing options...
ventura Posted November 16 Share Posted November 16 It is always advisable before performing any operation on the database records to first perform a backup of the database or tables affected by the changes. Also it is always advisable to use a filter in the queries that modify data, delete, update Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now