sql="update fenji set code='"&code_s&"'+right(code,len(code)-"&codeSelected_len&") where left(code,"&codeSelected_len&")='"&codeSelected&"'这个是asp的一个语句写法想翻译成mysql的语句应该怎么写呢,mysql是用concat连接,可是有错,请指教
调试欢乐多
$sql="update fenji set code='".$code_s."'+right(code,len(code)-".$codeSelected_len.") where left(code,".$codeSelected_len.")='".$codeSelected."'";
?>
code=concat('$code_s',right(code,length(code)-$codeSelected_len))
where left(code, $codeSelected_len&)=$codeSelected&";