[thelist] Trying to create table in MySQL DB with phpmyadmin

Robert Gormley robert at pennyonthesidewalk.com
Sun Sep 4 20:04:58 CDT 2005


Not directly related, but I was surprised by this column choice of BIGINT.

Are you really going to have 18,446,744,073,709,551,615 possible 
categories of data?

Rob||

Christian Anderson wrote:

>CREATE TABLE `table_CATEGORIES` (
>`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `tTITLE` VARCHAR NOT NULL ,
>`tLOCATION` VARCHAR NOT NULL , `tDATE` DATE NOT NULL
>)
>  
>




More information about the thelist mailing list