MMOCoin

Likes Likes:  0
Results 1 to 2 of 2
  1. 27-12-09, 11:08 AM #1
    LiLLeCarl
    LiLLeCarl is offline
    Contributor
    LiLLeCarl's Avatar
    Join Date
    Jan 2009
    Posts
    106
    Post Thanks / Like
    Rep Power
    19
    Reputation
    84
    Send a message via MSN to LiLLeCarl

    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 11:39 AM.
    Whos dat "LilleCarl"

    Its LilleCarl OMGBBQLOLZXD
  2. 04-02-10, 06:08 PM #2
    zlatko0o
    zlatko0o is offline
    Beginner
    Join Date
    Feb 2010
    Location
    http://thunderstorm-wow.net
    Posts
    10
    Post Thanks / Like
    Rep Power
    17
    Reputation
    7
    Send a message via MSN to zlatko0o

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



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

 

 
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Hide Hack By vFCoders