select sql遇到類似這個問題:
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains no

學習

創作

職場產業

<div class="draft-block draft--p left"><span style="font-weight: bold; ">select sql遇到類似這個問題:<br></span>SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column</div>
<div class="draft-block draft--p left"><span style="font-weight: bold; ">解決方式:<br></span>修改config/database.php中的設定:</div>
<div class="draft--imgNormal draft-block"><div><div style="height:588px" class="image-block-prerender" data-src="https://images.vocus.cc/fce7813b-46e0-4794-b69c-c58901c1e8b8.jpg" data-width="588" data-height="573" data-position="center"></div><figcaption class="imageCaption draft-block" style="cursor:text;display:block"></figcaption></div></div>
<div class="draft-block draft--p left">將strict改為false，也就是取消mysql的嚴格模式的意思。</div>
<div class="draft-block draft--p left"></div>
<div class="draft-block draft--p left"><span style="font-style: italic; ">本筆記參考:<br>1. </span><a href="https://stackoverflow.com/questions/40917189/laravel-syntax-error-or-access-violation-1055-error" target="_blank" class="draft--a"><span style="font-style: italic; ">https://stackoverflow.com/questions/40917189/laravel-syntax-error-or-access-violation-1055-error</span></a><span style="font-style: italic; "><br>2. </span><a href="https://wyq2214368.github.io/2019/07/30/php/laravel-de-groupby-bao-cuo-wen-ti-chu-li/" target="_blank" class="draft--a"><span style="font-style: italic; ">https://wyq2214368.github.io/2019/07/30/php/laravel-de-groupby-bao-cuo-wen-ti-chu-li/</span></a></div>

<p><strong>select sql遇到類似這個問題:<br>
</strong>SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column</p>
<p><strong>解決方式:<br>
</strong>修改config/database.php中的設定:</p>
<p><br></p>
<p>將strict改為false，也就是取消mysql的嚴格模式的意思。</p>
<p><br></p>
<p><em>本筆記參考:<br>
1. </em><a href="https://stackoverflow.com/questions/40917189/laravel-syntax-error-or-access-violation-1055-error"><em>https://stackoverflow.com/questions/40917189/laravel-syntax-error-or-access-violation-1055-error</em></a><em><br>
2. </em><a href="https://wyq2214368.github.io/2019/07/30/php/laravel-de-groupby-bao-cuo-wen-ti-chu-li/"><em>https://wyq2214368.github.io/2019/07/30/php/laravel-de-groupby-bao-cuo-wen-ti-chu-li/</em></a></p>

select sql遇到類似這個問題:
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column

解決方式:
修改config/database.php中的設定:

將strict改為false，也就是取消mysql的嚴格模式的意思。

本筆記參考:
1. https://stackoverflow.com/questions/40917189/laravel-syntax-error-or-access-violation-1055-error
2. https://wyq2214368.github.io/2019/07/30/php/laravel-de-groupby-bao-cuo-wen-ti-chu-li/

Laravel SQLSTATE[42000], 1055 Expression