How we can use the primary key in another table

Question

I have Two table

customer table which has contained the information of the customer. But it has an account number we make a primary key of the account number.
And now the second Table is Bill Table.I've use the account number of the customer table when we update some information about the Bill table then will update is automatically of the particular account number

so, please tell me how we can resolve this problem, and how we can use the foreign key of Bill table

Please search about Foreign Key and its feature: `ON UPDATE CASCADE` — Madhur Bhaiya, Oct 05 '19 at 10:00
I have no idea what you are asking for. Can you please add sample data from both tables , an example of the process and the desired outcome (as text in the question). — P.Salmon, Oct 05 '19 at 10:10

score 0 · Answer 1 · answered Oct 05 '19 at 12:48

I think what you are asking is how to update the Customer table at the same time when you are updating Bill table.

You can easily use a stored procedure to achieve this task. Within the stored procedure you can use transactions to make sure the 2nd update happens only if the first update is succeded. Otherwise, you can rollback.

score 0 · Answer 2 · answered Oct 05 '19 at 22:44

So imagine that this is your customer table:

CREATE TABLE customer (
    AccountNum int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    PRIMARY KEY (AccountNum)
);

PRIMARY KEY (AccountNum) > so you have a primary key in that table. Kudos!

CREATE TABLE BillTable (
    OrderID int NOT NULL,
    OrderNumber int NOT NULL,
    AccountNum  int NOT NULL,
    PRIMARY KEY (OrderID),
    FOREIGN KEY (AccountNum) REFERENCES customer(AccountNum)
);

Now you linked customer and BillTable.

generic question... generic answer. But hope this helps anyone. — skmala, Oct 05 '19 at 22:46

How we can use the primary key in another table

2 Answers2