mysql基础_视图

create view library2_view as select * from library2;

drop view library2_view;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for library
-- ----------------------------
DROP TABLE IF EXISTS `library`;
CREATE TABLE `library`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `description` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of library
-- ----------------------------
INSERT INTO `library` VALUES (1, '南图', '啊啊啊啊');
INSERT INTO `library` VALUES (2, '北图', '啊啊啊啊');
INSERT INTO `library` VALUES (3, '教师之家', '啊啊啊啊');
INSERT INTO `library` VALUES (4, '什么', '什么鬼');
INSERT INTO `library` VALUES (5, '什么', '什么鬼');
INSERT INTO `library` VALUES (6, '什么', '什么鬼');

SET FOREIGN_KEY_CHECKS = 1;

set character_set_results=GBK;

create view library_view as select * from library;

select * from library_view;

insert into library_view(id,name,description) values(7,'你是','你是谁');

 set names gbk;

 update library_view set description = '你' where name = '什么';

delete from library_view;