RE: potriedit databazicku sql

• Previous message: Mirex: "potriedit databazicku sql"
• Maybe in reply to: Mirex: "potriedit databazicku sql"
• Next in thread: h! y n e k . l i p a: "Re: potriedit databazicku sql"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

> Mam databazu nakrmenu asi 260 clankami v postnuke a rad by 
> som to ztriedil.
> samozrejme, da sa rucne, ale najprv sa spytam, kym miniem 3 
> hodiny casu.
> (tolko som tam vkladal skutocne datumy kedy clanky vysli :-))
> 
> INSERT INTO nieco VALUES (185, 1, '2', 'nazov', 'datum', 'blablabla->
> 
> Potreboval by som, aby sa riadky zoradili podla (ciselny) retazec
> 'datum' a potom ocislovali od 1 do 300. Vypis je z clanku cislo 185,
> to je to cislo, ktore zamyslam zmenit podla datumu.
> 
> Ciel je:
> 
> INSERT INTO nieco VALUES (1, 1, '2', 'nazov', '1999-08-05 
> 12:53:30', 'blablabla->
> INSERT INTO nieco VALUES (2, 1, '2', 'nazov', '2002-08-05 
> 12:53:30', 'blablabla->
> 

ja by som spravil asi toto - vytvorit temp tabulku s rovnakymi polami -
pole s id clanku dat ako autoincrement
potom

insert into temptable (polia okrem idclanku) select (polia okrem
idclanku) from table order by datum

a vysledok preniest do povodnej tabulky

na mysql mi to zbehlo, zotriedilo podla datumu a priradilo id-cka ako
chces ty

peter

• Previous message: Mirex: "potriedit databazicku sql"
• Maybe in reply to: Mirex: "potriedit databazicku sql"
• Next in thread: h! y n e k . l i p a: "Re: potriedit databazicku sql"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.2 : 05. 08. 2002, 14:46 CEST