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说道:
    Google Chrome Windows 10
    https://t.me/officials_pokerdom/3744
  2. HighRollerMage说道:
    Google Chrome Windows 10
    https://t.me/s/dragon_money_mani

发表回复

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