Shulou(Shulou.com)05/31 Report--

Mysql in the ON clause and USING clause how to use, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

Mysql ON clause and USING clause

In the concatenated SQL statement in Mysql, the syntax format of the ON clause is: table1.column_name = table2.column_name.

When the schema design uses the same naming style for the columns of the join table, you can use the USING syntax to simplify the ON syntax in the format: USING (column_name).

For example:

[sql]

SELECT f.color, c.is_primary, c.is_dark, c.is_rainbow

FROM flags f www.2cto.com

INNER JOIN color c ON f.color = c.color

WHERE f.country = 'China'

Equivalent to

[sql]

SELECT f.color, c.is_primary, c.is_dark, c.is_rainbow

FROM flags f

INNER JOIN color c USING (color)

WHERE f.country = 'China'

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.