Q_Q281564748的博客

原创 9.13

著名端口 0-102380端口分配给HTTP服务linux端口2^16= 65536动态端口1024-65535程序关闭之后，会释放端口ip标记网络地址端口：程序用来收发网络数据的通道OSI模型 tcp模型 ...

原创 9.14

1.2 接口类型按照范围划分1.2.1 系统之间的接口系统之间的接口：多个内部系统之间的交互，内部系统和外部系统之间的交互1.2.2 程序内部的接口程序的内部接口：方法和方法之间，模块和模块之间1.3 接口测试1.3.1 定义对系统或者组件之间的接口进行测试，只要是检验数据的交换，传递和控制管理过程，以及相互逻辑依赖的关系1.3.2 接口测试的原理模拟客户端向服务端发送请求，服务器接收请求之后进行相应的业务处理，并且向客户端返回响应，检查响应受否符合预期。

原创 9.15

1.4 接口规范1.4.0 web应用模式前后端不分离前后端分离json ： [{'msg_code':10001,'msg':'请求成功'}]<红楼梦>作者：曹雪芹男主：贾宝玉女主：林黛玉时间：清代json {'author':'cao','boy':'jia','girl':'lin','time':'qing'}​xml<book><author>cao</author><boy&g.

原创 9.16

原创 9.18

原创 9.17

1 . create database xkw charset=utf8;2.CREATE TABLE employee(empid INT UNSIGNED PRIMARY KEY,NAME VARCHAR(100),gender TINYINT CHECK(gender=0 OR gender=1 OR gender=2),title VARCHAR(100),birthday Date,depid VARCHAR(100));CREATE TABLE dep

原创 9.19-9.21

6.SELECT *,base_salary+title_salary AS 应发工资,base_salary+title_salary-deduction AS 实发工资 FROM (department AS d INNER JOIN employee AS e ON d.`depid`=e.`depid`) INNER JOIN salary AS s ON e.`empid`=s.`empid`;7.SELECT * FROM employee WHERE employee.`NAME` LIK

原创 9.22

原创 9.10-9.12

-- 3可以INSERT INTO emp_v1 VALUES('Trump','19500.00','SDCASD');-- 4UPDATE emp_v1 SET salary ='19500.00' WHERE email='OTUVAULT' AND last_name='Tuvault';-- 5DELETE FROM emp_v1 WHERE last_name='XXX'；

原创 9.9

-- 2CREATE OR REPLACE VIEW emp_v1ASSELECT last_name,email,phone_numberFROM employeesWHERE phone_number LIKE '011%' AND email LIKE'%e%';

原创 9.7

-- 1CREATE VIEWemp_v1ASSELECT last_name,salary,emailFROM employeesWHERE employee_idIN (SELECTemployee_idFROM employees WHEREphone LIKE ‘011%’);

原创 9.6

-- 3SELECT AVG(salary) FROM employees GROUP BY department_id;SELECT employee_id, last_name, salary, e.`department_id`FROM employees AS eINNER JOIN (SELECT AVG(salary) AS ag, department_idFROM employeesGROUP BY department_id) AS ag_depON

原创 8.26

-- 创建数据库-- 查看数据库SHOW DATABASES;-- 使用数据库USE 数据库名字-- 查看当前使用的数据SELECT DATABASE();-- 查看当前时间SELECT NOW();SELECT TIME('2021-08-30 10:54:50');SELECT TIMESTAMP();SELECT YEAR("2021-08-30 10:54:50");SELECT MONTH("2021-08-30 10:54:50")

原创 8.27

-- 表级约束CREATE TABLE addresses(id INT UNSIGNED, addre VARCHAR(200),phone VARCHAR(11),re_name VARCHAR(20),user_id INT UNSIGNED,CONSTRAINT pk PRIMARY KEY(id), -- 主键CONSTRAINT nn NOT NULL(phone), -- 非空CONSTRAINT fk FOREIGN KEY(user_id)...

原创 8.30

USE newdb;-- 查询所有的字段SELECT * FROM userinfos;DESC tp_goods;-- 查询商品id以及对应的超市价格SELECT goods_id,market_price FROM tp_goods;SELECT goods_id AS 编号,market_price AS 价格 FROM tp_goods;SELECT goods_id 编号,market_price 价格 FROM tp_goods;-- 查询当前商品

原创 8.31

-- 统计出每个品牌的商品个数SELECT * FROM tp_goods GROUP BY brand_id;SELECT brand_id FROM tp_goods GROUP BY brand_id;SELECT brand_id,GROUP_CONCAT(goods_name,market_price) FROM tp_goods GROUP BY brand_id;-- 分组配合聚合函数SELECT brand_id,COUNT(*) FROM tp_goods GRO.

原创 9.2 子查询

/* 子查询主查询 主要查询的语句，第一条select查询子查询：在一个SELECT语句中，嵌入另一个SELECT语句主查询 子查询关系子查询可以充当主查询的条件子查询嵌入到主查询中子查询也是一条完整的SELECT语句,但是不需要加分号案例1：请找出华为对应的商品：*/SELECT * FROM tp_goods WHERE brand_id=(SELECT tp_brand.`id` FROM tp_brand WHERE tp_brand.`name`

原创 9.3 视图

/* 语法规则create view 视图名AS合法有效的SQL语句*/-- 视图封装 找出id 50-60之间的产品CREATE VIEW v1ASSELECT goods_id,goods_name FROM tp_goods WHERE tp_goods.`goods_id` BETWEEN 50 AND 60;-- 使用视图SELECT * FROM v1-- 存储过程INSERT INTO boys VALUES(9,'张三',0);..

原创 2021-09-01

1、SELECT NOW();2、SELECT employee_id,CONCAT(first_name,last_name),salary,salary*1.2AS ‘new salary’FROM employees;3、SELECT CONCAT(first_name,last_name),LENGTH(CONCAT(first_name,last_name)) FROM employees ORDER BY SUBSTR(CONCAT(first_name,last_name)..