当前位置：网站首页>sql语句 异常 Err] 1064 – You have an error in your SQL syntax; check the manual that corresponds to your

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

2022-08-10 13:44:00 【全栈程序员站长】

大家好，又见面了，我是你们的朋友全栈君。

在我们开发的工程中，有时候会报 [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 isDel
			from  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 b
				inner join zz_deviceattribute as a 
				on a.Attribute_Id = b.Attribute_Id
				where b.Device_Id =  '05871a37-a242-40f9-bbea-33bdea7009d5'
				and a.isDel ='0'
				order by a.SortCode

发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/130032.html原文链接：https://javaforall.cn

原网站

版权声明
本文为[全栈程序员站长]所创，转载请带上原文链接，感谢
https://cloud.tencent.com/developer/article/2069546

边栏推荐

猜你喜欢

随机推荐