7 繁梦溪
尚未进行身份认证
暂无相关简介
-
Winodws10子系统openSUSE安装jupyter
-
一、安装pip install jupyter二、生成配置文件jupyter notebook --generate-configWriting default config to: /root/.jupyter/jupyter_notebook_config.py三、编辑配置文件vim /root/.jupyter/jupyter_notebook_config.p...
-
2019-12-03 08:54:50
-
Linux系统时间与Windows不符，Open SUSE时间同步设置
-
date命令：查看当前时间DESKTOP-R5E7NDM:~ # dateWed Nov 27 02:07:58 UTC 2019同步网络时间安装ntp服务命令：DESKTOP-R5E7NDM:~ # zypper in ntpLoading repository data...Reading installed packages...Resolving package...
-
2019-11-27 14:03:08
-
Windows子系统Open SUSE系统更新与Xshell连接
-
1、直接启动DESKTOP-QQ4J6H2:~ # /usr/sbin/sshdCould not load host key: /etc/ssh/ssh_host_rsa_keyCould not load host key: /etc/ssh/ssh_host_ecdsa_keyCould not load host key: /etc/ssh/ssh_host_ed25519_...
-
2019-11-24 08:44:00
-
jupyter_notebook_config.json
-
{ "NotebookApp": { "nbserver_extensions": { "jupyter_nbextensions_configurator": true }, "password": "sha1:27bfe715d13d:f2cc5055cc20746a36eb990ca217b46a07b86faf" }}
-
2019-11-22 23:38:15
-
Windows子系统Ubuntu系统更新与Xshell连接
-
更新资源sudo apt-get update对软件进行升级sudo apt-get upgrade升级系统版本sudo apt-get dist-upgrade安装openssh-serversudo apt-get install openssh-server查看ssh服务是否开启ps -e |grep ssh启动服务sudo ...
-
2019-11-13 15:58:37
-
查看表结构存储过程
-
DROP PROCEDURE IF EXISTS `show_table`;CREATE PROCEDURE `show_table`(IN currentIndex VARCHAR(200))BEGIN select ORDINAL_POSITION,TABLE_NAME,COLUMN_NAME, COLUMN_TYPE ,CHARACTER_MAXIMUM_LENGTH,COL...
-
2019-08-24 11:28:20
-
数据拉链实现数据表数据变更记录
-
-- ------------------------------ 创建demo表-- ----------------------------DROP TABLE IF EXISTS `tmp`;CREATE TABLE `tmp` ( `id` int(11) NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8...
-
2019-08-24 11:27:32
-
数据拉链demo
-
-- 生成演示数据CALL `Create table tmp`();-- 初始化拉链表演示CALL `Zipper table initialization`('20171218');-- 更新拉链表CALL `Update zipper table`('20190822');-- 更新拉链表CALL `Update zipper table`('20190823');...
-
2019-08-24 11:25:51
-
PostgreSQL存储过程-中标数据链接处理
-
-- 创建一个存储过程CREATE OR REPLACE PROCEDURE "来源链接处理"("批次" varchar='xxxxxxxx'::character varying) AS $BODY$ DECLARE sqlstring VARCHAR; BEGIN -- Routine body goes here... sqlstring:='DROP TABLE IF...
-
2019-07-23 12:51:01
-
Excel2019宏的应用之表格合并-中标数据处理
-
Excel2019Sub 中标数据处理()Dim rng As Range, sht As WorksheetStart = Timer'新建一个工作表，名称为：be_yaopinzhongbiaoWorksheets.Add.Name = "be_yaopinzhongbiao"'填写字段[A1] = "me_uid"[B1] = "me_name"[c1] = "me_b...
-
2019-07-23 12:17:01
-
PostgreSQL存储过程-中标数据处理-表格备份
-
-- 创建一个存储过程CREATE OR REPLACE PROCEDURE "中标数据备份"("批次" varchar='xxxxxxxx'::character varying) AS $BODY$ DECLARE sqlstring VARCHAR; BEGIN -- Routine body goes here... sqlstring:='DROP TABLE IF ...
-
2019-07-23 12:16:41
-
PostgreSQL切换数据目录
-
1、停止服务net stop PostgreSQL或2、进入注册表win+Rregedit输入路径计算机\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\postgresql-x64-11或计算机\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Serv...
-
2019-07-16 09:09:19
-
MySQL自定义函数提取中文
-
函数构造1、变量varstring2、计算变量varstring的长度3、截取varstring并正则判断4、将判断结果追加到变量v_temp5、循环3-46、返回v_tempSET @c='/BayerPharmaAG//BayerPharmaAG拜耳医药保健有限公司';set global log_bin_trust_function_creators=T...
-
2019-07-15 14:09:56
-
sql_mode查询与修改
-
/*修改my.ini:sql_mode=NO_ENGINE_SUBSTITUTION*/SELECT @@GLOBAL.SQL_mode;SET @@GLOBAL.sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; ...
-
2019-07-11 20:12:19
-
PL/Python - Python 过程语言自定义函数实现指定符号分割后元素间包含关系查找
-
1、单个单词的查找（元素间按空格拆分的二次判断）-- 定义函数找出列表中元素之间存在的包含关系DROP FUNCTION IF EXISTS pyinclude;CREATE FUNCTION pyinclude(s TEXT) RETURNS textAS $$ global s lt=s.split(";")#将字符串根据分号拆分成列表 long=len(lt) ls=[...
-
2019-07-02 14:13:57
-
PL/Python - Python 过程语言自定义函数实现指定符号分割后指定内容删除
-
DROP FUNCTION IF EXISTS pyremove;CREATE FUNCTION pyremove(s TEXT,r TEXT) RETURNS textAS $$ global s global r lt=s.split(";")#将字符串根据分号拆分成列表 if r: rt=r.split(";") else : rt=[] for t in rt...
-
2019-07-02 13:33:54
-
PL/Python - Python 过程语言自定义函数实现按照内容分割除重
-
--列表除重DROP FUNCTION IF EXISTS pyduplicates;CREATE FUNCTION pyduplicates(st TEXT,x TEXT)--s为字符串，x为分割符 RETURNS textAS $$ global st global x ls=st.split(x)#转为列表 lss=[]#定义变量 for s in ls: lss.a...
-
2019-07-01 16:40:27
-
PL/Python - Python 过程语言自定义函数实现首字母大写
-
PostgreSQL11安装Python3.6-- 首字母大写DROP FUNCTION IF EXISTS pytitle;CREATE FUNCTION pytitle(x text) RETURNS textAS $$ global x x = x.title() #python return x$$ LANGUAGE plpython3u;查看需要安装的p...
-
2019-07-01 14:46:45
-
Postgresql数据库的一些字符串操作函数
-
---- 建立小时记录与日记录的关联规则DROP FUNCTION IF EXISTS group_tbl_moburlvisit (name, timestamp);CREATE FUNCTION group_tbl_moburlvisit ( _tgrp name, _tick timestamp )...
-
2019-06-24 11:20:32
-
Windows10安装MongoDB（zip）
-
1、下载MongoDBhttps://www.mongodb.com/download-center/communitysystemLog:destination: filepath: "D:\MongoDB\log\mongod.log"D:\程序缓存\MongoDBlogAppend: truestorage:journal:enabled: trued...
-
2019-06-24 11:20:06
