webproclaim Posted October 31, 2006 Share Posted October 31, 2006 I'm trying to change a field in a MySQL database from a text field to a decimal field. Below is a sample of what I am trying to do but it is not working as there is something wrong with the syntax. Would someone mind showing me a 'fixed' version of the code below. Thanks.$ModifyTable = "ALTER TABLE tablename CHANGE fieldname fieldname DECIMAL(10,2) DEFAULT NULL"; Link to comment https://forums.phpfreaks.com/topic/25693-sql-statement-in-php-to-modify-table-in-mysql/ Share on other sites More sharing options...
fenway Posted October 31, 2006 Share Posted October 31, 2006 I thought you needed to say CHANGE COLUMN... and I always use MODIFY instead, since that way you don't have to repeat the fieldname. Link to comment https://forums.phpfreaks.com/topic/25693-sql-statement-in-php-to-modify-table-in-mysql/#findComment-117488 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.