UPDATE-SQL value in table with another value in table

Question

I need to update a value in table with value in other table

String sql6="UPDATE project.wish_list SET project.wish_list.quantity= project.book.quantity";

But don't work why?

thank you

In human language, what you are saying is : set the wish list quantity to some value of book quantity, but I'm not going to tell you from which book. Why do you think he is unable to do that ? — tvCa
– tvCa, Commented Nov 28, 2014 at 14:32

Jens · Accepted Answer · 2014-11-28 09:37:27Z

2

You have to join the tables:

sql6="UPDATE project.wish_list join project.book on <condition> SET project.wish_lista.quantity= project.book.quantity";

answered Nov 28, 2014 at 9:37

Jens

69.6k15 gold badges107 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

nonickname Over a year ago

error ora-00971 missing set keyword: i tried sql6="UPDATE project.wish_list join project.book on project.book.isbn = project.wish_list.isbn SET project.wish_list.quantity= project.book.quantity";

Jens Over a year ago

@neo999 Can you try this:

UPDATE project.wish_list SET project.wish_lista.quantity= (SELECT project.book.quantity FROM project.book WHERE project.book.isbn = project.wish_list.isbn)

Stimart · Accepted Answer · 2014-11-28 09:39:12Z

2

First of all you have a syntax error:

UPDATE project.wish_list SET project.wish_lista.quantity= project.book.quantity

The "a" in whish_list -> "project.wish_lista.quantity"... it should be:

UPDATE project.wish_list SET project.wish_list.quantity= project.book.quantity

answered Nov 28, 2014 at 9:39

Stimart

4484 gold badges8 silver badges20 bronze badges

1 Comment

nonickname Over a year ago

yes I know, It's typo error when i write post, sorry

Dhaval · Accepted Answer · 2014-11-28 09:39:57Z

2

Update wish_list set wish_list.quantity= book.quantity from wish_list as wish_list     

inner join book as book on wish_list.ID=book .ID

answered Nov 28, 2014 at 9:39

Dhaval

2,3791 gold badge15 silver badges16 bronze badges

2 Comments

nonickname Over a year ago

"on wish_list.ID" What is ID? (I have ISBN in book table and book wish list) thanks

Dhaval Over a year ago

ID is Primary Key For wish_list and Foreign Key for book or vice versa

Collectives™ on Stack Overflow

UPDATE-SQL value in table with another value in table

3 Answers 3

2 Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related