<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[chuangqiangming的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/chuangqiangming</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; chuangqiangming]]></copyright><item><title><![CDATA[mysql语法思维导图]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/124653893</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/124653893</guid><author>chuangqiangming</author><pubDate>Sun, 08 May 2022 20:24:01 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[hadoop]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/124653611</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/124653611</guid><author>chuangqiangming</author><pubDate>Sun, 08 May 2022 20:08:22 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[爬虫：四种统计图带码-》]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/124653566</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/124653566</guid><author>chuangqiangming</author><pubDate>Sun, 08 May 2022 20:06:01 +0800</pubDate><description><![CDATA[. 饼图 pie

import matplotlib.pyplot as plt

# 数据准备

nums = [25, 37, 33, 37, 6]

labels = ['High-school','Bachelor','Master','Ph.d', 'Others']

# 用 Matplotlib 画饼图

plt.pie(x = nums, labels=labels)

plt.show()

蜘蛛图

import numpy as np

import matplotlib.pyplo]]></description><category></category></item><item><title><![CDATA[python]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/124530827</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/124530827</guid><author>chuangqiangming</author><pubDate>Sun, 01 May 2022 19:01:43 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[mysql优化]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/124530747</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/124530747</guid><author>chuangqiangming</author><pubDate>Sun, 01 May 2022 18:58:53 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[mysql]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/124530759</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/124530759</guid><author>chuangqiangming</author><pubDate>Sun, 01 May 2022 18:55:43 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[hadoop]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/124530682</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/124530682</guid><author>chuangqiangming</author><pubDate>Sun, 01 May 2022 18:50:23 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[numpy函数]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/124391174</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/124391174</guid><author>chuangqiangming</author><pubDate>Sun, 24 Apr 2022 20:31:31 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[Java操作hdfs]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/124391059</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/124391059</guid><author>chuangqiangming</author><pubDate>Sun, 24 Apr 2022 20:25:42 +0800</pubDate><description><![CDATA[HDFSDemo.java

package cn.itcast.hadoop.hdfs; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.net.URI; i]]></description><category></category></item><item><title><![CDATA[sql查询优化]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/124390868</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/124390868</guid><author>chuangqiangming</author><pubDate>Sun, 24 Apr 2022 20:18:51 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[数据库——]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/124085812</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/124085812</guid><author>chuangqiangming</author><pubDate>Sun, 10 Apr 2022 21:04:07 +0800</pubDate><description><![CDATA[用户表
用户名 密码 注册日期 生日
CREATE TABLE yonghuinfo(
 userid INT PRIMARY KEY NOT NULL,
 paw INT NOT NULL,
 u_date DATE,
 birthday DATE
) ;
用户购买记录表
用户名 购物车记录 购买记录 
CREATE TABLE yonghugoumainfo(
 userid INT PRIMARY KEY NOT NULL,
 gouwuce INT,
 g...]]></description><category></category></item><item><title><![CDATA[爬虫_______]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/124085451</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/124085451</guid><author>chuangqiangming</author><pubDate>Sun, 10 Apr 2022 20:47:54 +0800</pubDate><description><![CDATA[XPath 是一门在 XML 文档中查找信息的语言。

XPath 可用来在 XML 文档中对元素和属性进行遍历。

XPath 是 W3C XSLT 标准的主要元素，并且 XQuery 和 XPointer 都构建于 XPath 表达之上。

安装

pip install lxml

fromlxmlimportetree



wb_data="""

&lt;div&gt;

&lt;ul&gt;

&lt;li c...]]></description><category></category></item><item><title><![CDATA[linux 安装jdk 和 hadoop]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/124084991</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/124084991</guid><author>chuangqiangming</author><pubDate>Sun, 10 Apr 2022 20:30:07 +0800</pubDate><description><![CDATA[进入jdk 所在文件夹

cd software/

安装在moudle文件下

tar -zxvf jdk-8u212-linux-64.tar.gz -C /opt/module/

进入jdk 所在文件夹

cd software/

安装在moudle文件下

tar -zxvf jdk-8u212-linux-64.tar.gz -C /opt/module/

配置环境变量

sudo vim my_env.sh

安装成功，ll指令查看

如下图，就是安装成功了


...]]></description><category></category></item><item><title><![CDATA[爬虫——————]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/119138003</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/119138003</guid><author>chuangqiangming</author><pubDate>Sun, 03 Apr 2022 15:06:08 +0800</pubDate><description><![CDATA[js数据类型一共分6 种

1，Number 数值

2，String 字符串

3,Boolean 布尔值

4,Null 空

5,Undefined 未定义

6,Object 对象

typeof ,可以获得一个值得数据类型且是String类型（typeof 值）


]]></description><category></category></item><item><title><![CDATA[Mysql__触发器]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/123937696</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/123937696</guid><author>chuangqiangming</author><pubDate>Sun, 03 Apr 2022 14:57:59 +0800</pubDate><description><![CDATA[触发器语法

create trigger triggerName after/before insert/update/delete on 表名 for each row #这句话在mysql是固定的 begin sql语句; end;

触发器案列

create trigger ins_stu after insert on student for each row begin insert into cj ( stu_id, stu_name) values( new.stuid, new.user]]></description><category></category></item><item><title><![CDATA[Linux——shell]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/123619244</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/123619244</guid><author>chuangqiangming</author><pubDate>Sun, 20 Mar 2022 19:34:20 +0800</pubDate><description><![CDATA[只读变量

语法：readonly变量名

接收用户输入

语法：read-p

删除变量 

语法：unset变量名path

条件判断句

if condition --如果

thencommand1command2...--执行

else --否则

command            --执行

关系运算符

运算符说明举例-eq检测两个数是否相等，相等返回true。[$a-eq$b]返回false。-ne检测两个数是否相等，不相等返回true。[$a-ne...]]></description><category></category></item><item><title><![CDATA[爬虫基础语法]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/123619089</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/123619089</guid><author>chuangqiangming</author><pubDate>Sun, 20 Mar 2022 19:21:46 +0800</pubDate><description><![CDATA[from urllib import request
import re

# 定义了一个URL
page = 100
url = "https://tieba.baidu.com/f?kw=%E6%AE%B5%E5%AD%90&amp;ie=utf-8&amp;pn=" + str(page)

try:
  # 定义请求头
  headers = {
    'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebK...]]></description><category></category></item><item><title><![CDATA[mySQL]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/123618773</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/123618773</guid><author>chuangqiangming</author><pubDate>Sun, 20 Mar 2022 19:05:31 +0800</pubDate><description><![CDATA[创建表的同时创建索引







组合索引








]]></description><category></category></item><item><title><![CDATA[爬虫基础_齐南汕]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/123465805</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/123465805</guid><author>chuangqiangming</author><pubDate>Sun, 13 Mar 2022 20:58:32 +0800</pubDate><description><![CDATA[入门程序



2.爬虫程序添加data、header，然后post请求

data

import urllib2 request = urllib2.Request(uri, data=data)

request.get_method = lambda: 'PUT' # or 'DELETE' response = urllib2.urlopen(request)

Header







3.爬虫程序添加cookie

4.正则表达式



1.了解正则表达式正则表达式是对字符串操作的一种...]]></description><category></category></item><item><title><![CDATA[Sql基础语法——齐南汕]]></title><link>https://blog.youkuaiyun.com/chuangqiangming/article/details/123464727</link><guid>https://blog.youkuaiyun.com/chuangqiangming/article/details/123464727</guid><author>chuangqiangming</author><pubDate>Sun, 13 Mar 2022 20:06:19 +0800</pubDate><description><![CDATA[建库

CREATE DATABASE IF NOT EXISTS （自定义库名）DEFAULT CHARSET utf8;

建表

CREATETABLEIF NOT EXISTS `自定义表名`(

`自定义字段``INT UNSIGNED AUTO_INCREMENT,

`自定义字段``VARCHAR(100)NOT NULL,

`自定义字段``VARCHAR(40)NOT NULL,

`自定义字段``DATE, PRIMARYKEY(`自定义字段`))ENGINE=InnoDBD...]]></description><category></category></item></channel></rss>