Blitz Posted August 31, 2005 Report Share Posted August 31, 2005 Ka var no datubazes izdabut ara visus ierakstus ja air tikai 1 kolonna. WHERE tada gadijumaa nevar noradit. Varbut ir kada iespejo tos visus ierakstit kaadaa masiivaa vai tamlidzigi. help :rolleyes: Link to comment Share on other sites More sharing options...
Delfins Posted August 31, 2005 Report Share Posted August 31, 2005 blin, `ir kolonna, un nevar norādīt WHERE kolonnu...` domā ko runā!!! Link to comment Share on other sites More sharing options...
Kristabs Posted August 31, 2005 Report Share Posted August 31, 2005 aha, muljkjiibas, tiko pameegjinaaju, nekaadu probleemu pie where izmantoshanas Link to comment Share on other sites More sharing options...
Blitz Posted August 31, 2005 Author Report Share Posted August 31, 2005 nu pag, Tabulaa, ir TIKAI viena kolonna ISN. ISN ir nejausi generets 7ciparu skaitlis. Tad "SELECT ISN FROM TABULA WHERE ISN=????????" Sitada veidaa tak nav iespejams neko dabut... un man vajag izdabut araa 16000 ierakstus Link to comment Share on other sites More sharing options...
bubu Posted August 31, 2005 Report Share Posted August 31, 2005 A vienkārši SELECT ISN FROM TABULA nevar? Link to comment Share on other sites More sharing options...
Delfins Posted August 31, 2005 Report Share Posted August 31, 2005 nu pag, Tabulaa, ir TIKAI viena kolonna ISN. ISN ir nejausi generets 7ciparu skaitlis. Tad "SELECT ISN FROM TABULA WHERE ISN=????????" Sitada veidaa tak nav iespejams neko dabut... un man vajag izdabut araa 16000 ierakstus 21713[/snapback] VISI_IERAKSTI un WHERE - tas ir pretrunīgi, `domā līdzi`... ja vajag visus, nelieto WHERE ja vajag daļu, lieto WHERE/LIMIT Link to comment Share on other sites More sharing options...
bubu Posted August 31, 2005 Report Share Posted August 31, 2005 offtopic: foruma sadaļa gan 'pareizā' izvēlēta... Link to comment Share on other sites More sharing options...
v3rb0 Posted August 31, 2005 Report Share Posted August 31, 2005 nu ja sausmigi grib visus un where pierakstit klaat, tad jau var rakstiit `where 1=1`, bet jeega tiesam nekada.. Link to comment Share on other sites More sharing options...
Analgiins Posted August 31, 2005 Report Share Posted August 31, 2005 nu ja sausmigi grib visus un where pierakstit klaat, tad jau var rakstiit `where 1=1`, bet jeega tiesam nekada..21718[/snapback] pietiek ar WHERE 1 Link to comment Share on other sites More sharing options...
kaszu Posted September 1, 2005 Report Share Posted September 1, 2005 (edited) Ta ka bubu rakstija ir pareizi, SELECT * FROM 'tabula' Nav vajadzibas izmantot WHERE Edited September 1, 2005 by kaszu Link to comment Share on other sites More sharing options...
bubu Posted September 1, 2005 Report Share Posted September 1, 2005 Kāpēc * ja vajag ikai ISN kolonnu? Link to comment Share on other sites More sharing options...
NeoX Posted October 18, 2005 Report Share Posted October 18, 2005 Kāpēc * ja vajag ikai ISN kolonnu? Nu shajaa gadiijumaa taa arii var jo tabulaa iktaa esot tikai 1 lauks ISN Link to comment Share on other sites More sharing options...
bubu Posted October 18, 2005 Report Share Posted October 18, 2005 wtf? Pēc pusotra mēneša pamodies, NeoX, un vēl par citu cilvēku db visu pārzin :D Link to comment Share on other sites More sharing options...
Recommended Posts