List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:August 9 2001 3:07am
Subject:Re: using BIGINT VS NUMERIC
View as plain text  
At 8:19 PM -0500 8/8/01, Timothy E. Cronin wrote:
>After RTFM ...
>
>when creating a table
>
>the following works
>id BIGINT PRIMARY KEY NOT NULL AUTO_INCREMENT
>
>but the following syntax fails:
>id NUMERIC PRIMARY KEY NOT NULL AUTO_INCREMENT
>
>I get the following error.
>
>Incorrect column specifier for column id

AUTO_INCREMENT columns should be used only with integer types.
NUMERIC isn't integer.

-- 
Paul DuBois, paul@stripped
Thread
using BIGINT VS NUMERICTimothy E. Cronin9 Aug
  • Re: using BIGINT VS NUMERICDennis Salguero9 Aug
  • Re: using BIGINT VS NUMERICPaul DuBois9 Aug