NaviCat Tabelle hinzufügen

07/17/2010 09:45 sᴛᴇcʀz#1
Hey .. ich hab mal ne Frage ..

ich wollte meine item_proto in navicat neu machen also
habe ich ne neue tabelle (item_proto2) erstellt welche genauso
aussieht wie die item_proto nur ohne inhalt .. jetzt würde ich gerne
inhalt hinzufügen - aber wie ?!
ich will ganz viel auf einmal hinzufügen ! was muss ich dafür machen wenn
ich nicht alles einzeln eintippen will ?! querry table'' oder wie das heißt geht
nicht weil des dann nicht in der tabelle ist sondern in so ner hintergrund
tabelle oder so ;o

Wenn ich jetzt zum Beispiel das alles auf einmal hinzufügen will :
Code:
Item vnum="0" hashName="'Noname'" name="Noname" type="0" subtype="0" weight="0" size="0" antiflag="0" flag="0" wearflag="0" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" ;
		Item vnum="1" hashName="'µ·²Ù·¯¹Ì'" name="Yang" type="9" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="0" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" ;
		Item vnum="2" hashName="'ÀÎÅͳ׼ųÎ070905-121713" name="Deutsche Version" type="0" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="0" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" ;
		Item vnum="10" hashName="'µµ+0'" name="Schwert+0" type="1" subtype="0" weight="0" size="2" antiflag="32" flag="1" wearflag="16" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="22" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="15" value2="19" value3="13" value4="15" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="11" refine_set="1" magic_pct="15" specular="0" socket_pct="1" ;
		Item vnum="11" hashName="'µµ+1'" name="Schwert+1" type="1" subtype="0" weight="0" size="2" antiflag="32" flag="1" wearflag="16" immuneflag="0" gold="100" buy_price="100" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="22" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="15" value2="19" value3="13" value4="15" value5="7" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="12" refine_set="2" magic_pct="15" specular="0" socket_pct="1" ;
		Item vnum="12" hashName="'µµ+2'" name="Schwert+2" type="1" subtype="0" weight="0" size="2" antiflag="32" flag="1" wearflag="16" immuneflag="0" gold="100" buy_price="100" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="22" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="15" value2="19" value3="13" value4="15" value5="14" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="13" refine_set="3" magic_pct="15" specular="0" socket_pct="1" ;
		Item vnum="13" hashName="'µµ+3'" name="Schwert+3" type="1" subtype="0" weight="0" size="2" antiflag="32" flag="1" wearflag="16" immuneflag="0" gold="100" buy_price="150" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="22" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="15" value2="19" value3="13" value4="15" value5="21" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="14" refine_set="4" magic_pct="15" specular="0" socket_pct="1" ;
		Item vnum="14" hashName="'µµ+4'" name="Schwert+4" type="1" subtype="0" weight="0" size="2" antiflag="32" flag="1" wearflag="16" immuneflag="0" gold="100" buy_price="150" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="22" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="15" value2="19" value3="13" value4="15" value5="28" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="15" refine_set="5" magic_pct="15" specular="30" socket_pct="1" ;
		Item vnum="15" hashName="'µµ+5'" name="Schwert+5" type="1" subtype="0" weight="0" size="2" antiflag="32" flag="1" wearflag="16" immuneflag="0" gold="100" buy_price="200" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="22" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="15" value2="19" value3="13" value4="15" value5="35" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="16" refine_set="6" magic_pct="15" specular="40" socket_pct="1" ;
		Item vnum="16" hashName="'µµ+6'" name="Schwert+6" type="1" subtype="0" weight="0" size="2" antiflag="32" flag="1" wearflag="16" immuneflag="0" gold="100" buy_price="250" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="22" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="15" value2="19" value3="13" value4="15" value5="42" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="17" refine_set="7" magic_pct="15" specular="50" socket_pct="1" ;
		Item vnum="17" hashName="'µµ+7'" name="Schwert+7" type="1" subtype="0" weight="0" size="2" antiflag="32" flag="1" wearflag="16" immuneflag="0" gold="100" buy_price="350" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="22" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="15" value2="19" value3="13" value4="15" value5="49" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="18" refine_set="8" magic_pct="15" specular="65" socket_pct="1" ;
		Item vnum="18" hashName="'µµ+8'" name="Schwert+8" type="1" subtype="0" weight="0" size="2" antiflag="32" flag="1" wearflag="16" immuneflag="0" gold="100" buy_price="500" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="22" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="15" value2="19" value3="13" value4="15" value5="56" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="19" refine_set="9" magic_pct="15" specular="80" socket_pct="1" ;
		Item vnum="19" hashName="'µµ+9'" name="Schwert+9" type="1" subtype="0" weight="0" size="2" antiflag="32" flag="1" wearflag="16" immuneflag="0" gold="2000" buy_price="750" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="22" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="15" value2="19" value3="13" value4="15" value5="63" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="15" specular="100" socket_pct="1" ;
Danke shconmal
07/17/2010 11:35 Portgas D. Ace#2
Dann musst du das alles kopieren, dann oben links auf File klicken -> dann auf Query und dann müsste ein leeres weißes Feld kommen, dort kanste das dann einfügen
07/17/2010 13:46 sᴛᴇcʀz#3
habe es anders gemacht .. das ist nämlich eine item_proto clientside und will die serverside machen ^^ habe jetzt die ganze kacke wie name= rausgemacht und überall striche bearbeitet und so .. dann noch die tabelle item_proto2 verändert und jetzt mach ich das mit query .. anders als query gehts wohl nicht ..