Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

how to modify mysql


commtheos

Recommended Posts

I'm trying to run this code

 

ALTER TABLE `orders` ADD `cc_cvv2` VARCHAR(4) AFTER `cc_number`;

 

for my site and I have not figured out how to. I have my username and pw for ftp but I couldn't get myphpadmin to work. Anybody have some simple instructions how to run this code. This is all I want to do.

 

Thank you

Link to comment
Share on other sites

You need to log into your phpmyadmin. Select your database name from the dropdown list on the left. Then click on SQL on the top right.

On the new page you will see a text box. Copy and paste the code you posted above into that box then click on Go and you are all set.

Wendy James

 

Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...