syntaxed Posted August 13, 2013 Share Posted August 13, 2013 (edited) Hi. I am trying to set up shipping cost per item based on weight and I'm still new with SQL. 1. How can I update all the weight of each item in my store to 1 using SQL query? 2. How can I set the default weight of new item as 1? I tried the following query but it gives the error below. Currently running the 220.127.116.11 prestashop update 'ps_product' set weight=1 The error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''ps_product' set weight=1' at line 1 Edited August 14, 2013 by syntaxed (see edit history) 1 Link to comment Share on other sites More sharing options...
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 account
Already have an account? Sign in here.Sign In Now