注意连接类型的拼写错误
原文英文,约300词,阅读约需1分钟。发表于: 。I noticed a typo in one of my sql queries today, but the funny thing is the query still worked fine. It looked something like this: SELECT * FROM table_1 LEFFT JOIN table_2 USING...
在SQL查询中发现拼写错误,导致表的别名不正确,执行了INNER JOIN而非LEFT JOIN。这强调了语法高亮的重要性,错误拼写未高亮显示,可能导致错误结果。