随笔分类 -  数据库编程

1 2 3 4 5 ··· 7 下一页
SQLSever,Oracle,PostgreSQL,MySQL,DB2,SQLite,MongoDB,HBase
sql: Expressing a Child-Parent-Grandparent Relationship Problem
摘要：msyql 8.0 with recursive x (tree,mgr,depth) as ( select cast(ename as CHAR(100)) as ename, mgr, 0 from emp where ename = 'MILLER' union all select cas 阅读全文
posted @ 2025-08-31 23:46 ®Geovin Du Dream Park™ 阅读(8) 评论(0) 推荐(0)
sql: Creating a Delimited List from Table Rows
摘要：mysql 8.0 CREATE TABLE EMP ( EMPNO INTEGER NOT NULL, ENAME VARCHAR(10), JOB VARCHAR(9), MGR INTEGER, HIREDATE DATE, SAL INTEGER, COMM INTEGER, DEPTNO 阅读全文
posted @ 2025-08-31 22:29 ®Geovin Du Dream Park™ 阅读(6) 评论(0) 推荐(0)
SQL Cookbook, 2nd Edition
摘要：• DB2 11.5• Oracle Database 19c• PostgreSQL 12• SQL Server 2017• MySQL 8.0 mysql 8.0: CREATE TABLE EMP ( EMPNO INTEGER NOT NULL, ENAME VARCHAR(10), JO 阅读全文
posted @ 2025-08-28 22:18 ®Geovin Du Dream Park™ 阅读(14) 评论(0) 推荐(0)
neo4j-community-5.26.0 create new database in windows 10
摘要：CREATE DATABASE honglouneto4j; CREATE DATABASE slow WAIT 5 SECONDS; START DATABASE customers CALL db.schema.visualization() :play start :sysinfo 1.edi 阅读全文
posted @ 2025-02-01 15:27 ®Geovin Du Dream Park™ 阅读(153) 评论(0) 推荐(0)
neo4j: sql script sample
摘要：the Movie Graph Create CREATE DATABASE hongloumeng SHOW DATABASES YIELD name CREATE DATABASE slow WAIT 5 SECONDS START DATABASE customers CALL db.sche 阅读全文
posted @ 2025-01-22 09:38 ®Geovin Du Dream Park™ 阅读(46) 评论(0) 推荐(0)
Oracle sql developer and Toad for Oracle set start DBMS output
摘要：Register - Day of AI https://dayofai.org/register/ Oracle sql developer Toad for Oracle 阅读全文
posted @ 2024-12-31 19:52 ®Geovin Du Dream Park™ 阅读(13) 评论(0) 推荐(0)
oracle: 21C create user
摘要：-- oracle 21c create user c##geovindu identified by 88888; grant create session,create table,unlimited tablespace to c##geovindu; create user c##geovi 阅读全文
posted @ 2024-12-28 16:29 ®Geovin Du Dream Park™ 阅读(34) 评论(0) 推荐(0)
oracle: create new database
摘要：用database configuration Assistant 引导创建数据库。 创建操作用户： -- 别加双引号，否则，无法用 create user geovindu identified by 888888; create user geovin identified by 888888; 阅读全文
posted @ 2024-12-23 20:50 ®Geovin Du Dream Park™ 阅读(23) 评论(0) 推荐(0)
string split function in postgreSQL 17.01 or SQL Server2019 or mySQL 9.0 or Oracel 21c
摘要：postgreSQL 17.01 + SELECT 'S0001' AS STU, unnest(string_to_array('G,E,O,V,I,N,D,U,B,,A,B,C,D,A,B,D,B,C,C,B,A,B,D,A,C,D,A,B,D,A,D,C,B,D,B,D,B,A,C,D,A,C 阅读全文
posted @ 2024-11-13 06:58 ®Geovin Du Dream Park™ 阅读(28) 评论(0) 推荐(0)
PostgreSQL16在WIN10安装
摘要：assembler汇编器 compiler编译器 interpreter 解释器 https://www.enterprisedb.com/downloads/postgres-postgresql-downloads Professional JavaScript for Web Develope 阅读全文
posted @ 2024-08-17 23:42 ®Geovin Du Dream Park™ 阅读(142) 评论(0) 推荐(0)
sql: SQLite,MySQL,SQL Server
摘要：SQLite 3 select StudentId,StudentName,StudentNO,StudentBirthday,(julianday('now')-julianday(StudentBirthday))/365 as Age from DuStudentList; SELECT (j 阅读全文
posted @ 2023-06-25 22:10 ®Geovin Du Dream Park™ 阅读(18) 评论(0) 推荐(0)
mysql: character set in mysql 8.0
摘要：-- https://dev.mysql.com/doc/refman/8.0/en/charset-database.html show variables like "character_set_%"; CREATE DATABASE `geovindu` CHARACTER SET utf8 阅读全文
posted @ 2023-04-29 14:57 ®Geovin Du Dream Park™ 阅读(19) 评论(0) 推荐(0)
sql server:Pivot and UNPivot data with date in the columns
摘要：--行列转换 drop table geovindu create table geovindu (ID int,ChangeName nvarchar(25),Number1 int,Number2 int) insert into geovindu select 1,'购物换领',10,1 un 阅读全文
posted @ 2022-07-07 12:06 ®Geovin Du Dream Park™ 阅读(31) 评论(0) 推荐(0)
sql server: create Trigger using del,insert,update
摘要：/* create database geovindu; 两数据库之间的一个类似表，进行一个表的操作添加，修改时的同步操作的触发器操作 use geovindu; create database DuMap go use DuMap go -- Geovin Du,涂聚文 --Geovin Du， 阅读全文
posted @ 2022-03-06 14:31 ®Geovin Du Dream Park™ 阅读(34) 评论(0) 推荐(0)
sql: paging in SQL Server
摘要：--sql server 2012 及以上 SELECT * FROM BookKindList ORDER BY (SELECT NULL) OFFSET 0 ROWS FETCH NEXT 3 ROWS ONLY go -- geovindu Geovin Du 涂聚文 Declare @Pag 阅读全文
posted @ 2021-12-28 15:14 ®Geovin Du Dream Park™ 阅读(50) 评论(0) 推荐(0)
sql server: Parent/Child hierarchy tree view
摘要：sql server - Parent/Child hierarchy tree view - Stack Overflow declare @pc table(CHILD_ID int, PARENT_ID int, [NAME] varchar(80)); insert into @pc sel 阅读全文
posted @ 2021-09-18 14:56 ®Geovin Du Dream Park™ 阅读(57) 评论(0) 推荐(0)
SQL: Recursive query in MySQL
摘要：DROP TABLE IF EXISTS `dudept`; CREATE TABLE `dudept` ( `Id` int(11) NOT NULL AUTO_INCREMENT comment 'ID', `deptCode` varchar(10) CHARACTER SET utf8 CO 阅读全文
posted @ 2020-08-29 11:30 ®Geovin Du Dream Park™ 阅读(300) 评论(0) 推荐(0)
SQL Server Trigger and Cursor Example
摘要：--查看数据库中所有触发器 https://docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql?view=sql-server-ver15 -- 涂聚文(Geovin Du) edit https://w 阅读全文
posted @ 2020-08-12 17:36 ®Geovin Du Dream Park™ 阅读(197) 评论(0) 推荐(0)
Sql：SQL Server CREATE SEQUENCE statement
摘要：自动增长跳至1001 https://stackoverflow.com/questions/17587094/identity-column-value-suddenly-jumps-to-1001-in-sql-server --1. 使用序列 (Sequence) https://docs.m 阅读全文
posted @ 2020-08-05 10:48 ®Geovin Du Dream Park™ 阅读(298) 评论(0) 推荐(0)
Sql: Oracle paging
摘要：用的Toad for Oracle 12.1 编辑，Oracle 10g 阅读全文
posted @ 2019-12-20 13:03 ®Geovin Du Dream Park™ 阅读(402) 评论(0) 推荐(0)

1 2 3 4 5 ··· 7 下一页