MySQL Forums
Forum List  »  Other Migration

Advanced Search
New Topic

Isue with Decimal datatype and auto increment
Posted by: vijayanand kalyanaraman
Date: September 23, 2009 06:52PM

Hi,
I am migrating data from Oracle to My sql database
I have fields whose datatype is number(38,0) in oracle. Upon migration the fileds data type is Decimal(38) in My sql. But i am unable to set Auto increment flag for this field. Changing to bigint will not work as its max size is limited to 20 digits. Have tried binary datatype as well, but not able to flag that coulum as auto increment

Please advise
Thanks,
Vijay

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Isue with Decimal datatype and auto increment
6242
vijayanand kalyanaraman
September 23, 2009 06:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.