Sql Запрос Видает Ошибку

[enermax7864 205]

UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='729';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='730';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='731';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='732';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='947';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='948';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='949';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='950';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='951';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='952';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='953';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='954';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='955';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='956';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='957';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='958';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='959';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='960';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='961';
UPDATE `etcitem` SET `consume_type`='stackable' WHERE `itemId`='962';

 

Видает ошибку

 

1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'
1054 - Unknown column 'itemId' in 'where clause'

Подскажите что нетак и как исправить

Изменено 2 сентября, 2012 пользователем enermax7864

[SmokiMo 892]

Он говорит что нет колонки itemId

[enermax7864 205]

так она есть)

[whаtеvеr 24]

Автоматическое сообщение

 

 

Эта тема была перемещена из "Общение на любую тему" в "Форум для новичков".

[Invizible 352]

Неизвестные "itemid" в колонке, где "where clause"

 

Дословный)

Изменено 2 сентября, 2012 пользователем Invizible

[enermax7864 205]

как исправить?

[enermax7864 205]

Ошибку решил) Нада било пробелчики повпихать они решают)

 

UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '729';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '730';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '731';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '732';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '947';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '948';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '949';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '950';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '951';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '952';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '953';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '954';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '955';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '956';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '957';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '958';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '959';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '960';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '961';
UPDATE `etcitem` SET `consume_type` = 'stackable' WHERE `item_id` = '962';