db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: is it easy to change int to double?
Date Tue, 01 Apr 2008 00:30:53 GMT
> Is there an easy way to change a column type from int to double while
> automatically converting the data?

One technique is as follows:

1) alter table add double-column
2) update table set double-column = int-column
3) alter table drop int-column

thanks,

bryan


Mime
View raw message