<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[implement_的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/implement_</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; implement_]]></copyright><item><title><![CDATA[mysql导入数据或批量新增是，出现主键冲突，则根据主键修改，否则插入]]></title><link>https://blog.youkuaiyun.com/implement_/article/details/118016456</link><guid>https://blog.youkuaiyun.com/implement_/article/details/118016456</guid><author>implement_</author><pubDate>Fri, 18 Jun 2021 09:51:32 +0800</pubDate><description><![CDATA[mysql "ON DUPLICATE KEY UPDATE" 语法
示例：
INSERT INTO goods(id,goods_name) VALUES(1,"主键冲突") ON DUPLICATE KEY UPDATE goods_name="主键冲突";

]]></description><category></category></item><item><title><![CDATA[go语言操作MYSQL数据库]]></title><link>https://blog.youkuaiyun.com/implement_/article/details/117996012</link><guid>https://blog.youkuaiyun.com/implement_/article/details/117996012</guid><author>implement_</author><pubDate>Thu, 17 Jun 2021 17:12:51 +0800</pubDate><description><![CDATA[一下介绍两种方式 ，go内置函数，和 sqlx
go内置函数database/sql

导入包


import (
   "database/sql"
   "fmt"
   _ "github.com/go-sql-driver/mysql"
   "time"
)




]]></description><category></category></item><item><title><![CDATA[MYSQL根据字段名查询字段所在的表和库]]></title><link>https://blog.youkuaiyun.com/implement_/article/details/117992608</link><guid>https://blog.youkuaiyun.com/implement_/article/details/117992608</guid><author>implement_</author><pubDate>Thu, 17 Jun 2021 14:15:13 +0800</pubDate><description><![CDATA[安装navicat的朋友 可以进入到 库information_schema里面的 表 COLUMNS，相信聪明的你一看便知



cha
]]></description><category></category></item><item><title><![CDATA[spring框架，任意位置获取 HttpServletRequest，HttpServletResponse，和真实请求ip]]></title><link>https://blog.youkuaiyun.com/implement_/article/details/117991380</link><guid>https://blog.youkuaiyun.com/implement_/article/details/117991380</guid><author>implement_</author><pubDate>Thu, 17 Jun 2021 13:46:13 +0800</pubDate><description><![CDATA[private static ServletRequestAttributes getCurrentRequestAttributes(){ return ((ServletRequestAttributes) RequestContextHolder.currentRequestAttributes()); }

public static HttpServletRequest getCurrentHttpServletRequest(){
    return getCurrentRequestAtt.]]></description><category></category></item><item><title><![CDATA[mysql 事件]]></title><link>https://blog.youkuaiyun.com/implement_/article/details/117988388</link><guid>https://blog.youkuaiyun.com/implement_/article/details/117988388</guid><author>implement_</author><pubDate>Thu, 17 Jun 2021 11:55:22 +0800</pubDate><description><![CDATA[-- 查询事件（任务调度器） 状态
   show variables like '%event_scheduler%';

-- 开启事件（任务调度器）
   ALTER EVENT event_user ENABLE;
-- 关闭事件（任务调度器）
   ALTER EVENT event_user DISABLE;


-- 查询当前的事件information_schema下
   SELECT * FROM information_schema.events;

-- 查询当前的事件mysql
.]]></description><category></category></item><item><title><![CDATA[mysql 自定义函数]]></title><link>https://blog.youkuaiyun.com/implement_/article/details/117988262</link><guid>https://blog.youkuaiyun.com/implement_/article/details/117988262</guid><author>implement_</author><pubDate>Thu, 17 Jun 2021 11:52:54 +0800</pubDate><description><![CDATA[-- 创建 过程程序

CREATE DEFINER=`root`@`localhost` PROCEDURE `test_function`()
    DETERMINISTIC
BEGIN
       UPDATE goods SET goods.gmt_create_sys=NOW() WHERE id =9;
END


-- 创建 函数

CREATE DEFINER=`root`@`localhost` FUNCTION custome_function(param INT)
RETURN.]]></description><category></category></item></channel></rss>