RE: lug-bg: MYSQL - svarzxani poleta
- Subject: RE: lug-bg: MYSQL - svarzxani poleta
- From: yavo@xxxxxxxxxxxxxxxxxx (yavor shahpasov)
- Date: Wed, 29 Aug 2001 01:13:21 +0300
Osven ako ne ikash tova pole da ti e PK (primary key) standartna praktika v
RDBMS e tova pole da e v edna ot tablitsite ti, kogato iskash da chetesh
pravish join, primer s dve tablitsi produkt/porachka producta ima kod I
tsena orachkata ima samo prduct code, kogato iskash da vidish kakva e
stoinosta na porachkata pravish join varhu product code ex.
select a.code, a.price, b.code
from products a, orders b
where a.code = b.productcode
yavor
> -----Original Message-----
> From: owner-lug-bg@xxxxxxxxxxxxxxxxxx
> [mailto:owner-lug-bg@xxxxxxxxxxxxxxxxxx]On Behalf Of Vasko Tomanov
> Sent: Tuesday, August 28, 2001 10:57 AM
> To: lug-bg@xxxxxxxxxxxxxxxxxx
> Subject: lug-bg: MYSQL - svarzxani poleta
>
>
> niakoi ima li ideia kak da napravia na MYSQL dve svarzani poleta -
>
> prosto w dve razlitshni tablici imam poleta ot tip INT iskam da stanat
> edno i sashto pole..
>
> - kakvoto stava s ednoto tva da stava i s drugoto..
>
> w drugite bazi tova go pravia s trigger ili s relation.. ne moga da
> nameria neshto podobno w mysql
>
> vasko
> ==================================================================
> =========
> A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers)
> http://www.linux-bulgaria.org/ Hosted by Internet Group Ltd. -
> Stara Zagora
>
===========================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers)
http://www.linux-bulgaria.org/ Hosted by Internet Group Ltd. - Stara Zagora
|