您的 SQL 语法有误;检查与您的MySQL服务器版本相对应的手册,了解要使用的正确语法


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

insert_into tb_loan (Product_Code, Customer_Code, Loan_Amount, Rate_Interest, Amount_Tenure, Emi_Amount, Emi_Start, Emi_End) VALUES (0,0,'10000',10.37,'20','546.6','25-10-2013','25-10-2013')

无法插入:您的 SQL 语法有错误;请查看与您的 MySQL 服务器版本对应的手册,了解在第 1 行的"insert_into tb_loan(Product_Code、Customer_Code、Loan_Amount、Rate_Interest、Am'"附近使用的正确语法

替换

insert_into

insert into

并更好地使用YYYY-MM-DD日期格式

insert into tb_loan (Product_Code, Customer_Code, Loan_Amount, Rate_Interest, Amount_Tenure, Emi_Amount, Emi_Start, Emi_End) 
VALUES (0,0,'10000',10.37,'20','546.6','2013-10-25','2013-10-25')

您的插入查询是错误的,请尝试此操作

INSERT INTO tb_loan(Product_Code, Customer_Code, Loan_Amount, Rate_Interest, Amount_Tenure, Emi_Amount, Emi_Start, Emi_End) VALUES (0,0,'10000',10.37,'20','546.6','25-10-2013','25-10-2013')

insert_into替换为INSERT INTO

相关文章: