Перейти к содержанию
Авторизация  
System

Sql запрос

Рекомендуемые сообщения

не получаеться залить в базу sql запрос

 

DELETE FROM `droplist` WHERE `itemId` NOT IN (57,6662,6656,6660,6659,6658,6657,8191,6360,6361,6362,8627,8633,8723,8724,872
5,8726,8727,8728,8729,8730,8731,8732,8733,8734,8735,8736,8737,8738,8739,8740,874
1
,8742,8743,8744,8745,8746,8747,8748,8749,8750,8751,8752,8753,8754,8755,8756,8757
,
8758,8759,8760,8761,8762,959,955,951,947,729,960,956,952,948,730,6577,6575,6573,
6
571,6569,6578,6576,6574,6572,6570,8166,8165,8164,8163,8162,8161,8176,8169,8168,8
1
67,8175,8160,8159,8158,8172,8171,8170,1419,6665,6666,6667,6668,6669,6670,6671,66
7
2,6661);

 

Ето удаляет все из дропа кроме того что я оставил вписал ид свои

Ошибка

 

 Query 111 start
[ERR] 1064 - 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 '5,8726,8727,8728,8729,8730,8731,8732,8733,8734,8735,8736,8737,8738,8739,8740,874' at line 2
[ERR] DELETE FROM `droplist` WHERE `itemId` NOT IN (57,6662,6656,6660,6659,6658,6657,8191,6360,6361,6362,8627,8633,8723,8724,872
5,8726,8727,8728,8729,8730,8731,8732,8733,8734,8735,8736,8737,8738,8739,8740,874
1
,8742,8743,8744,8745,8746,8747,8748,8749,8750,8751,8752,8753,8754,8755,8756,8757
,
8758,8759,8760,8761,8762,959,955,951,947,729,960,956,952,948,730,6577,6575,6573,
6
571,6569,6578,6576,6574,6572,6570,8166,8165,8164,8163,8162,8161,8176,8169,8168,8
1
67,8175,8160,8159,8158,8172,8171,8170,1419,6665,6666,6667,6668,6669,6670,6671,66
7
2,6661);
[SQL] Finished with error

 

Знаю что структура не та вроде поменять не могу что не пробивал не получаеться   

 

Вот  мое кое что   

 

DELETE FROM droplist WHERE itemId='57';
DELETE FROM droplist WHERE itemId='6662';
DELETE FROM droplist WHERE itemId='6656';
DELETE FROM droplist WHERE itemId='6660';
DELETE FROM droplist WHERE itemId='6659';
DELETE FROM droplist WHERE itemId='6658';
DELETE FROM droplist WHERE itemId='6657';
DELETE FROM droplist WHERE itemId='8191';
DELETE FROM droplist WHERE itemId='6360';
DELETE FROM droplist WHERE itemId='6361';
DELETE FROM droplist WHERE itemId='6362';
DELETE FROM droplist WHERE itemId='8627';
DELETE FROM droplist WHERE itemId='8633';
DELETE FROM droplist WHERE itemId='8732';
DELETE FROM droplist WHERE itemId='8742';
DELETE FROM droplist WHERE itemId='8752';
DELETE FROM droplist WHERE itemId='8762';
DELETE FROM droplist WHERE itemId='959';
DELETE FROM droplist WHERE itemId='955';
DELETE FROM droplist WHERE itemId='951';
DELETE FROM droplist WHERE itemId='947';
DELETE FROM droplist WHERE itemId='729';
DELETE FROM droplist WHERE itemId='960';
DELETE FROM droplist WHERE itemId='956';
DELETE FROM droplist WHERE itemId='952';
DELETE FROM droplist WHERE itemId='948';
DELETE FROM droplist WHERE itemId='730';
DELETE FROM droplist WHERE itemId='6577';
DELETE FROM droplist WHERE itemId='6575';
DELETE FROM droplist WHERE itemId='6573';
DELETE FROM droplist WHERE itemId='6571';
DELETE FROM droplist WHERE itemId='6569';
DELETE FROM droplist WHERE itemId='6578';
DELETE FROM droplist WHERE itemId='6576';
DELETE FROM droplist WHERE itemId='6574';
DELETE FROM droplist WHERE itemId='6572';
DELETE FROM droplist WHERE itemId='6570';
DELETE FROM droplist WHERE itemId='1419';
DELETE FROM droplist WHERE itemId='6665';
DELETE FROM droplist WHERE itemId='6666';
DELETE FROM droplist WHERE itemId='6667';
DELETE FROM droplist WHERE itemId='6668';
DELETE FROM droplist WHERE itemId='6669';
DELETE FROM droplist WHERE itemId='6670';
DELETE FROM droplist WHERE itemId='6671';
DELETE FROM droplist WHERE itemId='6672';
DELETE FROM droplist WHERE itemId='6661';
DELETE FROM droplist WHERE itemId='4037';
DELETE FROM droplist WHERE itemId='6673';
DELETE FROM droplist WHERE itemId='9555';
DELETE FROM droplist WHERE itemId='9556';
DELETE FROM droplist WHERE itemId='9557';
DELETE FROM droplist WHERE itemId='9558';
DELETE FROM droplist WHERE itemId='3470';
DELETE FROM droplist WHERE itemId='8638';
DELETE FROM droplist WHERE itemId='8639';
DELETE FROM droplist WHERE itemId='8626';
DELETE FROM droplist WHERE itemId='6622';
DELETE FROM droplist WHERE itemId='5799';
DELETE FROM droplist WHERE itemId='6721';

 

Ети Ид нада оставить в дропу что мне делать помогите

Сборка от капитошки!

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

Столбцы с базой не совпадают 

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

Разобрался сам уже

Вот кому то помогу

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM armor WHERE armor_type= 'heavy' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM armor WHERE armor_type= 'light' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM armor WHERE armor_type= 'magic' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM armor WHERE armor_type= 'none' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bigblunt' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bigsword' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'blunt' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bow' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'dagger' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'dual' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'dualfist' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'etc' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'none' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'pole' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'sword' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'rod' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bigblunt' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bigblunt' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bigblunt' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bigblunt' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bigblunt' );

 

 

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'arrow' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'dye' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'herb' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'recipe' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'scroll' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'shot' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' );

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

Для публикации сообщений создайте учётную запись или авторизуйтесь

Вы должны быть пользователем, чтобы оставить комментарий

Создать учетную запись

Зарегистрируйте новую учётную запись в нашем сообществе. Это очень просто!

Регистрация нового пользователя

Войти

Уже есть аккаунт? Войти в систему.

Войти
Авторизация  

  • Последние посетители   0 пользователей онлайн

    Ни одного зарегистрированного пользователя не просматривает данную страницу

×
×
  • Создать...