#1248 - Every derived table must have its own alias - can´t find the reason

Question

I'm getting this error:

#1248 - Every derived table must have its own alias

the query is:

UPDATE rifa
SET maxRifas=(
              (SELECT maxRifas 
               FROM (SELECT * FROM rifa AS crifa)
               WHERE crifa.id=1)
              -1)
WHERE rifa.id=1;

help please.

Answer 1

Nested queries must be given an alias when used in a FROM.

UPDATE rifa 
SET maxRifas=
  (
      (SELECT maxRifas 
       FROM (SELECT * 
             FROM rifa
            ) as crifa 
       WHERE crifa.id=1
      )-1
   )     
WHERE rifa.id=1;

Answer 2

try this

 UPDATE rifa SET maxRifas= (SELECT (maxRifas - 1) from rifa WHERE id=1)  ;