[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    Re: [PHP-DB] Updating MySQL Database after install
From:       kesavan trichy rengarajan <k7 () trk7 ! com>
Date:       2010-05-05 3:29:46
Message-ID: AANLkTilVYXwgyzSRE1cyFBSGy8-zzNGsNsNa0asJyB3l () mail ! gmail ! com
[Download RAW message or body]


You need to use the ALTER statement.
doc: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html
<http://dev.mysql.com/doc/refman/5.1/en/alter-table.html>example:
http://www.1keydata.com/sql/sql-foreign-key.html

On Wed, May 5, 2010 at 8:21 AM, Karl DeSaulniers <karl@designdrumm.com>wrote:

> Hi,
> I am wanting to get some pointers on how to update my MySQL database after
> there is already members.
> For eg, I am trying to set some foreign keys that were not part of my
> database when I installed it.
> There are members in that database. Can I update the database with the new
> .sql file without loosing my current info? If so, how?
> Fields in the user table have not changed except foreign keys have been
> assigned to it.
> TIA,
>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
>
>


[prev in list] [next in list] [prev in thread] [next in thread]