B*****g
发帖数: 34098 | 1 Oracle will fire the trigger, usually need to add WHEN clause to the trigger
.
I do know much about mysql.
how about
update xxxtable set col2 = col2||''
update xxxtable set col2 = col2, col3=col3
update xxxtable set col2 = col2, col3=col2
update xxxtable set col2 = CASE WHEN 1=1 THEN col2 ELSE col3 END |
|
a*******t
发帖数: 891 | 2 If a stored procedure takes ID as parameter and does a
select *
from xxxTable
where ID = @ID
Is it possible for me to get a SUM(cost) from the results without putting
the result into a table first? |
|
i****a
发帖数: 36252 | 3 I am always curious, is update xxxtable set col2 = col2 really an update.
curious on 2 levels. on the query execution level, is it really a
transaction, or does it set off trigger
on disk IO level, does it cause disk activity.
变。 |
|
