Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Changing "products_model" Field in Database


a.forever

Recommended Posts

Posted

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.

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...