$stu_no存放待删除学生的学号，请补充下面的代码？ $sql="delete from student where stu_no=_______";
举一反三
- 删除student表中学号为101的记录。其SQL语句为（ ）。 A: DELETE stu where stu_no=101 B: DELETE studnets C: DELETE student WHERE stu_no=101 D: DELETE FROM student WHERE stu_no=101
- $stu_no 是从修改学生表单中获得的学号，$stu_get是从地址栏中获得中带修改的学生的学号参数。请将下面判断修改后的学号是否有重复的代码用补充完整。$sql="select * from student where stu_no_____'$stu_no' and stu_no______'$stu_get'"; $result1=mysqli_query($conn,$sql) ; if(mysqli_num_rows($result1)_____0) {$noErr="学号重复"; }
- 以下删除stu表成绩小于60的记录，可是实现的代码是（） A: delete stu where score<60; B: delete from stu where score<60; C: delete stu D: truncate stu where score<60;
- $stu_no 是从修改学生表单中获得的学号，$stu_get是从地址栏中获得中带修改的学生的学号参数。请将下面判断修改后的学号是否有重复的代码用补充完整。 $sql="select * from student where stu_no_____'$stu_no' and stu_no______'$stu_get'"; $result1=mysqli_query($conn,$sql) ; if(mysqli_num_rows($result1)_____0) { die("[script]alert('该学号重复,请重新输入!');history.go(-1);[/]") ; [br][/br] }
- $stu_no 是从修改学生表单中获得的学号，$stu_get是从地址栏中获得中带修改的学生的学号参数。请将下面判断修改后的学号是否有重复的代码用补充完整。$sql="select * from student where stu_no_____'$stu_no' and stu_no______'$stu_get'"; $result1=mysqli_query($conn,$sql) ; if(mysqli_num_rows($result1)_____0) {die("<script>alert('该学号重复,请重新输入!');history.go(-1);</script>") ; }