a.forever Posted September 26, 2010 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.
FIMBLE Posted September 26, 2010 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.