当前位置：网站首页>Solve MySQL (1064) error: 1064 - you have an error in your SQL syntax;
Solve MySQL (1064) error: 1064 - you have an error in your SQL syntax;
2022-07-19 07:30:00 【YMeng_ Zhang】
Error message ：
cause ： Don't panic when you find problems , Find out why and how ！ This error occurs when executing the query statement , Generally, this kind of error reporting is a grammatical problem . By looking up MYSQL Reserved words found in ：" READ " The word mysql Is a reserved word , It's like JAVA The same keywords in , therefore You must use English Inverted quotation marks （`） The parcel , Just ok 了 ！
Wrong way one ： No single quotation marks .
Two wrong ways ： Single quotation mark ,but... Non inverted single quotation mark . Although this will not report an error , But the data cannot be displayed .
summary ： In a word, try not to use fields in the table mysql Keywords in , If used, please use the inverted quotation marks in English （`） Protect me ！！！
边栏推荐
- My world 1.12.2 Magic Baby (Fairy treasure dream) service opening tutorial
- 9.账户和权限
- Fundamentals of crawlers - basic principles of multithreading and multiprocessing
- MySQL解压版安装步骤（Windows）
- nodejs
- nodejs
- IP103.53.125. XXX IP address segment details
- Review - 5703 Statistical Inference and Modeling
- Network knowledge-03 data link layer PPPoE
- Network knowledge-04 network layer ICMP Protocol
猜你喜欢
The principle of SYN Flood attack and the solution of SYN Flood Attack
Network knowledge-03 data link layer PPPoE
网络知识-05 传输层-TCP
urllib库的使用
9.账户和权限
day01(Flume)
WCDMA soft handoff performance matlab simulation m, comparing the average number of activation sets (MasN), activation set update rate (Asur) and call interruption probability (OP) three performance i
M based on the MIMO channel capacity analysis of MATLAB, different antenna numbers are compared; Non codebook precoding SVD, GMD; Codebook precoding DFT, TXAA and spatial diversity
网络知识-03 数据链路层-以太网
M matlab simulation of bit error rate using LDPC, turbo and convolutional channel coding and decoding in VBLAST cooperative MIMO system segment
随机推荐
Pychart installation tutorial
Review of 4246 Algorithms for Data Science
M simulation of 16QAM and 2DPSK communication links based on Simulink, and get the bit error rate curve by calling Simulink model through MATLAB
Hypothesis testing
Solution to the conflict between security automatic login and anti CSRF attack
Speed feedback single closed loop DC speed regulation system based on Simulink
Network knowledge-05 transport layer UDP
M simulation of UWB MIMO radar target detection based on MATLAB, considering time reversal
High concurrency day01 (NiO, concurrent package)
听说今天发博客能领徽章！
Network knowledge-04 network layer IPv6
AB Testing Review
MySql
Nanny level one-stop service - self correlation to construct parent-child relationship (@jsonbackreference and @jsonmanagedreference solve circular dependency)
Legendary game setup tutorial
网络知识-02 物理层
正则表达式
MySQL regular expression ^ and $usage
What do you need to build a website
Review of 4121 Computer System for Data Science