A table iD UNid vid time
1 3 5 2021-01-01 14:00:02
1 April 6 2021-01-01 15:15:02
Insert table B
ID UNid vid time
2 5 7 2021-01-01 14:00:05
2 5 8 2021-01-01 15:00:03
Seconds + 3
Data more than
How do you achieve? O great god

CodePudding user response:

After the search when opening the transaction cycle into the set not to go

CodePudding user response:

After learning, I am a little white, give a code reference

CodePudding user response:

Want to know first, you are using SQL statements, transaction commit to write to the DB,
Or use EF entity mapping model, to transform the write,

In general batch write, using a single SQL statement is more conservative, are now mainstream with more ORM technology to write DAL entity framework

CodePudding user response:

Insert into A table of values (select * from table B) so that you can