How to use ON clause and USING clause in Mysql
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.
