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?