Are you using InnoDB for you tables?

Lasitha Alawatta wrote:
> Hello,
> 
>  
> 
> I have 2 issue, regarding MySQL “Foreign Key”.
> 
> I have two tables;
> 
> Table 01 */CUSTOMER/*
> 
> column name
> 
>       
> 
> characteristic
> 
> SID
> 
>       
> 
> Primary Key
> 
> Full_Name
> 
>       
> 
>  
> 
>  
> 
> Table */ORDERS/*
> 
> column name
> 
>       
> 
> characteristic
> 
> Order_ID
> 
>       
> 
> Primary Key
> 
> Order_Date
> 
>       
> 
>  
> 
> Customer_SID
> 
>       
> 
> Foreign Key
> 
> Amount
> 
>       
> 
>  
> 
>  
> 
> When I run “ALTER TABLE ORDERS ADD FOREIGN KEY (customer_sid) REFERENCES
> CUSTOMER(SID);” that sql statement,
> 
>  
> 
> I inserted 2 records to both tables.
> 
> _ _
> 
> _Question No. 01._
> 
> Then I removed 1 record from CUSTOMER table. But It want give any error
> message. It should give an error message, because in ORDERS table
> already have some records relevant to the deleted customer record in
> CUSTOMER table.
> 
>  
> 
> Question is why it want give any error ? (I’m using phpMyAdmin)
> 
>  
> 
> _Question No. 02._
> 
> Is there any tool available for to get a Database diagram (like in MS
> SQL Server). I found a tool call “DBDesigner 4”. But it wants show the
> DB Diagram.
> 
>  
> 
>  
> 
> Thanks in Advance,
> 
> Lasitha.
> 
>  
> 
>  
> 
> 
> 
> 
> DOTW DISCLAIMER:
> 
> This e-mail and any attachments are strictly confidential and intended for 
> the addressee only. If you are not the named addressee you must not disclose, 
> copy or take
> any action in reliance of this transmission and you should notify us as soon 
> as possible. If you have received it in error, please contact the message 
> sender immediately.
> This e-mail and any attachments are believed to be free from viruses but it 
> is your responsibility to carry out all necessary virus checks and DOTW 
> accepts no liability
> in connection therewith. 
> 
> This e-mail and all other electronic (including voice) communications from 
> the sender's company are for informational purposes only.  No such 
> communication is intended
> by the sender to constitute either an electronic record or an electronic 
> signature or to constitute any agreement by the sender to conduct a 
> transaction by electronic means.
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to