Error "This type of clause was previously parsed. (near "UPDATE" at position 55) "

0
Hello, I'm updating some information from a database, in which I have to update several, using:

UPDATE item SET item_mapa = '2' WHERE item_id = '263'
UPDATE item SET item_mapa = '2' WHERE item_id = '264'
UPDATE item SET item_mapa = '2' WHERE item_id = '265'
UPDATE item SET item_mapa = '2' WHERE item_id = '266'
UPDATE item SET item_mapa = '2' WHERE item_id = '267'

What happens is the following error:

  

Static analysis error:

     

4 errors were found during analysis.

     

This type of clause was previously parsed. (near "UPDATE" at position   55) This type of clause was previously parsed. (near "UPDATE" at   position 110) This type of clause was previously parsed. near   "UPDATE" at position 165) This type of clause was previously parsed.   (near "UPDATE" at position 220) SQL command:

     

UPDATE item SET item_mapa = '2' WHERE item_id = '263' UPDATE item SET   item_mapa = '2' WHERE item_id = '264' UPDATE item SET item_mapa = '2'   WHERE item_id = '265' UPDATE item SET item_mapa = '2' WHERE item_id =   '266' UPDATE item SET item_mapa = '2' WHERE item_id = '267'

MySQL Messages: Documentation

  

# 1064 - You have a syntax error in your SQL next to 'UPDATE item SET item_mapa =' 2 'WHERE item_id =' 264 'UPDATE item SET item_mapa'   on line 2

in php myadmin.

What can I do to update several bank lines?

    
asked by anonymous 28.08.2017 / 15:55

1 answer

0

Separate commands by semicolons (;)

    
28.08.2017 / 16:01