[摘要]+-------------+----------------+-----------------+-----------------+3 rows in set (0.00 sec)mysql&g...
+-------------+----------------+-----------------+-----------------+
3 rows in set (0.00 sec)
mysql>
接下来我们就使用MySQL的JOIN来连接以上两张表来读取tutorials_tbl表中所有tutorial_author字段在tcount_tbl表对应的tutorial_count字段值:
mysql> SELECT a.tutorial_id, a.tutorial_author, b.tutorial_count -> FROM tutorials_tbl a, tcount_tbl b -> WHERE a.tutorial_author = b.tutorial_author;+-------------+-----------------+----------------+
关键词:Mysql Join的运用图文详细教程