随笔分类 -  SQL

oracle,SQL, mysql
摘要:"慢查询" 阅读全文
posted @ 2018-07-06 13:11 随便了888 阅读(98) 评论(0) 推荐(0)
摘要:1. 备份 2. 修改 在[mysqld]下修改为bind address=0.0.0.0 没有的话就直接加上 3. 重启 `service mysql restart` 阅读全文
posted @ 2018-05-30 09:08 随便了888 阅读(933) 评论(0) 推荐(0)
摘要:#!/usr/bin/python # -*- coding:utf-8 -*- # @filename: search # @author:wwx399777 wuweiji # @date: 2018/1/25 9:35 import pymysql import pyecharts from datetime import datetime import pandas as pd im... 阅读全文
posted @ 2018-01-24 10:45 随便了888 阅读(358) 评论(0) 推荐(0)
摘要:`pip3 install mysqlclient` try again `python manage.py makemigrations python manage.py migrate` 阅读全文
posted @ 2018-01-23 14:15 随便了888 阅读(2469) 评论(1) 推荐(1)
摘要:一条命令解决 但这只是简单解决问题,详细查看 "百度经验" , "知乎" 上的讨论 forget root password reference:https://www.cnblogs.com/wxdblog/p/6864475.html 阅读全文
posted @ 2018-01-23 10:09 随便了888 阅读(1192) 评论(0) 推荐(0)
摘要:1、download mysql installer community 5.7.20 https://dev.mysql.com/downloads/file/?id=473605 or 链接:http://pan.baidu.com/s/1nvA8rDf 密码:tj1p 2、install te 阅读全文
posted @ 2017-11-06 00:04 随便了888 阅读(446) 评论(0) 推荐(0)
摘要:http://blog.csdn.net/xxm524/article/details/48754139 阅读全文
posted @ 2017-11-05 20:17 随便了888 阅读(197) 评论(0) 推荐(0)
摘要:oracle SQL select 'para1' || 'para2' as "para" must "" select count(*),c.id,c.name co... 阅读全文
posted @ 2017-08-17 14:20 随便了888 阅读(235) 评论(0) 推荐(0)
摘要:1、distinct去除重复项,s,d别名,order by s.time desc以时间逆序排列 select distinct s.time,d.area from server.table s,device.table d where s.id = d.id and s.time > '201 阅读全文
posted @ 2017-04-25 23:03 随便了888 阅读(142) 评论(0) 推荐(0)