MySQL 5.0.0-alpha-max-nt under win2k a small problem:
If I have a foreign key with reference to the same table, I get an error, ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist what can I do ? Yours Sincerely Morten Gulbrandsen ================================ USE test; DROP TABLE IF EXISTS A; CREATE TABLE A ( SSN CHAR(9) NOT NULL, SUPERSSN CHAR(9), DNO INT NOT NULL DEFAULT 1, PRIMARY KEY (SSN), INDEX (SUPERSSN), INDEX (DNO) )TYPE = INNODB; DESCRIBE A; ALTER TABLE A # line 42 here is the buggy code ADD FOREIGN KEY (SUPERSSN) REFERENCES A(SSN) ON DELETE SET NULL ON UPDATE CASCADE; #ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist mysql> select version(); +--------------------+ | version() | +--------------------+ | 5.0.0-alpha-max-nt | +--------------------+ 1 row in set (0.00 sec) Microsoft Windows 2000 [Version 5.00.2195] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
