Hi
In the product_attributes table I want to add "1" into the attributes_price_factor column but only when the value of options_values_id column is "39" using an SQL query. I have googled this but can't find exactly what I am looking for.
Could anybody help me on this please.
Thanks
Mike
Thread: SQL Query Load data into column
Results 1 to 6 of 6
Threaded View
-
12 Aug 2015, 01:37 PM #1
New Zenner
- Join Date
- Feb 2012
- Posts
- 27
- Plugin Contributions
- 0
SQL Query Load data into column
Reply With QuoteSimilar Threads
-
v151 reuse of SQL query results without rerunning query and with minimal memory use
By mc12345678 in forum General QuestionsReplies: 9Last Post: 12 Jul 2023, 12:26 AM -
v154 Help with a SQL Query for Query Builder
By lindasdd in forum Managing Customers and OrdersReplies: 2Last Post: 24 Mar 2016, 01:18 PM -
v151 SQL query setup. How do I TEST a query 'off-line'?
By lewisasding in forum General QuestionsReplies: 3Last Post: 8 Mar 2013, 12:24 AM -
Why SQL query have p, pd etc on Zen Cart but table in SQL no the p or pd?
By explorer1979 in forum General QuestionsReplies: 2Last Post: 15 Aug 2011, 04:58 AM -
Convert supplier XML product list into SQL to load into my database?
By jessedye in forum General QuestionsReplies: 0Last Post: 27 Jul 2009, 07:07 AM
