Re: Mysql adding extra fields.
| From: | hugh danaher | Date: | Fri, 29 Mar 2002 06:47:44 +0000 |
| Subject: | Re: Mysql adding extra fields. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-90646@lists.php.net to get a copy of this message | ||
Try,
[type] can be int or char (9999) or blob or real or something else drawn
from the mysql manual
$query="ALTER table_name ADD column_name [type] AFTER other_column_name";
$result=mysql_query($query);
if (!$result) die("couldn't alter table".mysql_error());
Hope this helps,
Hugh
----- Original Message -----
From: "David Duong" <davidduong1@hotmail.com>
To: <php-general@lists.php.net>
Sent: Thursday, March 28, 2002 9:33 PM
Subject: [PHP] Mysql adding extra fields.
> How do I add extra fields after it has already been set?
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>