博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
sql报错
阅读量:4229 次
发布时间:2019-05-26

本文共 356 字,大约阅读时间需要 1 分钟。

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'while id=1' at line 3
好久不打sql命令,刚刚学mybatis,就发现了这个错误,最后发现sql语句的条件update tb_user
        set name=#{name},sex=#{sex},age=#{age}
        while id=#{id}错了,是where,基础要好好巩固啊。

转载地址:http://bpjqi.baihongyu.com/

你可能感兴趣的文章
Information Systems : Achieving Success by Avoiding Failure
查看>>
AutoCAD & AutoCAD LT All-in-One Desk Reference For Dummies
查看>>
C# Programmer's Handbook
查看>>
Constructing Accessible Web Sites
查看>>
Linux Smart Homes For Dummies
查看>>
Building an ASP.NET Intranet
查看>>
Automating UNIX and Linux Administration
查看>>
Advanced C# Programming
查看>>
The Java(TM) Tutorial: A Short Course on the Basics (3rd Edition)
查看>>
Solaris(TM) Performance and Tools: DTrace and MDB Techniques for Solaris 10 and OpenSolaris
查看>>
Unicode Explained
查看>>
Essential C# 2.0
查看>>
Eric Sink on the Business of Software
查看>>
LPI Linux Certification in a Nutshell
查看>>
ATL Internals: Working with ATL 8 (2nd Edition)
查看>>
Programming Sudoku
查看>>
Collaborative Geographic Information Systems
查看>>
The Definitive Guide to the .NET Compact Framework
查看>>
Java 2 Platform, Enterprise Edition: Platform and Component Specifications
查看>>
C++ Coding Standards: 101 Rules, Guidelines, and Best Practices
查看>>