MySQL Database Tables
-
Can anyone here help in creating a Tables with Primary Key and Foreign Key? I have created tables but failed in Primary Key and Foreign Key. I am very new to Database.
CustInfo DealerInfo AssDealerInfo VehicleInfo LineItem
CustID(PK) DealerID(PK) AsDealerID(PK) VID(PK) LineItemID (PK)Now I want a Foreign Key dependency on AssDealerInfo that should have access to all the other tables. How to achieve this?
Your help is much appreciated. Thanks Happy Coding!
-
Can anyone here help in creating a Tables with Primary Key and Foreign Key? I have created tables but failed in Primary Key and Foreign Key. I am very new to Database.
CustInfo DealerInfo AssDealerInfo VehicleInfo LineItem
CustID(PK) DealerID(PK) AsDealerID(PK) VID(PK) LineItemID (PK)Now I want a Foreign Key dependency on AssDealerInfo that should have access to all the other tables. How to achieve this?
Your help is much appreciated. Thanks Happy Coding!
Can you please provide more information about attributes you have in your tables and which ones you would like to have Foreign Key constraints on ? And please explain what have you tried so far. What sort of errors did you get? If you haven't tried anything yet I would point you to these links: [General Create table and Primary Keys] [Foreign Keys]
-
Can you please provide more information about attributes you have in your tables and which ones you would like to have Foreign Key constraints on ? And please explain what have you tried so far. What sort of errors did you get? If you haven't tried anything yet I would point you to these links: [General Create table and Primary Keys] [Foreign Keys]
Thank you for the article. I have gone through it earlier but this time it is nice to read again. And I am using System i Navigator. Now in general DB2 or AS400 how can I create a Stored Procedure with parameters for Insert Statement? I totally agree that when everyone in the world is moving with new technologies and migrating data from AS400 to Oracle/SAP or some other things. I am still using this because my boss just loves AS400 like crazy.
Your help is much appreciated. Thanks Happy Coding!