mysql视图可以更新设置_MySQL视图篇，更新视图

创建用户信息表

DROP TABLE IF EXISTS `t_user_info`;

CREATE TABLE `t_user_info` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`uid` int(11) DEFAULT NULL,

`age` varchar(20) DEFAULT NULL,

`sex` varchar(20) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

插入演示信息数据

INSERT INTO `t_user_info` VALUES ('1', '1', '11', '男');

INSERT INTO `t_user_info` VALUES ('2', '2', '12', '女');

INSERT INTO `t_user_info` VALUES ('3', '3', '13', '男');

INSERT INTO `t_user_info` VALUES ('4', '4', '14', '女');

INSERT INTO `t_user_info` VALUES ('5', '5', '15', '男');

INSERT INTO `t_user_info` VALUES ('6', '6', '16', '女');

INSERT INTO `t_user_info` VALUES ('7', '7', '17', '男');

INSERT INTO `t_user_info` VALUES ('8', '8', '18', '女');

INSERT INTO `t_user_info` VALUES ('9', '9', '19', '男');

INSERT INTO `t_user_info` VALUES ('10', '10', '20', '女');