•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 391,592 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,717 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 10540 | Replies: 2
 |
•
•
Join Date: Oct 2005
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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: Oct 2005
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
hai i am also new
•
•
Join Date: Jul 2004
Posts: 191
Reputation:
Rep Power: 5
Solved Threads: 2
Junior Poster
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;
Hope it helps.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
- 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
