At 05:26 8/1/2004 +0100, Morten Gulbrandsen wrote: Hi,
I wasn't able to repeat:
Microsoft Windows XP [versão 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp.
c:\>cd\mysql\bin
C:\mysql\bin>mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.0-alpha-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> 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;
Query OK, 0 rows affected, 1 warning (0.11 sec)mysql> DESCRIBE A; +----------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+---------+------+-----+---------+-------+ | SSN | char(9) | | PRI | | | | SUPERSSN | char(9) | YES | MUL | NULL | | | DNO | int(11) | | MUL | 1 | | +----------+---------+------+-----+---------+-------+ 3 rows in set (0.00 sec)
mysql> ALTER TABLE A
-> ADD FOREIGN KEY (SUPERSSN) REFERENCES A(SSN)
-> ON DELETE SET NULL
-> ON UPDATE CASCADE;
Query OK, 0 rows affected (0.27 sec)
Records: 0 Duplicates: 0 Warnings: 0Please verify if your MySQL stuff has all the below files:
C:\mysql\bin>dir c:\mysql\data\mysql O volume na unidade C é Disk 1 Partition 1 O número de série do volume é 0000-0000
Pasta de c:\mysql\data\mysql
07/01/2004 11:39 <DIR> .
07/01/2004 11:39 <DIR> ..
22/12/2003 21:03 8.820 columns_priv.frm
22/12/2003 21:03 0 columns_priv.MYD
22/12/2003 21:03 1.024 columns_priv.MYI
22/12/2003 21:03 9.178 db.frm
22/12/2003 21:03 306 db.MYD
22/12/2003 21:03 3.072 db.MYI
22/12/2003 21:03 8.665 func.frm
22/12/2003 21:03 0 func.MYD
22/12/2003 21:03 1.024 func.MYI
22/12/2003 21:03 8.700 help_category.frm
22/12/2003 21:03 20 help_category.MYD
22/12/2003 21:03 3.072 help_category.MYI
22/12/2003 21:03 8.612 help_keyword.frm
22/12/2003 21:03 0 help_keyword.MYD
22/12/2003 21:03 1.024 help_keyword.MYI
22/12/2003 21:03 8.630 help_relation.frm
22/12/2003 21:03 0 help_relation.MYD
22/12/2003 21:03 1.024 help_relation.MYI
22/12/2003 21:03 8.770 help_topic.frm
22/12/2003 21:03 0 help_topic.MYD
22/12/2003 21:03 1.024 help_topic.MYI
22/12/2003 21:03 9.148 host.frm
22/12/2003 21:03 0 host.MYD
22/12/2003 21:03 1.024 host.MYI
22/12/2003 21:03 9.470 proc.frm
07/01/2004 13:33 156 proc.MYD
07/01/2004 13:33 2.048 proc.MYI
22/12/2003 21:03 8.925 tables_priv.frm
22/12/2003 21:03 0 tables_priv.MYD
22/12/2003 21:03 1.024 tables_priv.MYI
22/12/2003 21:03 9.992 user.frm
22/12/2003 21:03 160 user.MYD
22/12/2003 21:03 2.048 user.MYI
33 arquivo(s) 116.960 bytesMySQL 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]
-- Regards,
For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/
Miguel Angel Solórzano <[EMAIL PROTECTED]> São Paulo - Brazil
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.556 / Virus Database: 348 - Release Date: 26/12/2003
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
