andrisp Posted October 26, 2005 Report Share Posted October 26, 2005 mysql tabulaam kautkur glabaajaas informaacija, kad peedeejo reiz (datums, laiks) ir veiktas izmainjas tajaa ? Link to comment Share on other sites More sharing options...
andrisp Posted October 26, 2005 Author Report Share Posted October 26, 2005 mysql tabulaam kautkur glabaajaas informaacija, kad peedeejo reiz (datums, laiks) ir veiktas izmainjas tajaa ? 25528[/snapback] atradu pats SHOW TABLE STATUS //par visaam db tabulaam SHOW TABLE STATUS LIKE 'tabulas_nosaukums' // par kaadu konkreetu tabulu.. luku vairaak - http://dev.mysql.com/doc/refman/4.1/en/sho...ble-status.html Link to comment Share on other sites More sharing options...
andrisp Posted October 26, 2005 Author Report Share Posted October 26, 2005 (edited) hmmm.. ar kuru php funkciju es varu mysql timestamp formaatu '2005-12-12 24:59:59' paarveerst par unix_timestamp ? Edited October 26, 2005 by andrisp Link to comment Share on other sites More sharing options...
Analgiins Posted October 26, 2005 Report Share Posted October 26, 2005 naaksies tev to datetime (nevis mysql timestamp) formaatu splitot un likt funkcijaa mktime Link to comment Share on other sites More sharing options...
bubu Posted October 26, 2005 Report Share Posted October 26, 2005 ... mysql timestamp formaatu '2005-12-12 24:59:59' ... Tas nu galīgi nav nekāds timestamp formāts. Link to comment Share on other sites More sharing options...
Aleksejs Posted October 26, 2005 Report Share Posted October 26, 2005 Ar timestampiem darbojas šādas funkcijas: FROM_UNIXTIME(unix_timestamp),FROM_UNIXTIME(unix_timestamp,format) un UNIX_TIMESTAMP(), UNIX_TIMESTAMP(date) neko splitot nevajag. http://dev.mysql.com/doc/refman/5.0/en/dat...-functions.html Link to comment Share on other sites More sharing options...
andrisp Posted October 26, 2005 Author Report Share Posted October 26, 2005 Ar timestampiem darbojas šādas funkcijas:FROM_UNIXTIME(unix_timestamp),FROM_UNIXTIME(unix_timestamp,format) un UNIX_TIMESTAMP(), UNIX_TIMESTAMP(date) neko splitot nevajag. http://dev.mysql.com/doc/refman/5.0/en/dat...-functions.html 25558[/snapback] aha, shitaas zinu, paldies, bet vai var sasaistiit kopaa ar augstaakmineeto SHOW TABLE STATUS LIKE 'tabulasnosaukums' ? ja ne, tad buus vien jaasplito rezultaats ieksh php. Link to comment Share on other sites More sharing options...
Aleksejs Posted October 26, 2005 Report Share Posted October 26, 2005 Hmm, nezinu, bet katrā gadījumā InnoDB tabulām man rāda Update_time = NULL Link to comment Share on other sites More sharing options...
andrisp Posted October 27, 2005 Author Report Share Posted October 27, 2005 Hmm, nezinu, bet katrā gadījumā InnoDB tabulām man rāda Update_time = NULL 25561[/snapback] es izmantoju MyISAM, raada normaali Link to comment Share on other sites More sharing options...
Recommended Posts