Jump to content
×
×
  • Create New...
  • 0

mysql query (important pls help)


TRBizeps

Question

I need some help in mysql querys,

 

i extracted the new mob_proto by gameforge client

as you may know some columns are missing because they dont save them clientside

so i need a query for .sql i want to export 1 or 2 colums from mob_proto2 to mob_proto1 with checked by vnum so it exports from mob.proto2 monster 101 to mob_proto1 101 column gold_min

i tryed this but it does not work

 

SELECT mob_proto2.damage_min
    UPDATE mob_proto.damage_min
    WHERE mob_proto2.vnum = mob_proto.vnum
    );

"All for one and one for all." Alexandre Dumas

 

Link to comment
  • Answers 1
  • Created
  • Last Reply

Top Posters For This Question

Popular Days

Top Posters For This Question

1 answer to this question

Recommended Posts

  • 0

You type quite right.

So first of all be carefull doing query like this(that's and implicit join).

Note: You have to specify table and attr to not be ambiguos.

 

Anyway in your case:

To Extract and update this is the right syntax:

UPDATE mob_proto SET mob_proto.damage_min=(SELECT damage_min FROM mob_proto_copy WHERE mob_proto.vnum=mob_proto_copy.vnum);

 

To check if all is gone well then type something like this:

select vnum from mob_proto where NOT EXISTS(select * from mob_proto_copy where mob_proto.vnum = mob_proto_copy.vnum and mob_proto.damage_min = mob_proto_copy.damage_min);

 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Announcements

  • -15% Discount in Metin2 Dev Store (01/10/2021 => 31/12/2021) => Code => 15_PCT_OCT_TO_DEC_2021


  • Read our Rules
  • Activity

    1. 3

      Quest Craft

    2. 3

      Quest Craft

    3. 414

      [40250] Reference Serverfile + Client + Src [15 Available Languages]

    4. 11

      Metin2 Patcher with Electron

    5. 17

      I Want Find freebsd 11.4 with remove unnecessary codes

    6. 17

      I Want Find freebsd 11.4 with remove unnecessary codes

    7. 3

      Quest Craft

  • Recently Browsing

    • No registered users viewing this page.

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.