| | |
How To Create Foreign Key
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Oct 2005
Posts: 1
Reputation:
Solved Threads: 0
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!
![]() |
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 |
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





