dandelionoooo的博客

create or replace function stringArrayIntersectionCount(A in varchar2, B in varchar) return number deterministic --deterministic 是函数索引，意思是如果输入一样的话就不运行，取上次输入同样入参后运算出来的值。--新增判断A字符串数组和B字符串数组有交集的字符串个数函数。--判断A字符串数组和B字符串数组有交集的字符串个数。晚点等我试试管道函数看看效率是否有提升。

1.先把mysql安装包解压到你想要的文件夹2.跳转到文件夹的bin目录下3.先执行mysqld --initialize-insecure生成无初始密码的文件，再mysqld -install安装服务4.net start mysql启动服务5.输入mysql -uroot -p，并且要求输入密码时直接回车，进入mysql服务中6. 通过输入 ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxx';设置你想要的密码7.密码设置成功了。可以..

执行alter user 'root'@'localhost' identified with mysql_native_password by '密码'; 后，执行select host, user, authentication_string, plugin from user; root那行密码是没有加密过的密码导致一直登不上。解决方法是执行alter user 'root'@'localhost' identified by '密码';密码显示成一串加密字符串，验证也没有问题，就没有问题了

懒得每次都要重写 drop procedure if exists insertText;  delimiter $create procedure insertText()    BEGIN    DECLARE t_error INTEGER DEFAULT 0;       declare i int(11);     DECLARE CONTINUE HANDLER...

CREATE DEFINER = 'root'@'%' TRIGGER `tg_i` AFTER INSERT ON `table1`    //建立触发器  FOR EACH ROWBEGIN                                                                                                     ...

mysql字符串压缩compress(),uncompress()用法：SELECT COMPRESS(arrPositions) ,UNCOMPRESS(COMPRESS(arrPositions) ) from p_parking但是并不能用在触发器对表内某段数据压缩后插入另一个表中再传递到另一个数据库插入时解压缩的使用中去 ...

https://download.youkuaiyun.com/download/dandelionoooo/11420694安装包路径解压安装包 点击图上Setup.exe，装好。3.在crack文件夹里找到iNViSiBLE.reg并且双击，之后把该文件夹内的MyManager.exe替换掉安装时的路径下同名的文件。双击MyManager.exe打开。4.按如图所示添加项目...

SELECT REPLACE(feeValues, "\"", "\\\"") FROM p_charge_type;

今天数据库宕机了，只能查询不能增删改，看了下日志报的innodb_force_recovery>0这个。网上的资料说当innodb_force_recovery大于0时只允许查询，做法是把my.ini里面的innodb_force_recovery值改成0.我找到了文件，发现并没有innodb_force_recovery属性，就自己添加了一个innodb_force_recovery=0进...

INSERT INTO record_access(time,employeeId)       SELECT ra.time,ra.employeeId from `r_record_access` as ra      LEFT JOIN `kq_work_shift` as ws on ra.employeeId = ws.employeeId  where DATE_FORMAT(time...

select remarks from (select *,substring_index(substring_index(remarks,"】",1),'【',-1) as carCard from p_record_event )  as accwhere carCard LIKE '%C999%' 

select recordId, employeeId,startTime,endTime from `kq_absent_register` as ar where ar.employeeId = 75 and "2017-07-05" and "2017-07-05" >= DATE_FORMAT(ar.endTime,'%Y-%m-%d') and ar.type = 1

a=1;b=2;c=3;set d= select  LEAST(a,b,c);则d=1;set e= select  GREATEST(a,b,c);则e=3;

drop procedure if exists myProc;delimiter $$CREATE PROCEDURE myProc(in segNum int(11))  BEGIN   DECLARE j int;   DECLARE i int;   SET i=1;    SET j=segNum;     IF i > 0 THEN   loop1:

如何使用SQLManagerforMySQL2007导出整个数据库(2012-08-30 00:57:59)标签： it 择导出表、数据及结构，可参考如下步骤： 第一步，选择Tools | Extract Database，选择要导出的数据：第二步，修改导出文件的存放路径：第三步，选择导出表结构还是表数据：...

sum：求值的和count：求值的次数avg：求平均数

select * from ( select adddate('2017-03-01', numlist.id) as 'date' from (SELECT n1.i + n10.i*10 + n100.i*100 AS id FROM num n1 cross join num as n10 cross join num as n100) as numlist where adddate('2

select adddate('2017-03-01', numlist.id) as 'date' from (SELECT n1.i + n10.i*10 + n100.i*100 AS id FROM num n1 cross join num as n10 cross join num as n100) as numlist where adddate('2017-03-01', numl

start transaction;  //开启服务create procedure getData()begin   declare i int;   ////创建存储过程set i=0;while i  insert into `p_employee`(name,departmentId) values("xx",1);   插入数据   set i=i+1; 

https://segmentfault.com/a/1190000010264071?ref=myread

drop procedure if exists normalWorkOver;    delimiter $   create procedure normalWorkOver(in segNum int(11),in xxsetting int(11),in xxbegin varchar(20),in dsegNum int(11),in ddate VARCHA