错误代码: 1242 Subquery returns more than 1 row 1. 错误描述 1 queries executed, 0 success, 1 errors, 0 warnings 查询:SELECTt.id, DATE_FORMAT( t.statisTime,'%Y-%m-%d %H:%i:%s') statisTime, (SELECT`id`FROMt_truck_infoWHEREid = t.plateId... 错误代码:1242Subquery returns more than...
一切似乎都很顺利,突然之间,我的前端出现了这个错误: 致命错误:带有消息'SQLSTATE21000:基数违反: 1242子查询返回/var/www/html/system/ more .var: 78在Workbench下,我前面创建的每个视图都提供了以下错误:Mysql Error code: 1242 Subquery returns more than 1 row. 浏览3提问于2016-04-07得票数 0 回答已采...
1. 错误描述 1 queries executed, 0 success, 1 errors, 0 warnings 查询:SELECT t.id, DATE_FORMAT( t.statisTime, '%Y-%m-%d %H:%i:%s' ) statisTime, (SELECT `id` FROM t_truck_info WHERE id = t.plateId... 错误代码: 1242 Subquery returns more than 1 row 执行耗时 : 0.009 sec 传送...