Hello & Welcome to our community. Is this your first visit? Register
Follow us on
Follow us on Facebook Follow us on Twitter Watch us on YouTube


MMOCoin

Likes Likes:  0
Results 1 to 2 of 2
  1. #1
    Contributor
    LiLLeCarl's Avatar
    Join Date
    Jan 2009
    Posts
    106
    Post Thanks / Like
    Rep Power
    17
    Reputation
    84

    SQL Query Help ;D SOLVED


    Register to remove this ad
    delete from creature_proto where entry != creature_names.entry;
    delete from creature_proto where entry != (select entry from creature_names);


    something like that is what i can imagine its supposed to remove all entrys from creature_proto that doesent have a entry in creature_names well tthats it

    SOLUTION:
    delete from creature_proto where entry NOT IN (select entry from creature_names);



    // LilleCarl ;D


    › See More: SQL Query Help ;D
    Last edited by LiLLeCarl; 27-12-09 at 10:39 AM.
    Whos dat "LilleCarl"

    Its LilleCarl OMGBBQLOLZXD



  2. Related Threads - Scroll Down after related threads if you are only interested to view replies for above post/thread

  3. #2
    Beginner

    Join Date
    Feb 2010
    Location
    http://thunderstorm-wow.net
    Posts
    10
    Post Thanks / Like
    Rep Power
    15
    Reputation
    7

    Register to remove this ad
    I think you must do it manual

 

 

Visitors found this page by searching for:

Nobody landed on this page from a search engine, yet!
SEO Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -5. The time now is 06:37 PM.
Powered by vBulletin® Copyright ©2000-2024, Jelsoft Enterprises Ltd.
See More links by ForumSetup.net. Feedback Buttons provided by Advanced Post Thanks / Like (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
vBulletin Licensed to: MMOPro.org