开发者

Error Creating View From Importing MysqlDump

开发者 https://www.devze.com 2022-12-25 04:16 出处:网络
I don\'t speak SQL... Please, anybody help me.What does this mean?: Error SQL query: /*!50001 CREATE ALGORITHM=UNDEFINED *//*!50001 VIEW `v_sr_videntity` AS select `t`.`c_id` AS `ID`,`User`.`c_id`

I don't speak SQL... Please, anybody help me. What does this mean?:

Error SQL query:

/*!50001 CREATE ALGORITHM=UNDEFINED *//*!50001 VIEW `v_sr_videntity` AS select `t`.`c_id` AS `ID`,`User`.`c_id` AS `UserID`,`videntityfingerprint`.`ID` AS `VIdentityFingerPrintID`,`videntityfingerprint`.`FingerPrintID` AS `FingerPrintID`,`videntityfingerprint`.`FingerPrintFingerPrint` AS `FingerPrintFingerPrint` from ((`t_SR_u_Identity` `t` join `t_SR_u_User` `User` on((`User`.`c_r_Identity` = `t`.`c_id`))) join `vi_sr_videntity_0` `VIdentityFingerPrint` on((`videntityfingerprint`.`c_r_Identity` = `t`.`c_id`))) */;

MySQL said:

#1054 - Unknown column 'videntityfingerprint.ID' in 'field list' 

What do开发者_如何学Ces this mean? What is it expecting? How do I fix it? This file was created by mysqldump, so why are there errors when I import it?


http://bugs.mysql.com/bug.php?id=1689

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号