gpt4 book ai didi

mysql - 从导入 MysqlDump 创建 View 时出错

转载 作者:行者123 更新时间:2023-11-30 23:52:06 25 4
gpt4 key购买 nike

我不会说 SQL... 请任何人帮助我。这是什么意思?:

错误SQL查询:

/*!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 说:

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

这是什么意思?它在期待什么?我如何解决它?这个文件是mysqldump创建的,为什么我导入的时候会出错?

最佳答案

关于mysql - 从导入 MysqlDump 创建 View 时出错,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/2564076/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com