MYSQL JOIN连接的类型探讨

最新推荐文章于 2024-06-26 18:31:47 发布

agent_3650

最新推荐文章于 2024-06-26 18:31:47 发布

阅读量674

点赞数

分类专栏： PHP干货

本文链接：https://blog.csdn.net/p295848108/article/details/82530894

版权

PHP干货专栏收录该内容

2 篇文章 0 订阅

订阅专栏

1. 准备数据

执行脚本添加测试数据

//创建数据表
CREATE TABLE `user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(45) CHARACTER SET latin1 DEFAULT NULL COMMENT '用户名',
  `phone` varchar(45) CHARACTER SET latin1 DEFAULT NULL COMMENT '电话',
  `email` varchar(45) CHARACTER SET latin1 DEFAULT NULL COMMENT '邮箱',
  `reg_time` int(10) unsigned NOT NULL COMMENT '注册时间',
  `last_time` int(10) unsigned NOT NULL COMMENT '上次登录时间',
  `state` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '用户状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=gbk;
CREATE TABLE `user_post` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL,
  `title` varchar(45) CHARACTER SET latin1 DEFAULT NULL,
  `content` text CHARACTER SET latin1,
  `time` int(10) unsigned NOT NULL,
  `state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=gbk;
//导入测试数据
INSERT INTO `user` VALUES (1,'zhangshan','13623561234','zhangshan@qq.com',1536313909,1536313909,0),(2,'lisi','13612345678','lisi@qq.com',1536313969,1536313969,0),(3,'wangwu','13688888888','wangwu@qq.com',1536314005,1536314005,0),(4,'tom','13256897894','tom@qq.com',1536314050,1536314050,0),(5,'john','15566666666','john@qq.com',1536314086,1536314086,0);
INSERT INTO `user_post` VALUES (1,1,'ONE','This is test 1 by 1',1536378534,0),(2,1,'TWO','This is test 2 by 1',1536378534,0),(3,3,'ONE','This is test 1 by 3',1536378610,0),(4,5,'ONE','This is test 1 by 5',1536378633,0),(5,7,'ONE','This ia test 1 by 7',1536378657,0),(6,8,'ONE','this is test 1 by 8',1536378679,0);