Do MySQL are going to support NULL value for foreign key fields (in case parent are not null)

Hi All. Do MySQL are going to support NULL value for foreign key fields (in case parent are not null) I didn't found any mentions about this problem in news or somewhere else. If you have any kind of info please answer. Because so hard to use foreign keys without this option. Sincerely yours,

Re: A sum of a few columns in where clause?

>> I've got query like this: >> "select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C + >> TABLE.D) > 0" >> A,B,C,D are decimal values. >> The problem is, I think, with NULL columns. Often B,C and D don't >> have decimal value, but NULL. >> I thought, that this should be counte

ALTER TABLE & Foreign key problems

Hi. I am using MySQL 3.23.44-max and InnoDB tables. I also using foreign key in my tables. I have problem, I couldn't alter my table and add any foreign keys. SQL like this: alter table data_entry add FOREIGN KEY (data_task_id) REFERENCES data_task(identity); give me any error but key doesn't crea

Join problem, Please help.

Hi. I am running MySQL 3.23.44-Max I have 2 tables. Table "A" +---++ IDName +---++ 1 string 1 2 string 2 +---++ Table "B" +---++ IDName +---++ 2 string 2 3 string 3 +---++ And I need result +---++ ID

MySQL + InnoDB + fereign keys

Hi. I am using MySQL 3.23.44-MAX. with InnoDB I have create two tables (one of them parent, other child). All seems Ok. But when I am trying to insert new record into the table I am getting key violation. It happened when I am trying insert null value into field that have foreign key. (column c