Hi, Hick,
On Fri, Oct 25, 2013 at 12:52 AM, Hick Gunter <h...@scigames.at> wrote: > How did you populate the first two fields of the leagueplayers relation? > > Since SQLite doesn't do ALTER TABLE ADD COLUMN there must have been an old > leagueplayers table without the new fields. > SQLite does support ALTER TABLE ADD syntax. Thank you. > > So why not > > INSERT INTO <new table> SELECT o.playerid,o.leagueid,p.rank,p.rank from > <old table> o LEFT JOIN players p ON o.playerid = p.playerid; > > and add the values for the new fields during the initial load? > > -----Ursprüngliche Nachricht----- > Von: Igor Korot [mailto:ikoro...@gmail.com] > Gesendet: Freitag, 25. Oktober 2013 01:35 > An: General Discussion of SQLite Database > Betreff: Re: [sqlite] Is this a proper syntax? > > Igor, > > > On Thu, Oct 24, 2013 at 12:57 PM, Igor Tandetnik <i...@tandetnik.org> > wrote: > > > On 10/24/2013 3:23 PM, Igor Korot wrote: > > > >> Will this query work: > >> > >> UPDATE a SET a.field1 = (SELECT b.field1 FROM b AS myfield), a.field2 > >> = myfield... > >> > >> or I will have to repeat subquery for a.field2? > >> > > > > I'm pretty sure you will have to repeat the subquery. In your > > statement, myfield is an (unused) alias for table b, not for a value > > produced by the subquery (which I don't know of any way to name or > reuse). > > > > Well, let me try to explain myself. > Consider following schema: > > CREATE TABLE players( playerid INTEGER, name TEXT, rank INTEGER, PRIMARY > KEY playerid); CREATE TABLE leagueplayers(playerid INTEGER, leagueid > INTEGER, original_rank INTEGER, current_rank INTEGER); > > The players table is populated. > What I'm trying to do is to populate the second table with the last 2 > fields: original_rank and current_rank. > > So I was thinking of something like this: > > UPDATE leagueplayers SET original_rank = (SELECT rank FROM players AS a), > current_rank= a WHERE players.playerid = leagueplayers.playerid; > > But I guess this query will not work. ;-) > > Any idea how to make the proper query? > > Thank you. > > -- > > Igor Tandetnik > > > > > > ______________________________**_________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http: > > //sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > -------------------------------------------------------------------------- > Gunter Hick > Software Engineer > Scientific Games International GmbH > Klitschgasse 2 – 4, A - 1130 Vienna, Austria > FN 157284 a, HG Wien > Tel: +43 1 80100 0 > E-Mail: h...@scigames.at > > This e-mail is confidential and may well also be legally privileged. If > you have received it in error, you are on notice as to its status and > accordingly please notify us immediately by reply e-mail and then delete > this message from your system. Please do not copy it or use it for any > purposes, or disclose its contents to any person as to do so could be a > breach of confidence. Thank you for your cooperation. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
