在liunx环境下 mysql 新增报错

最新推荐文章于 2021-11-18 16:51:26 发布
最新推荐文章于 2021-11-18 16:51:26 发布
阅读量436 收藏
点赞数
分类专栏： 综合
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/SUMMER11210/article/details/103985088
版权

**在liunx环境下 mysql 新增报错 **

<insert id="insertStation" parameterType="pd">
		<selectKey keyProperty="stationId" resultType="Integer" order="BEFORE"> 
            SELECT nextval('station_info') 
    	</selectKey>
		INSERT INTO STATION_INFO(
			stationId,
			stationNum,
			stationName,
			stationState,
			stationType,
			departmentId,
			longitude,
			latitude,
			address,
			lastEditUserId,
			lastEditTime
		) VALUES (
			#{stationId,jdbcType=INTEGER},
			#{stationNum,jdbcType=VARCHAR},
			#{stationName,jdbcType=VARCHAR},
			#{stationState,jdbcType=VARCHAR},	
			#{stationType,jdbcType=INTEGER},	
			#{departmentId,jdbcType=INTEGER},
			#{longitude,jdbcType=VARCHAR},
			#{latitude,jdbcType=VARCHAR},
			#{address,jdbcType=VARCHAR},
			#{lastEditUserId,jdbcType=VARCHAR},
			NOW()			
		)	
	</insert>

报错

INFO  c.h.c.aspect.doCheck.DoCheckAspect -around execution(void com.hclz.module.boxmgr.service.StationService.insertStation(PageData))	Use time : 56 ms with exception : org.springframework.jdbc.BadSqlGrammarException: Error selecting key or setting result to parameter object. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION guardtest.nextval does not exist
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION guardtest.nextval does not exist
org.springframework.jdbc.BadSqlGrammarException: Error selecting key or setting result to parameter object. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION guardtest.nextval does not exist
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION guardtest.nextval does not exist
	at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:93)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
	at com.sun.proxy.$Proxy84.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
	at com.hclz.core.dao.DaoSupport.save(DaoSupport.java:27)
	at com.hclz.core.dao.DaoSupport$$FastClassBySpringCGLIB$$8d4ef030.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at com.hclz.core.dao.DaoSupport$$EnhancerBySpringCGLIB$$ec2e3eb5.save(<generated>)
	at com.hclz.module.boxmgr.service.StationService.insertStation(StationService.java:55)
	at com.hclz.module.boxmgr.service.StationService$$FastClassBySpringCGLIB$$adff4cd1.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
	at com.hclz.core.aspect.doCheck.DoCheckAspect.around(DoCheckAspect.java:97)
	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.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at com.hclz.module.boxmgr.service.StationService$$EnhancerBySpringCGLIB$$736c5bb.insertStation(<generated>)
	at com.hclz.module.boxmgr.controller.StationAppController.insert(StationAppController.java:75)
	at com.hclz.module.boxmgr.controller.StationAppController$$FastClassBySpringCGLIB$$93ba0f64.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
	at com.hclz.core.aspect.log.LogMessageAspect.around(LogMessageAspect.java:77)
	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.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at com.hclz.module.boxmgr.controller.StationAppController$$EnhancerBySpringCGLIB$$8124b533.insert(<generated>)
	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.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:891)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION guardtest.nextval does not exist
	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:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1242)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
	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.$Proxy111.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
	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.$Proxy109.query(Unknown Source)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
	at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processGeneratedKeys(SelectKeyGenerator.java:68)
	at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processBefore(SelectKeyGenerator.java:47)
	at org.apache.ibatis.executor.statement.BaseStatementHandler.generateKeys(BaseStatementHandler.java:141)
	at org.apache.ibatis.executor.statement.BaseStatementHandler.<init>(BaseStatementHandler.java:63)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.<init>(PreparedStatementHandler.java:41)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.<init>(RoutingStatementHandler.java:46)
	at org.apache.ibatis.session.Configuration.newStatementHandler(Configuration.java:563)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
	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:433)
	... 106 more

原因：
**换了链接数据库 线上数据库没有添加自定函数 **
在这里插入图片描述
新增 nextval()函数

CREATE DEFINER=`root`@`%` FUNCTION `nextval`(seq_name varchar(50)) RETURNS int(11)
BEGIN
UPDATE system_sequence
SET CURRENT_VALUE = CURRENT_VALUE + INCREMENT
where name=seq_name;
return currval(seq_name);
END
RadiantGlow
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
【MYSQL】数据库序列相关整理
꧁༺舒月༻꧂的博客
03-11 905
1. 数据库序列的应用场景： 序列用在父表主键的生成中, 同时主键也是子表的外键 insert into parent_table(id) values(seq1.nextval); insert into child_table(pid) values(seq1.currval); 2.序列的相关描述 提供的一个产生唯一数值型值的机制。通常用于表的主健值，序列只能保证唯一，不能保证连续。...
关于使用框架操作Oracle数据库切换MySQL数据库时，nextval的问题！
醉陌浮生，乱谜浊
06-30 2272
错误代码： Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select mysql.nextval('SEQ_ID')]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQ
函数明明存在应用却报错不存在 function xxx does not exist
热门推荐
leandzgc的专栏
11-12 8万+
错误信息：function xxx does not exist. No function matches the given name and argument types. You might need to add explicit type casts 函数找不到可能的原因 1、当前schema下不存在对应的函数（例如未增加schema名称，或当前连接的schema非public，且函数...
pg数据库查看序列 currval() 报错问题 relation [sequence] does not exist
weixin_41276238的博客
10-23 2807
环境: pg数据库 9.6.8 问题: 使用currval查询序列时报错 select currval(t_interest_payment_id_seq’) 反复查看表的ddl语句,发现序列名称没有错误 查询序列表信息,再次确定序列名称正确 三.解决: 原来是 当前会话使用currval() 前必须先使用nextval()才行,先调用nextval() select nextval(‘t_interest_payment_id_seq’); 再用currval查询,正确显示 ...
执行脚本报错
渐行渐近
03-31 938
 rails2.3.4一般会报这个错误： undefined method `quote_ident for PGconn:Class 解决办法是： 在config/initializes/new_rails_defaults.rb中加入以下三行代码    def PGconn.quote_ident(name) %("#{name}") end 原文地址
MySQL快速指南
07-06
1. **多线程支持**：MySQL采用核心线程的多线程系统，能够充分利用多处理器环境，提高并发处理能力。 2. **跨平台兼容性**：可以在Windows、Linux、Mac OS等多种操作系统上运行。 3. **丰富的数据类型**：支持多种...
goon:一款集合了fscan和kscan等优秀工具功能的扫描爆破工具
最新发布
04-25
新增 -no 选项，不保存文件，适用于linux下报错open too many files title、finger扫描可以直接输入domain和url 爆破类支持输入ip、ip段和127.0.0.1:6379格式数据 2022年08月19日 v3.5 端口指纹优化，不输出无关...
2020年PHP多仓库erp进存销仓库管理系统.rar
05-09
运行环境 php5.6 、MYSQL5.6 、Linux、apache、nginx 该ERP系统部署安装非常简单，只需要空间支持PHP上传到根目录即可简单安装即可。运行速度和数据处理效率都非常高，非常适合中小企业仓库管理使用。 更新日志： ...
Hyperf 协程框架 v2.1.10
04-21
#3189 修复 kafka 在集群模式下无法正常使用的问题。 #3191 修复 json-rpc 客户端因对端服务重启，导致连接池中的连接全部失效，新的请求进来时，首次使用皆会报错的问题。 新增 #3170 为 hyperf/watcher 组件...
UniDAC Professional 8.0.1 D10.3 Rio专用
11-08
1. **多平台支持**：UniDAC不仅适用于Windows操作系统，还支持macOS和Linux等跨平台开发，使得开发的软件能够灵活部署在不同系统上。 2. **广泛的数据库支持**：UniDAC提供对众多流行数据库的支持，如Oracle、MySQL...
MariaDB 自增序列nextVal函数问题
weixin_34151004的博客
09-01 1341
　　需要把另外一台服务器上数据库拷贝过来，已知该数据库版本-10.0.22-MariaDB-wsrep；自己这台服务器上数据库版本：10.3.0-MariaDB-10.3.0+maria~xenial-log；使用navicat客户端； 　　然而遇到一个问题，那就是本地自建naxtval的函数无法使用--执行select naxtval（“databases_name”）报错，具体错误如下： ...
postgresql 在导入sql时 遇到 “XXX_id_seq“ does not exist
innocencezz的博客
11-18 3990
出现这种问题一般是由于在postgresql表中建立了自增字段，id定义为Serial 类型，当执行完成建表语句后，postgresql会自动将其增加： “id” int4 NOT NULL DEFAULT nextval(‘xxx_id_seq’::regclass) 当你在导入新的sql 时，会显示 xxx_id_seq 不存在的错误信息 解决方法： 新建查询，执行 DROP SEQUENCE IF EXISTS xxx_id_seq; CREATE SEQUENCE xxx_id_seq; CREAT
Mycat之数据库主键自增长（数据库增长的方式）-yellowcong
01-16 1万+
我们先来通过mycat实现一个自增长的主键，现在有两个数据库，mycat和mycat2,然后设定数据库增长的方式，按照自增长的方式实现。自增长实现步骤：1、创建数据库，2、创建mycat的自增长函数,3、插入需要自增长策略，4、配置schemal.xml,添加自增长的表，5、配置server.xml，设置主键增长策略，6、配置sequence_db_conf.properties，添加需要自增长的
mysql nextval()_mysql中实现类似oracle中的nextval函数
weixin_33096511的博客
01-18 2254
建表 `sys_sequence`CREATE TABLE IF NOT EXISTS`sys_sequence` (`NAME`varchar(50) NOT NULL,`CURRENT_VALUE`int(11) NOT NULL DEFAULT '0',`INCREMENT`int(11) NOT NULL DEFAULT '1',PRIMARY KEY(`NAME`)) ENGINE=In...
Last_SQL_Error: Error 'Can't drop database 'ABC'; database doesn't exist' on query. Default database...
weixin_33726313的博客
04-27 1580
查看从库状态发现报错： show slave status\G; 发现是主库上删除了一个数据库，但是从库上面没有，从库执行这个语句的时候失败报错。 解决方法： 停止从库 stop slave; 创建语句中所说的数据库，这里使用ABC create database ABC; 启动从库 start slave; 问题解决。 再次查看show slave status\G,发...
mysql实现nextVal功能
jdzms23的专栏
03-12 4万+
首先创建表： CREATE TABLE `sys_sequence` ( `NAME` varchar(50) NOT NULL, `CURRENT_VALUE` int(11) NOT NULL DEFAULT '0', `INCREMENT` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`NAME`) ) 插入记录 IN
mycat(1)主键自增之数据库自增的方式
夏天
10-08 760
数据准备 1、创建数据库 创建两个数据库，并都创建test表 #创建数据库 create database mycat; #添加表 use mycat #创建表test create table test3(id int auto_increment primary key,name varchar(32)) ; #创建数据库 create database mycat3; #添加表 use mycat 2 #创建表test create table test3(id int auto_increm
mysql查询错误 FUNCTION nvl does not exist
Koow的博客
11-14 1万+
mysql 中没有nvl ()函数,使用ifnull代替，示例如下: mysql> SELECT ifnull(sum(P.PAYMONEY),0) totalmoney  FROM jc_pay P; +------------+ | totalmoney | +------------+ |          0 | +------------+ 1 row in set
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值