sql语句 异常 Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your

在我们开发的工程中，有时候会报
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ------
这种异常 不用多想，肯定是我们的sql语句出现问题，下面我只说我经常犯的一种错误。当然还有很多种错误，我们遇到再说。

这时候 我们不难发现 错误的原因是我们这里多了一个 ，号

有时候也会出现这种错误 [Err] 1054 - Unknown column ‘----------’ in 'field list’

这时候是我们的字段写错了 我们会发现数据库中并没有这个字段 而是我们的字段写错了

下面为大家写上两个同级sql

select a.Attribute_Id as Attribute_Id,          a.Attribute_Name as Attribute_Name,      a.Attribute_Alias as Attribute_Alias,a.Attribute_Unit as Attribute_Unit,a.DeviceType_Id as DeviceType_Id,a.SortCode as SortCode,a.UpdateTime as UpdateTime,   a.isdel as isDelfrom  zz_deviceattribute as a
where   Attribute_Id in(
select Attribute_Id from ZZ_DeviceAttributeRelation
where Device_Id =  '05871a37-a242-40f9-bbea-33bdea7009d5')

 select distinct a.Attribute_Id as Attribute_Id,a.Attribute_Name as Attribute_Name,a.Attribute_Alias as Attribute_Alias,a.Attribute_Unit as Attribute_Unit,a.DeviceType_Id as DeviceType_Id,a.SortCode as SortCode,a.UpdateTime as UpdateTime,   a.isdel as isDel        from ZZ_DeviceAttributeRelation  as binner join zz_deviceattribute as a on a.Attribute_Id = b.Attribute_Idwhere b.Device_Id =  '05871a37-a242-40f9-bbea-33bdea7009d5'and a.isDel ='0'order by a.SortCode

欢迎大家加入技术群聊