insert data into table having foreign key

Question

I have two tables linked as follows:

CREATE TABLE `property_details`( id INT NOT NULL, `name` VARCHAR(100), PRIMARY KEY(id) )

and

CREATE TABLE `hilton`( `property_id` INT NOT NULL, `start_date` DATE DEFAULT NULL, `end_date` DATE DEFAULT NULL, `msg` VARCHAR(100) DEFAULT NULL, `sunday` INT(11), `monday` INT(11), `tuesday` INT(11), `wednesday` INT(11), `thursday` INT(11), `friday` INT(11), `saturday` INT(11), FOREIGN KEY(property_id) REFERENCES property_details(id) )

I insert data in property_details table. eg..

INSERT INTO property_details(`id`,`name`) VALUES ('1','Hilton');

Now, i want to enter data in hilton table. Can u tell me how should i write query for entering data in hilton table?

exactly like how you inserted data into the property_detail table! — e4c5
– e4c5, Commented Sep 21, 2016 at 11:06
I have mentioned the query for entering data in property_details table — Radhika Kulkarni
– Radhika Kulkarni, Commented Sep 21, 2016 at 11:08

rbr94 · Accepted Answer · 2016-09-21 11:15:03Z

1

You firstly have to insert data in the PrimaryKey Table (property_details), so that there is a PrimaryKey you can reference in the ForeignKey Table (hilton).

1)

INSERT INTO property_details('id','name') VALUES ('1','Hilton');

2)

INSERT INTO hilton ('property_id',...) VALUES ('1',...);

edited Sep 21, 2016 at 11:15

answered Sep 21, 2016 at 11:11

rbr94

2,2874 gold badges27 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Radhika Kulkarni Over a year ago

This does not work! I am getting following error: " INSERT INTO hilton(property_id,start_date,end_date,msg,sunday,monday,tuesday,wednesday,thursday,friday,saturday) VALUES ('1', '2016-9-9','2016-9-9','AI','100','100','100','100','100','100','100');"

rbr94 Over a year ago

Then what's your error. You don't give the mysql error above in your comment. That's just the statement!

Community · Accepted Answer · 2017-05-23 10:27:24Z

Just insert as before:

INSERT INTO hilton(`property_id`, `sunday`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`) VALUES (1, 0, 1, 2, 3, 4, 5, 6);

See this SQL fiddle: http://sqlfiddle.com/#!9/456ba/1

Probably see also: how to insert foreign key in a table

Collectives™ on Stack Overflow

insert data into table having foreign key

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related