MySql什么是插入预订的最佳方式

Question

I have a database that looks like this

I was wondering with the separate tables and such, do i insert everything one table at a time, Like insert a row in booking, insert a row in the Customers, and last insert a row in Booking_has_Customers? Is there an easier way to do this?

Halls is unchanging just in case they have more rooms to hire.

And when retrieving data from the database, is it best to use a join on the foreign keys to get a full overview incase i need all data?

Thanks in advance!

Answer 1

1. No there is no easier way, you need to insert the data to each table individually. However, this is the exact situation that asks for transactions. Transactions ensure that either all required insertions happen, or none of them.

2. This question is pretty broad and cannot be generally answered. If it makes sense to retrieve data from multiple tables, then joins could be a good answer and foreign keys are good starting points for a join condition. But a join condition may have contain expressions beyond the foreign keys. It all depends the actual use case.

I would rather ask specific questions for specific use cases for reports / queries in separate questions. This way you can get answers tailored to the exact question.