Question

数据库里如何用update更改表内数据

用UPDATE更新学好为‘2000070401’并且课程编号为‘A010001’的成绩为82，更新学好为2000070404的学生姓名为‘刘刚’性别为女，班级编号为‘20010704’
这个要怎么写啊？哪位高手指导下呀，非常感谢啊！！

Answer 1

UPDATE 表1 set 成绩 = 82 where 学号 = 2000070401’and 课程编号 =‘A010001’

UPDATE 表1 set 姓名 =‘刘刚’,性别 = '女'，班级编号 =‘20010704’
where 学号 = '2000070404'

Answer 2

比如:
string sql = "update news set title=@title,body=@body where id=@id";
OleDbParameter[] para = new OleDbParameter[] {
new OleDbParameter("@title", txttitle.Text.Trim()),
new OleDbParameter("@body", this.body.Value.ToString()),
new OleDbParameter("@id",int.Parse(Request["id"].ToString()))
};
DBClass.ExecuteNonQueryCan(sql, para)

Answer 3

update tbl_name set courseNo='A010001',courseGrade=82 where stuNo='2000070401';
update tbl_name set stuName='刘刚',sex='女'，classNo='20010704' where stuNo='2000070401';

Answer 4

UPDATE youtable set score = 82 where xuehao = '2000070401’and coursenum =‘A010001’

UPDATE youtable set name =‘刘刚’,sex = '女'，classnum =‘20010704’
where xuehao = '2000070404'