Geovin Du Dream Park

2. 在neo4j-community-5.26.1\data\databases和neo4j-community-5.26.1\data\transactions 文件夹下创建自己数据库名称的文件夹。如honglouneo4j。在neo4j-community-5.26.1\conf 文件夹。2.重启动电脑，重启服务器 neo4j.bat console。1.edit neo4j.conf 把。相数据库文件自动生成。

用原始密码：初始账号和密码：neo4j 修改密码。查看java -version 版本。在住处电脑重新配置一下neo4j,2.配置java jdk。jdk 21 官网下载。

Oracle sql developerToad for Oracle

【代码】string split function in postgreSQL 17.01 or SQL Server2019 or mySQL 9.0 or Oracle 21c。

【代码】postgreSQL 17.01: string split function。

select 存储过程，在现了解的情况，还是没有mysql,sqlserver等好写好用。

®Geovin Du Dream Park™ - 博客园 (cnblogs.com)找出各数据库的相同和差异，找出规律规则，用程序生成。

/*create database geovindu;两数据库之间的一个类似表，进行一个表的操作添加，修改时的同步操作的触发器操作use geovindu;create database DuMapgouse DuMapgo-- Geovin Du,涂聚文--Geovin Du， 塗聚文*/--基础数据设置BasicDataSet--书分类目录kind--BookKindFormIF EXISTS (select * from sysobjects where id.

--sql server 2012 及以上 涂聚文 Geovin Du geovindu 注SELECT * FROM BookKindListORDER BY (SELECT NULL)OFFSET 0 ROWS FETCH NEXT 3 ROWS ONLYgo -- geovindu Geovin Du 涂聚文Declare @PageNo INTDeclare @PageSize INTSet @PageNo=1Set @PageSize=4Select * From (S.

---循环declare @n intdeclare @rowcount int declare @name varchar(50)create table #temp( id int identity(1,1), ColumnNme nvarchar(100))insert into #temp select COLUMN_NAME from 数据库名.INF

MySQL存储过程:#插入一条返回值DELIMITER $$DROP PROCEDURE IF EXISTS `geovindu`.`proc_Insert_BookKindOut` $$CREATE PROCEDURE `geovindu`.`proc_Insert_BookKindOut` (IN param1Name NVarChar(1000),IN param1Parent I

use test;create database Liber;use Liber;#顯示數据庫 20150210 Geovin Du 涂聚文SHOW DATABASES;drop table BookKindList;#书目录create table BookKindList( BookKindID INT NOT NULL AUTO_INCREMENT, #自动增加

SQLite sql script:CREATE TABLE BookKindList( BookKindID INTEGER PRIMARY KEY AUTOINCREMENT, BookKindName varchar(500) not null, BookKindCode varchar(100) null, BookKindParent

MySql 5.6(XP)/5.7(win7) 添加用户和设置局域访问权限操作.请在 http://sourceforge.net/  下载MySql Control Center(不是安装版本).

我用Connector/Net 6.9读取MySql 4.1 时，会报以下错：1.Connector/Net no longer supports server versions prior to 5.02.Unable to connect to any of the specified MySQL hosts.后来我下载 http://dev.mysql.com/downloads

--pg_catalogSELECT * from pg_class c,pg_attribute a,pg_type t where c.relname='BookKindList' and a.attnum>0 and a.attrelid=c.oid and a.atttypid=t.oidSELECT a.attname from pg_class c,pg_attribute a,

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Dat

use geovindu;#函数DELIMITER $$drop function if exists f_GetDepartmentName $$CREATE function f_GetDepartmentName( did int) returns nvarchar(400) begindeclare str nvarchar(100);select Depar

-- 2012--https://technet.microsoft.com/zh-cn/library/ms186778(v=sql.110).aspx--对象目录视图 (Transact-SQL)select * from sys.foreign_keysselect * from sys.foreign_key_columnsselect * from sys.all_colum

数据类型表：TypeNameProviderDbTypeColumnSizeCreateFormatCreateParametersDataTypeBFILE14294967296BFILE System.Byte[]BLOB24294

CREATE OR REPLACE PROCEDURE proc_Insert_BookKindList (temTypeName nvarchar2,temParent int)ASncount number;begin--SELECT COUNT (*) INTO ncount FROM BookKindList fm1 where EXISTS (SELECT BookKi

----自动增长ID --序列创建 drop SEQUENCE BookPlaceList_SEQ;CREATE SEQUENCE BookPlaceList_SEQINCREMENT BY 1 -- 每次加几个START WITH 1 -- 从1开始计数NOMAXVALUE -- 不设置最大值NOCYCLE -- 一直累加，不循

--添加描述 Geovin Du--https://msdn.microsoft.com/en-us/library/ms180047.aspx--https://msdn.microsoft.com/zh-cn/library/ms180047(v=sql.120).aspx--https://msdn.microsoft.com/zh-cn/library/ms179853(v=sql.

---某個錶的列名,主键，外键---20150923 涂聚文 SQL Server: Get table primary key and Foreign Key using sql query DECLARE @SchemaName VARCHAR(200),@TableName VARCHAR(200)SET @SchemaName='dbo'SET @TableName='BookIn

类似于SQL Server中的:sp_executesqlsql server script:--- 涂聚文 20160906IF EXISTS (SELECT * FROM sysobjects WHERE [name] = 'proc_Select_DuDeptUserCount')DROP PROCEDURE proc_Select_DuDeptUserCountGOCR

/*递归查询 塗聚文---SQL Server 2005环境下的实现：*/--生成测试数据 create table Dept(ID int,ParentID int,msg varchar(20)) insert into Dept select 1,0

---树形（父子关系类）分级类统计（父子统计）--涂聚文 2014-08-14drop table BookKindListcreate table BookKindList( BookKindID INT IDENTITY(1,1) PRIMARY KEY, BookKindName nvarchar(500) not null, BookKindParent

---使用 UNION、INTERSECT 或 EXCEPT 运算符合并的所有查询必须在其目标列表中有相同数目的表达式select * from BookInfoList--存在不同的select BookInfoID,BookInfoBarCode from BookInfoList where BookInfoStatus=1 except select BookInventoryInf

---沒有去除重復的記錄select distinct ContractLaborEmployeeUidKey,ContractLaborEndDate from ContractLaborList order by ContractLaborEndDate descselect * from ContractLaborList order by ContractLaborEmploy

---sql server 2005 測試 塗聚文 捷為工作室，締友計算機信息技術有限公司---查找公曆節日--select (@year-GooddayStaryear) as Gyear,GooddayContent from GoodDaysList where @year>=GooddayStaryear and GooddayStarmoth=@month and GooddayS

---数据来源：http://topic.youkuaiyun.com/u/20100424/07/29529d9d-bc54-4877-b198-4426b4d85024.html if object_id('SolarData') is not null drop table SolarData go create table SolarData ( yearid int not

---2005附加數據庫---ATTACH DATABASE TEMPLATE---涂聚文 2012 元旦exec sp_attach_db 'Asset5','D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Asset5.mdf','D:\Program Files\Microsoft SQL Server\MSSQL.1\

---SQL SERVER 2000 遍历父子关系數據表（二叉树）获得所有子节点 所有父节点及节点层数函数---Geovin Du 涂聚文--建立測試環境Create Table GeovinDu([ID] Int, fatherID Int, [Name

---ntext數據類型字符替換 ---2011-08-21 塗聚文 深圳大運會期間,政府貼出"溫馨提示",交通管制,世界之窗周邊不充許到陽台觀看,出入憑居住證不是身份證create table tt( sid INT IDENTITY(1,1), cont

---會計記賬 Debit-Credit BookkeepingCREATE TABLE #geovindu ( Account VARCHAR(20), --賬號 [Date] DATETIME, --

---兩個時間之差的合計DECLARE @I INTSET @I = DATEDIFF(ms,GETDATE()-RAND()*24,GETDATE())SELECT convert(varchar(10), @I/86400000) + ' Days ' +

---塗聚文 Geovin DuDECLARE @myid uniqueidentifierSET @myid = NEWID()SELECT CONVERT(char(255), @myid) AS 'char';GO--塗聚文 Geovin Dudeclare @

---ntext數據類型字符替換 ---2011-08-21 塗聚文 深圳大運會期間,政府貼出"溫馨提示",交通管制,世界之窗周邊不充許到陽台觀看,出入憑身份證create table tt( sid INT IDENTITY(1,1), cont

---表中的主鍵select [name],'tablekey'= (select top 1 COLUMN_NAME from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = sysobjects.name) from sysobjects where type='U'--所有表select * from

---去除字符串中重復的值函數create function StringRemove(@str nvarchar(2000))returns varchar(2000)asbegin declare @result nvarchar(2000),@temp nvarchar(1000) set @result='' set @temp='' while(c