mybatis|mysql 批量更新问题之check the manual that corresponds to your MySQL server version for the right sy

最新推荐文章于 2024-07-26 03:47:23 发布
最新推荐文章于 2024-07-26 03:47:23 发布
阅读量3.7k 收藏 3
点赞数 3
分类专栏： mysql mybatis
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u014636209/article/details/113121408
版权

原始报错信息·


org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: 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 'update tv_service
       SET code = 'scode_gxf_20210125_002',

          name = ' at line 61
### The error may exist in file [/Users/gaoxinfu/wd/code/BesTV-OTT/sync-data-tvcms/target/classes/mapper/cts/CtsTvServiceSpecMapper.xml]
### The error may involve com.bestv.sync.data.tvcms.dao.mapper.cts.CtsTvServiceSpecMapper.updateBatch-Inline
### The error occurred while setting parameters
### SQL: update tv_service        SET code = ?,            name = ?,            type = ?,            price = ?,            validity_status = ?,            publish_status = ?,            create_time = ?,            update_time = ?,            operator_name = ?,            description = ?,            bitrate = ?,            item_type = ?,            charge_strategy = ?,            free_episode_new = ?,            charge_follow_episode = ?,            episode_mark_id = ?,            episode_mark_display_type = ?,            orgId = ?,            isDeleted = ?,            publishTime = ?,            memberTypeId = ?,            first_assembled_time = ?,            assembled_time = ?,            first_distributed_time = ?,            distributed_time = ?,            distributed_status = ?,            cts_deleted = ?,            cts_deleted_time = ?,            version = ?        where id = ?      ;        update tv_service        SET code = ?,            name = ?,            type = ?,            price = ?,            validity_status = ?,            publish_status = ?,            create_time = ?,            update_time = ?,            operator_name = ?,            description = ?,            bitrate = ?,            item_type = ?,            charge_strategy = ?,            free_episode_new = ?,            charge_follow_episode = ?,            episode_mark_id = ?,            episode_mark_display_type = ?,            orgId = ?,            isDeleted = ?,            publishTime = ?,            memberTypeId = ?,            first_assembled_time = ?,            assembled_time = ?,            first_distributed_time = ?,            distributed_time = ?,            distributed_status = ?,            cts_deleted = ?,            cts_deleted_time = ?,            version = ?        where id = ?
### Cause: 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 'update tv_service
       SET code = 'scode_gxf_20210125_002',

          name = ' at line 61
; bad SQL grammar []; nested exception is 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 'update tv_service
       SET code = 'scode_gxf_20210125_002',

          name = ' at line 61

	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:235)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
	at com.sun.proxy.$Proxy100.update(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:287)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:67)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57)
	at com.sun.proxy.$Proxy238.updateBatch(Unknown Source)
	at com.bestv.sync.data.tvcms.dao.mapper.cts.CtsTvServiceSpecMapperTest.updateBatch(CtsTvServiceSpecMapperTest.java:35)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:675)
	at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:125)
	at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:132)
	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:124)
	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:74)
	at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:104)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:62)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:43)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:35)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:202)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:198)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:135)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:69)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:135)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at java.util.ArrayList.forEach(ArrayList.java:1257)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at java.util.ArrayList.forEach(ArrayList.java:1257)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:32)
	at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)
	at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:229)
	at org.junit.platform.launcher.core.DefaultLauncher.lambda$execute$6(DefaultLauncher.java:197)
	at org.junit.platform.launcher.core.DefaultLauncher.withInterceptedStreams(DefaultLauncher.java:211)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:191)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:128)
	at com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:69)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
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 'update tv_service
       SET code = 'scode_gxf_20210125_002',

          name = ' at line 61
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1915)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1254)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
	at com.sun.proxy.$Proxy105.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
	at com.sun.proxy.$Proxy281.update(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
	... 69 more


Process finished with exit code 255

背景

概述

1.我们在开发的过程中，有些数据是不断地更新的，这个时候，可能需要我们不断地去进行数据同步，
  同一时间，变更的数据可能是多条的记录，因此我们需要批量更新
2.如果在同步的过程，只是同步更新一条记录是不会报上面的错的，
  只有同步多条记录的时候，才会报错，因此多条记录对于一个方法来讲其实是一个sql

Mapper

public interface CtsTvServiceSpecMapper {
    int updateBatch(@Param("updateList")List<CtsTvService> ctsTvServiceList);
}

Mapper SQL

<update id="updateBatch" parameterType="com.bestv.sync.data.tvcms.domain.entity.cts.CtsTvService" >
    <foreach item="item" index="index" collection="updateList" open="" separator=";" close="">
      update tv_service
      <set >
          code = #{item.code,jdbcType=VARCHAR},
          name = #{item.name,jdbcType=VARCHAR},
          type = #{item.type,jdbcType=VARCHAR},
          price = #{item.price,jdbcType=REAL},
          validity_status = #{item.validityStatus,jdbcType=BIGINT},
          publish_status = #{item.publishStatus,jdbcType=BIGINT},
          create_time = #{item.createTime,jdbcType=TIMESTAMP},
          update_time = #{item.updateTime,jdbcType=TIMESTAMP},
          operator_name = #{item.operatorName,jdbcType=VARCHAR},
          description = #{item.description,jdbcType=VARCHAR},
          bitrate = #{item.bitrate,jdbcType=VARCHAR},
          item_type = #{item.itemType,jdbcType=TINYINT},
          charge_strategy = #{item.chargeStrategy,jdbcType=SMALLINT},
          free_episode_new = #{item.freeEpisodeNew,jdbcType=VARCHAR},
          charge_follow_episode = #{item.chargeFollowEpisode,jdbcType=VARCHAR},
          episode_mark_id = #{item.episodeMarkId,jdbcType=BIGINT},
          episode_mark_display_type = #{item.episodeMarkDisplayType,jdbcType=SMALLINT},
          orgId = #{item.orgid,jdbcType=BIGINT},
          isDeleted = #{item.isdeleted,jdbcType=BIGINT},
          publishTime = #{item.publishtime,jdbcType=TIMESTAMP},
          memberTypeId = #{item.membertypeid,jdbcType=VARCHAR},
          first_assembled_time = #{item.firstAssembledTime,jdbcType=TIMESTAMP},
          assembled_time = #{item.assembledTime,jdbcType=TIMESTAMP},
          first_distributed_time = #{item.firstDistributedTime,jdbcType=TIMESTAMP},
          distributed_time = #{item.distributedTime,jdbcType=TIMESTAMP},
          distributed_status = #{item.distributedStatus,jdbcType=TINYINT},
          cts_deleted = #{item.ctsDeleted,jdbcType=TINYINT},
          cts_deleted_time = #{item.ctsDeletedTime,jdbcType=TIMESTAMP},
          version = #{item.version,jdbcType=INTEGER}
      </set>
      where id = #{item.id,jdbcType=BIGINT}
    </foreach>
  </update>

解决方案:

连接mysql数据库的配置中加上如下的配置： &allowMultiQueries=true

        url: jdbc:mysql://127.0.0.1:3306/cts?useUnicode=true&useSSL=false&zeroDateTimeBehavior=convertToNull&characterEncoding=utf8&serverTimezone=GMT%2B8&allowMultiQueries=true

在这里插入图片描述

具体关于 allowMultiQueries 的解释，大家可以参考了解

https://www.cnblogs.com/jeffen/p/6038261.html

东山富哥
关注
专栏目录
check the manual that corresponds to your MySQL server version for the right syntax to use完美解决
计算机毕业论文源码，学生个人网页制作html源码。贴近用户做网络推广和互联网优化。
09-02 17万+
check the manual that corresponds to your MySQL server version for the right syntax to use near方法有六个： 1、在数据库表冲突字段前后加 `符号(键盘Tab键上面那个键)，就不会再报语法错误了； 2、修改数据库表中冲突字段名称，修改为和 SQL语句关键字不冲突的其他名称。 3、navicat工具不可以，命令行可以。 check the manual that corresponds to your MySQ
逻辑删除报错：You have an error in your SQL syntax； check the manual that corresponds to your MySQL
肖肖的博客
06-18 2100
运行逻辑删除时报错
Mysql错误:check the manual that corresponds to your MySQL server version for the right syntax
LT_lover的专栏
12-27 16万+
数据库表字段与SQL关键字冲突导致的错误 错误信息为：check the manual that corresponds to your MySQL server version for the right syntax 这是之前写的一条 Mysql语句报的 SQL错误，但是仔细检查 SQL语句没有发现有什么异常问题。后来百度查到，我的数据库表中有一个字段名为 desc，这
mysql server version fro the right syntax to use near
最新发布
weixin_31690347的博客
07-26 1433
如何解决 “mysql server version for the right syntax to use near” 错误 作为一名经验丰富的开发者，我经常遇到新手开发者在处理MySQL时遇到的问题。其中最常见的问题之一是：“mysql server version for the right syntax to us...
org.apache.ibatis.binding.BindingException: Mapper method 'com.example.demo.mapper.UserMapper.findCo
ldlly0505的博客
12-13 4359
<select id="findCountByContditon" resultMap="user" parameterType="com.example.demo.po.User"> select count(id) from user <where> <if test="na...
【Database】表名是关键词MySQL server version for the right syntax
liudongdong_jlu
09-03 1156
Mysql错误:check the manual that corresponds to your MySQL server version for the right syntax【加 `符号、修改有冲突的字段名】 check the manual that corresponds to your MySQL server version for the right syntax错误【字段名用了...
check the manual that corresponds to your MySQL server version for the right syntax to use near
扎哇太枣糕的笔记博客
02-12 6万+
问题描述 想要在MyBatis中完成对指定表的指定字段的指定顺序进行排序，这么一看就需要传三个参数供mapper映射文件接收。于是我写了一个mapper接口、mapper映射文件动态拼接SQL语句、一个测试类，运行测试类出现以下报错。 我的代码 问题解决 方法一：sql语法 先检查一下你的SQL语法是不是书写错误，最简单的方法就是将你的SQL语句复制粘贴到Navicat中的查询中进行运行，看看是否能够正常运行且是自己想要的结果。 方法二：字段名 ...
数据库疑难杂症 java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual tha
12-14
check the manual that corresponds to your MySQL server version for the right syntax to use near ‘order’ at line 1 数据库报错如下： Error querying database. Cause: java.sql.SQLSyntaxErrorException: ...
解决——》ERROR 1064 (42000)You have an error in your SQL syntax； check the manual that corresponds
小仙~
12-08 2826
解决——》ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
mybatis进行批处理更新失败，控制台报sql语法错误You have an error in your SQL syntax； check the man....
weixin_44768879的博客
10-26 648
mybatis的批量更新简单语句 <update id="updateUserGetEvaluateScore" parameterType="list"> <foreach collection="list" item="userTotalScore" index="index" separator=";"> update user_score <set> user_score = #{userTotalScore.
MySQL批量更新（上） + Mybatis 实现
Mr.hu
09-13 2747
批量更新 前言 增删改查-数据库四大基本操作，批量更新如何实现呢？MySQL官方给出的一个控制指令可以解决这个问题：CASE SQL原理 CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ... [ELSE statement_list] END CASE Or: CASE WHEN search_condition THEN stateme
AmqpConnectException: java.net.ConnectException: Connection timed out: conn
Delores的博客
09-07 2182
org.springframework.amqp.AmqpConnectException: java.net.ConnectException: Connection timed out: connect 在SpringBoot中使用RabbitMQ时，容易出现、连接不成功的情况原因有下： 1、SpringBoot的版本和RabbitMQ的版本不对应 2、连接端口，默认5672，连接主机的端口也...
异常“check the manual that corresponds to your MySQL server version for the right syntax to use near ”
minge0001的博客
05-17 2467
异常“check the manual that corresponds to your MySQL server version for the right syntax to use near ”
MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
热门推荐
vanezuo的专栏
08-14 29万+
本地化GO的时候一直遇到一个错误就是check the manual that corresponds to your MySQL server version for the right syntax，反复检查过多次语句都没发现错误，后来网上搜索解决方法见到： http://
MYSQL错误：check the manual that corresponds to your MySQL server version for the right syntax to use
m0_52586092的博客
08-12 3万+
错误信息：heck the manual that corresponds to your MySQL server version for the right syntax to use near 解决方法有两个： 1.在数据库表冲突字段前后加 `符号(Tab键上面那个键)，就不会再报语法错误了； 2.修改数据库表中冲突字段名称，修改为和 SQL语句关键字不冲突的其他名称。 3.navicat不可以，命令行可以。 ...
关于org.springframework.amqp.AmqpConnectException: java.net.ConnectException: Connection timed out问题
baxxdwyp的博客
10-15 3193
先说遇到得情况，我用的阿里云服务器，安装启动rabbitMq后，开放端口，我windows可以访问 但是idea一直报错 第一想的是配置文件的问题，因为本机可以访问，idea访问超时，看一下配置 然后自己做了个对比，我开启本地的rabbitMq 不再报错，而且可以使用！ 查阅了网上的很多种方法都未能解决。 ...
异常-check the manual that corresponds to your MySQL server version for the right
海恩的博客
04-30 416
表名和字段名不要用关键字，通常在表名之前加t_是为了防止用到关键字。MySQL关键字
check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATABASE mybatis-example' at line 1
11-09
这个错误提示是因为在MySQL中使用了不正确的语法。通常情况下，这个错误提示会告诉你在哪里出现了问题，比如这里是在第1行附近。这个错误提示还会告诉你要使用哪种语法，但是你的MySQL版本可能不支持这种语法。 解决这个问题的方法是检查你的MySQL语法是否正确，并确保你的MySQL版本支持你使用的语法。如果你不确定如何解决这个问题，可以参考引用中提到的链接，里面有详细的解决方案。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

东山富哥

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值