 |  |  |  |  |  |  |  |
How To Create Foreign Key
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
hi,im really new to MySQL,can some one help me in joining table pls...i hv 2 tables,customer table and record table
customer table with CustomerID,Customer Name,CustomerAddress,
record table with RecordID,CustomerID,Date,
how to make the CustomerID in record as foreign key? how to join that two tables so that record will be deleted when i delete the customer id?
i hope u guys could give me a hand :cry: thanks!
customer table with CustomerID,Customer Name,CustomerAddress,
record table with RecordID,CustomerID,Date,
how to make the CustomerID in record as foreign key? how to join that two tables so that record will be deleted when i delete the customer id?
i hope u guys could give me a hand :cry: thanks!
•
•
Join Date: Jul 2004
Posts: 234
Reputation: 
Solved Threads: 8
Posting Whiz in Training
Just to take note that there is no Foreign key in MySQL unless your database's type is InnoDB. I assume you are using MyISAM.
Hope it helps.
•
•
•
•
DELETE FROM Customer WHERE CustomerID = yourcustomerid;
DELETE FROM Records WHERE CusomerID = yourcustomerid;
|
Similar Threads
- error 1005 at line 46: Can't create table '.\time\entrytab.frm' (errno :150) (MySQL)
- Best way to develop db for survey? (Database Design)
- change primary key (MS SQL)
- Nesting A Table (C#)
- Assigning Foreign Keys (Database Design)
- mySQL foreign keys (MySQL)
- MySQL vs. PostgreSQL (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: Update statement
- Next Thread: problem with autogenerated mysql query
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop legal license licensing linux maintenance mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization
