Monthly Archives: October 2008

MySQL5 TINYINT, SMALLINT, MEDUIMINT, INT, BIGINT boundaries

From MySQL Documentation, boundaries of the numerical types are as follows: Type Min Value Max Value Bytes TINYINT -128 127 1 TINYINT UNSIGNED 0 255 1 SMALLINT -32,768 32,767 2 SMALLINT UNSIGNED 0 65,535 2 MEDIUMINT -8,388,608 8,388,607 3 MEDIUMINT … Continue reading

Posted in 4QuickLookUp | Tagged | Leave a comment

PHP date format for MySQL DATETIME fields

date(“Y-m-d H:i:s”, $timestamp);

Posted in PHP | Tagged , | Leave a comment