Enrique Vega wrote:
>
> on 1/17/01 10:35 AM, Enrique Vega at [EMAIL PROTECTED] wrote:
>
> > I am using phpMyAdmin and the table sitegroup has only three fields; id,
> > name, admingroup. It does not have the realm field. I don't know how to "run
> > that statement by hand." I would like to use the browser interface of
> > phpMyAdmin to add the realm field, but I do not know what to set the Type,
> > Attributes,Null,Default, and Extra variables to.
>
> Well, I just tried to add the new "realm" field using phpMyAdmin and
> couldn't do it because php is no longer working due to midgard php. So, can
> someone instruct me how to add the field using telnet mysql?
echo "ALTER TABLE sitegroup ADD COLUMN realm varchar(255) DEFAULT '' NOT
NULL;" | mysql -u midgard -p midgard
Emile
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]