database/llg_SQLQuery1.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

use myshopping 
go 
select * from users
select * from admin
select * from tosend 
select * from functional
select * from grants
select * from goodsType
select * from supplier
insert into supplier(S_Name, S_Address, S_TelName, S_TelPhone)
select '株洲南大门批发市场','株洲芦松区','谭斌','13812345678' union
select '杭洲市批发市场','杭洲市','张三','13812345678' union
select '北京市批发市场','北京市','李四','13812345678'  
select * from shelves
insert into shelves(s_name)
select 'A' union 
select 'B' union 
select 'C' 
SELECT * from goodstype
update goodsType set g_typename='男士外套' where g_id=3

insert into goods(G_typeID, G_Name, G_oldPrice, G_newPrice, G_imgAddress, G_supplierID, G_shelvesID, G_onTime, G_count, G_display, G_summary, G_details)
select 2,'羊绒毛织大衣',160,135,'2.jpg',1,1,getDate(),50,1,'暂无详情介绍','暂无详细信息'

SELECT * FROM STOCK
INSERT INTO STOCK(S_gid, S_count, S_date, S_opMan, S_opMoney)
SELECT 1,10,GETDATE(),'刘落根',1260

SELECT * FROM CONSUME
INSERT INTO CONSUME(C_codeID, C_UID, C_GID, C_count, C_sumPrice, c_Date, C_state)
SELECT '20100102180621',1,1,2,252,getdate(),0 union
SELECT '20100102180621',1,2,3,405,getdate(),0 

SELECT * FROM GOODSASSESS
INSERT INTO GOODSASSESS(G_GoodsID, G_content, G_userId, G_Date, G_display)
SELECT 1,'这件商品很不错',1,getdate(),0

-- 插入数据
 select * from users --用户
 insert into users(U_uName, U_uPass, U_Name, U_sex, U_Type, U_score, U_birthday, U_phone, U_email, U_isLock)
 select 'yjy','123456','袁瑾瑜','男',0,0,'1988-05-26','15573305937','ttttt@126.com',0 union
select 'wjj','123456','武建军','男',0,0,'1988-05-26','15573305937','tasdftt@126.com',0

insert into goodstype(g_typeName) --商品类型
select '男士休闲' union
select '毛绒鞋' union
select '平鞋'


select * from goods
alter table goods
delete column  keywords varchar(50)
--添加商品
insert into goods(G_id,G_typeID, G_Name, G_oldPrice, G_newPrice, G_imgAddress, G_supplierID, G_shelvesID, G_onTime, G_count, G_display, G_details)
select * from tosend
insert into tosend(T_Uid, T_Name, T_address, T_post, T_phone, T_email, T_sentType, T_payType, T_remarks)
			select 1,'刘落根','湖南省株洲市','412103','1381234567','ait_work@126.com',1,1,'无'

select * from tosend
delete tosend