| 
	
 | 
 Posted by John Nichel on 06/10/57 11:16 
tony yau wrote: 
> Hi all, 
>  
> I try to do the following: 
>  
> CREATE TABLE IF NOT EXISTS Invoice( 
>   PKey INTEGER, 
>   Received DATETIME, 
>   Cost DECIMAL(10,2), 
>   FileName VARCHAR(50), 
>   RefNum CHAR(10), 
>  
>   PRIMARY KEY (PKey) 
> ) TYPE=MyISAM COMMENT='Invoice Data'; 
>  
> but it keep generating  RefNum VARCHAR(10)  instead of CHAR(10) 
>  
> I don't understand, please help (or point me to RTFM page) 
 
How about the MySQL website, and/or a MySQL mailing list? 
 
--  
John C. Nichel 
ÜberGeek 
KegWorks.com 
716.856.9675 
john@kegworks.com
 
  
Navigation:
[Reply to this message] 
 |