-
Join操作類型--內連接（inner join）查看全部
-
5種Join類型查看全部
-
舉列用數(shù)據(jù)表查看全部
-
Join操作的類型--Left Out Join查看全部
-
不錯呀查看全部
-
sql inner join demo查看全部
-
先關閉記筆記頁再打開發(fā)查看全部
-
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', '孫悟空', '斗戰(zhàn)勝佛'); 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語句中出現(xiàn)的表字段 解決辦法: 通過使用join進行聯(lián)合更新 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
提交
取消