Phpmyadmin

[xTremoxx]

Hello friends, i need to add this structures in House Table:

`bid` int(11) NOT NULL DEFAULT '0',
 `bid_end` int(11) NOT NULL DEFAULT '0',
 `last_bid` int(11) NOT NULL DEFAULT '0',
 `highest_bidder` int(11) NOT NULL DEFAULT '0',

What command i need to use in phpmyadmin?

 

[Rombadr]

ALTER TABLE houses_or_whatever_the_name_is
    ADD COLUMN bid int (11) NOT NULL DEFAULT '0',
    ADD COLUMN bid_end int (11) NOT NULL DEFAULT '0',
    ADD COLUMN last_bid int (11) NOT NULL DEFAULT '0',
    ADD COLUMN highest_bidder int (11) NOT NULL DEFAULT '0';

Change houses_or_whatever_the_name_is to the table name

 

[xTremoxx]

Tks to reply, i get error:

1. Missing comma before start of a new alter operation. (near "ADD" at position 74)

 

[Rombadr]

Edited my post, the error explains the issue pretty well though

 

[pink_panther]

Tks to reply, i get error:

1. Missing comma before start of a new alter operation. (near "ADD" at position 74)

yeah, if you honestly can't figure it out from here, you probably shouldn't even be touching an SQL database. :|

ALTER TABLE 'houses_or_whatever_the_name_is'
    ADD COLUMN bid int (11) NOT NULL DEFAULT '0',
    ADD COLUMN bid_end int (11) NOT NULL DEFAULT '0',
    ADD COLUMN last_bid int (11) NOT NULL DEFAULT '0',
    ADD COLUMN highest_bidder int (11) NOT NULL DEFAULT '0';