ORDER BY - why doesnt it work??
Posted by: Simon Gabor
Date: November 19, 2015 06:59AM

Hello,

I have a problem, that i dont understand at all.

A create a simple table, then put data into it.

(see below).

Then i make a query: SELECT * FROM studiok3 ORDER BY studio_nev

The first 26 rows are in abc order, but after all a new order begins.


CREATE TABLE IF NOT EXISTS `studiok3` (
`studio_id` bigint(20) unsigned NOT NULL,
`studio_nev` varchar(255) CHARACTER SET utf8 COLLATE utf8_hungarian_ci NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=35 ;

--
-- A tábla adatainak kiíratása `studiok3`
--
INSERT INTO `studiok3` (`studio_id`, `studio_nev`) VALUES
(1, ' Allure Poledance Studio'),
(2, ' ArtPole Aerial Studio'),
(3, ' ArtPole Buda'),
(4, ' Attitude Beauty and Pole'),
(5, ' Chrome Bunnies'),
(6, ' Chrome Pole'),
(7, ' Dollhouse Boudoir'),
(8, ' Dollhouse Buda'),
(9, ' Dollhouse Pest'),
(10, ' Magic Fitness'),
(11, ' Pol-E-Fit Rúdsport Rúdtánc Stúdió Cegléd'),
(12, ' Pole Dance Fitness Blaha'),
(13, ' Pole Dance Fitness Buda Flex'),
(14, ' Pole Dance Fitness Oktogon'),
(15, ' Pole Magic Rúdtánc Stúdió'),
(16, ' Poledance Paradise'),
(17, ' PolePlay Budapest'),
(18, ' POLEX Boudoir'),
(19, ' POLEX Buda'),
(20, ' Royal Fitness'),
(21, ' Rúdtánc Debrecen'),
(22, ' Rúdtánc Érd'),
(23, ' Rúdtánc Fitnesz Eger'),
(24, ' Rúdtánc Forma-1 Fitnesz Szeged'),
(25, ' Szlávy Eszter Rúdsport Akadémia'),
(26, ' TT Pole'),
(27, 'Dollhouse Miskolc'),
(28, 'Pole Fitness Stúdió'),
(29, 'Pole Position Kecskemét'),
(30, 'PolePlay Budaörs'),
(31, 'POLEX ABC'),
(32, 'POLEX Csepel'),
(33, 'POLEX Dunavarsány'),
(34, 'ABC Dunavarsány'),
(35, 'Vertical Spin Sportrúdtánc SE');


RESULT after SELECT * FROM studio3 ORDER BY studio_nev


Allure Poledance Studio
ArtPole Aerial Studio
ArtPole Buda
Attitude Beauty and Pole
Chrome Bunnies
Chrome Pole
Dollhouse Boudoir
Dollhouse Buda
Dollhouse Pest
Magic Fitness
Pol-E-Fit Rúdsport Rúdtánc Stúdió Cegléd
Pole Dance Fitness Blaha
Pole Dance Fitness Buda Flex
Pole Dance Fitness Oktogon
Pole Magic Rúdtánc Stúdió
Poledance Paradise
PolePlay Budapest
POLEX Boudoir
POLEX Buda
Royal Fitness
Rúdtánc Debrecen
Rúdtánc Érd
Rúdtánc Fitnesz Eger
Rúdtánc Forma-1 Fitnesz Szeged
Szlávy Eszter Rúdsport Akadémia
TT Pole
ABC Dunavarsány <<- NEW ABC ORDER BEGINS?? WHY????
Dollhouse Miskolc
Pole Fitness Stúdió
Pole Position Kecskemét
PolePlay Budaörs
POLEX ABC
POLEX Csepel
POLEX Dunavarsány
Vertical Spin Sportrúdtánc SE


Thanks
Gabor

Options: ReplyQuote


Subject
Views
Written By
Posted
ORDER BY - why doesnt it work??
1893
November 19, 2015 06:59AM
873
November 19, 2015 07:22AM
879
November 19, 2015 07:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.