This problem faces during the time of insertion of the table content.
Some Other causes like import into database
Static analysis: 2 errors were found during analysis. Variable name was expected. (near “%” at position 429)
Error
Static analysis:
2 errors were found during analysis.
- Variable name was expected. (near “%” at position 429)
- Ending quote ‘ was expected. (near “” at position 444)
SQL query:
INSERT INTO msg (camp, msg) VALUES (‘First’, ‘വെറും%203999/-%20രൂപക്ക് %20വെബ്സൈറ്റ്%0a%0aTwo%20time%20installment%20payment%0aLife%20long%20service%0aNo%20hidden%20cost%0a%0aഇപ്പോൾ%20വെബ്സൈറ്റ്%20വളരെ%20കുറഞ്ഞ%20ചിലവിൽ%0a%0a🔰%20Fully%20Mobile%20Responsive%20website%0a🔰%20Free%20domain%20and%20web%20hosting%0a🔰%20Whatsapp%20chat%20integration%0a🔰%20Free%20maintanence%0a🔰%205%20email%20id’s%0a%0aFor%20more%20details%20call%20:%206238180489’)
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's%0a%0aFor%20more%20details%20call%20:%206238180489')' at line 1
Solution
This occurs in the case of we have entered the ‘ in the value.
INSERT INTO msg (camp, msg) VALUES (‘First’, ‘Enter Customer’s Mobile No’);
You can see in the above insert section in the Customer‘s section this statement is closing.
Correct Usage :
INSERT INTO msg (camp, msg) VALUES (‘First’, ‘Enter Customer Mobile No’);
Other Cases