MySQL与CONCAT错误1548重复 - 无法从mysql.proc加载。表可能已损坏 [英] MySQL duplicates with CONCAT error 1548 - Cannot load from mysql.proc. The table is probably corrupted

问题描述

我有这个查询，将firstname与姓氏连接，然后找到重复的内容：

i have this query witch concatenates firstname with last name and then find the duplicates:

SELECT import.*, import.CONCAT(nume,' ',prenume) full2 
FROM import 
INNER JOIN (SELECT CONCAT(nume,' ',prenume) full,COUNT(*) 
            FROM import 
            WHERE users_id=1 
            GROUP BY full 
            HAVING COUNT(*)>1) as t2 ON import.full2 = t2.full 
WHERE users_id=1

我认为sql语法是正确的，但我收到错误：1548 - 无法从mysql.proc加载。该表可能已损坏

i think the sql syntax is correct but i get the error: 1548 - Cannot load from mysql.proc. The table is probably corrupted

5.1.59 mysql版本是否有问题？

is there any problem with the 5.1.59 mysql version?

推荐答案

检查所有数据库中与当前版本的MySQL服务器不兼容的所有表：

Examines all tables in all databases for incompatibilities with the current version of MySQL Server:

mysql_upgrade -uroot -p

http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html

这篇关于MySQL与CONCAT错误1548重复 - 无法从mysql.proc加载。表可能已损坏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！