Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 关于数据库外键和主键查询的有关问题

关于数据库外键和主键查询的有关问题

WBOY
Release： 2016-06-13 13:39:32
Original
774 people have browsed it

关于数据库外键和主键查询的问题
刚学数据库没多久，请教各位大神：
A表有ID和姓名，B表有ID和分数，B表的ID是A表的外键，如何通过查找A表的姓名就能得到分数！

------解决方案--------------------
select B.fenshu from A join B ON A.id=B.id where A.name='张三';

Related labels：
id name select where
source：php.cn
Previous article： 请教大家都用什么PHP开发工具 Next article： 求教mysql批量更新有关问题
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
SQL Count() also requires 0 I have only one table and I want to count each entry of a tag that starts with 0. Now I tr...
From 2024-04-06 19:48:53
0
1
449
sql groupby not working, I want to group by code_branch ->select('a.statusasstatus','b.nameascustomer_name','e.nameasbranch_name','c.nameas...
From 2024-04-06 19:24:49
0
2
488
An error was encountered while trying to retrieve the latest version of a package from search.maven.org "Error: Unable to retrieve data from Maven repository" while retrieving latest v...
From 2024-04-05 12:11:23
0
1
1471
Modify matSelect style when displaying options How to change properties of mat-select when option is on? <mat-selectclass="select...
From 2024-04-05 09:23:19
0
1
1374
Echo inside div with nested echo I'm trying to use echo<?phprequire'connect.php';$query=mysqli_query($conn,"SELECT*...
From 2024-04-04 11:09:23
0
1
390
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template