>Sent: Thursday, April 04, 2002 6:16 AM
>To: MySQL (E-mail) (E-mail)
>Cc: Rochester, Dean
>Subject: RE: How do you set the char format for a column in Mysql table
>
>
>* Rochester, Dean
>> I have a Mysql table with a char(2) column, name is Dependents.
>> I want the
From: "Rochester, Dean" <[EMAIL PROTECTED]>
> I have a Mysql table with a char(2) column, name is Dependents. I want
the
> value that I insert to always be to places. I have tried
>
> Insert into Table1 Dependents values '02';
>
> but it inserts 2 in the Dependents column
>
> How do I make it
time
Dean-O
aka Java Dude, SQL Geek in training
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 6:16 AM
To: MySQL (E-mail) (E-mail)
Cc: Rochester, Dean
Subject: RE: How do you set the char format for a column in Mysql table
* Rochester
* Rochester, Dean
> I have a Mysql table with a char(2) column, name is Dependents.
> I want the value that I insert to always be to places. I have tried
>
> Insert into Table1 Dependents values '02';
>
> but it inserts 2 in the Dependents column
Really? It is not valid SQL...
mysql> create ta
Will the data in this field always be numbers? you could just use TINYINT(2)
UNSIGNED ZEROFILL
-Original Message-
From: Rochester, Dean [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 8:56 AM
To: MySQL (E-mail) (E-mail)
Subject: How do you set the char format for a column in
I have a Mysql table with a char(2) column, name is Dependents. I want the
value that I insert to always be to places. I have tried
Insert into Table1 Dependents values '02';
but it inserts 2 in the Dependents column
How do I make it insert 02?
Thanks
Dean-O