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
_______________________________________________
Bug-gnubg mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/bug-gnubg
