How to insert the delete data update (note do not use the update)

CodePudding user response:

Said demand for concrete, the best test data and results are presented

CodePudding user response:

Such as this, UPDATE the name of the table 1 gygx
The SET gygx. Gyoid=
(the SELECT gy. Pid FROM table 2 gy
WHERE gygx. Oids=gy. Oid AND gy. Reltype=21
)

CodePudding user response:

Is a full table updates? I will see what you mean,
The insert to update the data to a table inside first, and then delete the old data,
PS: why do it?

CodePudding user response:

Yes, because before using the update will appear some problems in the project, just wonder if can use the delete and insert instead of the update, is similar to the hadoop no update, is to use the insert overwrite

CodePudding user response:

Update error because you written statement is not right,
Headache medicine foot, this is wrong?