Posted by J.O. Aho on 12/23/05 12:00

Bob Baboie wrote:
> Hi Folks,
>
> I have multpile databases on various domains all using the same table.
>
> Trying to find a simple script to add 2 additional fields to each table
> without manually having to do it.
>
> INSERT INTO `master` (`PermaBotLinkURL`, `PermaBotLink`) VALUES
> ('value01','value02');
>
> This does not work obviously, because trying to instert in to something that
> does not exist

You need to alter the table before you can insert anything new, see
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html


//Aho

[Back to original message]