Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Update the question so it focuses on one problem only by editing this post.

Closed 9 years ago.

Im trying to UPDATE queueStatusINT WHERE statusINT is 8 and queueStatusINT is NOT equal to 2 and type is $type. But I keep getting an error:

ERROR 1064 (42000) at line 1: 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 ‘ queueStatusINT!= 2’, type=’int   at line 1

Im using this SQL query to do the update:

UPDATE $mysqlTable SET queueStatusINT= 2’ WHERE statusINT= 8’, queueStatusINT!= 2’, type=‘$type’;

I have also noticed that I can do a NOT equal to in a SELECT command…

SELECT nameTXT FROM $mysqlTable WHERE queueStatusINT!= 2  ORDER BY queueStatusINT DESC, priorityINT DESC, id ASC LIMIT 7;

Answer 1

You need to use AND to combine your criteria, not just commas.

For example

UPDATE $mysqlTable 
SET    queueStatusINT =  2 
WHERE  statusINT      =   8 
AND    queueStatusINT !=  2 
AND    type           =   $type

Answer 2

Change your UPDATE to:

UPDATE $mysqlTable 
SET queueStatusINT= 2’ 
WHERE statusINT=8
AND queueStatusINT !=2 
AND type=‘$type’;

I assume queueStatusINT is an Integer (as the name suggests) - you should leave out the as they symbolize a string/character.

Best wishes, Fabian

友情链接