<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[mabaiteng的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/mabaiteng</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; mabaiteng]]></copyright><item><title><![CDATA[MySQL学习记录（十一）--常见的约束]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/122071880</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/122071880</guid><author>mabaiteng</author><pubDate>Tue, 21 Dec 2021 19:49:42 +0800</pubDate><description><![CDATA[#常见的约束
/*

含义：一种限制，用于限制表中的数据，为了保证表中的数据的准确和可靠性

分类：六大约束
 NOT NULL:非空约束，用于保证该字段的值不能为空（如姓名、学号）
 defaut ：默认。用于保证该字段有默认值。（如性别）
 primary key :主键，用于保证该字段的值具有唯一性，并且非空。
 unique:唯一，保证该字段的值具有唯一性，可以为空（如座位号）
 check：检查约束【mysql中不支持】
 foreign key :外键，用于限...]]></description><category></category></item><item><title><![CDATA[TensorFlow学习记录（九）---人工神经网络经典框架]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121925811</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121925811</guid><author>mabaiteng</author><pubDate>Tue, 14 Dec 2021 13:58:43 +0800</pubDate><description><![CDATA[人工神经网络经典框架]]></description><category></category></item><item><title><![CDATA[TensorFlow学习记录（八）---实现多层人工神经网络]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121925579</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121925579</guid><author>mabaiteng</author><pubDate>Tue, 14 Dec 2021 13:53:17 +0800</pubDate><description><![CDATA[多层神经网络实现鸢尾花的分类
]]></description><category></category></item><item><title><![CDATA[TensorFlow学习记录（七）---实现单层人工神经网络]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121925548</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121925548</guid><author>mabaiteng</author><pubDate>Tue, 14 Dec 2021 13:47:37 +0800</pubDate><description><![CDATA[import tensorflow as tf
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
#加载数据集
TRAIN_URL ="http://download.tensorflow.org/data/iris_training.csv"
train_path = tf.keras.utils.get_file(TRAIN_URL.split('/')[-1],TRAIN_URL)
df_iris_train ]]></description><category></category></item><item><title><![CDATA[MySQL学习记录（十）--DDL语言]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121925417</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121925417</guid><author>mabaiteng</author><pubDate>Tue, 14 Dec 2021 13:42:32 +0800</pubDate><description><![CDATA[数据定义语言
	----库和表的管理

一、库的管理
创建、修改、删除

二、表的管理
创建、修改、删除

创建：create
修改：alter
删除：drop]]></description><category></category></item><item><title><![CDATA[MySQL学习记录（十）--DML语言]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121915022</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121915022</guid><author>mabaiteng</author><pubDate>Mon, 13 Dec 2021 21:31:48 +0800</pubDate><description><![CDATA[修改；删除；插入]]></description><category></category></item><item><title><![CDATA[MySQL学习记录（九）--联合查询]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121911933</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121911933</guid><author>mabaiteng</author><pubDate>Mon, 13 Dec 2021 18:50:48 +0800</pubDate><description><![CDATA[#进阶九-联合查询
/*
union 联合 合并： 将多条查询语句的结果合并成一个结果
语法：
	查询语句1
	union
	查询语句2
	union
	...

应用场景：
	要查询结果来自两个表以上，且表之前没有直接连接关系
	但查询信息一致时
	
特点：
	1.要求多条查询语句的查询列数是一致的
	2.要求多条查询语句的每一列的类型和顺序是一致的
	3.使用union 关键字默认是去重，如果使用union all可以包含重复项
	
	
*/


#引入案例：查询部门编号&gt;90或邮箱信息包含 a.]]></description><category></category></item><item><title><![CDATA[MySQL学习记录（八）--分页查询]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121904835</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121904835</guid><author>mabaiteng</author><pubDate>Mon, 13 Dec 2021 14:32:45 +0800</pubDate><description><![CDATA[#进阶8 :分页查询
/*
应用场景：当显示的数据，一页显示不全，需要分页提交sql请求
语法：
	select 查询列表
	from 表
	【join type】 join 表2
	on 连接条件
	[where 
	group by
	having
	order by]
	
	
	limit 【offset】，size
	offset 要显示条目的起始索引（起始索引，从0开始）
	size 要显示的条目个数
特点：
	1.limit语句放在最后
	2.公式
	要显示的页数page，每页的条目数size
]]></description><category></category></item><item><title><![CDATA[MySQL学习记录（七）--子查询]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121904792</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121904792</guid><author>mabaiteng</author><pubDate>Mon, 13 Dec 2021 14:31:22 +0800</pubDate><description><![CDATA[#进阶七：子查询
/*
含义：出现在其他语句中的SELECT语句，称为子查询或者内查询
	外部的查询语句，称为主查询或者外查询
分类：
	按子查询出现的位置：
		select 后面
			--仅支持标量子查询
		from 后面
			--仅支持表子查询
		where后面或having后面（※）
			--标量子查询（※）
			--列子查询（※）
			--行子查询
		exists后面（相关子查询）
			--表子查询
	按结果集的行列数：
		标量子查询（结果只有一行一列）
		列子查询（结果集只]]></description><category></category></item><item><title><![CDATA[TensorFlow学习记录（六）---分类问题]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121898169</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121898169</guid><author>mabaiteng</author><pubDate>Mon, 13 Dec 2021 09:25:17 +0800</pubDate><description><![CDATA[一元逻辑线性回归


import numpy as np
import matplotlib.pyplot as plt
import tensorflow as tf
x = np.array([137.97,104.50,100.00,124.32,79.20,99.00,124.00,114.00,106.69,138.05,53.75,46.91,
              68.00,63.02,81.26,86.21])
y = np.array([1,1,0,...]]></description><category></category></item><item><title><![CDATA[MySQL学习记录（六）--连接查询]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121792067</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121792067</guid><author>mabaiteng</author><pubDate>Wed, 08 Dec 2021 15:15:50 +0800</pubDate><description><![CDATA[#进阶六：连接查询
/*
含义：多表查询，查询字段涉及多个表

笛卡尔乘积现象：表1：m行；表二：n行，结果=m*n行

发生原因：没有有效的连接条件

分类：
	按年代分类：
		sq192标准:仅支持内连接
		sq199标准【推荐】
	
	按功能分类：
		内连接：
			等值连接
			非等值连接
			自连接
		外连接：
			左外连接
			右外连接
			全外连接
		交叉连接

*/  

SELECT * FROM `beauty`;
SELECT * FROM `boys`;

#笛卡]]></description><category></category></item><item><title><![CDATA[TensorFlow学习记录（五）---TensorFlow实例]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121790474</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121790474</guid><author>mabaiteng</author><pubDate>Wed, 08 Dec 2021 14:29:23 +0800</pubDate><description><![CDATA[实例：波士顿房价数据集一元线性回归


import tensorflow as tf
import numpy as np
import matplotlib.pyplot as plt
#加载数据集
boston_housing = tf.keras.datasets.boston_housing
(train_x,train_y),(test_x,test_y)=boston_housing.load_data()
#数据处理
x_train = train_x[:,5]
y_train = t...]]></description><category></category></item><item><title><![CDATA[TensorFlow学习记录（四）---TensorFlow自动求导机制]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121790407</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121790407</guid><author>mabaiteng</author><pubDate>Wed, 08 Dec 2021 14:26:23 +0800</pubDate><description><![CDATA[一元函数


import tensorflow as tf
x = tf.Variable(3.)
with tf.GradientTape(persistent=True) as tape:
    y = tf.square(x)
    z = tf.pow(x,3)
dy_dx = tape.gradient(y,x)
dz_dx = tape.gradient(z,x)
print(y)
print(dy_dx)
print(z)
print(dz_dx)
del tape #使用完之后手动释放]]></description><category></category></item><item><title><![CDATA[TensorFlow学习记录（四）---梯度下降法之多元线性回归]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121790311</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121790311</guid><author>mabaiteng</author><pubDate>Wed, 08 Dec 2021 14:23:29 +0800</pubDate><description><![CDATA[import numpy as np
import matplotlib.pyplot as plt
area = np.array([137.97,104.50,100.00,124.32,79.20,99.00,124.00,114.00,106.69,138.05,53.75,46.91,
              68.00,63.02,81.26,86.21])
price = np.array([145.00,110.00,93.00,116.00,65.32,104.0...]]></description><category></category></item><item><title><![CDATA[TensorFlow学习记录（三）---梯度下降法之一元线性回归]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121766318</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121766318</guid><author>mabaiteng</author><pubDate>Tue, 07 Dec 2021 12:35:48 +0800</pubDate><description><![CDATA[import numpy as np
import matplotlib.pyplot as plt
x = np.array([137.97,104.50,100.00,124.32,79.20,99.00,124.00,114.00,106.69,138.05,53.75,46.91,
              68.00,63.02,81.26,86.21])
y = np.array([145.00,110.00,93.00,116.00,65....]]></description><category></category></item><item><title><![CDATA[TensorFlow学习记录（二）---回归]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121766285</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121766285</guid><author>mabaiteng</author><pubDate>Tue, 07 Dec 2021 12:29:56 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[TensorFlow学习记录（一）---张量]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121766270</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121766270</guid><author>mabaiteng</author><pubDate>Tue, 07 Dec 2021 12:28:41 +0800</pubDate><description><![CDATA[import tensorflow as tf
import numpy as np
na = np.arange(12).reshape(3,4)
ta= tf.convert_to_tensor(na)
print(type(na))
print(type(ta))



import tensorflow as tf
import numpy as np
a= tf.constant(np.arange(12).reshape(3,4))
print(a)
b=tf.split(a,[2,...]]></description><category></category></item><item><title><![CDATA[MySQL学习记录（五）--分组查询]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121740615</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121740615</guid><author>mabaiteng</author><pubDate>Mon, 06 Dec 2021 09:52:51 +0800</pubDate><description><![CDATA[#进阶5：分组查询
 /*
 语法： select 分组函数，列（要求出现在group by后）
	from 表
	【where 筛选条件】
	group by 分组的列表
	【order by 子句】
注意：
	查询列表和group by后要相同
 
特点:筛选条件可以分为两类：
		 数据源			位置			关键字
	分组前： 原始表			group by 子句前		where
	分组后 ：分组后的数据表		group by 子句后		having
	
	支持单字段分组和多字段分组（逗号隔开），表达式..]]></description><category></category></item><item><title><![CDATA[MySQL学习记录（四）--常见函数]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121740584</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121740584</guid><author>mabaiteng</author><pubDate>Mon, 06 Dec 2021 09:51:20 +0800</pubDate><description><![CDATA[#进阶4：常见函数
/*
关注函数名和函数功能（叫什么、干什么）
分类
1.单行函数
	如concant、length、ifnull
	①字符函数 length concat substr  instr upper  trimlower lpad rpad replace 
	②数学函数 round ceil floor truncate mod 
	③日期函数 now curdate curtime year month day mintue str_to_date date_format
	④其他函数.]]></description><category></category></item><item><title><![CDATA[MySQL学习记录（三）--排序查询]]></title><link>https://blog.youkuaiyun.com/mabaiteng/article/details/121718877</link><guid>https://blog.youkuaiyun.com/mabaiteng/article/details/121718877</guid><author>mabaiteng</author><pubDate>Sat, 04 Dec 2021 17:28:13 +0800</pubDate><description><![CDATA[#进阶3：排序查询
/*
引入：
	seclet *from employees;
语法：
	select 查询列表
	from 表
	where 筛选条件
	order by 排序列表 asc（升序）|desc(降序)
	1.不写默认升序
	2.支持多字段排序、表达式、别名
	3.一般放查询语句最后，limit除外。

*/
#案例1：查询员工信息，工资从高到低排序
SELECT *FROM `employees` ORDER BY`salary` DESC;


#案例2：查询部门编号大于90 的员工.]]></description><category></category></item></channel></rss>