MySQLの使い方

select * from 表1 inner join 表2 on 表1.相同的列=表2.相同的列;

select 表1的列 from 表1 inner join 表2 on 表1.相同的列=表2 .相同的列

select * from 表1 inner join 表2 using(相同的列);

SELECT * FROM type,article where type.id=article.type_id;

CREATE TABLE `type` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '类型编号',
  `type_name` varchar(255) DEFAULT '' COMMENT '文章类型名称',
  `order_num` int(11) NOT NULL DEFAULT '0',
  `icon` varchar(255) DEFAULT '' COMMENT '自定义图标',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='文章类型表';

INSERT INTO `demo`.`type` (`id`, `type_name`, `order_num`, `icon`) VALUES ('1', '前端教程', '1', 'iconclass-9');
INSERT INTO `demo`.`type` (`id`, `type_name`, `order_num`, `icon`) VALUES ('2', '前端工具', '2', 'icontoolset');
INSERT INTO `demo`.`type` (`id`, `type_name`, `order_num`, `icon`) VALUES ('3', '随笔', '9', 'iconnote');