|
|
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
Navigation:
[Reply to this message]
|