Klez Posted January 10, 2005 Report Share Posted January 10, 2005 Tātad... MySQLā stāva tabula ar sekojošiem ierakstiem: +--------------------------+ + -id- | -nickID- | dats + +--------------------------+ +- 1 ----- 12 ----- .... --+ +- 2 ----- 12 ----- .... --+ +- 3 ----- 12 ----- .... --+ +- 4 ----- 12 ----- .... --+ +- 5 ----- 12 ----- .... --+ +- 6 ----- 12 ----- .... --+ +- 7 ----- 13 ----- .... --+ +- 8 ----- 13 ----- .... --+ +- 9 ----- 13 ----- .... --+ man ir vajadziigs dabuut no DB aaraa ierakstus, bet lai tie ieraksti neatkaartojas paredzeeta ir mekleeshana, bet tie nickID nav zinaami, vajag dabuut no tabulas visus unikaalos nickID ir tas iespeejams? un ja ir tad varbuut vareetu kkaadu ideju pamest .... Link to comment Share on other sites More sharing options...
rumpels Posted January 10, 2005 Report Share Posted January 10, 2005 SELECT DISTINCT(`nickID`) FROM `tabula` mekleshana un atlase ir viens un tas pats, to ko pieprasa atlasa un atrod...pec Tevis rakstita vareja saprast ka shis kverijs Tev lidz ja nea izskaidro precizak ;) Link to comment Share on other sites More sharing options...
PheliX Posted January 10, 2005 Report Share Posted January 10, 2005 select nickID from tabula group by nickID; Link to comment Share on other sites More sharing options...
Klez Posted January 10, 2005 Author Report Share Posted January 10, 2005 paldiesss :)) Link to comment Share on other sites More sharing options...
Recommended Posts