RE: [PHP-DB] Add column to a table

[Walter, Marcel]

For mysql:

Alter table tablename add column column-name columntype;

Regards,
Marcel

-Original Message-
From: Shaun Thornburgh [mailto:shaun;mania.plus.com]
Sent: 31 October 2002 13:39
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Add column to a table


Hi,

Please could someone tell me what the syntax is to add a column to a table?

Thanks



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
If you have received this e-mail in error or wish to read our e-mail 
disclaimer statement and monitoring policy, please refer to 
http://www.drkw.com/disc/email/ or contact the sender.
--


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Add column to a table

[Aaron Wolski]

ALTER TABLE TableName ADD COLUMN columnParametersHere

E.g: ALTER TABLE UserTable ADD COLUMN userName varchar(255);


Aaron
 -Original Message-
 From: Shaun Thornburgh [mailto:shaun;mania.plus.com] 
 Sent: Thursday, October 31, 2002 7:39 AM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] Add column to a table
 
 
 Hi,
 
 Please could someone tell me what the syntax is to add a 
 column to a table?
 
 Thanks
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php