Is there any difference in the efficiency of the two SQL?

there seems to be no difference between the two SQL implementations.

select * from A 
left join B on A.aid=B.aid
where A.aid=100
select * from (
    select * from A where A.aid=100
) AA
left join B on AA.aid=B.aid

what do you think of SQL performing interpretive analysis?

Mar.14,2021

EXPLAIN select * from A 
left join B on A.aid=B.aid
where A.aid=100;

EXPLAIN select * from (
    select * from A where A.aid=100
) AA
left join B on AA.aid=B.aid

look at the execution plan of the two statements.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b31d9d-e318.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b31d9d-e318.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?