Re: Why does data type change?

[Adam Hooper]

Kiskedee@stripped wrote:
> Command:
> create table products_tmp as
> select * from products_tbl;
> 
> Table: products_tmp
> Prod_ID    char(10)       not null
> Prod_Desc     char(40)       not null
> Cost              decimal(6,2) not null

If anything, you should be asking the MySQL general list, and not 
MySQLCC, since you're only using MySQLCC as a low-level command-line to 
MySQL itself (are you sure you wouldn't prefer the command-line client?)

Adam Hooper
adamh@stripped