tufanv Expert Licensed User Longtime User Nov 12, 2014 #1 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
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 Expert Licensed User Longtime User Nov 12, 2014 #2 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 Upvote 0
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 Expert Licensed User Longtime User Nov 12, 2014 #3 when i try it with sql command it changed successfuly. Thank you ! Upvote 0
DonManfred Expert Licensed User Longtime User Nov 12, 2014 #4 i cannot see the image. What is the SQL-Command you want to execute with mysql? there must be an error in your query Upvote 0
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 Expert Licensed User Longtime User Nov 12, 2014 #5 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 DonManfred said: i cannot see the image. What is the SQL-Command you want to execute with mysql? there must be an error in your query Click to expand... Upvote 0
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 DonManfred said: i cannot see the image. What is the SQL-Command you want to execute with mysql? there must be an error in your query Click to expand...
