Freelance Web Designer in Dubai & SEO Expert in Kerala
01 / 01

MySQL Static analysis: errors were found during analysis.

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: Documentation

#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 Customers section this statement is closing.

Correct Usage :

INSERT INTO msg (camp, msg) VALUES (‘First’, ‘Enter Customer Mobile No’);

Other Cases

you have an error in your sql syntax near  at line 1
variable name was expected near  at position 54
there was an error while applying the sql script to the database
2006 – mysql server has gone away set foreign_key_checks = on
set foreign_key_checks = on error
sql error 1064
error 1064 mysql 42000
mysql server version for the right syntax to use near  at

 

by anvar
Published : May , 5

Post a comment

Your email address will not be published. Required fields are marked *

Categories

WhatsApp Logo Chat