ZHANG y_-CSDN博客

(null, "四件套", "https://www.baidu.com/1.png", 4, 0, 17, 0, 2, now(), now(), null),(null, "炸鸡", "https://www.baidu.com/1.png", 4, 0, 16, 0, 3, now(), now(), null),(null, "可乐", "https://www.baidu.com/1.png", 4, 0, 10, 0, 4, now(), now(), null),

2023-05-31 14:17:30 41 1

原创 MySQL第十三周

shop_goods_label_price_id int unsigned not null comment '商品标签价格表ID',shop_goods_label_type_id int unsigned not null comment '分类ID',goods_label_type_name varchar(50) not null comment '商品标签分类',shop_goods_type_name varchar(50) not null comment '分类名字',

2023-05-25 16:44:43 28 1

原创 MySQL第十二周

2 | 药学院 | 3 | 2 | 3 | 3 | 药学 || 2 | 药学院 | 3 | 2 | 3 | 3 | 药学 |

2023-05-18 17:32:54 35

原创第十一周MySQL

sql = "insert into student values (1, '甜甜'),(2, '笨笨')"# 2. 获取指针游标。# 3. 准备SQL语句。# 4. 执行SQL语句。# 2. 获取指针游标。# 3. 准备SQL语句。# 4. 执行SQL语句。# 2. 获取指针游标。# 3. 准备SQL语句。# 4. 执行SQL语句。# 2. 获取指针游标。# 3. 准备SQL语句。# 4. 执行SQL语句。# 3. 准备SQL语句。# 4. 执行SQL语句。# 3. 准备SQL语句。

2023-05-11 16:08:18 53

原创 MySQL第十周

(1, "OPPO K10x 极光 8GB+128GB 67W超级闪充 5000mAh长续航 120Hz高帧屏 6400"),(2, "OPPO A36 6GB+128GB 晴川蓝高通骁龙680 5000mAh长续航 90Hz炫彩屏"),经常用与条件查询的字段、字段值取值范围要广(不重复的值比较多)- `like "%字符串%"` 匹配包含指定字符的。- `like "字符串%"` 匹配指定字符开头的。- `like "%字符串"` 匹配指定字符结尾。`show indexes from 表名`

2023-05-04 17:02:35 42

原创 MySQL第九周

student_id int unsigned not null auto_increment unique comment "学生ID",| 1 | 姥爷 | 100 || 2 | 七七 | 60 || 5 | 散兵 | 0 || 5 | 散兵 | 0 |

2023-04-27 15:37:59 46

原创 MySQL第八周

student_sex char(2) default '保密' comment '学生性别'student_sex char(2) default '保密' comment '学生性别'student_sex char(2) default '保密' comment '学生性别'student_sex char(2) default '保密' comment '学生性别'insert into student04 values (null, '甜甜', '女');

2023-04-20 15:23:34 27 1

原创第七周 MySQL

insert into student values('122613201026', '小笨笨', '2005-11-14', '保密');insert into student values('122613201026', '小笨笨', '2005-11-14', 'nv');('122613201026', '小呆呆', '2003-11-17', '男'),('122613201027', '小酷酷', '2005-1-4', '女');ALTER TABLE 表名 ADD 字段信息 FIRST;

2023-04-13 15:50:17 56 1

原创第六周 mysql

insert into student (student_name,student_id, student_age) values( '小甜甜', 1, 18);insert into student (student_id, student_name, student_age) values(1, '小甜甜', 18);insert into student (student_id, student_name, student_age) values(2, '小萍萍', 18);

2023-04-06 16:00:04 44 1

ZHANG_____LE的博客

原创 MySQL第十五周

原创 MySQL第十四周