随笔分类 - SQL
oracle,SQL, mysql
摘要:1. 备份 2. 修改 在[mysqld]下修改为bind address=0.0.0.0 没有的话就直接加上 3. 重启 `service mysql restart`
阅读全文
摘要:#!/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...
阅读全文
摘要:`pip3 install mysqlclient` try again `python manage.py makemigrations python manage.py migrate`
阅读全文
摘要:一条命令解决 但这只是简单解决问题,详细查看 "百度经验" , "知乎" 上的讨论 forget root password reference:https://www.cnblogs.com/wxdblog/p/6864475.html
阅读全文
摘要: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
阅读全文
摘要:http://blog.csdn.net/xxm524/article/details/48754139
阅读全文
摘要:oracle SQL select 'para1' || 'para2' as "para" must "" select count(*),c.id,c.name co...
阅读全文
摘要: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
阅读全文

浙公网安备 33010602011771号