select高级——内连接

1.显示内连接

内连接是返回连接表中符合连接条件记录的连接查询

SQL

select  newsTitle , topicName
from  news as n 
inner join topic as t 
on n.topicId = t.topicId

结构

2.隐式内连接

SQL

select newsTitle , topicName
from news as n , topic as t 
where n.topicId = t.topicId

结构

表结构

表代码

/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.0.102
 Source Server Type    : MySQL
 Source Server Version : 50720
 Source Host           : 192.168.0.102
 Source Database       : test_select

 Target Server Type    : MySQL
 Target Server Version : 50720
 File Encoding         : utf-8

 Date: 09/23/2021 08:36:24 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `comment`
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `cmtId` int(4) NOT NULL AUTO_INCREMENT,
  `newsId` int(4) NOT NULL,
  `cmtContent` varchar(100) NOT NULL,
  `cmtDate` datetime NOT NULL,
  `cmtIP` varchar(20) NOT NULL,
  `cmtAuthor` varchar(20) DEFAULT