将一个表的id添加到另一个表中以获取特定值mysql [关闭]
问题描述：
+----+----------+-----+-----------+----------+
| ID | NAME | AGE | ADDRESS | SALARY |
+----+----------+-----+-----------+----------+
| 1 | Ramesh | 32 | Ahmedabad | 2000.00 |
| 2 | Khilan | 25 | Delhi | 1500.00 |
| 3 | kaushik | 23 | Kota | 2000.00 |
| 4 | Chaitali | 25 | Mumbai | 6500.00 |
| 5 | Hardik | 27 | Bhopal | 8500.00 |
| 6 | Komal | 22 | MP | 4500.00 |
| 7 | Muffy | 24 | Indore | 10000.00 |
+----+----------+-----+-----------+----------+
+-----+---------------------+-------------+--------+
| OID | DATE | CUSTOMER_ID | AMOUNT |
+-----+---------------------+-------------+--------+
| 102 | 2009-10-08 00:00:00 | | 3000 |
| 100 | 2009-10-08 00:00:00 | | 1500 |
| 101 | 2009-11-20 00:00:00 | | 1560 |
| 103 | 2008-05-20 00:00:00 | | 2060 |
+-----+---------------------+-------------+--------+
Here i have a two table and i want to add one tables customer id to the another table , please help me on this
+ ---- + ---------- + ---- - + ----------- + ---------- + \ N | ID | NAME | 年龄| 地址| SALARY |
+ ---- + ---------- + ----- + ----------- + ---------- + \ N | 1 | 拉梅什| 32 | 艾哈迈达巴德| 2000.00 |
| 2 | Khilan | 25 | 德里| 1500.00 |
| 3 | kaushik | 23 | 哥打| 2000.00 |
| 4 | Chaitali | 25 | 孟买| 6500.00 |
| 5 | 哈迪克| 27 | 博帕尔| 8500.00 |
| 6 | Komal | 22 | MP | 4500.00 |
| 7 | Muffy | 24 | 印多尔| 10000.00 |
+ ---- + ---------- + ----- + ----------- + ---------- + \ ñ\ N + ----- + + --------------------- ------------- + ----- --- + \ N | OID | 日期| CUSTOMER_ID | AMOUNT |
+ ----- + --------------------- + ------------- + ---- ---- + \ N | 102 | 2009-10-08 00:00:00 | | 3000 |
| 100 | 2009-10-08 00:00:00 | | 1500 |
| 101 | 2009-11-20 00:00:00 | | 1560 |
| 103 | 2008-05-20 00:00:00 | | 2060 |
+ ----- + --------------------- + ------------- + ---- ---- +
code> pre>
这里我有一个两个表，我想将一个表客户ID添加到另一个表中，请帮我这个 p >
div>
答
You can do it with SQL FOREIGN KEY Constraint on ALTER TABLE. You can see the documentation here.
ALTER TABLE first_table_name
ADD FOREIGN KEY (id)
REFERENCES second_table_name(CUSTOMER_ID)
It should work.