Re: [Bug-gnubg] Relational database minor change suggestion

[Holger]

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