A brief discussion on the usage of using in mysql database

The usage of using in mysql is:

using() an join query for two tables that requires the columns specified by using() to exist in both tables and USES the conditions used for join.

Example:

  select a.*, b.* from a left join b using(colA);

Is equal to:

  select a.*, b.* from a left join b on a.colA = b.colA;

Above is the content of this article, I hope you enjoy.