用主键插入表 [英] insert into table with primary key

问题描述

嗨 我有一张桌子，我在其中填写了一些字段，因为
但是现在我想用主键填充该表的其他字段

我该怎么办?

感谢

解决方案

尝试一下.
更新您的表名" SET
表格字段" =您要添加的内容
WHERE [产品密钥字段"] =产品密钥"

例如

更新tblProduct设置
[产品名称] ="鞋盒"
其中[产品ID] = 1

假设您将产品ID设置为产品密钥，并且产品ID为1，则必须指定其中产品ID =产品密钥".

hi I have a table that I fill some fields of that,befor
BUT now I want fill another fields of that table with primary key

what do I do?

thanks

解决方案

Try this.
UPDATE "your table name" SET
"Table field" = "what you want to add
WHERE ["The product key field"] = "The product key"

e.g

UPDATE tblProduct SET
[Product Name] = ''Shoe box''
WHERE [Product ID] = 1

Say you set the Product ID as the product key, and the Product ID is 1 you have to specify "where Product ID = the product key".

这篇关于用主键插入表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！