Need Help

[rampage]

Hi Guys, I Am am trying to import 3 tables into another database but I am having troubles

I Hope you can help me out

Here is the data I have

Please note rob_proto is in a different database

REPLACE rob_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage , maxdamage, rangedattacktime, rangemindamage, rangemaxdamage, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, money, spell1, spell2, spell3, spell4)

SELECT entry, minlevel, maxlevel, faction_A, minhealth, maxhealth, maxmana, scale, npcflag, baseattacktime, mindmg , maxdmg, rangeattacktime, minrangedmg, maxrangedmg, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6,(combat_reach, bounding_radius, auras, maxgold, spell1, spell2, spell3, spell4

FROM

rob_base.creature_template

rob_base.creature_addon (auras)

rob_base.creature_model_info (bounding_radius) and (combat_reach)

[peterlaursen]

REPLACE .. SELECT .. explained here: http://dev.mysql.com/doc/refman/5.1/en/replace.html

REPLACE [LOW_PRIORITY | DELAYED]

[INTO] tbl_name [(col_name,…)]

SELECT …

.. but the problem is that the SELECT part of your statement is not a valid SQ-statement.

Try

1) using *full syntax* like tablename.columnname for every column in the SELECT-part

2) what is the silly paranthesis before 'combat_reach' supposed to do?

3) the table-list must be seperated by commas

like

REPLACE table_1 (col_1, col_2, col_3)

SELECT table_x.col_m, table_y.col_n, table_z.col_o

FROM table_x. table_y. table_x

[Author]

Posts