常规update语句(通用):
update t_user
set user_name='abc'
where user_id='a123'
oracle:
update t_user tb
set tb.user_name='abc'
where user_id='a123'
sqlserver:
update tb
set tb.user_name='abc'
from t_user tb
where user_id='a123'
--记录下来以备所需常规update语句(通用):
update t_user
set user_name='abc'
where user_id='a123'
oracle:
update t_user tb
set tb.user_name='abc'
where user_id='a123'
sqlserver:
update tb
set tb.user_name='abc'
from t_user tb
where user_id='a123'
--记录下来以备所需