You have an error MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 20

最新推荐文章于 2023-08-07 14:09:13 发布
原创 最新推荐文章于 2023-08-07 14:09:13 发布 · 1k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文介绍了解决MySQL中因使用'TYPE='而非'ENGINE='导致的语法错误的方法，并提供了在Linux环境下使用vi编辑器批量替换关键字的具体步骤。

ERROR 1064 (42000): 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 'TYPE=InnoDB' at line 20

ERROR 1064 (42000): 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 'TYPE=MyISAM' at line 14


解决办法：

将"TYPE=InnoDB" 替换为"ENGINE=InnoDB" 

将"TYPE=MyISAM" 替换为"ENGINE=MyISAM" 


linux 的vi 里面执行命令：

:.,$s/TYPE=InnoDB/ENGINE=InnoDB/g


:.,$s/TYPE=MyISAM/ENGINE=MyISAM/g



参考：http://stackoverflow.com/questions/16408334/how-do-i-fix-error-in-your-sql-syntax-check-the-manual-for-the-right-synta

mysql报错：MySQL server version for the right syntax to use near type=InnoDB的解决方法
01-21
本文实例讲述了mysql报错：MySQL server version for the right ... check the manual that corresponds to your MySQL server version for the right syntax to use near ‘type=InnoDB’ at line 1 二、解决方案
shell脚本 操作mysql 注意事项 You have an error in your SQL syntax MySQL server version for the right syntax
fairynini的博客
05-18 446
操作mysql数据库数据，当需要每天重复时，就自然想到写程序，那么最简单的办法，就是用shell脚本操作。 但是经常会发生的事情就是，mysql中都测试过的sql语句，到了shell中就频频报语法错误。这是为什么呢？ ERROR 1064 (42000) at line 19: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right s
have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo
笔记小屋
10-17 355
错误信息如下 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 '' at line 17 解决 错误的原因有很多种，有可能是你插入的时候没传参数、空集合传进来等等。 ...
You have an error in your SQL syntax; for the right syntax to use near 'xxx'
mindcarver
08-16 2523
Error querying 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...
mysql报错系列持续整理1064 - You have an error in your SQL syntax；...near...
Aldeo
08-05 4万+
前言 怎么又是这个错，感觉似曾相识之前遇到过多次了。是的这就是mysql语句报错1064 - You have an error in your SQL 。syntax;...near...感觉每次不管什么原因，都是报的类似错误呢。。。 本文旨在整理开发过程中遇到的类似的错误，并持续更新。 1.新建表时报错 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL se
MySQL java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax 关键字异常处理
Yeats_Liao的博客
06-21 2万+
MySQL java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax 关键字异常处理
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 'version' at line 1
08-01
然而，用户当前的问题描述是：“请问MySQL SQL syntax error near version fix”，并且引用了多个不同的错误示例。因此，我们需要提供针对不同错误场景的解决方案。 解决方案： ### 1. 修改root密码时的语法错误...
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 '' at line 10
最新发布
10-16
check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10` 错误时，可从以下方面排查并解决： #### 列定义不完整 若在约束定义之前的列定义不完整，缺少...
SQL 错误 [1064] [42000]: 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 '=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci' at line 5
07-12
用户提供的错误信息片段是“near 'InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci'”，这表明错误发生在指定存储引擎和字符集的附近。 根据错误信息，我们可以推断出用户可能是在执行一个创建表...
You have an error in your SQL syntax； check the manual that corresponds to your MySQL server version
热门推荐
qq_40233706的博客
12-03 50万+
当你遇到MySQL中报错：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 时肿么办？ 解bug法则第一条： 遇事不要慌，先发个盆友圈 (*^▽^*) 一.先看问题 == You have an error in your SQL syntax; check the manual th
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio
BFELFISH的博客
06-04 1万+
对数据库进行操作时出错，百度了n多个解决方法后，看到有个是把关键字当表名了，我就尝试在MySQL中建立查询，发现后面怎么改都出错，然后，将order重命名为orders后，再查询，过了。后了解到是因为order是关键字 如果是别的出现这个错误，但是没有用order的，可以考虑是不是sql写错了，可以先在数据库中建立查询测试一下。 百度了这么多，总结主要解决方法 1.SQL语句写错 先...
运行程序时报错： MySQL server version for the right syntax to use near ‘NULL‘ at line 1
weixin_48919886的博客
11-16 2631
总结：如果sql语句中NULL判断不够完善有可能导致出现空值，把出现空值的可能性扼杀了问题也就解决了。解决办法：如果sql语句中出现NULL，会导致报错，加入值判断，完善写法，顺利解决问题。
调用存储过程报错 MySQL server version for the right syntax to use near ‘NULL‘ at line 1
tabvla的博客
11-03 3367
MySQL调用存储过程call报错 MySQL server version for the right syntax to use near 'NULL' at line 1
your MySQL server version for the right syntax to use near 'NULL' at line 1
dwsMo2的博客
12-20 1万+
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 ‘NULL’ at line 1 今天使用mysql事件执行一段程序, set @deletesql =CONCAT
MySQL报错：MySQL server version for the right syntax to use near ‘nulls last‘ at line 1
weixin_43620238的博客
08-07 1623
配置order_by.default_null_ordering: last后报错：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 'nulls last' at line 1
mysql near_MySQL server version for the right syntax to use near '' at
weixin_28963585的博客
02-07 1万+
MySQL server version for the right syntax to use near '' at line 1 问题描述: 线上日志在执行数据库表insert操作时,出现如下异常: ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:? Yo...
MySQL server version for the right syntax to use near ‘null and password=null‘ at line 1
CCLONER的博客
09-02 1011
根本原因。 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 'null and password=null' at line 1 sun.reflect.Nativ.
mysql at lin1_MySQL server version for the right syntax to use near '' at line 1
weixin_32009121的博客
01-28 754
DbError:YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear''atline1publicstaticfunctiongetCount($table,$conditi...Db Error: You have an error...
MySQL server version for the right syntax to use near ''
keny-大成的博客
01-15 1万+
1.配置不对，一直提示'' 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 ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值