List:General Discussion« Previous MessageNext Message »
From:Graeme B. Davis Date:May 20 1999 5:58pm
Subject:Re: default value
View as plain text  
but "n.a." isn't an integer....

:)

How about ...default NULL perhaps ?

Graeme

----- Original Message ----- 
From: Harald Seckel <Harald.Seckel@stripped>
To: <mysql@stripped>
Sent: Thursday, May 20, 1999 1:48 PM
Subject: default value


> Greetings!
> 
> I am administrating a MySQL db. Lets say I have a table with column type
> INTEGER. When I insert data MySQL changes any empty cell to "0". But
> this should be "n.a." or something like this. 
> 
> I tried to set a default value following the tutorial:
> 
> CREATE TABLE test (columnA INTEGER NOT NULL DEFAULT 'n.a.')
> 
> It doesn't work. :(
> 
> I am asking for help. :)
> 
> Thanks, Harald.
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread3648@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
> 
> 

Thread
default valueHarald Seckel20 May
  • Re: default valueGraeme B. Davis20 May
  • Re: default valuePaul DuBois25 May
RE: default valueUnknown Sender20 May
  • Re: default value(Eric Savage)20 May