UPDATE `oceansne_website08`.`oc_gallery_image_description` ogi
LEFT Join `gallery_image_to_album` gi ON gi.image_id = ogi.gallery_image_id
SET
`gallery_album_id` = gi.album_id
WHERE ogi.gallery_album_id =0;
SELECT * FROM mydb.MyVeryLongTableNameThatIFindTediousToWrite
INNER JOIN myotherdb.MyEvenLongerAndMoreTediousTableWithAnEvenLongerName
ON mydb.MyVeryLongTableNameThatIFindTediousToWrite.id = myotherdb.MyEvenLongerAndMoreTediousTableWithAnEvenLongerName.otherId
WHERE myotherdb.MyEvenLongerAndMoreTediousTableWithAnEvenLongerName.value > 100
为了使其更易读,可以使用别名,以便将相同的选择写入:
SELECT * FROM mydb.MyVeryLongTableNameThatIFindTediousToWrite tbla
INNER JOIN myotherdb.MyEvenLongerAndMoreTediousTableWithAnEvenLongerName tblb
ON tbla.id = tblb.otherId
WHERE tblb.value > 100
在一些sql风格中,您需要编写 mydb.MyVeryLongTableNameThatIFindTediousToWrite AS tbla 相反,但这个答案有点离题
UPDATE `oceansne_website08`.`oc_gallery_image_description` ogi
LEFT JOIN `gallery_image_to_album` gi
ON gi.image_id = ogi.gallery_image_id
SET `gallery_album_id` = gi.album_id
WHERE ogi.gallery_album_id =0
2条答案
按热度按时间dhxwm5r41#
假设你有一张table叫
MyVeryLongTableNameThatIFindTediousToWrite
你想加入吗MyEvenLongerAndMoreTediousTableWithAnEvenLongerName
你可以写:为了使其更易读,可以使用别名,以便将相同的选择写入:
在一些sql风格中,您需要编写
mydb.MyVeryLongTableNameThatIFindTediousToWrite AS tbla
相反,但这个答案有点离题kyxcudwk2#
它是一个别名;引用示例中的表的缩写形式。
这里ogi指的是表-->
oceansne_website08
.oc_gallery_image_description
gi指的是表格-->gallery_image_to_album