Hello.
> FOREIGN KEY (A_areaNum) REFERENCES Area(areaNum),
Put Area in backticks ('`'). See:
http://dev.mysql.com/doc/refman/5.0/en/legal-names.html
Nabegh Al-Thalji wrote:
> When I execute the following query
>
> CREATE TABLE Sponsor (
> sNum INTEGER UNSIGNED NOT NULL,
> sAdr
Hi,
You are using a reserved function name "AREA" (polygon function) as a
fieldname. Simply change the field's name or try using quotes around
it...
Detlev
> [...]
> FOREIGN KEY (A_areaNum) REFERENCES Area(areaNum),
> [...]
> Any ideas?
--
MySQL General Mailing List
For list archives:
