Raimiks Posted November 20, 2006 Report Share Posted November 20, 2006 "insert into projects (name, `desc`) values ('Vakances', '')": Duplicate entry '0' for key 1 mēģinu uztaisit rubriku, bet vinš man lūk ko raksat. Link to comment Share on other sites More sharing options...
andrisp Posted November 20, 2006 Report Share Posted November 20, 2006 desc droši vien ir primary key vai unique vai kas tāds, tāpēc divas vienādas vērtības tajā kolumnā nevar būt. Link to comment Share on other sites More sharing options...
Raimiks Posted November 20, 2006 Author Report Share Posted November 20, 2006 Nevajag taisīt muļķīgas QUOTEs (bubu) hmmm desc ka paskatities primary ir vai nava ?? Link to comment Share on other sites More sharing options...
andrisp Posted November 20, 2006 Report Share Posted November 20, 2006 http://dev.mysql.com/doc/refman/5.0/en/describe.html Link to comment Share on other sites More sharing options...
Raimiks Posted November 20, 2006 Author Report Share Posted November 20, 2006 man id primary stav ?? ar desc viss oki ?? Link to comment Share on other sites More sharing options...
andrisp Posted November 20, 2006 Report Share Posted November 20, 2006 ko ? Link to comment Share on other sites More sharing options...
Raimiks Posted November 20, 2006 Author Report Share Posted November 20, 2006 Nevajag taisīt muļķīgas QUOTEs (bubu) man ID stav ka PRIMARY. Nevis DESC. Link to comment Share on other sites More sharing options...
andrisp Posted November 20, 2006 Report Share Posted November 20, 2006 Nu tad tev iespējams nav pielikts auto_increment tam ID. http://dev.mysql.com/doc/refman/5.0/en/exa...-increment.html Link to comment Share on other sites More sharing options...
Raimiks Posted November 20, 2006 Author Report Share Posted November 20, 2006 Nevajag taisīt muļķīgas QUOTEs (bubu) SQL-запрос: ALTER TABLE `projects` CHANGE `id` `id` INT( 12 ) NOT NULL DEFAULT '0' AUTO_INCREMENT Ответ MySQL: Документация #1067 - Invalid default value for 'id' Lūk ka viņš uz manis sarajas kad mēģināju uzlikt Link to comment Share on other sites More sharing options...
andrisp Posted November 20, 2006 Report Share Posted November 20, 2006 (edited) AUTO_INCREMENT laukiem nav default value. PS. Necitē visu, ko es saku. Tas tikai traucē informācijas uztveršanai. Edited November 20, 2006 by andrisp Link to comment Share on other sites More sharing options...
Raimiks Posted November 20, 2006 Author Report Share Posted November 20, 2006 ID man vel stav ka UNIQUE blin.. lai es velreiz nemtos pārtaisīt kādām bazi vienas problemas :( Link to comment Share on other sites More sharing options...
Recommended Posts