Chickenz Posted March 6, 2004 Report Share Posted March 6, 2004 VAi ir kaads qverijs kursh atlasa visus ieraxtus no datubāzes iznjemot kādu konkrētu - piem: Tabula lalala: id 1, id 2, id 3, id 4, id 5, id 6, id 7, id 8 Kā lai atlasa visus id iznjemot 3? Link to comment Share on other sites More sharing options...
hu_ha Posted March 6, 2004 Report Share Posted March 6, 2004 select * from table where id<>3 Link to comment Share on other sites More sharing options...
Roze Posted March 6, 2004 Report Share Posted March 6, 2004 Der arii != proti select * from table where id!='3' Manupraat izskataas smukaak :) un logjiskaak proti nevis 'lielaaks mazaaks' bet 'nav vienaads ar' Link to comment Share on other sites More sharing options...
Aleksejs Posted March 6, 2004 Report Share Posted March 6, 2004 (edited) Vispareizāk, domājams, ir tā kā SQL99 vai ANSI SQL. Kā? Vai <> vai != tiešām nezinu :D Edited March 6, 2004 by Aleksejs Link to comment Share on other sites More sharing options...
Roze Posted March 7, 2004 Report Share Posted March 7, 2004 Nu MySQLs jau diezgan daudz vietaas nav pietureejies pie standartiem :) Kas gan zinamaa meeraa dazhreiz dod priekshroocibas attieciibaa uz citaam db sisteemaam.. Link to comment Share on other sites More sharing options...
Chickenz Posted March 7, 2004 Author Report Share Posted March 7, 2004 :rolleyes: Paldies, es vienkārši savai raxtu sistēmai gribēju pievienot to ka parāda visus pārējos ieraxtus, izņemot to kuru lasa... Moderator ja vari ta izdzēs šo topicu... Link to comment Share on other sites More sharing options...
Recommended Posts