Android Question little mysql question

[tufanv]

Hello

I have an existing table with a field working as integer. but when i try to change the type from integer to double i am getting an error :

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') NULL DEFAULT NULL' at line 1

Any ideas why i cant change it ?
ty

 

[LucaMs]

I don't know MySql enough, but you could search on web:
http://stackoverflow.com/questions/1356866/how-do-i-change-the-data-type-for-a-column-in-mysql

 

[tufanv]

when i try it with sql command it changed successfuly. Thank you !

 

[DonManfred]

i cannot see the image. What is the SQL-Command you want to execute with mysql?
there must be an error in your query

 

[tufanv]

via phpmyadmin i couldnt change the type via spinner but i run the sql command at it has been changed from int to double
there is no problem now

i cannot see the image. What is the SQL-Command you want to execute with mysql?
there must be an error in your query