why don't you just export the products and the field you want to change using Apsona to a CSV, edit it and import it back, no need to risk sql mistakes?
Thread: SQL Syntax Help
Results 1 to 9 of 9
Hybrid View
-
28 Aug 2012, 10:15 PM #1
Totally Zenned
- Join Date
- Aug 2007
- Location
- Gijón, Asturias, Spain
- Posts
- 2,826
- Plugin Contributions
- 31
Re: SQL Syntax Help
Steve
github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...
-
29 Aug 2012, 06:49 AM #2
Deceased
- Join Date
- Jan 2007
- Location
- Australia
- Posts
- 6,167
- Plugin Contributions
- 7
Re: SQL Syntax Help
Speed!
Originally Posted by torvista
A few minutes spent learning how to achieve a bulk change using SQL can save many hours of export/edit/import, which also has its own risk of mistakes. The important thing is avoid doing the learning on 'live' data. Make a copy first.
Cheers
Rod
Reply With QuoteSimilar Threads
-
SQL Syntax error 1064 You have an error in your SQL syntax
By vxnut in forum General QuestionsReplies: 1Last Post: 25 Aug 2011, 05:58 AM -
HELP... 1064 You have an error in your SQL syntax;
By limelites in forum General QuestionsReplies: 11Last Post: 16 Oct 2009, 05:31 PM -
sql syntax error 1064 - HELP NEEDED - Master Password
By mydesignerstudio in forum All Other Contributions/AddonsReplies: 2Last Post: 20 Jul 2009, 04:22 PM -
SQL Syntax error: check for right syntax to use near '000000
By gabyone in forum General QuestionsReplies: 2Last Post: 9 Feb 2008, 08:23 PM -
1064 SQL syntax Error - Max Value Changed ...HELP!!
By Canvas101 in forum Setting Up Categories, Products, AttributesReplies: 3Last Post: 7 Oct 2007, 01:14 PM
