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_descriptiongi指的是表格-->gallery_image_to_album