Re: [PHP-DB] Updating MySQL Database after install

You need to use the ALTER statement. doc: 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 wrote: > Hi, > I am wanting to get

[PHP-DB] Updating MySQL Database after install

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 wi