Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home Database Mysql Tutorial FEDERATED表的left join问题_MySQL

FEDERATED表的left join问题_MySQL

Jun 01, 2016 pm 01:51 PM
null surface

bitsCN.com

Address 为Innodb表，AppUser 为FEDERATED表，下面的连接查询如果用INNER JOIN 就正常，用left join连接的结果Name全为null，即使有匹配的行，怀疑是mysql的bug

select a.*,b.Name from Address AS a
LEFT JOIN AppUser AS b ON b.AID = a.CheckAdminID
where a.AID=1006948

暂时解决办法：将AppUser改名AppUser1，建个视图AppUser引用AppUser1，结果正常。

bitsCN.com
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

Hot Article

Repo: How To Revive Teammates
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
1 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
How Long Does It Take To Beat Split Fiction?
3 weeks ago By DDD
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Difficulty in updating caching of official account web pages: How to avoid the old cache affecting the user experience after version update?
3 weeks ago By 王林
Show More

Hot tools Tags

Code&IT
Voice
Business
Marketing
AI Detector
Chatbot
Design&Art

Hot Article

Repo: How To Revive Teammates
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
1 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
How Long Does It Take To Beat Split Fiction?
3 weeks ago By DDD
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Difficulty in updating caching of official account web pages: How to avoid the old cache affecting the user experience after version update?
3 weeks ago By 王林
Show More

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Show More

Hot Topics

Where is the login entrance for gmail email?
7296
9
Java Tutorial
1622
14
CakePHP Tutorial
1342
46
Laravel Tutorial
1259
25
PHP Tutorial
1206
29
Show More
Related knowledge
What do undefined and null mean? What do undefined and null mean? Nov 20, 2023 pm 02:39 PM

What do undefined and null mean?

What is the difference between null and NULL in c language What is the difference between null and NULL in c language Sep 22, 2023 am 11:48 AM

What is the difference between null and NULL in c language

When to use null and undefined When to use null and undefined Nov 13, 2023 pm 02:11 PM

When to use null and undefined

What is the difference between null and undefined What is the difference between null and undefined Nov 08, 2023 pm 04:43 PM

What is the difference between null and undefined

How to implement the statement to view table data in MySQL? How to implement the statement to view table data in MySQL? Nov 08, 2023 pm 01:40 PM

How to implement the statement to view table data in MySQL?

How to set read-only permissions on a table in Oracle database? How to set read-only permissions on a table in Oracle database? Mar 06, 2024 pm 03:03 PM

How to set read-only permissions on a table in Oracle database?

Use MySQL to create a recommendation system table to implement the recommendation system function Use MySQL to create a recommendation system table to implement the recommendation system function Jul 02, 2023 am 10:01 AM

Use MySQL to create a recommendation system table to implement the recommendation system function

How to remove null from php array How to remove null from php array Dec 23, 2022 am 10:27 AM

How to remove null from php array

See all articles