Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > mysql中关于左连接，取出来的数据顺序和主表不一样

mysql中关于左连接，取出来的数据顺序和主表不一样

WBOY
Release： 2016-06-06 09:33:26
Original
1482 people have browsed it

mysqlsql

如题，楼主最近在跟着视频学习SQL语句，发送自己做出来的效果和老师不一样 如图
这时两张表，学生表和班级表图片说明
要求是查询班级一样的学生信息，查出左连接显示是这样的：图片说明
右连接显示这样图片说明
请问一下为什么左连接查询出来显示数据的顺序不是按照学生表的顺序来啊？学生表不是主表么？为什么我显示出来的itcast顺序完全乱了，而是按照后面右表的id顺序来排？ 求求求，急求大神解疑

Related labels：
mysql sql
source：php.cn
Previous article：svn 安装以后，mysql 就不能用ip登录了。 Next article：关于mysql和hadoop数据交互的问题，和hadoop的文件夹设计
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
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2311
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2445
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
2060
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1948
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
2011
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