执行insert语句的时候不知道为什么会有这个错,原来是我在where条件后面 一个String类型的我没有给 单引号 ’ ’
INSERT INTO XXX(id,pid,p1)
SELECT UUID_SHORT() as id,id as pid,p1
FROM prjestablish WHERE p1 != '0'
不是这样
INSERT INTO XXX(id,pid,p1)
SELECT UUID_SHORT() as id,id as pid,p1
FROM prjestablish WHERE p1 != 0
记录一下这个忽略了基础知识的错误