我想用两个不同的值插入相同的记录。我有两个分离表Table-x
和Table-Y
。
Table-x
包含邮政编码,该邮政编码将多个,Table-y
包含其余列。
INSERT into Table-x (id,field1,field2,zip,field3) VALUES (NULL,val1,val2,<Tabley.zipcode>,val3)
我想执行上述语句untill Table-x
具有zip代码
您可以使用WHERE .... IS NOT NULL
:
INSERT into Table-x (id,field1,field2,zip,field3)
SELECT id, field1, field2, zip, field3 FROM Tabley
WHERE Tabley.zipcode IS NOT NULL
使用INSERT INTO...SELECT
INSERT INTO TableX (id, field1, field2, zip, field3)
SELECT NULL, @val1, @val2, zipcode, @val3
FROM TableY