- 博客(9)
- 资源 (3)
- 收藏
- 关注
原创 MYSQL 插入数据库,(过滤重复)
insert into security_role_group_rel(GRP_ID,ROLE_ID,RG_ID) select '$GRP_ID$','$ROLE_ID$',uuid() from dual where NOT EXISTS (select * from security_role_group_rel where GRP_ID = '$GRP_ID$' and ...
2018-08-26 06:56:39 1012
原创 ssh 请求mysql 命令
连接数据库mysql -u userName -p显示数据库:mysql-> show databases;使用数据库:mysql-》 user tableName;查询数据表mysql-> show tables;数据表创建执行mysql-》 source src ...
2018-08-20 20:25:03 220
原创 SSH 请求MYSQL 命令
List of all MySQL commands:Note that all text commands must be first on line and end with ';'? (\?) Synonym for `help'.clear (\c) Clear the current input statement.connect (\r) Recon...
2018-08-20 20:15:58 407
转载 SSH Secure Shell Client登陆配置服务器mysql命令
SSH上去以后,执行mysql -u username -p然后输入密码,进入mysql命令行,此时的终端上应该是以下样式:创建数据库是mysql>create database dbname; 删除数据库是mysql>drop database dbname;你想myuser使用mypassword从任何主机连接到mysql服务器的话。mysql&g...
2018-08-20 18:13:57 242
原创 sql 自动计算两个日期之间相隔时间
/detediff 函数计算 day ,month 等 示例,计算天数差:select datediff(day,BEGINTIME,ENDTIME) as PlanTimer from tableName
2018-08-17 14:04:58 4645
原创 调用mui插件,窗体无法滑动问题
最近做移动端开发,需要一个侧滑功能,由于偷懒,调用了mui的侧滑功能,然而引用了mui.js之后,侧滑是可以了,放在移动端的滑动事件就没了。查找再三,发下如下问题。mui里将滑动事件自己禁止了。// document.addEventListener('touchmove', function(e) { e.preventDefault(); }, false)原生配了个方法,支持区域...
2018-08-16 11:34:56 1008
原创 侧滑淡出样式(仅css,js稍微写下样式切换就好)
.slideLeft{ transform: translate(-200px,0px); transition-delay: 0s; transition-timing-function: ease; transition-duration: 1s; } .slideRight{ transform: translate(...
2018-08-16 09:25:19 289
转载 Jquery轨道图插件 Subway Map 解释
I have always been fascinated by the visual clarity of the London Underground map. Given the number of cities that have adopted this mapping approach for their own subway systems, clearly this is a po...
2018-08-07 11:25:16 2811
原创 Sql Server Merge 用法
merge into [DN_DEPARTMENT] as dusing [sys_projectInfo] as pon d.MYGUID = p.LandIdwhen MATCHEDTHEN UPDATE SET d.DEPARTMENT_TYPE_NAME= '项目公司',d.DEPARTMENT_NAME=p.LandName,d.DEP_LEVEL=5,d.DEP_IS_...
2018-08-06 18:15:37 172
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人