| 
	
 | 
 Posted by "tony yau" on 06/10/75 11:16 
found the answer sorry about this 
 
"Tony Yau" <tony.yau@emigen.co.uk> wrote in message 
news:20050518181658.10441.qmail@lists.php.net... 
> 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) 
> Tony Yau
 
  
Navigation:
[Reply to this message] 
 |