Unknown column 's1' in 'field list'
来源:互联网 发布:淘宝网首页电脑版 编辑:程序博客网 时间:2024/05/21 07:11
错误信息:Unknown column 's1' in 'field list'
分析原因:数据库中的字符串要用引号区分的,所以,
sql="update stu set name='"+name+"',classes='"+classes+"',score='"+score+"' where id='"+id+"'";必须要加上单引号,才可以区分出来。
mysql总结
在数据库里面采用的是单引号。有句口诀叫单单双双加加。意思就是说,最外面为单引号,然后是双引号,接着是两个+号,最里面为字符串。如下所示:
string sql=”select * from table where id>0 and name='”+nn+”'”;
0 0
- Unknown column 's1' in 'field list'
- Unknown column 'Mary' in 'field list'
- Unknown column 'Extent1.Discriminator' in 'field list'
- Unknown column 'conuintoken' in 'field list' 解决办法
- Unknown column 'filevalue' in 'field list'
- Unknown column 'user_Id' in 'field list'
- Unknown column 'Mary' in 'field list'
- Unknown column '*' in 'field list' 异常解决
- Unknown column 'organ_id' in 'field list'
- Unknown column 'Mary' in 'field list'
- Unknown column 'xxx' in 'field list'
- Unknown column '' in 'field list'解决方案
- Unknown column '' in 'field list'解决方案
- Unknown column 'user0_.id' in 'field list'
- Unknown column 'xxx' in 'field list'
- Unknown column '' in 'field list'解决方案
- Hibernate下的Unknown column 'student_number' in 'field list'错误
- MySQL Query : Unknown column 'paginationtype' in field list
- Android入门标准
- 插花艺术之东方式花艺
- 一道微软笔试题
- ADT的Android SDK版本扩展
- Android开发学习笔记之通过反射技术修改listview的快速滑块图像
- Unknown column 's1' in 'field list'
- 相册制作软件--4月精选婚纱相册模板{H1.爱的天空}样片
- 10招教你完全识别IDC骗子
- Codeforces Round #135 (Div. 2) D 树形dp
- 优化多个Fragment切换出现的问题FragmentTabAdapter
- centos7 安装 vnc
- Java中equals和==的区别
- oracle中pl/sql编程案例
- Java Web高级特性之(四)过滤器、监听器、拦截器的区别