How can i make these table changes!

[Guest]

Hi,

 

sorry for my stupidity but i was wondering what the MySQL query needs to be (using phpMyadmin) so that i can do this:

 

TABLE CHANGES:

Add the following new fields to products_description table. NOTE: The lengths can be anything you perfer to use.

products_head_title_tag varchar 50

products_head_desc_tag longtext 300

products_head_keywords_tag longtext 300

 

im not sure how to do this. many of the other contributions have a sql file i can upload and run.

 

can any one help?

 

Thanks heaps!

 

P.S. I know crossposting is bad but no answer over in the other section, and i need a quick answer.

[equilla]

Hi,

 

all you need to do is to use phpmyadmin to edit the database. Click on the relevant table in the left pane so that it's structure appears in the right pane and then find the "Add new field" option towards the bottom of the right pane. Enter 3 in the box next to this (as you have 3 fields to enter).

 

Click "Go" and then enter those details in the form that appears.

 

Job done!

 

Cheers,

 

 

 

Mark

[Guest]

Thanks a lot!