-
Join操作类型--内连接（inner join）查看全部
-
5种Join类型查看全部
-
举列用数据表查看全部
-
Join操作的类型--Left Out Join查看全部
-
不错呀查看全部
-
sql inner join demo查看全部
-
先关闭记笔记页再打开发查看全部
-
DROP TABLE IF EXISTS `user_kills`; CREATE TABLE `user_kills` ( `id` int(2) NOT NULL, `user_id` int(2) NOT NULL, `timestr` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `kills` int(2) DEFAULT NULL, PRIMARY KEY (`id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `user_kills` VALUES ('1', '2', '2013-01-10 00:00:00', '10'); INSERT INTO `user_kills` VALUES ('2', '2', '2012-02-01 00:00:00', '2'); INSERT INTO `user_kills` VALUES ('3', '2', '2012-02-05 00:00:00', '12'); INSERT INTO `user_kills` VALUES ('4', '4', '2013-01-10 00:00:00', '3'); INSERT INTO `user_kills` VALUES ('5', '2', '2013-02-11 00:00:00', '5'); INSERT INTO `user_kills` VALUES ('6', '2', '2013-02-06 00:00:00', '1'); INSERT INTO `user_kills` VALUES ('7', '3', '2013-01-11 00:00:00', '20'); INSERT INTO `user_kills` VALUES ('8', '2', '2013-02-12 00:00:00', '10'); INSERT INTO `user_kills` VALUES ('9', '2', '2013-01-07 00:00:00', '17');查看全部
-
-- ---------------------------- -- Table structure for user2 -- ---------------------------- DROP TABLE IF EXISTS `user2`; CREATE TABLE `user2` ( `id` int(11) NOT NULL, `user_name` varchar(3) CHARACTER SET utf8 DEFAULT NULL, `over` varchar(5) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of user2 -- ---------------------------- INSERT INTO `user2` VALUES ('1', '孙悟空', '成佛'); INSERT INTO `user2` VALUES ('2', '牛魔王', '被降伏'); INSERT INTO `user2` VALUES ('3', '蛟魔王', '被降伏'); INSERT INTO `user2` VALUES ('4', '鹏魔王', '被降伏'); INSERT INTO `user2` VALUES ('5', '狮驼王', '被降伏');查看全部
-
-- ---------------------------- -- Table structure for user1 -- ---------------------------- DROP TABLE IF EXISTS `user1`; CREATE TABLE `user1` ( `id` int(11) NOT NULL, `user_name` varchar(3) CHARACTER SET utf8 DEFAULT NULL, `over` varchar(5) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of user1 -- ---------------------------- INSERT INTO `user1` VALUES ('1', '唐僧', '旃檀功德佛'); INSERT INTO `user1` VALUES ('2', '孙悟空', '斗战胜佛'); INSERT INTO `user1` VALUES ('3', '猪八戒', '净坛使者'); INSERT INTO `user1` VALUES ('4', '沙僧', '金身罗汉');查看全部
-
查看笔记查看全部
-
update user1 set over=‘齐天大圣’ where user1.user_name in ( select b.user_name from user1 a join user2 b on a.user_name = b.user_name); ERROR 1093错误 不能更新from语句中出现的表字段 解决办法: 通过使用join进行联合更新 update user1 a join select b.user_name from user1 a join user2 b on a.user_name = b.user_name) b on a.user_name = b.user_name set a.over=‘齐天大圣’;查看全部
-
Join的连接类型查看全部
-
开始学习查看全部
-
开始学习了查看全部
举报
0/150
提交
取消