Posted By: znouza (- Armored Pilsener -) on 'CZdatabases' Title: Re: GUI client pro (My)SQL Date: Mon Jan 31 16:59:11 2000 > Zdar. > > Existuje neco, cim se da interaktivne manipulovat s SQL tabulkou ? > Myslim tim, ze se pripojim k (My)SQL serveru, vyberu tabulku a ona se mi > objevi > v okne, kde muzu editovat jednotlive polozky a provedene zmeny ukladat. To je otazka toho sql klienta (phpMySQLAdmin, enteprise manager ..) > > Druhy dotazek ... v MySQL mam dve tabulky tab1, tab2: > > tab1: > +-------+-------+-------+ > | col11 | col12 | col13 | > +-------+-------+-------+ > | A | xx | NULL | > | C | xx | NULL | > | D | xx | NULL | > | B | xx | NULL | > +-------+-------+-------+ > > tab2: > +-------+-------+ > | col21 | col22 | > +-------+-------+ > | A | 1 | > | B | 2 | > | C | 3 | > | D | 4 | > +-------+-------+ > > A ja potrebuju, aby tab1 vypadala takto: > +-------+-------+-------+ > | col11 | col12 | col13 | > +-------+-------+-------+ > | A | xx | qw-1 | > | C | xx | tr-3 | > | D | xx | gt-4 | > | B | xx | cx-2 | > +-------+-------+-------+ > > Se SQL nemam skoro zadne zkusenosti, takze uvitam jakekoli info. select * from tab1 left join tab2 on tab1.col11=tab2.col21 > Diky > > Rosik _ _ /-------- znouza ( o)(o ) /__________ || | | || |_| "The game of life is hard to play..." ** __| 3T