mysql报错 ERROR 1148 (42000) 5C

ERROR 1148 (42000): The used command is not allowed with this MySQL version
说明:启动mysql前,已经成功设置参数--local-infile=1;昨天可以正常使用,今天就不行了.
还请给出切实可行的解决方案,跪求!

2个回答

百度了一下,没发现什么,但是有一点可以确定,mysql设置参数千万不要以为重启正常就一切ok了,很可能某天重启就起不来了,原因就是参数设置的问题,
所有千万注意,最好能弄个相同的环境测试一下

wqk1014
我说那个你 还请给出切实可行的解决方案,你说的都是废话..我都查过
大约一年之前 回复

应该是mysql版本问题

检查一下mysql版本号:mysql> select version();

mysql5.1或者以上的都支持load data local infile操作

解决方法:登录是加 --local-infile 可解决问题

例子: mysql --local-infile -u test -p

如果你觉得每次都要加参数很麻烦,可以在安装时加上--enable-local-infile

例子:

./configure --prefix=/usr/local/mysql --enable-local-infilemakemake install

TofuCai
TofuCai 回复wqk1014: -- local-infile=1你是不是没加空格
大约一年之前 回复
wqk1014
我说那个你 还请给出切实可行的解决方案,你说的都是废话..我都查过.粘贴复制党就别浑水摸鱼
大约一年之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
MYSQL ERROR 1064(42000)
mysql> CREATE TABLE EMPLOYEE_PAY_TBLn -> (n -> EMP_ID VARCHAR(9) NOT NULL PRIMARY KEY,n -> POSITION VARCHAR(15) NOT NULL,n -> DATE_HIRE DATE,n -> PAY_RATE DECIMAL(4,2),n -> DATE_LAST_RAISE DATE,n -> SALARY DECIMAL(8,2),n -> BONUS DECIMAL(6,2),n -> CONSTRAINT EMP_FK FOREIGN KEY (EMP_ID) REFERENCES EMPLOYEE_TBL (EMP_ID)n -> );nERROR 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 'KEY,nPOSITION VARCHAR(15) NOT NULL,nDATE_HIRE DATE,nPAY_RATE DECIMAL(4,2),nDAT' at line 3nn![图片说明](https://img-ask.csdn.net/upload/201807/23/1532350629_867182.png)![图片说明](https://img-ask.csdn.net/upload/201807/23/1532350816_54315.jpg)
【报错解决】+【MySQL】ERROR 1064(42000)
MySQL错误:ERROR 1064 (42000)出现情形报错原因解决方案 出现情形 在修改账户密码时,我输入了以下命令: mysql> set password = password('123'); 出现了以下报错: ERROR 1064(42000):You have an error in your SQL syntax; check the manual that corresp...
初学mysql, ERROR 1064 (42000)
我初学MYSQL, 在华军软件下的5.0.51a版本。装上后只有第一次成功创建一个tabel,之后的每一次都提示ERROR 1064 (42000)。重装后也从没创建成功。到底ERROR 1064 (42000)是什么?我哪里打错了?rn rnmysql> create table deptrn -> (rn -> deptno int primary key,rn -> dname varchar(14),rn -> loc varchar(13),rn -> );rnERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatrncorresponds to your MySQL server version for the right syntax to use near ')' atrn line 6rnrnmysql> create table deptrn -> BEGINrn -> END;rnERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatrncorresponds to your MySQL server version for the right syntax to use near 'BEGINrnrnEND' at line 2
mysql 报错ERROR 1064 (42000),原因使用了mysql保留字
执行select语句: select * from cfg_parameter where key='nSJtifqVSI7HkPrKHlxhD6'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version f
mysql列名设为关键字导致报错ERROR 1064 (42000)
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 ‘int’ at line 1 我在数据库用户表user中加入了一列,列名为right,导致...
mysql, ERROR 1064 (42000) 各位帮看下
create table if not exists blog_sitern(rn siteid int not null,rn sitename varchar(20) not null,rn displayName varchar(100) not null,rn sitedetail text,rn siteicon varchar(50),rn sitelogo varchar(50),rn cssfile varchar(50),rn createTime timestamp not null,rn lastTime timestamp,rn siteurl varchar(100),rn "status" int not null,rn primary key (siteid)rn);rnrn报错说这句有问题rn "status" int not null,rnrn
error 0064(42000)错误
[img=https://img-bbs.csdn.net/upload/201410/27/1414400463_329616.jpg][/img]rnrn我就是这样打开了数据库,然后就输入上面一句话,剩下就运行不了,请问是什么回事。
sqlstate 42000[error 7399]
小弟在作一个数据同步的项目时,通过linked server方式链接远程服务器,并将本地的数据传输到远程服务器,经常没规律的出现sqlstate 42000[error 7399]的错误,如何解决?
关于mysql出错ERROR 1064 (42000)
我的代码如下,虽然显示出错,但是操作结果又是正确的,这是怎么回事咧?rnmysql> delimiter $rnmysql> create procedure add_time(OUT result int)rn -> beginrn -> update time set time_id=time_id+1 where user_id=2;rn -> end$rnQuery OK, 0 rows affected (1.13 sec)rnrnmysql> SET GLOBAL event_scheduler = 1;rn -> $rnmysql> create event time_ev on schedule every 5 secondrn -> do rn -> call add_time(@result);rn -> end$rnQuery OK, 0 rows affected (0.00 sec)rnERROR 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 'end' at line 1rn
报错1064(42000) 郁闷!!!
我的数据库栏目rn name char 10rn num int rn sex charrn cash intrn ID charrn add char 100rn password charrnrn我的SQL 语句rnrn mysql > update client set Add = "a" where name = "aa";rnrn Add 这一栏 中 123 数据是存在的 而且 如果我换成其他的 栏目 比如cash 之类的 不报错rnrn 那句报错是:rn 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 'Add = "a"' at line 1
mysql报错 error 121
在创建表格的时候报错情况如下:rnERROR 1005 (HY000): Can't create table '.\dbuser\cacert.frm' (errno: 121)rnERROR 1005 (HY000): Can't create table '.\dbuser\userinfo.frm' (errno: 121)rnrn这张表格在其他人的电脑上可以创建成功,但在我电脑上就会报错,什么原因啊?rn我要创建的表格代码如下:rn[code=SQL][/code]rnrn-- mysql> \.db_setup.mysqlrnrnCREATE DATABASE dbuser;rnUSE dbuser;rnrn--rn-- table1rn--rnrnCREATE TABLE `cacert`(rn `collection-owner` INT(10) NOT NULL,rn `CERTTYPE` VARCHAR(20),rn `USERJID` VARCHAR(64),rn `DAY` INT(10),rn `KEYLEN` INT(4),rn `CERTSTATE` INT,rn `REVOKEREASON` VARCHAR(255),rn `REVOKETIME` VARCHAR(10),rn `BEGINTIME` TIMESTAMP,rn `ENDTIME` VARCHAR(10),rn PRIMARY KEY(`collection-owner`)rn ) ENGINE=InnoDB;rn rn--rn-- table2rn--rnCREATE TABLE `userinfo`(rn `collection-owner` INT(10) NOT NULL,rn `USERINFO` VARCHAR(255),rn `CERTINFO` VARCHAR(4096),rn PRIMARY KEY(`collection-owner`),rn INDEX(`collection-owner`),rn FOREIGN KEY(`collection-owner`) REFERENCES `cacert`(`collection-owner`) ON DELETE CASCADE) ENGINE=InnoDB;rnrnrn高手给看看!
SQL Error: 933, SQLState: 42000
执行程序的时候报出这个问题,麻烦各位帮我看看:rn2011-01-20 09:00:56,062 WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 933, SQLState: 42000rn2011-01-20 09:00:56,062 ERROR [org.hibernate.util.JDBCExceptionReporter] - ORA-00933: SQL 命令未正确结束rnrn2011-01-20 09:00:56,078 WARN [org.apache.struts.action.RequestProcessor] - Unhandled Exception thrown: class org.springframework.dao.InvalidDataAccessResourceUsageExceptionrn2011-01-20 09:00:56,093 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SSHTEST].[action]] - Servlet.service() for servlet action threw exceptionrnjava.sql.SQLException: ORA-00933: SQL 命令未正确结束rnrn at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)rn at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)rn at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)rn at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)rn at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:212)rn at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:795)rn at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1030)rn at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:835)rn at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1123)rn at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284)rn at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3328)rn at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)rn at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)rn at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)rn at org.hibernate.loader.Loader.doQuery(Loader.java:674)rn at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)rn at org.hibernate.loader.Loader.doList(Loader.java:2220)rn at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)rn at org.hibernate.loader.Loader.list(Loader.java:2099)rn at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)rn at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)rn at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)rn at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)rn at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)rn at main.com.rpc.persist.StuInfoDAO$1.doInHibernate(StuInfoDAO.java:63)rn at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)rn at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:342)rn at main.com.rpc.persist.StuInfoDAO.getStuinfo(StuInfoDAO.java:61)rn at main.com.rpc.biz.StuInfoHandlerImpl.getStuinfo(StuInfoHandlerImpl.java:38)rn at main.com.rpc.web.StuInfoAction.doQuery(StuInfoAction.java:34)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)rn at java.lang.reflect.Method.invoke(Method.java:585)rn at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)rn at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)rn at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)rn at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)rn at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)rn at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)rn at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)rn at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)rn at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)rn at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)rn at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)rn at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)rn at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)rn at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)rn at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)rn at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)rn at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)rn at java.lang.Thread.run(Thread.java:595)rnrnrnrn代码:rnpublic List getStuinfo(final int firstSize,final int pageSize)rn HibernateTemplate ht=this.getHibernateTemplate();rn List list=ht.executeFind(new HibernateCallback()rn public Object doInHibernate(Session session)throws HibernateException, SQLException rn return session.createQuery(" from User ").setFirstResult(firstSize).setMaxResults(pageSize).list();rn rn rn );rn return list;
revoke错误 ERROR 1141 (42000):
mysql> grant all privileges on *.* to b@'%' identified by 'b' with grant option;rnQuery OK, 0 rows affected (0.00 sec)rnrnmysql> revoke all on atest.* from b@'%';rnERROR 1141 (42000): There is no such grant defined for user 'b' on host '%'rnmysql>rnrn如何回收用户 b 的一个数据库权限?
ERROR 1064 (42000) at line 1346:
我在导入数据库DBInit_0_31_0180_table_mysql.sql这个文件,提示出错。我用的是linux6.5企业版,mysql5.045版本 用csp ERROR 1064 (42000) at line 1346: 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.top 50 level characterrn请高手帮我解决下,感激不尽
mysql workbench error 1148 无法加载本地数据的解决方法
windows10 workbench 8.0 1148的暂时解决方法如下: 1.在workbench中输入 show global variables like ‘local_infile’; 结果应该为:on,该问题与local-infile是否=1无关,是workbench的bug; 2.继续输入show variables like ‘secure_file_priv’; 结果应该为C:\...
MySQL使用命令行窗口创建存储过程报错ERROR 1064 (42000)原因及解决方案
MySQL在创建存储过程的时候,如创建productpricing存储过程,如果使用的是Navicat等程序创建,代码是CREATE PROCEDURE productpricing() BEGIN selectavg(prod_price) as priceaverage fromproducts; END; 但是,如果是在命令行界面,上述语句在fro...
mysql使用报错1142(42000)解决方法
今天在学习mysql的时候,一顿蜜汁操作,再次使用mysql的时候发现,不管用啥子命令,都出现了一个报错 mysql> select user,password from mysql.user; ERROR 1142 (42000): SELECT command denied to user ‘root’@‘localhost’ for table ‘user’ 看了一下报错信息,权限不够...
MySQL设置主键外键时错误:ERROR 1064 (42000)
环境:MySQL 5.7问题:之前为这个终生图书馆小项目设计了几张表User,HaveRead,SignIn,Book,BookLabel,BookPlan,结果昨晚发现如果User表用户变化(比如删除用户等等),SignIn和HaveRead不能及时变化还得自己写代码做一个验证逻辑有点麻烦。何干事跟我提到说可以设置主键外键来解决这个问题;在重新创建这些表以及构建外键关系的时候,MySQL报了这样一
mysql 创建外键提示ERROR 1064(42000)错误,谢谢
在mysql创建如下表的时候,提示错误,请大家帮忙看看,谢谢!rn[code=SQL]rnmysql>create table Course(rnCno char(4) primary key,rnCname CHAR(40),rnCpno char(4),rnCeredit snallint,rnFOREIGN KEY Cpno REFERENCES Course(Cno)rn);rn[/code]rn无法创建成功,提示外键这行出错,这个是里面创建课程表的例子。谁帮忙解答下,谢谢!
关于mysql 新建表出现 error 1064(42000) 的一些疑问?
因为我是新手,有很多问题都不是很明白,可能对你们来说是些小问题,但希望大家能不吝指教下,嘿嘿。rnrn下面说说关于mysql 新建表却出现 error 1064(42000) 的一个疑问:rnrn[color=#FF0000]CREATE TABLE 'voteopt' (rn'ID' smallint(5) NOT NULL auto_increment,rn'votename' varchar(100) NOT NULL,rnPRIMARY KEY ('ID')rn) ENGINE=MYISAM DEFAULT CharSet=Latin1;[/color]rnrn当我用上面的sql语言在新的数据库中建表时就会出现下面的错误:rnrn[color=#FF0000]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 ''voteopt' (rn'ID' smallint(5) NOT NULL auto_increment,'votename' varchar(100) NO' at line 1 [/color]rnrn我在网上查了好久也没有找到解决方法。后来当我把上面所有的分号都去掉改成如下:rnrn[color=#FF0000]CREATE TABLE voteopt (rnID smallint(5) NOT NULL auto_increment,rnvotename varchar(100) NOT NULL,rnPRIMARY KEY (ID)rn) ENGINE=MYISAM DEFAULT CharSet=Latin1;[/color]rnrn却就能建表了。rn我想问一下这是为什么呢,因为我刚开始学,可能对你们来说是些小问题,但对我来说却不是太明白,希望你们能帮忙解释下,[color=#FF0000]谢谢[/color]了。
MySQL分数排名问题“ERROR 1064 (42000)”解决方法
在做“分数排名”问题时,运行语句总是出现“ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your”。 原因是在语句中使用了rank,而rank是mysql 的保留字。 当使用mysql保留字的时候,需要使用反引号将其引起来(就是键盘第二排的第一个) 开始以...
mysql 错误。ERROR 1064 (42000)删除数据库的时候遇到的问题
问题 在删除数据库的时候,遇到了一个问题 后来百度了一大把,发现要删除的数据库名要要引号引起来。 然后添加引号 继续错误 。。。。。。。 。。。。。。。。 。。。。。。。。。 继续百度,发现添加的引号错了,看下图。 真可怕,一个符号折腾了两个小时。 不过,好歹,从坑里踩出来了。 ...
Mysql创建存储过程时,出现ERROR 1064 (42000):的原因的一种
下面的Error信息,大家看着挺熟悉的吧。 ERROR 1064 (42000):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 'DEC
mysql中新建数据库出现ERROR 1064 (42000)如何解决?
本人出现如下错误请问大家如何办?rnC:\Program Files\MySQL\MySQL Server 4.1\bin>mysql -u root -prnEnter password: ******rnWelcome to the MySQL monitor. Commands end with ; or \g.rnYour MySQL connection id is 8 to server version: 4.1.20-community-ntrnrnType 'help;' or '\h' for help. Type '\c' to clear the buffer.rnrnmysql> create datebase lnnu;rnERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatrncorresponds to your MySQL server version for the right syntax to use near 'datebrnase lnnu' at line 1rnmysql>rn新手上路,望指教!
ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.28]错误
rn数据操作时出现如下错误,请大虾帮帮我。rnERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.28]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 '[tel]' at line 1 rnrn代码如下:rn<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>rnrnrnrnrnrnrn Untitled Pagernrnrn rnrn rn rn rn rn rn rnrnrn
MySql ERROR 1064 (42000)同样的错误,不一样的解决方法
开始时代码是这样:然后运行:代码根本毫无错误,但为什么会出错呢?在我花了2个小时后终于知道了答案。我没有加分号!!!!!修改后代码:然后再次运行后:再一次为自己的无知和粗心感到绝望!!!...
mysql更新数据库, 错误 42000
php,mysql,pdo,"UPDATA tb_music_lists SET user_m_sex=0 WHERE music_lists_id=7"rnrn报错,"42000",1064," You have an error in your SQL syntax. Check the manual trnhat corresponds to your MySQL server version for the right syntax to use near 'UPDATA tb_music_lists SET user_m_sex=0 WHERE music_lists_id=7' at line 1"rnrn请问是什么问题?mysql版本是5.5
跪求大神指导 ERROR 1064 (42000)
drop PROCEDURE if exists prc_track_week_delete;rncreate PROCEDURE prc_track_week_delete()rnBEGINrn declare v_starttime datetime default now();rn declare v_endtime datetime default now();rn rn rn declare exit handler for NOT FOUND begin end;rn declare exit handler for SQLEXCEPTION call prc_log(v_starttime,'prc_track_week_delete', 'error','');rnrn TRUNCATE table g.ia_track_week;rn commit;rnEND;rn-------------------------------------rnERROR 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 '' at line 3rn在mysql 版本为5.5.16上可以运行,在5.5.8上就运行出错,求指导
Hibernate出错 SQL Error: 1064, SQLState: 42000
Hibernate: select commodityc0_.commodityClassID as commodit1_0_, commodityc0_.commodityClassName as commodit2_0_ from fcShopping.dbo.commodityClass commodityc0_rn21:20:04,976 WARN JDBCExceptionReporter:77 - SQL Error: 1064, SQLState: 42000rn21:20:04,980 ERROR JDBCExceptionReporter:78 - 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 '.commodityClass commodityc0_' at line 1rnrn[url=http://www.blogjava.net/wintys/archive/2009/06/03/error_hibernate_mysql_blob.html]网上说[/url]可能是sql语句用了mysql的保留字或者是二进制数据的编码问题,但我都试了,还是不行。我是在调试已经有的代码,所以sql语句应该不会错。哪里可能会有问题,谢谢大家了。
Error 1102 <42000>: Incorrect DB name
我检查了我数据库名称和密码,都没有问题,可是在跑SQL语句的时候会出这样的问题。rnrnMySql装在Win Server 2003 上面,我想可能是字符集问题,rn可是我把服务器和客户端的字符集都改成了utf8,还是一样有问题。rnrn不知道有没有遇到过相同问题的人,指导一下。rnrn谢谢各位牛人~
求救sqlmaint fail ,SQLSTATE 42000 Error 20029
怎樣解決這個問題..發生在sql2000 maintenance plans上,transaction log 與 integrity check ,到micrsoft website 沒有指示...怎麼辦!!!!rnhttp://support.microsoft.com/default.aspx?scid=kb;en-us;Q288577
存储过程 ERROR 1064 (42000) 错误 求解
建表语句rnCREATE TABLE IF NOT EXISTS `shuai` (rn `field1` varchar(50) NOT NULL,rn `field2` int(11) NOT NULL,rn `field3` int(11) NOT NULLrn) ENGINE=MyISAM DEFAULT CHARSET=latin1;rnrnINSERT INTO `shuai` (`field1`, `field2`, `field3`) VALUESrn('hello', 1, 0),rn('hello', 2, 0),rn('hello', 3, 0),rn('hello', 4, 0),rn('hello', 5, 0),rn('hi', 1, 0),rn('hi', 2, 0),rn('hi', 3, 0),rn('hi', 4, 0),rn('hi', 5, 0);rnrn存储过程语句rnDROP PROCEDURE check_app_version;rnDELIMITER //rnCREATE PROCEDURE check_app_version()rnBEGINrn DECLARE field1 VARCHAR;rn DECLARE field2 INT;rn DECLARE apps CURSOR FOR SELECT `field1`,MAX(`field2`) FROM `shuai` GROUP BY `field1`;rnOPEN apps;rnREPEATrn FETCH apps INTO field1,field2;rn UPDATE `shuai` SET `field3` = 1 WHERE `shuai`.`field1` = field1 AND `shuai`.`field2` =field2 AND `shuai`.`field3` =0 LIMIT 1 ;rnCLOSE apps;rnEND ;rn//rnDELIMITER ;
ERROR 1064 (42000): 为什么老师这个错误。
听说csdn大神很多阿~~~ rnrn我刚学 今天下载了个Mysql5.5 装好了 rnrn创表的时候老是出现这个, 是哪里错了, 求大神知道一二。rnrn[img=https://img-bbs.csdn.net/upload/201306/03/1370267978_285779.jpg][/img]rnrn在线等答案。 谢谢了。
sql state:42000,sql error code:229
我在写sql语句的时候总出现这总错误rn怎么回事啊
org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
Hibernate: select hibernate_sequence.nextval from dualrn56141 [http-8080-Processor23] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000rn56141 [http-8080-Processor23] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: 序列不存在rnrn56157 [http-8080-Processor23] WARN org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class org.hibernate.exception.GenericJDBCExceptionrn56157 [http-8080-Processor23] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/PMgt].[action] - Servlet.service() for servlet action threw exceptionrnjava.sql.SQLException: ORA-02289: 序列不存在rnrn at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)rn at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)rn at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)rn at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)rn at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)rn at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)rn at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)rn at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)rn at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)rn at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:75)rn at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:85)rn at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)rn at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)rn at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)rn at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)rn at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)rn at org.hibernate.impl.SessionImpl.save(SessionImpl.java:481)rn at org.hibernate.impl.SessionImpl.save(SessionImpl.java:476)rn at com.crinode.mbank.dao.Impl.POpDaoImpl.Opinsert(POpDaoImpl.java:59)rn at com.crinode.mbank.service.Impl.POpserviceImpl.Opinsert(POpserviceImpl.java:51)rn at com.crinode.mbank.action.POpAction.Opinsert(POpAction.java:146)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)rn at java.lang.reflect.Method.invoke(Unknown Source)rn at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)rn at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)rn at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)rn at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)rn at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)rn at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)rn at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)rn at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)rn at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)rn at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)rn at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)rn at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)rn at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)rn at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)rn at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)rn at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)rn at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)rn at java.lang.Thread.run(Unknown Source)rnrn这个错误是怎么回事?请各位帮帮忙!
帮忙!!ERROR 1064 (42000): You have an error in your SQL syntax;
CREATE TABLE aaarn rn FLOW_ID BIGINT PRIMARY KEY,rn FLOW_FLAG_ID BIGINT NOT NULL, rn FRONT_ID BIGINT,rn BACK_ID BIGINT,rn ARRIVE_FLAG BIGINT default 0,rn ACCTION BIGINT,rn DISCUSS BIGINT,rn JION_NUM BIGINT,rn FINISH_NUM BIGINT,rn RESULT BIGINT,rn FOREIGN KEY(USE_PUR_ID) REFERENCES user_purview(USE_PUR_ID)rn ENGINE=InnoDB DEFAULT CHARSET=gbk;rnrn运行后出现的错误。错在哪里呢?rnERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatrncorresponds to your MySQL server version for the right syntax to use near 'rn FLOW_ID BIGINT PRIMARY KEY,rn FLOW_FLAG_ID BIGINT NOT NULL,rn FRONT_ID BIGINT,' at line 2rnmysql>rn
急求!!ERROR 1064 (42000): You have an error in your SQL
ERROR 1064(42000) You have an error in your SQL syntax:check the corresponds to your MySQL server version for the right syntax to use DATABASE abcrn USE abcrn SHOW TABLES' at line 2rnrnrn这个是什么问题?刚装好Mysql,想建一个数据库尝试一下,就出现这个问题,请各位帮帮忙,弄了一个早上了。我的mysql版本是mysql-5.1.38-win32.msi
合肥工业大学oj 1148 队列
//这是一个数学问题, //注意到如果队列中去掉最矮的一个人,会使对数减少1(最矮的在队列两侧)或2(最爱的人在队列中) //根据这个规律dp #include&amp;lt;iostream&amp;gt; using namespace std; int n, m; int main(){ while(true){ cin &amp;gt;&amp;gt; n &amp;gt;&amp;gt; m; if(n ==...
用cmd 命令符 报错1064 42000
创建表里的数据名出错rncreate table tianshan_1 (id int unsigned primary key auto-increment, name varchar(200), price float(8,3),sales int);rnrn
MySQL更改口令报错ERROR 1064
MySQL必知必会 P203更改口令,语句为:mysql&amp;gt; SET password for ben=password('123456');运行会报错ERROR 1064 (42000): You have an error inyour SQL syntax; check the manual thatcorresponds to your MySQL server versionfor ...
相关热词 c# stream 复制 android c# c#监测窗口句柄 c# md5 引用 c# 判断tabtip 自己写个浏览器程序c# c# 字符串变成整数数组 c#语言编程写出一个方法 c# 转盘抽奖 c#选中treeview