Lookup used Version of MySql && MySql Foreign Keys and Referencial Integrity

[Vince Veggus]

Hello,

I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the
used version. What is the command to do that? (according to mysql.info
it is Version 3.23.42. )

Are foreign keys and referencial integrity supported by MySQL Version
3.23.42. ?
If yes - why is the second "insert into" command allowed? (see below)

-- 
Thanks in Advance and Best regards,
 Vince                          mailto:[EMAIL PROTECTED]






drop table FremdeNLTB;
drop table FNL_ErkennungTB;

create table FremdeNLTB
   (
      FN_ID int unsigned not null,
      Topic varchar(255),
      Name varchar(255),
      KatIK int unsigned,
      Primary Key (FN_ID),
      Index (FN_ID)
   )
   Type=InnoDB
;
create table FNL_ErkennungTB
   (
      FNLE_ID int unsigned not null,
      FN_ID int unsigned not null,
      receivedFrom varchar(255),
      originFrom varchar(255),
      receivedBy varchar (255),
      originSentTo varchar (255),
      Primary Key (FNLE_ID),
      Index (FN_ID),
      Foreign Key (FN_ID)
         References FremdeNLTB(FN_ID)
         On Delete Cascade
         On Update Cascade
   )
   Type=InnoDB
;
insert into FremdeNLTB
   values
      (11,'lost+found','lost+found',999),

      (21,'MS/Windows','lost+found',999),
      (22,'MS/Windows','Cluster',999),
      (23,'MS/Windows','Plattform-Migration',999),

      (31,'MPE','lost+found',999),

      (41,'LINUX','lost+found',999),

      (51,'OpenView','lost+found',999),
      (52,'OpenView','SAM',999),
      (53,'OpenView','Omniback2',999),

      (61,'Storage/SAN','lost+found',999),
      (62,'Storage/SAN','XP',999),
      (63,'Storage/SAN','EMC',999),
      (64,'Storage/SAN','VA',999),

      (71,'Applications','lost+found',999),
      (72,'Applications','SAP',999),
      (73,'Applications','ORACLE',999)
;
insert into FNL_ErkennungTB
   values
      (1,11,'','','','')
;
insert into FNL_ErkennungTB
   values
      (123,123,'this','should','not be','possible!!!')
;


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]