Another sql newbie question

[Slowpoke]

Is it possible to use sql to create objects like in xml? E.g. How would the following (giving napoleon india's trait as well as his own) be translated to sql?

<GameData>
<Leader_Traits>
<Row>
<LeaderType>LEADER_NAPOLEON</LeaderType>
<TraitType>TRAIT_POPULATION_GROWTH</TraitType>
</Row>
</Leader_Traits>
</GameData>

 

[smellymummy]

either one of these

update Leader_Traits set TraitType="TRAIT_POPULATION_GROWTH" where LeaderType="LEADER_NAPOLEON";
insert into Leader_Traits (LeaderType, Traitype) VALUES ("LEADER_NAPOLEON", "TRAIT_POPULATION_GROWTH");

first one changes his trait, second one adds a row, not sure which you want

 

[lemmy101]

For reference.

Adding in XML:

<GameData>
    <NameOfTable>
        <Row> 
               <ValueToSet>1</ValueToSet>
               <ValueToSet2>true</ValueToSet>
        </Row>        
    </NameOfTable>
</GameData>

Adding in SQL:

INSERT INTO NameOfTable (ValueToSet, ValueToSet2) VALUES ("1", "true");

Updating in XML:

<GameData>
    <NameOfTable>
        <Update>
              <Set ValueToUpdate="1"/>
              <Where KeyToSearchFor="ValueOfKey"/>
         </Update>       
    </NameOfTable>
</GameData>

Updating in SQL:

UPDATE NameOfTable SET ValueToUpdate="1" WHERE KeyToSearchFor = "ValueOfKey";

 

[Slowpoke]

Ah, thanks a bunch