Project

General

Profile

Bug #108

Updated by Deca Park about 1 year ago

<p><strong>[ADMIN / USER] all SQL</strong></p> 

 <p>1.product_code <p>1.<strong>product_code / qna_code (don&#39;t use LIKE on _code PK column)</p> column)</strong></p> 

 <ul> 
	 <li>Change <li><strong>Change LIKE with =&nbsp;</li> =&nbsp;</strong></li> 
 </ul> 

 <p>2.order_no <p>2.<strong>order_no / product_name_list / mall_name_list / product_name / product_code<br /> 
 &nbsp; &nbsp;username / id<br /> 
 &nbsp; &nbsp;MallRecommend &gt; title / content</p> content</strong></p> 

 <ul> 
	 <li>Remove UPPER()</li> 
 </ul> 

 <p><span style="color:#e74c3c;">3.order_no</span></p> 

 <ul> 
	 <li><span style="color:#e74c3c;">Change LIKE with =&nbsp;</span></li> <li><strong>Remove UPPER()</strong></li> 
 </ul> 

Back