easypopulate, How to change sql database field?

[Elazar]

Hi !

 

Could someone help me please ??

 

I use easypopulate 2.78v. I want to increase the product_model field from 12 chars to 20 or even 25 chars, that it will allow me to use long serial numbers.

 

What is the sql command do I need to use ??

 

Any help will be much appreciated !

 

Thanks in advance :)

 

Regards,

 

Elazar

[kgt]

You can just use phpMyAdmin to increase the field size. It's an option in the tabel detail to edit a field definition.

[Elazar]

You can just use phpMyAdmin to increase the field size. It's an option in the tabel detail to edit a field definition.

 

 

Thanks a lot kgt !

 

I found that I need to modify 2 fields. I can use also the SQL Text Tool with the further commands. Is it right to do it this way ??

 

Paste the code below for each table into the sql query box in phpMyAdmin changing the number 12 to a new number and click save.

 

 

alter table osc_products change products_model products_model varchar(25);

 

alter table osc_orders_products change products_model products_model varchar(25);

 

Thanks

 

Regards,

Elazar

[kgt]

If you have the SQL, or know the language, you can use the SQL tab. If you're not familiar with SQL or don't have an SQL statement to run, then you can use the tools that phpMyAdmin provides to alter the table. In the background, phpMyAdmin is performing the same SQL statement.