Comments (2)
对创建函数处做如下改动,即可顺利导入:
delimiter //
CREATE FUNCTION FUN_SEQ
(SEQ VARCHAR(50)) RETURNS BIGINT(20)
BEGIN
UPDATE SEQ_TABLE
SET CURRENT_VALUE = CURRENT_VALUE + INCREMENT
WHERE SEQ_NAME=SEQ;
RETURN FUN_SEQ_CURRENT_VALUE(SEQ);
END //
CREATE FUNCTION FUN_SEQ_CURRENT_VALUE
(SEQ VARCHAR(50)) RETURNS BIGINT(20)
BEGIN
DECLARE VALUE INTEGER;
SET VALUE=0;
SELECT CURRENT_VALUE INTO VALUE
FROM SEQ_TABLE
WHERE SEQ_NAME=SEQ;
RETURN VALUE;
END //
CREATE FUNCTION FUN_SEQ_SET_VALUE
(SEQ VARCHAR(50), VALUE INTEGER) RETURNS BIGINT(20)
BEGIN
UPDATE SEQ_TABLE
SET CURRENT_VALUE=VALUE
WHERE SEQ_NAME=SEQ;
RETURN FUN_SEQ_CURRENT_VALUE(SEQ);
END //
CREATE FUNCTION FUN_NOW()
RETURNS DATETIME
BEGIN
RETURN now();
END //
-- 时间函数
CREATE FUNCTION FUN_DATE_ADD
(STR_DATE VARCHAR(10), STR_INTERVAL INTEGER) RETURNS DATE
BEGIN
RETURN date_add(STR_DATE, INTERVAL STR_INTERVAL DAY);
END //
delimiter ;
from roncoo-pay.
两个办法:
- 用Navicat for MySQL这个工具 导入脚本
- 脚本中 创建函数处加转义符处理
from roncoo-pay.
Related Issues (20)
- 请教个业务问题 账户历史流水 与 会计系统之间的关系?
- 微信支付报错 HOT 1
- sample-shop中的RoncooPayController中的100行构建form请求方式为啥不用post?
- NotifyTask第115行 HOT 1
- 什么时候更新一个spring boot 版本
- 多IP判定条件,对于A类IP地址存在问题 HOT 1
- 什么时候更新一版spring cloud的
- app-notify:App#startInitFromDB
- alipay 的两个jar 包过时了
- database.sql中函数无法执行成功
- 内存溢出
- 资源未释放:文件 HOT 2
- tomcat启动报错
- 重要!通知notify未做消息签名
- 请教几个问题?
- 广告打的挺响的,一看代码写得真烂 HOT 3
- 结算的时候为什么没有加入用户的银行账户呢
- why use mysql 5.0 as server?
- roncoo-pay-app-notify工程初始化数据问题
- 为啥龙果支付项目没考虑引入多个数据源
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from roncoo-pay.