File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Query for multiple updations in a table

 
sunita shaw
Ranch Hand
Posts: 45
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
UPDATE Ruby SET `eprodstatus` = 'InActive' where `vSKU` = '127712' , '127713' , 127714';

I want to set the word "Inactive" in 3 of the rows to the field with vsku= '127712' , '127713' and 127714';
My above query does not work.What is the query for making multiple updation to a column
Kindly let me know urgently as I have a release and I am stuck!!!
 
Maximilian Xavier Stocker
Ranch Hand
Posts: 381
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use OR in your WHERE clause...

The ending query should look like


[ December 02, 2005: Message edited by: Maximilian Stocker ]
 
Mahesh Rana
Ranch Hand
Posts: 139
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
UPDATE Ruby SET eprodstatus = 'InActive'
WHERE vSKU IN ( '127712' , '127713' , 127714');
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic