[Err] 1292 -Truncated incorrect DOUBLE value:

Question

DELETE oat
FROM
oauth_access_token oat,
(
SELECT
t2.mobile,
t2.username
FROM
store t1
LEFT JOIN store_owner t2 ON t1.storeOwnerId = t2.id
WHERE
t1.id = '10000272'
) t3
WHERE
oat.user_name = t3.mobile
OR oat.user_name = t3.username;

执行sql删除操作，报错 [Err] 1292 - Truncated incorrect DOUBLE value: 'XXX’

网上搜很多出现这种问题的都是update语句 and改成“,”; DELETE 语句出现这种错误怎么解决

Answer 1

t3.user_name = concat(t2.mobile, '') 就能解决了