As shown in figure why first is not null, even have a code for a second there was a row is null MySQL8.0 is version

CodePudding user response:

With MySQL version should it doesn't matter, use this tool has a relationship with you,
The first query can because is considered by tool cannot update the view data, and the second query is a single table query, allowed to change data, so appear blank rows?