Re: new column in mysql
| From: | Randy Clamons | Date: | Fri, 29 Apr 2005 22:54:03 +0000 |
| Subject: | Re: new column in mysql | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-25942@lists.php.net to get a copy of this message | ||
Ross,
How are you inserting the data into your mySql table? If you create your table definition before you
insert the data, the column data will be filled in for you.
Randy Clamons
Systems Programming
Novaspace.com
> ------------Original Message------------
> From: "Ross Hulford" <ross@aztechost.com>
> To: php-windows@lists.php.net
> Date: Fri, Apr-29-2005 2:34 PM
> Subject: [PHP-WIN] new column in mysql
>
> Hi,
>
> I have a table with 15 columns or so that has been inherited from an
> older
> db and am trying to insert an auto increment column (in mysql) without
> having to number it manually. This is fine when I add new colums via a
> form
> but the old entries have a null value
>
> Alternatively It has been converted from Excel soif anyone knows how to
> do
> it that way that would help.I never use Excel so have no clue about it.
>
>
> R.