jsboy123的专栏

438Install the additional module tablefunc once per database, which provides the function crosstab(). Since Postgres 9.1 you can use CREATE EXTENSION for that:Improved test caseSimple form - not fit for missing attributescrosstab(text) with 1 input paramet

id,lon,lat,speed,source,data_time,is_delete,`out`,`in`,course,heading,depth_avg,)id,lon,lat,speed,source,data_time,is_delete,`out`,`in`,course,heading,depth_avg,

创建并发索引create index on tbl_real_time_data(tm,monitor_factor_code) WITH (timescaledb.transaction_per_chunk

Postgresql12 分区性能比较好目前是10.凑合用用吧。思路如下：按月创建表根据主表tbl_original_datacreate table tbl_original_data_202101() INHERITS (tbl_original_data);create table tbl_original_data_202102() INHERITS (tbl_original_data);create table tbl_original_data_202103() INHERIT

select max(id) from tbl_device_infoSELECT nextval('tbl_device_info_id_seq');比较下自增ID是否一样。不一样。替换下select setval('tbl_device_info_id_seq', (select max(id) from tbl_device_info) + 1)

同比：SELECT DISTINCT B.dateM,B.dateY,B.Total,B.Total+B.Total*AVG( B.per ) OVER ( PARTITION BY B.dateM ) as predictionTotal , AVG( B.per ) OVER ( PARTITION BY B.dateM ) AS [AvgPer] ,MA...

Win10上安装SQLServer2012 要先安装Net3.5，找了很久。终于找到解决办法。.NET Framework 3.5是许多应用程序赖以运行的基础环境框架，可谓是Windows系统必装组件，可是有许多用户却遇到错误提示“Windows无法完成请求的更改。参数错误。错误代码: 0x80070057”在线安装失败的问题。为此MS酋长早就已经分享了Win10离线安装.NET Framew...

驱动下载地址：http://dev.mysql.com/downloads/connector/odbc/2、管理工具-ODBC数据源-系统DSN-添加-选择 MYSQL ODBC 5.3 Unicode DRIVER-完成​会跳出来MYSQL连接参数Data Source Name:数据源名称Decription:描述,随便写Server:MYSQL服务器的IP...

CREATE USER 'root'@'localhost' IDENTIFIED BY 'zw@';GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;CREATE USER 'root'@'%' IDENTIFIED BY 'zw@';GRANT ALL PRIVILEGES ON *.* TO '...

#进入容器docker exec -it mysql bash#进入mysqlmysql -u root -p#重置密码ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_pa...

1.删除表里90%数据DELETE T FROM (SELECT TOP (90) PERCENT *       FROM [KS_DataBase2017].[dbo].[KS_EquipRec20170518] where ColTime >='2017-05-18' and ColTime       ORDER BY NEWID()) T2.查询一年内每个月总记录

SQL Server 权限管理标签：SQL SERVER/MSSQL SERVER/数据库/DBA/权限控制/管理/分配/登入名/数据库用户/角色概述      对数据库系统而言，保证数据的安全性永远都是最重要的问题之一。一个好的数据库环境，必须明确每个用户的职责，并分配其对应的权限。同时出现问题了也可以找到根源。你是否会有这样的需求：给某个用户查询所有

select EquipmentID,[concentration],[instantFlow],[outputQuantity],[pressure],[temperature],ColTime from (select a.EquipmentID,[FieldName],FieldValue,ColTimefrom KS_EquipRec201703 aleft joi

任意值:Select RecID, [RamCode],EquipMentID,[RecPressure],[ColTime] FROM   (SELECT RecID,[RamCode],EquipMentID,[RecPressure],[ColTime], datediff(mi,[ColTime],DATEADD(mi,-5,CASE WHEN DATEPART(mi,GETD

参考例子http://sqlfiddle.com/#!6/a63a6/457  SELECT LogicalStationID,[气体浓度_DLastValue],[传感器状态_DLastValue],  [水位状态_DLastValue],[电池状态_DLastValue],  case when [气体浓度_DLastTime]>=[传感器状

use mastergo/*添加服务器*/EXEC sp_addlinkedserver@server = 'hang', /*此名字可以随便取*/@srvproduct = 'SQL',@provider = 'SQLOLEDB',@datasrc = '10.130.26.x' /*说明：另外一台服务器的IP*/go/*登陆服务器*/EXEC sp_addlinkedsr...

在PG数据里创建一张表CREATE TABLE public.month(  code character(50),  month date,  value double precision)插入数据这样，INSERT INTO public.month(            code, month, value)    VALUES ('code1',

update `v9_news` set thumb=REPLACE(thumb,'cca','aaa')

将两个或者多个字段一起约束成一个唯一约束 1 alter table 表名 add constraint 约束名 unique (列名1,列名2)