a.forever Posted September 26, 2010 Share Posted September 26, 2010 I'm using Easy Populate, and it's come to my attention that one of my product's model numbers exceeds the default 12 character limit set by osC. I need to change the "products_model" field of the "products" table in my database from 12 to 14 (or more). But since I don't formally know SQL, I don't know the proper code to make this happen in myPHP. Can someone provide the lines of code I need to make this happen? I'm quite sure it's very easy for anyone knowing SQL. Thanks for your time. Link to comment Share on other sites More sharing options...
FIMBLE Posted September 26, 2010 Share Posted September 26, 2010 try ALTER TABLE `products` CHANGE `products_model` `products_model` VARCHAR( 20 ) change to the 20 to what you need , then run in your phpmyadmin Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
a.forever Posted September 26, 2010 Author Share Posted September 26, 2010 Thanks. It worked. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.