my sql实验视图_mysql 创建视图 heidisql查看视图报错

exceptionmessage:正则表达式与ParseViewStructure()中视图代码不匹配：CREATEALGORITHM=UNDEFINEDDEFINER=`skip-grantsuser`@`skip-grantshost`SQLSECURITYDEFINERVIEW`v_userdragon...

exception message : 正则表达式与 ParseViewStructure() 中视图代码不匹配： CREATE ALGORITHM=UNDEFINED DEFINER=`skip-grants user`@`skip-grants host` SQL SECURITY DEFINER VIEW `v_userdragoninfo` AS select `p`.`accountid` AS `accountid`,`p`.`name` AS `name`,`d`.`id` AS `id`,`d`.`dragonid` AS `dragonid`,`d`.`userid` AS `userid`,`d`.`dragoncode` AS `dragoncode`,`d`.`geneid` AS `geneid`,`d`.`headid` AS `headid`,`d`.`state` AS `state`,`d`.`price` AS `price`,`d`.`algebra` AS `algebra`,`d`.`growRate` AS `growRate`,`d`.`birth` AS `birth`,`d`.`nuggets` AS `nuggets`,`d`.`attack` AS `attack`,`d`.`weight` AS `weight`,`d`.`birthnum` AS `birthnum`,`d`.`dragoninfo` AS `dragoninfo`,`d`.`birthcooltime` AS `birthcooltime`,`d`.`birthtime` AS `birthtime`,`d`.`feednum` AS `feednum`,`d`.`feedtime` AS `feedtime`,`d`.`shoptype` AS `shoptype`,`d`.`seasonreward` AS `seasonreward`,`d`.`daynuggetsnum` AS `daynuggetsnum`,`d`.`buytime` AS `buytime`,`d`.`activeid` AS `activeid`,`d`.`createdAt` AS `createdAt`,`d`.`updatedAt` AS `updatedAt` from (`m_dragon` `d` join `m_player` `p` on((`d`.`userid` = `p`.`id`))).

展开