使用SQL命令将教师表teacher中工资salary字段的值增加500,应该使用的命令是()。
发布时间:2021年10月04日
A.Replace salary with salary+500
B、Update teacher salary with salary+500
C、Update set salary with salary+500
D、Update teacher set salary=salary+500
答案:D
A.Replace salary with salary+500
B、Update teacher salary with salary+500
C、Update set salary with salary+500
D、Update teacher set salary=salary+500
答案:D