insert into Student(Sno,Sname,Ssex,Sage,Sdept) values'95001','李勇','男','24','CS' '9500'1错误insert into Student(Sno,Sname,Ssex,Sage,Sdept) values('95001','李勇','男','24','CS')insert into Student(Sno,Sname,Ssex,Sage,Sdept) 列名无效查
来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/26 17:03:05
insert into Student(Sno,Sname,Ssex,Sage,Sdept) values'95001','李勇','男','24','CS' '9500'1错误insert into Student(Sno,Sname,Ssex,Sage,Sdept) values('95001','李勇','男','24','CS')insert into Student(Sno,Sname,Ssex,Sage,Sdept) 列名无效查
insert into Student(Sno,Sname,Ssex,Sage,Sdept) values'95001','李勇','男','24','CS' '9500'1错误
insert into Student(Sno,Sname,Ssex,Sage,Sdept)
values('95001','李勇','男','24','CS')
insert into Student(Sno,Sname,Ssex,Sage,Sdept) 列名无效
查询已成功执行,但是Student还是无效
insert into Student(Sno,Sname,Ssex,Sage,Sdept) values'95001','李勇','男','24','CS' '9500'1错误insert into Student(Sno,Sname,Ssex,Sage,Sdept) values('95001','李勇','男','24','CS')insert into Student(Sno,Sname,Ssex,Sage,Sdept) 列名无效查
先用select * from Student 看看各个列到底名称是什么,列明无效就是你字段名与数据库里不匹配