What is the best way to make a table of books?

Question

MySQL

Hello. There is a table of books and a book, of course, has authors, and since there can be many authors, the question arises, how best to store authors? Make a separate table or write everyone in one field?

Answer 1

And one author can have many books.
Naturally, the authors in a separate table and a many-to-many relationship through the 3rd table
And read about normal forms

Answer 2

my God, have you looked at at least one manual? There are also plenty of detailed examples with books.

Answer 3

In general, the idea is such a
List of books, a list of authors and a separate book-author. Accordingly, there may be several entries about the book, but with different authors
_______________
BookId
BookName
_______________
AuthorId
AuthorName
_______________
Id
BookId
AuthorId