MySQL Static analysis: errors were found during analysis.

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.

1. Variable name was expected. (near “%” at position 429)
2. 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’)

MySQL said: 

#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