Re: [PHP-DB] mysql question From: Datahntr (ododa <email protected>)
Date: 07/13/00

"Joanna" <joanna <email protected>> wrote in message
news:Pine.LNX.4.21.0007131531310.2448-100000 <email protected>
> I'm new to this world so please bare with me.
>
> I'm currently using php4 and mysql on w2k server, and so far so good
> I got everything running.
>
> I created few tables and inserted some information I would like to add
> another field to an existing table how do I do that? I know you got to use
> ALTER TABLE mytable ????????

The way to find this answer is to RTFM.

ALTER TABLE tablename ADD COLUMN column_def;

where column_def is some valid column definition such as "mynewcol
VARCHAR(10)".

Example: ALTER TABLE sess_track ADD COLUMN page VARCHAR(70);
adds a "page" column to the sess_track table.

That's in TFM (the mySQL manual, section 7.8), and that's a SQL question,
not a PHP question. 

--
O.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>