MySQL中的USING

USING等价于join on中的on,联合查询时会用到

例如:

select a.id,b.name from table_a a join table_b b on a.id = b.id

等价于:

select a.id,b.name from table_a a join table_b b USING(id)

点赞
  1. Pokerdomded说道:

    Warning: Undefined variable $uapic in /www/wwwroot/www.murongx.cn/wp-content/themes/kratos-pjax-master/inc/ua.php on line 424
    Google Chrome Windows 10
    https://t.me/officials_pokerdom/3744
  2. HighRollerMage说道:

    Warning: Undefined variable $uapic in /www/wwwroot/www.murongx.cn/wp-content/themes/kratos-pjax-master/inc/ua.php on line 424
    Google Chrome Windows 10
    https://t.me/s/dragon_money_mani

发表回复

电子邮件地址不会被公开。必填项已用 * 标注