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"; Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.