是否可以向一行添加插入查询?当我将查询作为两个运行时,它们都添加到不同的行。
$query1 = "INSERT INTO `mysaved` (`Username`) VALUES ('bob123')";
$query2 = "INSERT INTO `mysaved` (`Name`, `Image`)
SELECT *
FROM sport b
JOIN sport a
on a.Tag = b.Name
where a.SportID <> b.sportID and a.Name = 'Football'"
您可以将值放入select
.
INSERT INTO mysaved (Name, Image, Username)
SELECT name, image, 'bob123'
FROM sport b
JOIN sport a
on a.Tag = b.Name
where a.SportID <> b.sportID
and a.Name = 'Football'
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句