MySQL
hm11290219
这个作者很懒,什么都没留下…
展开
-
python MySQL 写入excel
#!/usr/bin/env python#coding=utf-8import xlwtimport xlrdimport MySQLdbimport osos.chdir("E:\work")def lancome15_write_rows(): #将字段写入到EXCEL新表的第一行 L = ['Id', 'Amount of money', 'Purchase ti原创 2016-08-10 14:34:07 · 1113 阅读 · 0 评论 -
Lancome5_order
#!/usr/bin/env python# -*- coding: utf-8 -*- import xlwtimport xlrdimport xlutilsfrom xlutils.copy import copyimport MySQLdbimport osos.chdir("E:\work") def lancome15_addview(): conn=MySQLd原创 2016-08-22 16:55:15 · 362 阅读 · 0 评论 -
python update mysql 2
#!/usr/bin/env python# -*- coding: utf-8 -*- import xlwtimport xlrdimport xlutilsfrom xlutils.copy import copyimport MySQLdbimport osos.chdir("E:\work") def lancome15_read_excel(): workbook原创 2016-08-15 11:12:09 · 270 阅读 · 0 评论 -
sql 查询某一字段包含特定字符的数量
select case when bus_scope like '%婚纱摄影%' then 1 when bus_scope like '%婚庆策划%' then 2 when bus_scope like '%婚庆设备%' then 3 when bus_scope like '%广告策划%' then 4原创 2016-11-11 12:04:32 · 13521 阅读 · 0 评论 -
根据两个已有表建立新表
create table clue.dust as SELECT distinct c.company_name,c.reg_no, c.city, c.bus_scope, case when b.flag=1 then 1 else 0 end as new_flagFROM (select company_name, reg_no,city,bus_scope,province fro原创 2016-12-05 10:03:09 · 492 阅读 · 0 评论 -
提取文章高频词
# -*- coding: utf-8 -*-# * @author haoming# * @date 2016/11/08import MySQLdbimport pandas as pdimport numpy as npimport reimport codecs import jiebaimport jieba.analyseimport loggingfrom gens原创 2016-12-06 12:47:44 · 5829 阅读 · 0 评论 -
几个sql语句
select count(distinct(company_name)) from bj_capital 60/69select count(distinct(company_name)) from bj_capital2 134/193SELECT company_name FROM bj_capital UNION SELECT company_name FROM bj_原创 2016-12-06 17:45:38 · 308 阅读 · 0 评论