czjnoe的博客

ALTER TABLE 表名 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;SHOW Table Status WHERE `Name` = '表名';

SELECT DATEDIFF(month,'2021-05-16 18:00:00',getdate())*1.0/12 as '年差值' , cast(DATEDIFF(month,'2021-04-16 18:00:00',getdate())*1.0/12 as decimal(18,1)) as '年差值-保留小数位', DATEDIFF(Hour,'2022-05-16 18:00:00',getdate())*1.0/24 as '天差值' , .

查看被锁表： select sess.sid, sess.serial#, lo.oracle_username,--登录账号 lo.os_user_name,--登录电脑 ao.object_name,--被锁表名 lo.locked_mode --锁住级别 from v$locked_object lo,dba_objects ao,v$session sess where ao.object_id=lo.object_id and lo.session_id=sess.sid;

环境：Window10win64_11gR2_client查看Oracle字符集：select userenv('language') from dual;添加环境变量:变量名：NLS_LANG变量值：SIMPLIFIED CHINESE_CHINA.AL32UTF8

原因：Oracle账户多次以错误密码登录，导致数据库服务器宕机，账户被锁定以系统账户sys 登录Oracle，查看sql:SELECT * FROM DBA_PROFILES WHERE RESOURCE_NAME = 'FAILED_LOGIN_ATTEMPTS';原来Oracle默认是限制账户10次错误密码登录解决：首先需要先解锁被locked的账户：alter user [自己账户名] account unlock;可以增加限制次数或者总结设置无限制：..

1、查询表的大小select object_name(id) tablename,8*reserved/1024 reserved,rtrim(8*dpages/1024)+'Mb' used,8*(reserved-dpages)/1024 unused,8*dpages/1024-rows/1024*minlen/1024 free, rows,* from sysindexes where indid=1 order by reserved desc ...

1、打开cmdcd到保存目录2、输入指令:sqlite3 test.db3、输入 .database 便可在目录下创建数据库

一、Sql直接读取select 'SeqName'.NEXTVAL from dual二、Func函数create or replace function GetSequenceFunc( seqName in char)return intAS sqlstr varchar(100); seqValue number(20);begin sqlstr := 'select '||seqName||'.nextval from dual

一、下载地址：MonGoDb:https://www.mongodb.com/try/download/community可视化软件：https://www.mongodb.com/try/download/compass二、安装参考：https://www.runoob.com/mongodb/mongodb-window-install.html

select * from (select t.*,CAST( case when tbl.is_ms_shipped = 1 then 1 when ( select major_id from sys.extended_properties where major_id = tbl.object_id and minor_id .

函数：SCHEMA_NAMEselectSCHEMA_NAME()SELECT * FROM sys.database_principals;(default_schema_name列即为默认架构)

网盘下载（版本mysql-v5.7.25）：链接：https://pan.baidu.com/s/1j_-2VfF0S38aXQzer7L8tg提取码：8ict安装完成后找到安装目录：（我的安装目录如下图）配置环境变量。将此（C:\Program Files\MySQL\MySQL Server 5.7\bin）目录添加环境变量。1.以管理员身份打开cmd:执行...