on delete cascade works for self-referencing row but on update cascade isn't?

ssage: ERROR 1217: Cannot delete or update a parent row: a foreign key constraint fails Any ideas why this is occurring? Regards, Jindo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 4.0.2 & my.cnf

in my.cnf, it began to run without a problem. Am I doing something wrong or is this a known/hidden bug in 4.0.2? Yours, Jindo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.m

RE: Connect to Database over the Internet

should give you the answer. Check if root is only allowed to connect from 127.0.0.1 (localhost) Hope this helps. SolNET Digital Jindo <[EMAIL PROTECTED]> Tel: +886 2 26547645 Fax:+886 2 26515005 Cell: 0922706509 -Original Message- From: Bryan [mailto:[EMAIL PROTECTED]] Sent: Wed

Re: Database Design

ore related to database design and preferably have some real-world scenarios as examples. Regards, Jindo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: Database connection error

tabase privileges AND host privileges) (defined in table db and table host) OR table privileges (defined in table tables_priv) OR column privileges (defined in table column_priv) You can find in-depth explanation from the documentations so check it out :) Cheers, Jindo -Original Message

Data Type - tinyint(1) vs tinyint(4)

T output. TINYINT(1) and TINYINT(4) gives the exact same output. Any ideas? Jindo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

RE: newbie question AUTO_INCREMENT

test; auto_increment column must be keyed and only one auto_increment col is allowed per table. Regards, Jindo > -Original Message- > From: Kevin Haughton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 17, 2001 3:01 AM > To: [EMAIL PROTECTED] > Subject: newbie question

MySQL 4.0 alpha source build with pgcc

0-alpha-source --disable-shared --enable-assembler --with-extra-charsets=none --with-mysqld-ldflags=-a ll-static --with-openssl --with-innodb --without-debug Regards, Jindo - Before posting, please check: http://www.mysql.com/ma

Change character set for client

still says: character set latin1. Insertions of certain Chinese characeter that has \ in it cannot be properly escaped and end up being garbled. Please shed some lights here. Thanks Regards, Jindo - Before posting, please

RE: insert BLOB in perl

values(?)")->execute($data)' Study the error message, you should get the idea as to why you have problems inserting binary data into MySQL when it's running using big5 as charset. Regards, Jindo > -Original Message- > From: Vincent Chen [mailto:[EMAIL PROTECTED