[Err] 1064 - You have an error in your SQL syntax； check the manual that corresponds to your MySQL s

已于 2023-11-10 20:29:18 修改
阅读量2.2k 收藏
点赞数
分类专栏： # mysql 数据库 文章标签： mysql sql 数据库
于 2023-02-03 14:36:02 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/lxl2092828212/article/details/128866314
版权
错误1064提示SQL语法错误，特别是varchar2类型在MySQL中不存在。应将varchar2替换为varchar。管理员姓名和密码字段设置时出现了问题，需调整为MySQL兼容的语法。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

[Err] 1064 - 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 'varchar2(20) not null, -- 管理员姓名
        a_pwd varchar2(20) default '123456'' at line 8

这个错误提示提醒你语法可能有问题，也有可能是后面出现的中文逗号；

对于Oracle转mysql的注意mysql只有varchar类型，没有varchar2；这里就是出现这个错误。

ProgrammingError: 1064 (42000): You have an error in your SQL syntax； check the manual...解决方案
weixin_43178406的博客
07-03 1万+
本文主要介绍了ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual…解决方案，希望能对使用python将csv转换为MySQL的同学们有所帮助。 文章目录 1. 问题描述 2. 解决方案
[Err] 1064 - You have an error in your SQL syntax；Navicat sql语句创建表出现的问题
翱翔于世纪的博客
04-09 5622
1、问题描述： sql语句创建stu表 -- 创建stu学生表 create table stu( sno char(9) PRIMARY KEY not null, sn varchar(30) not null, ssex char(2) check(ssex='男' or ssex='女') not null, snative varchar(30) not null, mno c...
1064 - You have an error in your SQL syntax； check the manual that corresponds to your MySQL server
最新发布
suningsss的博客
05-08 83
保证符号正确的前提下，删掉字段前面的空格试一下。
[Err] 1064 - You have an error in your SQL syntax； checkthe manual that corresponds...解决方法总结与分析
m0_74406361的博客
06-22 2万+
[Err] 1064 - You have an error in your SQL syntax; checkthe manual that corresponds to your MySQL serverversion for the right syntax to use near USING BTREE)ENGINE = InnoDB CHARACTER SET = utf8 COLLATE =utf8 general ci RO' at line 4[Err] SET NAMES utf8;我出现
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL s
angelzly的博客
11-22 6390
[Err] 1064 - 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 '# 1、确定sql语句没有问题 2、考虑是编码问题 在创建数据库的时候我选择了utf-8，出现了106...
(1064, “You have an error in your SQL syntax； check the manual that corresponds to your MySQL server
和大家一起涨芝士
12-16 1万+
(1064, "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 '== '1'' at line 1") 原因及解决办法
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL s...
weixin_34117522的博客
07-16 1万+
[Err] 1064 - 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 ''<h1 style="text-align: center;&...
解决1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL。。。。问题
m379373142的博客
02-22 15万+
Navicat 下运行SQL出现如下问题： 1064 - 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 ''order_master' ( 'order_id' VA...
完美解决：ERROR 1064 (42000): You have an error in your SQL syntax； check the manual that corresponds to
Mortalz7
11-15 5万+
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 'identified by 'mortalz7' with grant option' at line 1
数据库疑难杂症 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: ...
错误代码： 1064You have an error in your SQL syntax； check the manual that corresponds to your MySQL ser
dujiuv587的博客
03-10 1万+
查看与您的MySQL服务器版本相对应的手册，了解“……”附近要使用的正确语法。先检查一下自己写的SQL语句中的符号是否有中文的，有的话改过来就可以啦~。如果这些都正确的话，证明问题就很细微啦，需要根据具体情况。会出现这种问题，大部分都是因为自己的粗心大意啦~检查单词有没有拼
错误代码： 1064 You have an error in your SQL syntax； check the manual that corresponds to your MySQL ser
hjy6666hjy的博客
02-15 1万+
sql语句错误改正
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
水镜先生的博客
05-20 5557
1064 - 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 ‘order’ at line 7 上传文档 翻译过来内容是:1064-您的SQL语法有错误；请查看与您的MySQL服...
SQL查询1064报错 [ERR] 1064 - You have an error in your SQL syntax； check the manual.......
热门推荐
凌云
10-11 23万+
MySQL建表出现1064问题问题 SQL语句 DROP DATABASE IF EXISTS bookstore; DROP DATABASE bookstore; USE bookstore; CREATE TABLE t_user ( 'id' INT PRIMARY KEY auto_increment, 'username' VARCHAR ( 20 ) NOT NULL UNIQUE, 'password' VARCHAR ( 32 ) NOT NULL, 'email' VARCHA
Mysql报错：#1064 - You have an error in your SQL syntax； check the manual that corresponds .......
weixin_44164489的博客
09-24 2060
今天用SQL查询的时候出现以下报错： #1064 - 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 'xxxx' at line 1 最终检查出是用错了关键词搭配，将SELECT … FROM … 写成了SELECT … IN …就好了。 因此遇到上述报错可能是因为：用错了Mysql的关
mysql报错1064 - You have an error in your SQL syntax； check the manual that corresponds to your MySQL
马力十足的蜗牛
10-22 2120
运行如下代码后报错：1064 - You have an error in your SQL syntax;经查询发现，MySQL最新版本（8.0.31）的推出，MySQL才增加了对SQL标准INTERSECT和EXCEPT表运算符的支持。如果低于此版本使用这两个表运算符的话会报错1064。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值