- 博客(13)
- 资源 (57)
- 问答 (5)
- 收藏
- 关注
转载 MySQL查询结果另外自带一列自增序列号
在mysql、或hive中查询时需要自己构建一个自增序列时可参照以下语法:set @rownum=0;select @rownum:=@rownum+1 as id from dual;set @rownum=0;SELECT @rownum:=@rownum+1 AS rownumFROM dual limit 10;SET @rownum =0;SELECT *,@...
2018-12-29 14:47:36 616
转载 mysql多个字段拼接
mysql> select concat('1','2','3') from test ;+---------------------+| concat('1','2','3') |+---------------------+| 123 |+---------------------+https://www.cnblogs.com/crystaltu/p/6699004.h...
2018-12-29 14:24:03 1351 1
转载 使用mysql 统计函数 结果为null时返回值改为0
SELECT COALESCE(SUM(total),0) FROM test_tablehttps://www.cnblogs.com/modou/p/7699373.html
2018-12-28 21:38:54 1407
转载 Java String字符串转成json数组并且遍历
https://blog.csdn.net/Architect_CSDN/article/details/80079688
2018-12-28 20:59:36 9354
转载 MySQL-this is incompatible with sql_mode=only_full_group_by
https://blog.csdn.net/qq_42175986/article/details/82384160
2018-12-28 20:20:15 209
转载 Sql语句将0 1转化为男女性别
SELECT CASE `user_gender` WHEN '1' THEN '男' WHEN '0' THEN '未知'ELSE '女' END AS gender FROM `info_user`https://blog.csdn.net/LXL516809007/article/details/46006123
2018-12-28 13:58:44 6689
转载 AngularJS系列之select下拉选择第一个选项为空白的解决办法
https://blog.csdn.net/linzhiqiang0316/article/details/52489668
2018-12-27 19:38:35 700
原创 angular.js发送ajax请求
$scope.ajaxData = function () { //需要向后台传递的数据 var postData = { id: 1 } $http({ method: 'GET', url: 'http://127.0.0.1/company/getList', params: postData ...
2018-12-27 15:48:26 1171
原创 python发送web请求的案例(基于Django)
from django.shortcuts import renderfrom django.http import HttpRequest, HttpResponsefrom Books.models import BookInfo, PeopleInfoimport jsondef test(request): id = request.GET.get("id") l...
2018-12-25 09:51:44 486
原创 python 对象转为json
import jsonfrom django.core import serializersjsonInfo1 = json.dumps(list)jsonInfo2 = serializers.serialize("json", PeopleInfo.objects.all())
2018-12-24 15:15:08 376
转载 __init__() missing 1 required positional argument: 'on_delete'
from django.db import models# Create your models here.class BookInfo(models.Model): """ 定义书籍信息模型类 """ # 设计name属性 name = models.CharField(max_length=10)class PeopleInfo(models...
2018-12-21 14:23:08 3263
转载 https://blog.csdn.net/xm_csdn/article/details/74419683
https://blog.csdn.net/xm_csdn/article/details/74419683
2018-12-18 19:22:28 646
原创 mybatis使用foreach查询
<select> <include refid="Base_Column_List" /> from router where management_id = #{managementId,jdbcType=INTEGER} and department_id = #{departmentId,jdbcType=INTEGER} and ...
2018-12-14 11:06:06 643
FiddlerSetup.zip
2019-07-16
OBS-Studio
2018-12-22
kibana-6.4.2-x86_64
2018-10-22
kibana-6.4.2-windows-x86_64
2018-10-22
kibana-6.4.2-linux-x86_64
2018-10-22
centos7修改语言环境支持中文总失败
2018-03-24
struts2 Session生命周期
2017-12-14
php创建类的方法 php菜鸟一枚 请问这行代码是什么意思?
2017-05-01
Android中如何无损保存BitMap文件?
2017-03-10
Java如何调用打印机打印本地文档
2016-09-08
TA创建的收藏夹 TA关注的收藏夹
TA关注的人