SQL baze podataka - Sponzor: Baze-Podataka.net MySQL, MSSQL, Oracle, Access, ODBC. Ako imate problem brže i preciznije ćete dobiti odgovor ako priložite strukturu tabela ili skript koji kreira tabele i puni ih test podacima umesto što to problem opisujete samo rečima. Sponzor: Baze-Podataka.net - Blog o bazama podataka |
![]() |
|
Alati teme | Način prikaza |
![]() |
#11 |
Milan Cvejic
Wrote a book
|
![]() moze sta god da treba...
![]()
__________________
http://weevify.com |
![]() |
![]() |
![]() |
#12 | |
član
Certified
Datum učlanjenja: 27.11.2007
Poruke: 71
Hvala: 10
12 "Hvala" u 11 poruka
![]() |
![]() Citat:
![]() |
|
![]() |
![]() |
![]() |
#13 |
novi klan
Professional
Datum učlanjenja: 03.02.2007
Poruke: 326
Hvala: 43
427 "Hvala" u 50 poruka
![]() ![]() ![]() ![]() ![]() |
![]() Evo poigrao sam se malo grubom silom u MySQL-u:
Kôd:
DELIMITER $$ DROP FUNCTION IF EXISTS `test`.`simple_path`$$ CREATE FUNCTION `test`.`simple_path` (path char(20)) RETURNS char(20) BEGIN DECLARE counter INT DEFAULT 2; DECLARE simple_path char(20) DEFAULT SUBSTR(path, 1, 1); WHILE counter <= CHAR_LENGTH(path) DO IF SUBSTR(path, counter-1, 1) <> SUBSTR(path, counter, 1) THEN set simple_path = CONCAT(simple_path, SUBSTR(path, counter, 1)); END IF; SET counter = counter + 1; END WHILE; RETURN simple_path; END$$ DELIMITER ; select distinct simple_path(concat(step_1, step_2, step_3, step_4, step_5)) from test
__________________
We professional we dealin' with business |
![]() |
![]() |
![]() |
#14 |
old school
Professional
|
![]() Je l' ti moze ovo ista pomoci?
Kôd:
select distinct concat( step_1, IF(step_1 = step_2, '', step_2), IF(step_2 = step_3, '', step_3), IF(step_3 = step_4, '', step_4), IF(step_4 = step_5, '', step_5) ) as path, total_cost, path_length from tvoja_tabela; ![]()
__________________
Blog: Baze podataka ------------------------ Oracle OCP DBA Oracle OCE SQL Expert Oracle OCP Developer Certified MySQL DBA Poslednja izmena od Dejan Topalovic : 25. 09. 2009. u 00:27. |
![]() |
![]() |
![]() |
#15 |
old school
Professional
|
![]() I jesi nasao rjesenje?
__________________
Blog: Baze podataka ------------------------ Oracle OCP DBA Oracle OCE SQL Expert Oracle OCP Developer Certified MySQL DBA |
![]() |
![]() |
![]() |
#16 |
Milan Cvejic
Wrote a book
|
![]() nisam,
ceo clanak se nalazi ovde, pa koga interesuje... http://www.dbazine.com/ofinterest/oi-articles/celko13 Hvala svakako...
__________________
http://weevify.com |
![]() |
![]() |
![]() |
#17 |
old school
Professional
|
![]() Procitao sam clanak, ali mi nije bas sve jasno... Npr. zasto ovaj red:
(s, s, s, x, y, 11, 1) ima path_length 1, a ovaj red: (s, x, y, y, y, 11, 2) ima path_length 2, ako su nakon skracivanja cvorova (na "sxy") ekvivalentni? Ne mozes nista iskombinovati sa gorenavedenim rjesenjem koristeci CONCAT?
__________________
Blog: Baze podataka ------------------------ Oracle OCP DBA Oracle OCE SQL Expert Oracle OCP Developer Certified MySQL DBA |
![]() |
![]() |
![]() |
|
|
![]() |
||||
Tema | Početna poruka teme | Forum | Odgovori | Poslednja poruka |
Double float problem - resen, ali ima dodatni problem :0 | ljtruba | (X)HTML, JavaScript, DHTML, XML, CSS | 34 | 23. 08. 2008. 02:28 |
Canvas 3D Graph | kodi | (X)HTML, JavaScript, DHTML, XML, CSS | 1 | 05. 08. 2007. 21:37 |
Da li je određeni path stvarna adresa fajla? | Ilija Studen | PHP | 4 | 09. 06. 2006. 17:07 |