[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Bug-gnubg] Relational database minor change suggestion
From: |
Holger |
Subject: |
Re: [Bug-gnubg] Relational database minor change suggestion |
Date: |
Tue, 31 May 2005 19:06:03 +0200 |
On Tue, 10 May 2005 08:28:43 +0200, Jim Segrave wrote:
> The table name 'match' is a reserved word in mysql, making it not
> possible to use mysql with gnubg.
You can quote all names of databases, tables, columns and aliases with
backticks (`match`) and thus use reserved words or spaces.
> If we do change it, does anyone know if you can just do
> ALTER TABLE match RENAME TO bgmatch;
> and have that also change the constraints for an existing database?
This will only change this table, not any other table or a constraint
of that table to the table being changed. Therefore these tables must
also be altered. (ALTER TABLE DROP FOREIGN KEY ... ; ALTER TABLE ...
ADD FOREIGN KEY ... REFERENCES ...)
Regards,
Holger