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