Jump to content



- - - - -

where do I add new field to table, and where is SQL statement


This topic has been archived. This means that you cannot reply to this topic.
4 replies to this topic

#1   paulgg

paulgg
  • Members
  • 20 posts

Posted 19 May 2006 - 03:55 AM

I am adding the e-way payment modules to accept credit card payments, part of the instructions are to:



c.  Table Change:      Add new field to "orders" table.

    New Field:  eway_id int(11) default 0 NOT NULL



    SQL Statement:
    ----------------------------------------------
    ALTER TABLE orders ADD (eway_id int(11) NOT NULL default '0')


Where do I add new field to table?
Where is the SQL statement?

#2   kgt

kgt
  • Members
  • 2,883 posts

Posted 19 May 2006 - 02:26 PM

Open phpMyAdmin.

Choose your oscommerce database.

Click the SQL tab along the top.

Paste this into the text box that appears:
ALTER TABLE orders ADD (eway_id int(11) NOT NULL default '0')

Click Go.

Have a beer.

#3   paulgg

paulgg
  • Members
  • 20 posts

Posted 19 May 2006 - 10:19 PM

Where do I access phpmyadmin? (I'm new at this)

I thought the instructions below were 2 seperate instructions, will copying the "ALTER TABLE orders ADD (eway_id int(11) NOT NULL default '0')" into the SQL statement also cover the "New Field: eway_id int(11) default 0 NOT NULL
"

thanks for your previous reply.................


c. Table Change: Add new field to "orders" table.

New Field: eway_id int(11) default 0 NOT NULL



SQL Statement:
----------------------------------------------
ALTER TABLE orders ADD (eway_id int(11) NOT NULL default '0')

#4   Jan Zonjee

Jan Zonjee

    Governor of Peace

  • Core Team
  • 7,084 posts

Posted 19 May 2006 - 10:28 PM

View Postpaulgg, on May 20 2006, 12:19 AM, said:

Where do I access phpmyadmin? (I'm new at this)
That is something your ISP usually provides for accessing your database(s). Check their information or contact them for that.

Quote

I thought the instructions below were 2 seperate instructions, will copying the "ALTER TABLE orders ADD (eway_id int(11) NOT NULL default '0')" into the SQL statement also cover the "New Field: eway_id int(11) default 0 NOT NULL
Yes.

You can find documentation on phpMyAdmin on their website.

#5   paulgg

paulgg
  • Members
  • 20 posts

Posted 23 May 2006 - 03:50 AM

Thanks for your help-

I found phpmyadmin in Cpanel, and I will give it a go............................