Update and merge

Source: Internet
Author: User

Reference Address: http://blog.csdn.net/ml5271169588/article/details/6734981

According to the online content summarized as follows:

Update

Update tablename set ... where id=?

Merge

The record is first queried based on the ID, and if the data to be updated is the same as the queried data, there is no UPDATE statement.

If the data is not queried based on the ID, there is an insert record,

The following are excerpts from the Web:
When we use update, the state of the object A that we provide becomes persisted after execution is complete.
But when we use the merge, the execution is done, we provide the object A is still out of the tube State, hibernate or new a B, or retrieve a persistent object B, and we provide a copy of all the values of object A to this B, after the completion of the implementation of B is a persistent state, And the A we provide is a managed state.

**

Update and merge

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.