如何写一个MySQL Insert Into语句与内连接?

Question

用户在这里添加信息:表单

信息被添加到shoes表中。

数据库:数据库

我想插入ShoeImage, ShoeName, ShoeStyle, ShoeColor, ShoePrice和ShoeDescr，而不是ShoeID(这是自动递增的)，ShoeBrandID和ShoeSizeID。

我的insert语句:

$sql = "INSERT INTO $tblShoes VALUES (NULL, '$ShoeImage', '$ShoeName', '$ShoeStyle', '$ShoeColor',
'$ShoePrice', '$ShoeDescr')";

如何写这个插入语句与内部连接?

Answer 1

Might works.

INSERT INTO shoes
(
'ShoeImage',
'ShoeName',
'ShoeStyle',
'ShoeColor',
'ShoePrice',
'ShoeDescr',
'ShoeBrandID',
'ShoeSizeID'
)
VALUES(
NULL,
'$ShoeImage',
'$ShoeName',
'$ShoeStyle',
'$ShoeColor',
'$ShoePrice',
'$ShoeDescr',
(SELECT BrandID FROM shoebrand WHERE BrandName = '$ShoeBrand'),
(SELECT SizeID FROM shoesize WHERE Size = '$ShoeSize')
)