110.(后端)商品管理数据的填充——sql添加数据

最新推荐文章于 2024-05-19 03:18:57 发布

想成为数据分析师的开发工程师

最新推荐文章于 2024-05-19 03:18:57 发布

阅读量141

点赞数

分类专栏：电子商城管理系统文章标签： mysql 数据库 flask sql 后端

本文链接：https://blog.csdn.net/m0_63953077/article/details/127638150

版权

电子商城管理系统专栏收录该内容

134 篇文章 22 订阅

订阅专栏

1.概述

上文已经使用flask-migrate建立好模型，这里就编写sql语句添加数据即可

2.代码展示

insert into t_goods (name,price,number,introduce,big_log,small_log,state,cid_one,cid_two,cid_three,weight,hot_number,is_promote) value ('SOULKISS 高冷气质硬核款 16姆米桑蚕真丝双绉显瘦挂脖露肩连衣裙',879.99,100,'chanpin','','',2,1,17,65,100,30,1);
insert into t_goods (name,price,number,introduce,big_log,small_log,state,cid_one,cid_two,cid_three,weight,hot_number,is_promote) value ('AmandaX定制重磅奢华真丝提花连肩袖小A连衣裙',879.99,100,'chanpin','','',2,1,17,65,100,30,1);
insert into t_goods (name,price,number,introduce,big_log,small_log,state,cid_one,cid_two,cid_three,weight,hot_number,is_promote) value ('AmandaX定制30姆米2色重缎可调节V领吊带连衣裙',1380,100,'chanpin','','',2,1,17,65,100,30,1);
insert into t_goods (name,price,number,introduce,big_log,small_log,state,cid_one,cid_two,cid_three,weight,hot_number,is_promote) value ('吊带连衣裙女2020夏季新款V领雪纺气质印花A字复古小碎花过膝长裙',359.00,100,'chanpin','','',2,1,17,65,100,30,1);
insert into t_goods (name,price,number,introduce,big_log,small_log,state,cid_one,cid_two,cid_three,weight,hot_number,is_promote) value ('4/17拍 ^_^ 小婷版 温柔小姐姐 白色小花收腰长款连衣裙（20夏）',1399.99,100,'chanpin','','',2,1,17,65,100,30,1);
insert into t_goods (name,price,number,introduce,big_log,small_log,state,cid_one,cid_two,cid_three,weight,hot_number,is_promote) value ('【思思法代】SANDRO 20春夏蕾丝镂空连衣裙女 SFPRO01010 R20568E',1386,100,'chanpin','','',2,1,17,65,100,30,1);