andrisp Posted April 27, 2005 Report Share Posted April 27, 2005 bija MySQL 3.. nodumpojaam datubaazes.. uzlikaam MySQL 4.. importeejaam visu atpakalj.. bet tagad, piemeeram, palaizhot SELECT MAX(smth) FROM `table` uz kolumnas, kur visos laukumos ir skaitlji, vinjs man izdod kautkaadu skaitli, kas nu galiigi nav lielaakais.. paliidziet. paldies. Link to comment Share on other sites More sharing options...
bubu Posted April 27, 2005 Report Share Posted April 27, 2005 smth kolonnai tips ir skaitlisks? Link to comment Share on other sites More sharing options...
andrisp Posted April 27, 2005 Author Report Share Posted April 27, 2005 smth kolonnai tips ir skaitlisks? 16979[/snapback] varchar vienaa citaa analogaa tabulaa man ir shajaa pashaa kolumnaa ir lauki ar veertiibaam j/1, j/2, j/3, j/4 utt., bet MAX normaali straadaa. Link to comment Share on other sites More sharing options...
bubu Posted April 27, 2005 Report Share Posted April 27, 2005 Vai tev tajā kolonna glabājās tikai skaitļi? Ja jā, tad mēģini šādi: SELECT MAX(CAST(smth AS INTEGER)) FROM `table` (un vispār tad labāk kolonnas tipu pamainīt). Link to comment Share on other sites More sharing options...
Recommended Posts