Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 急 MySQL Error# 1064,该如何处理

急 MySQL Error# 1064,该如何处理

WBOY
Release： 2016-06-13 11:14:35
Original
890 people have browsed it

急： MySQL Error#: 1064
    如题，错误提示为：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM bbs_sub LEFT OUTER JOIN bbs_rep ON bbs_sub.bbs_ID=bbs_rep.bbs_sub_ID GROUP ' at line 1

    这个问题在网上搜了一下，遇到的人不少，解决的却不多，俺这个菜鸟遇到后更是没办法，特来此请高手赐教，多谢！！！


------解决方案--------------------
1064错误是最常见的错误，它是指SQL语句中出现了语法错误。从它的提示 
syntax to use near 'FROM bbs_sub 
可以找到 FROM bbs_sub 附近有一处错误。
AS LatesTime,
FROM bbs_sub 

这儿多了个逗号，所以引起了歧义
Related labels：
bbs from nbsp sub syntax
source：php.cn
Previous article：php数组，批改，遍历，函数等 Next article：几个php基础但是书下没找到的有关问题
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1429
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1284
PX automatic conversion to REM error  <style>html {   font-size: calc(100vw / 3.75);      }...
From 2024-04-16 09:34:16
0
0
4687
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template