花椒主播SQL数据导入资料信息

分类：传奇3G私服    ‌‍ 阅读：1335

2024-12-07 00:00

UPDATE [HuaJiao].[dbo].[结算]
SET [HuaJiao].[dbo].[结算].[主播真名] = [HuaJiao].[dbo].[花资料].[姓名]
from [HuaJiao].[dbo].[结算],[HuaJiao].[dbo].[花资料]
WHERE [HuaJiao].[dbo].[结算].[HID] = [HuaJiao].[dbo].[花资料].[id]


UPDATE [HuaJiao].[dbo].[结算]
SET [HuaJiao].[dbo].[结算].[手机] = [HuaJiao].[dbo].[花资料].[手机号]
from [HuaJiao].[dbo].[结算],[HuaJiao].[dbo].[花资料]
WHERE [HuaJiao].[dbo].[结算].[HID] = [HuaJiao].[dbo].[花资料].[id]


UPDATE [HuaJiao].[dbo].[结算]
SET [HuaJiao].[dbo].[结算].[一小时待遇] = [HuaJiao].[dbo].[花资料].[一小时待遇]
from [HuaJiao].[dbo].[结算],[HuaJiao].[dbo].[花资料]
WHERE [HuaJiao].[dbo].[结算].[HID] = [HuaJiao].[dbo].[花资料].[id]


UPDATE [HuaJiao].[dbo].[结算]
SET [HuaJiao].[dbo].[结算].[开户行] = [HuaJiao].[dbo].[花资料].[开户行]
from [HuaJiao].[dbo].[结算],[HuaJiao].[dbo].[花资料]
WHERE [HuaJiao].[dbo].[结算].[HID] = [HuaJiao].[dbo].[花资料].[id]


UPDATE [HuaJiao].[dbo].[结算]
SET [HuaJiao].[dbo].[结算].[银行卡号] = [HuaJiao].[dbo].[花资料].[银行卡号]
from [HuaJiao].[dbo].[结算],[HuaJiao].[dbo].[花资料]
WHERE [HuaJiao].[dbo].[结算].[HID] = [HuaJiao].[dbo].[花资料].[id]