bubu Posted December 29, 2005 Report Share Posted December 29, 2005 (edited) Gray_Wolf ar VARCHAR2 Oraklē esi pazīstams (ja pareizi atcerējos nosaukumu)? SkyD: http://dev.mysql.com/doc/refman/5.1/en/string-types.html Edited December 29, 2005 by bubu Link to comment Share on other sites More sharing options...
SkyD Posted December 29, 2005 Author Report Share Posted December 29, 2005 Atradu tādu štelliti, nodomāju, ka tas varētu but, ka nosaka max garumu, cik var iebaazt ieksh simbolus?? kO? Reku šek ir: mysql> SET max_sort_length = 2000; Nu ?!! Tas kautkaa neder??! Link to comment Share on other sites More sharing options...
v3rb0 Posted December 29, 2005 Report Share Posted December 29, 2005 tak saka visi tev - nelieto varchar bet text ja garus textus glabāt.. Link to comment Share on other sites More sharing options...
Grey_Wolf Posted December 29, 2005 Report Share Posted December 29, 2005 SkyD--> @*^(&^(&^ veidojot DB tabulu katram tabulas laukam (ROW) tiek noraadiits Datu tips.... ID parasti ir INT paarejie peec vajadziibas Datums --> DATETIME niks --> VARCHAR teksts --> text utt... --------- bubu --> jaa esmu dzirdeejis par VARCHAR2 ( max garums skjiet bija pie 2K ) :) bet tas ir tas pats kas saliidzinaat asambleraa WORD un DOBLE WORD ;) abi glabaa datus pilniigi vienaadi --> apgriestaa formaataa, tomeer tas nav viens un tas pats :) VARCHAR arii oracle var ierakstiit tikai 255 simbolus ;) P.S. Negribu striideeties , ar Oracle nesmu paaraak njeemies... Link to comment Share on other sites More sharing options...
SkyD Posted December 29, 2005 Author Report Share Posted December 29, 2005 Nu tagad tas viss kljuust saprotamaaks.. Bet varbuut tad vari paraadiit kaadu piemeeru ar to text?!?! Vinjsh darbojas apmeeram taa? TEXT(1000) ??!! Link to comment Share on other sites More sharing options...
Grey_Wolf Posted December 29, 2005 Report Share Posted December 29, 2005 CREATE TABLE `bla` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT , `niks` VARCHAR( 255 ) NOT NULL , `tekstc` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) TYPE = MYISAM; Link to comment Share on other sites More sharing options...
SkyD Posted December 29, 2005 Author Report Share Posted December 29, 2005 Nu taa jau ir cita runa :DD~~ uzreiz nevareeji man to ieboreet? :DD~~ Link to comment Share on other sites More sharing options...
Grey_Wolf Posted December 29, 2005 Report Share Posted December 29, 2005 SkyD --> un kas tavupraat te visiem ir jaasniedz bezmaksas konsuultaacijas. Manupraat pasham ir jaamaacas, un ja nu galiigi nekas nesanaak tikai tad prasiit padomu... Un atbilde uz tavu jautaajumu bija pashi DB pamati.... Link to comment Share on other sites More sharing options...
SkyD Posted December 29, 2005 Author Report Share Posted December 29, 2005 mjaaa.... Bet buutu paraadijis shito piemeeru, vo sen jau es buutu licis pa shito jautaajumu juus mieraa ::D~ un tagad es zinaashu kaa ir ar to lietu!!=]~~ Link to comment Share on other sites More sharing options...
v3rb0 Posted December 29, 2005 Report Share Posted December 29, 2005 interesanti liekas ka tiek līdz "mysql> SET max_sort_length = 2000;" bet par cita tipa lauka izmantošanu - nini. Link to comment Share on other sites More sharing options...
SkyD Posted December 30, 2005 Author Report Share Posted December 30, 2005 Ir iespeejams papildinaat tabulu?!!! Ja jaa, kaa?!! Link to comment Share on other sites More sharing options...
Grey_Wolf Posted December 30, 2005 Report Share Posted December 30, 2005 ALTER TABLE `test` ADD `e` VARCHAR( 222 ) NOT NULL AFTER `b` ; Link to comment Share on other sites More sharing options...
SkyD Posted December 30, 2005 Author Report Share Posted December 30, 2005 to AFTER arii var nelikt, ja?!! Link to comment Share on other sites More sharing options...
SkyD Posted December 30, 2005 Author Report Share Posted December 30, 2005 Veel probleema ... !!|| Man ir uzlikts lai kaarto peec Jaunaakiem vai Vecaakiem ierakstiem, tad nu luuk kods... <? $karto = $_GET['kartot']; switch($karto) { case '1': $kartot = 'id DESC'; $_SESSION['kartot'] = $kartot; break; case '2': $kartot = 'id; $_SESSION['kartot'] = $kartot; break; default: $kartot = 'id DESC'; $_SESSION['kartot'] = $kartot; break; } ?> Lieta taada, ka nospiezhot uz 2 vinjsh man sakaarto peec vecaakiem ierakstiem, tas ok, bet tiklidz uzspeizh atkal no jauna sadalju "jaunumi", atkal ir sakārtot pēc jaunākā..! $izvelk = mysql_query("SELECT * FROM blog ORDER BY ".$_SESSION['kartot'].""); Un nemaz neprasiet vai ir ielikts saakumaa session_start(); .IR! Link to comment Share on other sites More sharing options...
Grey_Wolf Posted December 30, 2005 Report Share Posted December 30, 2005 SkyD --> 1. Palasi MYSQL manuaali 2. Pirms postee Ruupiigi izlasi savu kodu !!!! tu pats saproti rakstot mainiigos kuraa briidii ir kartot un kad karto? Link to comment Share on other sites More sharing options...
Recommended Posts