得到此错误＃1064

Question

When I'm inserting my table empinfo

Query for Insert table

$sql="INSERT INTO empinfo(EmpName,Add,MobileNo)values('$EmpName','$Add','$MobileNo')";

I get the 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 'Add,MobileNo)values('jaimin','Baroda','123')' at line 1 

Answer 1

Add is a reserved word within MySQL. If you want to use it as an identifier, then surround it with backticks (as you always should do with identifiers):

$sql="INSERT INTO empinfo(`EmpName`,`Add`,`MobileNo`)values('$EmpName','$Add','$MobileNo')";