no; you'll have to do a little workaround (no guarantee!!):
in order to change table1.field2 from integer to float:
[store the whole table in a temp table]
create table temp as select from table1;
[now CHECK the temporary table so nothing is lost! don't ignore errors! because next we'll do:]
drop table table1;
[now rebuild the original table with the data type changed:]
create table table1(......., field2 float, .....);
[restore the original data]
insert into table1 select from temp;
[re-CHECK data!]
drop table temp;
note:
will only work if the new field can hold the old field's values (integer->float)
if you plan to insert numbers into a text field, you might need to convert the values to char!
* do this only if you know exactly what you're doing and that it will work- otherwise you'll risk data loss. in doubt, better leave it.
