blocks|key|13424|text|图书表格：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|13425|13426|id|unordered-list-item|13427|name|13428|author|13429|13430|作者表：|13431|13432|13433|13434|13435|获取包括作者姓名在内的所有图书。|13436|SELECT+*+FROM+Books+LEFT+JOIN+Auhtors+ON+Authors.id+=+Books.author|code-block|syntax|javascript|13437|获取特定作者的所有图书：|13438|SELECT+*+FROM+Books+WHERE+Author+=+$authorID|13439|如果您了解基本的SQL，我认为这并不难理解|13440|entityMap^0|0|5|0|0|0|0|0|0|0|4|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@$9|1A|A|1B|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|1C|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|1D|8|@]|D|@]|E|$]]|$1|J|3|K|5|I|7|1E|8|@]|D|@]|E|$]]|$1|L|3|M|5|I|7|1F|8|@]|D|@]|E|$]]|$1|N|3|-4|5|6|7|1G|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|1H|8|@$9|1I|A|1J|B|C]]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|1K|8|@]|D|@]|E|$]]|$1|R|3|H|5|I|7|1L|8|@]|D|@]|E|$]]|$1|S|3|K|5|I|7|1M|8|@]|D|@]|E|$]]|$1|T|3|-4|5|6|7|1N|8|@]|D|@]|E|$]]|$1|U|3|V|5|6|7|1O|8|@]|D|@]|E|$]]|$1|W|3|X|5|Y|7|1P|8|@]|D|@]|E|$Z|10]]|$1|11|3|12|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|13|3|14|5|Y|7|1R|8|@]|D|@]|E|$Z|10]]|$1|15|3|16|5|6|7|1S|8|@]|D|@]|E|$]]|$1|17|3|-4|5|6|7|1T|8|@]|D|@]|E|$]]]|18|$]]

Books table:

<ul>
<li>id</li>
<li>name</li>
<li>author</li>
</ul>

Authors table:

<ul>
<li>id</li>
<li>name</li>
</ul>

Getting all Books including the author's name.

<pre><code>SELECT * FROM Books LEFT JOIN Auhtors ON Authors.id = Books.author
</code></pre>

Getting all Books by a specific author:

<pre><code>SELECT * FROM Books WHERE Author = $authorID
</code></pre>

I think this is not that hard to understand, if you know basic SQL

blocks|key|1258919|text|使用关系数据库，您将在Books表中放置一个authorID列，并将其配置为Authors表中的外键。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1258920|您可以通过SQL连接获取给定图书的作者；也可以通过SQL连接获取所有图书。|1258921|查看这个PHP教程，它解决了一个类似的案例：http://www.roseindia.net/sql/sqljoin/leftJoin.shtml|offset|length|1258922|entityMap|0|LINK|mutability|MUTABLE|url|http://www.roseindia.net/sql/sqljoin/leftJoin.shtml^0|0|0|M|1F|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

Using a relational DB, you'd put an authorID column in the Books table and configure that to be a foreign key into Authors table.

You'd get the author of a given book via a SQL join; you could also get all the Books via a SQL join as well.

Check out this PHP tutorial which addresses a similar case: <a href="http://www.roseindia.net/sql/sqljoin/leftJoin.shtml" rel="nofollow">http://www.roseindia.net/sql/sqljoin/leftJoin.shtml</a>

blocks|key|4054018|text|您的数据库架构...|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4054019|books|offset|length|style|CODE|4054020|4054021|id+INT|unordered-list-item|BOLD|4054022|title+VARCHAR|4054023|author_id+INT|4054024|4054025|authors|4054026|4054027|id+INT|4054028|name+VARCHAR|4054029|4054030|4054031|books表中的author_id字段将对应于authors表中的id字段。然后，您可以通过简单的连接将两者结合起来，并提取所需的数据……在这项工作中，MySQL+manual是你的朋友，或者这里是a+simple+RIGHT+JOIN+/+LEFT+JOIN+tutorial。|4054032|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.6/en/left-join-optimization.html|1|http://phpweby.com/tutorials/mysql/32^0|0|0|5|0|0|0|2|0|0|5|0|0|9|0|0|0|7|0|0|0|2|0|0|4|0|0|0|8|9|X|2|24|C|0|2R|14|1|0^^$0|@$1|2|3|4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1D|8|@$D|1E|E|1F|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|1H|8|@$D|1I|E|1J|F|L]]|9|@]|A|$]]|$1|M|3|N|5|K|7|1K|8|@$D|1L|E|1M|F|L]]|9|@]|A|$]]|$1|O|3|P|5|K|7|1N|8|@$D|1O|E|1P|F|L]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1R|8|@$D|1S|E|1T|F|G]]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]|$1|U|3|V|5|K|7|1V|8|@$D|1W|E|1X|F|L]]|9|@]|A|$]]|$1|W|3|X|5|K|7|1Y|8|@$D|1Z|E|20|F|L]]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|21|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|22|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|23|8|@$D|24|E|25|F|G]|$D|26|E|27|F|G]]|9|@$D|28|E|29|1|2A]|$D|2B|E|2C|1|2D]]|A|$]]|$1|12|3|-4|5|6|7|2E|8|@]|9|@]|A|$]]]|13|$14|$5|15|16|17|A|$18|19]]|1A|$5|15|16|17|A|$18|1B]]]]

Your database schema ...

<h2><code>books</code></h2>

<ul>
<li>id INT</li>
<li>title VARCHAR</li>
<li>author_id INT</li>
</ul>

<h2><code>authors</code></h2>

<ul>
<li>id INT</li>
<li>name VARCHAR</li>
</ul>

<hr>

The <code>author_id</code> field in the books table will correspond to the <code>id</code> field in the authors table. You would then do simple joins to combine the two and pull out the data you need ... The <a href="http://dev.mysql.com/doc/refman/5.6/en/left-join-optimization.html" rel="nofollow">MySQL manual</a> is your friend in this endeavor, or here is <a href="http://phpweby.com/tutorials/mysql/32" rel="nofollow">a simple RIGHT JOIN / LEFT JOIN tutorial</a>.

blocks|key|1256155|text|所以您想要books表和authors表之间的关系？|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1256156|您要做的就是使用一个作者id作为主键来设置authors表。然后，每行将包含一个作者。在books表中，您可以添加有关该书的所有必要信息的列，包括作者。这里的author列应该是一个整数，它将包含authors表中列出的作者的id。|1256157|除此之外，还应该使books表中的author列成为指向authors表和id列的外键。|1256158|当您需要一本书的相关信息时，您可以使用JOIN来连接两个表，并为您提供有关作者的信息。这也适用于作者的个人资料。您只需在book表上指定一个简单的查询，以列出具有作者id的所有图书。|1256159|entityMap^0|5|5|C|7|0|18|5|2Q|7|0|S|7|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]|$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|X|8|@$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|10|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|M|$]]

So you want a relation between the <code>books</code> table and the <code>authors</code> table?

What you do is set up your authors table with an author id as your primary key. Each row will then contain one author. In your <code>books</code> table you add columns for all necessary information about the book, including the author. The author column should here be an integer that will contain the id of the author listed in the <code>authors</code> table. 

In addition to this you should make the author column, in the books table, a foreign key that points towards the <code>authors</code> table and id column.

When you want information regarding a book you'll use JOIN to connect both tables and give you information about the author aswell. This also goes for the profile of the author. You just specify a simple query on the books table to list out all books with the authors id.

I'm working on a site that handles books, and in my database I want to have 2 tables, one for Books and one for Authors.

The problem is, that I want to have a column in the books that points to the author, so when a person views a book he could have a button to go to the author's page.

And probably the bigger problem:
In the authors' page I want to have a list of books by that author and the ability to click on each book to view it.

I don't know what data-type to associate with the coloumns and how to make them interact with each other.

I'd be happy to get an explaination, a guide or a good reference.

Connecting 2 tables

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我在一个处理书籍的网站上工作，在我的数据库中，我想有两个表，一个用于图书，一个用于作者。问题是，我想在书中有一个指向作者的列，这样当一个人查看一本书时，他可以有一个按钮转到作者的页面。可能还有更大的问题:在作者的页面中，我想要有该作者的书籍列表，并能够单击每本书来查看它。我不知道将什么数据类型与列相关联，以及如何使它们彼此交互。我会很高兴得到一个解释，一个指南或一个很好的参考。

问连接2个表
EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问连接2个表EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问连接2个表
EN